Code not working

[psycho]

Hi all,

could somebody explaine me why this is not working ???

<?php
mysql_connect ("$host");
mysql_select_db("$db");
$sql= "SELECT ID FROM gegevens" ;
$test=mysql_query($sql);

$nb = mysql_num_rows("$test");
echo "We found $nb members with name Wessam";
?>

i get an error when i try it.

did get the code from php.net

the error i get "mysql_num_fields(): supplied argument is not a valid MySQL "

thanks for you time

[ir4z0r]

is this really the error message? you don't even use this function ...

<?php
  mysql_connect ($host);
  mysql_select_db("$db"); 
  $sql= "SELECT ID FROM gegevens"; 
  $test=mysql_query($sql); 
  if ($test)
  {  

    $nb = mysql_num_rows($test);
  }
  else $nb = 0;

  echo "We found $nb members with name Wessam"; 
?>

[toma42]

You're not storing your mysql resource identifier. You should go read a mysql/php tutorial then try again.

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

[psycho]

You're fast .... :-)

thanks for the tips

have a nice day

[kevinsequeira]

change $nb = mysql_num_rows("$test");
to $nb = mysql_num_rows($test);

ie remove the " "

reg
kevin

[ir4z0r]

Originally posted by toma42
You're not storing your mysql resource identifier.

I don't get this one. what is $test ?

[psycho]

$test is just something i use when i'm testing a code

i know what is wrong

ir4z0r you code did help me lol

i just the wrong .inc file for the database
after using you're code it did gave me a 0
but there are two entrees in the database

i tryed to get to the wrong database
shame on me

but thanks do for you're fast reaction
liked it

have a nice day