[SOLVED] can't get mysql num rows

[contra10]

i'm trying to create an if statement in which if the row doens't exists a statement is shown but the statement does not show as i know there should be no result

 

<?php


$querye = "SELECT * FROM `events` WHERE `evcategory`='cultural' and val='true' and `evcity`='$city' and `country` = '$country' ORDER BY dateofevsearch ASC";
$resulte = mysql_query($querye) or die(mysql_error());
$checkifex = mysql_num_rows($resulte);

while ($postede = mysql_fetch_assoc($resulte))
{
$eventname = "{$postede['evname']}";
$eventid = "{$postede['eid']}";
$eventsubcat = "{$postede['evsubcategory']}";

if ($checkifex != 0) {
echo"<table align= 'left'>";
echo "<tr><td align='center'>$eventname $checkifex<br>";
echo"</td></tr>";
echo"</table>";
}else{
	echo"<table>";
	echo "<tr><td>There are no results at this time</td></tr>";
	echo "</table>";
}	
}	

?>

[allworknoplay]

You said if a row doesn't exist..sooo...? You can do an IF on this..

 

 

if($checkifex == 0) {

//do something

}

[contra10]

but if i say that it doesn't exist then it will echo nothing as 0 retrieves no result...if it is not equal to 0 then i have results in my query hence it echos...my problem is that the "There are no results at this time" never shows

[allworknoplay]

That's because you don't have any statements for it!! Use this...

 

 

<?php

    
$querye = "SELECT * FROM `events` WHERE `evcategory`='cultural' and val='true' and `evcity`='$city' and `country` = '$country' ORDER BY dateofevsearch ASC";
$resulte = mysql_query($querye) or die(mysql_error());
$checkifex = mysql_num_rows($resulte);

while ($postede = mysql_fetch_assoc($resulte))
{
   $eventname = "{$postede['evname']}";
$eventid = "{$postede['eid']}";
$eventsubcat = "{$postede['evsubcategory']}";

if ($checkifex != 0) {
   echo"<table align= 'left'>";
   echo "<tr><td align='center'>$eventname $checkifex<br>";
   echo"</td></tr>";
   echo"</table>";
   }elseif($checkifex == 0){
      echo"<table>";
      echo "<tr><td>There are no results at this time</td></tr>";
      echo "</table>";
   }   
}   

?>

[trq]

You need to do the check outside of your while(), otherwise that should throw an error.

 

<?php

$querye = "SELECT * FROM `events` WHERE `evcategory`='cultural' and val='true' and `evcity`='$city' and `country` = '$country' ORDER BY dateofevsearch ASC";
$resulte = mysql_query($querye) or die(mysql_error());
if ($checkifex = mysql_num_rows($resulte)) {
  while ($postede = mysql_fetch_assoc($resulte)) {
    $eventname = $postede['evname'];
    $eventid = $postede['eid'];
    $eventsubcat = $postede['evsubcategory'];
    
    echo"<table align= 'left'>";
    echo "<tr><td align='center'>$eventname $checkifex<br>";
    echo"</td></tr>";
    echo"</table>";
  
  }
} else {
  echo"<table>";
  echo "<tr><td>There are no results at this time</td></tr>";
  echo "</table>";
}	

?>

[contra10]

ohhh...ok thxs