easy PHP/MYSQL question

newbiejim · 10 Apr 2006 at 20:13

dabbling with PHP/MYSQL and it works ok but stupidly havign difficulty in returning informative text (eg; no results returned) when no matching records are returned, the code below works to retrieve.
How do I return the no results returned etc?

Code:

$link_id = mysql_connect("localhost","root","**********");

  mysql_select_db("printservers",$link_id);

 

$sql = "SELECT * FROM printserverstable";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
 {




echo "<center><table WIDTH = 810 BORDER =1>";
echo "<tr width = 810>";
echo "<td WIDTH = 110>".$row['location']."</td>";
echo "<td WIDTH = 110>".$row['sublocation']."</td>";
echo "<td WIDTH = 140>".$row['brand']."</td>";
echo "<td WIDTH = 110><A HREF = ".$address,$row['ipaddress'].">".$row['ipaddress']."</A></td>";
echo "<td WIDTH = 110>".$row['updatedby']."</td>";
echo "<td WIDTH = 140>".$row['comments']."</td>";
echo "<td WIDTH = 110>".$row['id']."</td>";
echo "</tr>";
echo "</table></center>";


}

Beansprout · 10 Apr 2006 at 20:30

Code:

if(mysql_num_results($query) < 1) {

echo 'Ark! There be no results';

} else {

//do that table-echo-while-thing

}

Might work. Might not. But http://www.php.net/mysql_num_rows is what you need

newbiejim · 10 Apr 2006 at 21:00

how simple was that?, superb, thanks a lot , dunno if ure code was a typo but I changed

Code:

mysql_num_results

to

Code:

mysql_num_rows

and wey hey it works , many thanks mate, I was on the right track conceptually/logically but unfortunately ws too much of a dullard to get there myself :eek:

now to paging the results..... :confused:

Beansprout · 10 Apr 2006 at 21:13

I got back from Canada earlier today with 1hrs' sleep, I plead not guilty