[SOLVED] can someone help me with one line of php???? PLEASE

[skippa]

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/thebestj/public_html/poker.php on line 1097

 

heres line 1097

 

return mysql_fetch_array(mysql_query("SELECT p.*, u.poker, u.money FROM poker p left join users u on (u.username='{$_SESSION['username']}') WHERE p.id=u.poker"));

 

 

whats wrong with it.

[Maq]

Add this in and see what it outputs:

 

   return mysql_fetch_array(mysql_query("SELECT p.*, u.poker, u.money FROM poker p left join users u on (u.username='{$_SESSION['username']}') WHERE p.id=u.poker") or die(mysql_error()));

[Mchl]

Most likely the query fails. Change this one line into three

$sql = "SELECT p.*, u.poker, u.money FROM poker p left join users u on (u.username='{$_SESSION['username']}') WHERE p.id=u.poker";
$result = mysql_query($sql) or die(mysql_error()." $sql");
return mysql_fetch_array($result);

 

this should display what causes the error

[skippa]

nope, still an error somewhere on that line.

[Maq]

nope, still an error somewhere on that line.

 

Yeah, what is it?  The "or die(mysql_error())" should kill the script and output a more "descriptive" error message.

[skippa]

Unknown column 'u.poker' in 'field list' SELECT p.*, u.poker, u.money FROM poker p left join users u on (u.username='Chris') WHERE p.id=u.poker

 

Thats The Problem. 

 

Has Anyone Got Msn Where I Can Have A Chat To And They Can Have A Good Look At The Script.?

[Mchl]

Well? Is there a field called 'poker' in 'users' table?

[skippa]

nahh there aint, how can i add one?

[Maq]

You can easily create one through such web apps like, "PHPMyAdmin".

 

Or, you can do it the old fashioned way:

 

ALTER TABLE users ADD poker VARCHAR(60);

[skippa]

Yeah im in PhpMyAdmin now, and in the database. how do i add one through there.

[Maq]

I think it's, DB >> table_name >> OPERATION tab, then add your table.

[skippa]

ok. added poker. but the page on the site has gone completly blank.

[Mchl]

Well... we helped you with this one line, haven't we?

 

Please visit this link http://www.phpfreaks.com/tutorial/debugging-a-beginners-guide/page1

[skippa]

yeah, you have, thanks everyone.

[Maq]

ok. added poker. but the page on the site has gone completly blank.

 

Probably cause there's nothing in the 'poker' column yet.

[skippa]

yeah says null fo every user in database, it shouldnt say null should it..

[Maq]

yeah says null fo every user in database, it shouldnt say null should it..

 

Well if you just created it how is it supposed to have data in it?