Random Value for SQL

[kei_ki7]

$pot = mysql_fetch_array(mysql_query("SELECT pid FROM ibwf_albumpic WHERE private='0' ORDER BY rand() LIMIT 1"));

$new = mysql_fetch_array(mysql_query("SELECT MAX(pid) FROM ibwf_albumpic WHERE private='0'"));

is that correct?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kendee/public_html/wap/v2/album.php on line of $pot

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kendee/public_html/wap/v2/album.php on line of $new

for $pot
i just want to get random pid in ibwf_albumpic for 1day (picture of the day)

and for $new
i just want to get the maximum value of pid to get the newest pid or order by time

[ori]

the query looks fine whats the contents of ya table like rows etc

[ZED]

be sure that ur SqL is correct lol ....try this

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT pid FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));
or

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT id FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));

or

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT id, uid FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));

[thanatos]

SELECT pid FROM table WHERE private='0' ORDER BY time DESC LIMIT 1

[ZED]

SELECT pid FROM table WHERE private='0' ORDER BY time DESC LIMIT 1

this in not random ..... it place 1st or last photo

[thanatos]

look at his post.. he wants to get newest value of pid..

[ZED]

ah ok dude ...i dont see bout that i just look @ the title

[ori]

the 1st query is for random result 2nd is for pid value

[kei_ki7]

the query looks fine whats the contents of ya table like rows etc

thanks for that info! i think i got a heavy stress

be sure that ur SqL is correct lol ....try this

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT pid FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));
or

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT id FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));

or

$pot = mysql_fetch_array(mysql_query("SELECT DISTINCT id, uid FROM ibwf_albumpic WHERE private='0' ORDER BY RAND() LIMIT 1"));

thanks for the red font same comment

SELECT pid FROM table WHERE private='0' ORDER BY time DESC LIMIT 1

thanks for the reply

by the way i got wrong column thanks to all =)