[SOLVED] count($result) help

[MikeDXUNL]

Alright, my database has entries with ID's

 

1, 2, 4

 

 

only those 3 are in the database

 

when I go to try and see if the game is in the DB

 

<?php
$result = mysql_query("SELECT * FROM videogames WHERE gameid = '$gameid'") or die ("Error: ".mysql_error());


$countResult = count($result);
echo $countResult; 
?>

 

if echo's out 1 no matter what the number is (ie. 5, 32, 500)

when those ID's don't exsist.

any help?

[Jabop]

Your result is true, you're not using the proper count.

 

<?php

$countResult=mysqli_num_rows(mysqli_query($result));

 

echo $countResult;

?>

[MikeDXUNL]

gah! can't believe I didn't catch that myself.

 

thank you!