Resource id as result of query?

Anon

I'm getting Resource id #4 as result of select query,I have tried to use mysql_fetch_array to get the contents of the array but it\'s not working, there is only one possible result from the query:

$sql= "SELECT dayofmonth(Date_From) from rates where Rates_ID = '$row_id'";

It works on the cmd line but how do I get the result from a script?

Any help greatly appreciated!

Anon

one of these should work...

$sql= "SELECT dayofmonth(Date_From) from rates where Rates_ID = '$row_id'";
$sql_r = mysql_query($sql);
// to get the first result of the query
$day = mysql_result($sql_r, 0);

or this...

// names the colomn in the array that the
// value will be stored in
$sql= "SELECT dayofmonth(Date_From) AS day from rates where Rates_ID = '$row_id'";
$sql_r = mysql_query($sql);
$v = mysql_fetch_array($sql_r);
$day = $v["day"];

hope that helps

Anon

Thanks very much that worked perfectly! ;-)

[deleted]

It helps if you also know why you got taht error:

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=12