[SOLVED] Problem Getting Search To Work

[stevesimo]

Hi, I have a database page which all I am trying to do is display a count of all the records contained in the table.  Although my code seems to be working the count isn't being returned.

 

Here is my code:

 

  $border = mysql_query("SELECT * from orders");
  $orders = mysql_fetch_object($border); 
  $results = $orders->num_rows;
[code]

Can anyone see what is wrong with this as I am not sure what I am doing wrong.

Thanks

Steve

[/code]

[tauchai83]

  
<?php
$total = sql_query1("SELECT count(*) FROM table_name E WHERE conditions");
?>

[Hell Toupee]

Or without the need for a second query,

 

instead of:

 

$results = $orders->num_rows;

 

it should be:

 

$results = mysql_num_rows($border);