Re: WHERE problem

Without the single-quotes, I still get nothing returned. Bruce Cowin wrote:

Are you getting an error or just nothing returned? The first thing I'd check is if index is a numeric field and if it is, remove the single quotes from around $randi in the where clause. Regards, Bruce

Mike Shanley <thebarmy@omniversalism.com> 20/02/2007 9:23:08 a.m. >>>

I'd like to think I understood code a little better than this, but I've got a problem with my WHERE... I know it's the WHERE because I get a good result when I leave it out. And the random function is also working... I honestly can't figure it out. Thanks in advance for help with this laughable prob. --------------------------- // How many are there? $result = mysql_query("SELECT count(*) FROM fortunes"); $max = mysql_result($result, 0); // Get randomized!... the moderated way... $randi = mt_rand(1, $max-1); $q = "SELECT text FROM fortunes WHERE index = '$randi'"; $choose = mysql_query($q); $chosen1 = mysql_fetch_array($choose); // Ready to ship... $fortune = '<span class="quotecyc">&quot;' . $chosen1[0] . '&quot;<br/>-Omniversalism.com</span>'; mysql_close();

-- Mike Shanley ~you are almost there~ "A new eye opens on March 5." -Omniversalism.com