> -----Original Message----- > From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 30, 2003 12:57 PM > To: [EMAIL PROTECTED] > Subject: [PHP] while loop- will this work? > > > > > Should this work? > > $f1 = rand(999,99999999999); > > while($check_sid = mysql_query("SELECT * FROM > that_table WHERE this = > '$f1'")){ > > $f1 = rand(999,99999999999); > > } > > > i.e. put the random number in a loop to check and make sure > it is already > not in use?
If you check the result set for a match. $result being true will only mean the sql executed, and not that the value was in the table. So you should do a mysql_fetch_row($result) and if it succeeds the row exists in the table. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
