Ajax chat - login issue

Question

On my Ajax Chat script I have got this warning:

Warning: mysql_fetch_array() expects parameter 1 to be resource,
boolean given in /home/mychat/public_html/c/listChats.php on line 7

Line 7:

while($row = mysql_fetch_array($sql)){

listChats.php:

<?php 
$chats = "";

include_once("scripts/connect_db.php");

$sql = mysql_query("SELECT * FROM (
    SELECT * FROM chatBox order by id DESC LIMIT 20
) TMP ORDER BY tmp.id ASC");

while($row = mysql_fetch_array($sql)){
    $chat = $row['chatBody'];
    $username = $row['username'];
    $chats = '<p><span id="un">' . $username . ':</span> ' . $chat . '</p>';
    echo "$chats";
}
?>

There are [**three hundred fifteen potential duplicates**](http://stackoverflow.com/search?q=%22+mysql_fetch_array%28%29+expects+parameter+1+to+be+resource%2C+boolean+given%22) containing the error message you have provided. Every last one of them has the same core issue. The query failed and returned a bool. You need to add error checking to your code, and you need to fix the underlying SQL error. Hover over the downvote arrow. One of the reasons suggested there is "this question does not show any research effort," and it doesn't. — Charles, Dec 24 '12 at 06:48
Now I know why people don't come on here your -point system is crazy — Agustin Leyva, Dec 24 '12 at 06:49
@Charles Well if you say so and the reason I added this was because I was lost and needed help. — Agustin Leyva, Dec 24 '12 at 06:51
So whats the deal with the points system - / + drop in points get ban — Agustin Leyva, Dec 24 '12 at 06:52
Good questions get upvoted. Bad questions get downvoted. Don't take it personally. You might not have gotten the help you wanted, but you did get this help, at least: **always search for your error message first**. ***Always***. — Charles, Dec 24 '12 at 06:54
@Charles I never take things personal site got rules, but thank's for the advice — Agustin Leyva, Dec 24 '12 at 06:59
possible duplicate of [mysql\_fetch\_array() expects parameter 1 to be resource, boolean given in select](http://stackoverflow.com/questions/2973202/mysql-fetch-array-expects-parameter-1-to-be-resource-boolean-given-in-select) — Fenton, Dec 24 '12 at 10:46
@SteveFenton sorry bro its not a possible duplicate of mysql_fetch_array() expects parameter 1 to be resource, boolean given in select. Because my code is different same problem different help problem. Plus problem was taken care of by the help of Harry. — Agustin Leyva, Dec 24 '12 at 11:17
It is the same issue. Bad SQL syntax causes the issue. The answers to that question show you how to get the error message from MySQL to help diagnose the problem. — Fenton, Dec 24 '12 at 11:18

Hkachhia · Accepted Answer · 2012-12-24T10:23:54.570

1

Your query syntax is wrong

Try this

$sql = mysql_query("SELECT *,(

    SELECT * FROM chatBox order by id DESC LIMIT 20

) as data FROM TMP ORDER BY tmp.id ASC");

Updated query

select *,(select username from chatBox where id=".$_SESSION['userid'].") from chatBody where user_id=".$_SESSION['userid']

edited Dec 24 '12 at 10:23

answered Dec 24 '12 at 06:30

Hkachhia

4,463
6
41
76

Still same issue thanks for the help – Agustin Leyva Dec 24 '12 at 06:46
I think first you have check your db connection is establish properly or not – Hkachhia Dec 24 '12 at 06:54
I used this code `$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());` and got this warning: `Warning: mysql_query() [function.mysql-query]: Access denied for user 'amljrx10'@'localhost' (using password: NO) in /home/amljrx10/public_html/c/listChats.php on line 3 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/amljrx10/public_html/c/listChats.php on line 3 Error in query: . Access denied for user 'amljrx10'@'localhost' (using password: NO)` – Agustin Leyva Dec 24 '12 at 07:04
It indicates that amljrx10 has a password, but you are not supplying it.so give this error. – Hkachhia Dec 24 '12 at 07:07
are you talking about the database password. – Agustin Leyva Dec 24 '12 at 07:21
Ya you have must apply password when connect the database. – Hkachhia Dec 24 '12 at 07:24
Yes I did the chat Box is showing and when you write and submit it; it shows it in the database but not in the box. – Agustin Leyva Dec 24 '12 at 07:25
Means after sumbit the page data save successfully in database but not display in textbox – Hkachhia Dec 24 '12 at 07:28
yes you are right "but not display in textbox" – Agustin Leyva Dec 24 '12 at 07:29
Ok then you have write code like this in your textbox. – Hkachhia Dec 24 '12 at 07:30
nope here's the link [ChatBox site](http://amljr.x10.mx/c/index.php) – Agustin Leyva Dec 24 '12 at 07:49
Your link is not working – Hkachhia Dec 24 '12 at 08:19
did you click on the "ChatBox Site" – Agustin Leyva Dec 24 '12 at 08:31
Ya its give error message Sorry, you must be logged in to chat – Hkachhia Dec 24 '12 at 08:42
sorry about that forgot .. Here [ChatBox Site](http://amljr.x10.mx/c/login.php) email demo@demochat.com pass demo – Agustin Leyva Dec 24 '12 at 09:00
I have see your code.You have blank text box in post_chat function.See it – Hkachhia Dec 24 '12 at 09:11
I does not want link of your js file.I have already seen it.See in last line of function post_chat() you have blank chat text box in this function. – Hkachhia Dec 24 '12 at 09:18
Remove or comment this line document.getElementById("chat").value = ""; from function – Hkachhia Dec 24 '12 at 09:20
I comment it out but still warning – Agustin Leyva Dec 24 '12 at 09:26
Can you post code of listChats.php page so I will solve your problem easily. – Hkachhia Dec 24 '12 at 09:28
Have you update your code as per my answer? – Hkachhia Dec 24 '12 at 09:31
Yes but still same problem – Agustin Leyva Dec 24 '12 at 09:32
Ok tell me which detail you want to fetch from chatbox table – Hkachhia Dec 24 '12 at 09:36
I just want it to show the username and text – Agustin Leyva Dec 24 '12 at 09:38
I took out `,( SELECT * FROM chatBox order by id DESC LIMIT 20 ) as data FROM TMP ORDER BY tmp.id ASC` and left this `"SELECT * FROM chatBox"` – Agustin Leyva Dec 24 '12 at 09:41
Template meta-programming (TMP) – Agustin Leyva Dec 24 '12 at 09:42
Query is wrong please tell me in which table you have stored username.If you want to display text of login user in div.then you have write a different query not this. – Hkachhia Dec 24 '12 at 09:45
I have a table call "chatBox" with username in it and chatBody that store's the text – Agustin Leyva Dec 24 '12 at 09:50
Ok Have you manage login user id in session or other way? – Hkachhia Dec 24 '12 at 09:54
Ok try this query "select *,(select username from chatBox where id=".$_SESSION['userid'].") from chatBody where user_id=".$_SESSION['userid'] Change session name as per your code – Hkachhia Dec 24 '12 at 10:00
What about now is it working right – Agustin Leyva Dec 24 '12 at 10:13
Well I see your username as "Chat" and your text as "Is it working correctly ?" – Agustin Leyva Dec 24 '12 at 10:18
@AgustinLeyva please tell me your problem is solve or not ? – Hkachhia Dec 24 '12 at 10:19

score 0 · Answer 2 · edited Aug 21 '15 at 07:42

0

I think you are using wrong table name.

Try this

$sql = mysql_query("SELECT *,(

    SELECT * FROM chatBox order by id DESC LIMIT 20

) as data FROM TMP ORDER BY TMP.id ASC");

If your table is TMP then use TMP.id if it is tmp then use tmp.id

edited Aug 21 '15 at 07:42

Litisqe Kumar

2,512
4
26
40

answered Dec 24 '12 at 06:52

fmask

481
7
18

Ajax chat - login issue

2 Answers2