note 15640 deleted from function.mysql-query by jimw
| From: | jimw@php.net | Date: | Sat, 08 Dec 2001 22:21:03 +0000 |
| Subject: | note 15640 deleted from function.mysql-query by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-22292@lists.php.net to get a copy of this message | ||
$link = mysql_pconnect("$derver", "$user", "$pass")
or die ("Could not connect");
$query = "$sqlquery";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
print "<table border=\"1\">";
$fieldsret = mysql_num_fields ($result);
print "<tr>";
for ($i=0;$i<$fieldsret;$i++)
{
print "<th>" . mysql_field_name($result, $i) . "</th>";
}
print "</tr>";
$rowsret=mysql_fetch_row ($result);
for($i=0;$i<$num_rows;$i++)
{
print "<tr>";
foreach($rowsret as $a)
{
print "<td>" . $a . "</td>";
}
print "</tr>";
}
}
mysql_close($link);