[SOLVED] MySQL result resource Error

[dizzy1]

hi, im tryin to find out how may rows thier are in a sql im doing, the answer should be 0. THis is the error msg i get:

 

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fhlinux144/user/htdocs/Search.php on line 388

 

$mysql  = " Select * from  ";								
$mysql .= " venue ";


$temp = mysql_query($mysql);			
Line 338: $NumRows = mysql_num_rows($temp); 

echo "NumRows: $NumRows <br>";

 

 

i need to know the value of NumRows so i can see if the value is not equal to 0 so it will continue

 

if ($NumRows  != 0 ){
//DO SOMTHING
}

 

Thanks In Advance

Dizzy

 

 

[redarrow]

<?php

$result = $mysqli->query("SELECT COUNT(*) as TOTALFOUND from table");

$row_array=$result->fetch_array(MYSQLI_ASSOC);

print($row_array['TOTALFOUND']);

?>

[redarrow]

$mysql  = " Select count(*) from  ";                       

$mysql .= " venue ";

 

 

$temp = mysql_query($mysql);       

Line 338: $NumRows = mysql_num_rows($temp);

 

echo "NumRows: $NumRows <br>";

[revraz]

Use mysql_error() after your query to see why your query is failing.

[dizzy1]

i changed it to:

 

$mysql  = " Select * from  ";                        
$mysql .= " venue ";

$temp = mysql_query($mysql);	

if(mysql_num_rows($temp) != 0) { 
{

 

But still didnt work i tried changing the mysql_query to fetch_array and the error turned into a fatal error.

 

i tried puttin in mysql_error(); all over the place and it didnt do anything.

 

help me please ???

 

[redarrow]

<?php
$temp = mysql_query($mysql)or die(mysql_error()); ?>

<<< add it tell us what failing mate.

[revraz]

$mysql  = "Select * from venue";

 

$temp = mysql_query($mysql) or die (mysql_error());

[dizzy1]

<?php
$temp = mysql_query($mysql)or die(mysql_error()); ?>

<<< add it tell us what failing mate.

 

Cheers everyone tat is a brilliant piece of syntax mysql_error(), when used correctly, it basically told me the table didnt exist and the reason it didnt exist was becuase the damn table callled venue should of been spelt Venue, capital V.

 

THANKS EVERYONE FOR ALL YOUR TIME AND PATIENCE. ;D