Jump to content


Photo

king of newbie questions


  • Please log in to reply
1 reply to this topic

#1 birdie

birdie
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts
  • LocationBirmingham UK

Posted 11 April 2006 - 02:29 PM

hi, i am completely brain dead today so this should be a very easy question to answer.

Could someone please give me the method to finding out where a table has rows with a sql statement like this please..

$sql = "SELECT 2 FROM table WHERE 2=$var";

is mysql_num_rows the only way?
ps. there is a high chance that there will be no rows of this statement being returned so mysql_fetch_array etc usually bring up errors.


thanks

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 11 April 2006 - 02:33 PM

Use [a href=\"http://php.net/mysql_num_rows\" target=\"_blank\"]mysql_num_rows[/a]().




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users