Known Sub Species of Urban Dragons
|
error_reporting(0);
$f = mysql_connect ("localhost", "urbamcd9_urbweb", "MSWPGH123!!") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("urbamcd9_urbandragons");
if (empty($limit)) $limit=50;
$verbose_queries=0;
$sql = "SELECT id, image_url1, common_name FROM dragon ORDER BY common_name";
$result = mysql("urbamcd9_urbandragons", $sql);
if (empty($result))
{
echo mysql_error()."
\n";
}
$num = mysql_numrows($result);
for ($i =0 ;$i < $num; $i++)
{
$id = mysql_result($result, $i, "id");
$common_name = mysql_result($result, $i, "common_name");
$urlname= mysql_result($result, $i, "image_url1");
printf ("");
printf ("");
printf ("$common_name");
printf (" |
");
}
?>