note 15640 added to function.mysql-query
| From: | php-general at lists dot php dot net | Date: | Mon, 24 Sep 2001 15:03:54 +0000 |
| Subject: | note 15640 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-18250@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);
--
http://www.php.net/manual/en/function.mysql-query.php
http://master.php.net/manage/user-notes.php?action=edit+15640
http://master.php.net/manage/user-notes.php?action=delete+15640
http://master.php.net/manage/user-notes.php?action=reject+15640