Cannot display any data in my web page

[nscheung]

I have created a mysql database with a table named 'testing', and fields of 'a', 'b' and 'c'. All the fields are inserted values.

When I write a php file, which contains the following code:

$num=mysql_num_rows($result999);

I try and test the code with "print $num;", it returns that there are data. However, when I use the following code on the webpage, it just display nothing. What's wrong with my code? Or is it the problem of setting the character set of the webpage with the mysql db?

<?
$strsql="select * from testing where a = '1'";
$result=mysql_query($strsql);
print $a;
?>

[Shrike]

mysql_query() queries the database, which generates a record set. You then need to use one of the data gathering functions such as mysql_fetch_array() and mysql_fetch_row() to actually obtain some data.

[nscheung]

After add this statement "$row=mysql_fetch_array($result);", it works. Thanks very much!!! It has tolerated me for days .......