It is Ok. I can hide some details in php magic. When I click each row and it should be open in different window with complete details in a Vertical table format. What should I do? Is there any tips?
************************************************** *****
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/host790/public_html/test123/results.php on line 14
Number matches found:
Error message script is as follows
************************************************** *****
<html>
<head>
<title>Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<h1>Search Results</h1>
<?php
$database="host790_product";
mysql_connect ("localhost", "host790_product", "1234");
@mysql_select_db($database) or die( "Unable to select database");
$query = "select * from tablename";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p>Number matches found: ".$num_results."</p>";
echo "<hr>";
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "<p><strong># ";
echo stripslashes($row["contact_id"]);
echo "<p><strong>Name: ";
echo stripslashes($row["first_name"]);
echo "<p><strong>Category: ";
echo stripslashes($row["lastname"]);
echo "<p><strong>Comment: ";
echo stripslashes($row["comments"]);
echo "<hr>";
echo "</p>";
}
?>
</body>
</html>
************************************************** *****