checking if a number is in the database...

[akrocks_extreme]

i'm trying to check if there is a number in my table and if there is up it the number and check again.. but there is something wrong with my code..

$newsid = mysql_num_rows(mysql_query("SELECT * FROM news"));

$checkid = mysql_query("SELECT newsid FROM news WHERE newsid='$newsid'");

i want to get the id from the number of rows. and then check if there is already an id of that number, this happens when a row is deleted from the table. so we count the rows and keep adding 1 until we have a number that is already used (and perferably larger than the old id's).

so here is my problem, $checkid is returning Resource ID #4... what is that supposed to mean? is it a syntax error (thats not being caught by php)? or something else?

thanks.

[ZibingsCoder]

You aren't touching the results of the query, you're just accessing the entire data set that is returned.

$newsid = mysql_num_rows(mysql_query("SELECT * FROM news")); 

while ( $row = mysql_fetch_array($newsid) )
{
   $checkid = mysql_query("SELECT newsid FROM news WHERE newsid='{$row['newsid']}'");

   if ( mysql_num_rows($checkid) > 0 )
   {
      //the newsid exists
   }
}

[drawmack]

you should be using auto_number for this. http://www.mysql.com/auto_number