[SOLVED] query not working..

[acctman]

is there a reason why this query is not work

err: PHP Warning:  mysql_result(): supplied argument is not a valid MySQL result resource in ...

$date = mysql_result(mysql_query("SELECT m_date, m_id FROM rate_members WHERE m_id=$id"), 0, "m_date");		

[PFMaBiSmAd]

Add the following right after that line to find out why the query failed -

 

echo mysql_error();

 

[BLaZuRE]

is there a reason why this query is not work

err: PHP Warning:  mysql_result(): supplied argument is not a valid MySQL result resource in ...

$date = mysql_result(mysql_query("SELECT m_date, m_id FROM rate_members WHERE m_id=$id"), 0, "m_date");		

 

Yeah .. there's always a reason.

Anyway, I'd say save your your mysql_query into a variable, i.e. $result = mysql_query("...");.  It makes your code look much cleaner and easier to troubleshoot.  That way, you can print out what your query returns and check to see if that's what you want.

Another thing that I see in your code: You're querying $id.  $id exists in PHP, not MySQL.  That's another reason why you should save it as a separate variable.  Concatenate your string.  You're including the text $id right now, not THE VALUE of $id, which is different.