|
function mysqli_result($res,$row=0,$col=0){
$numrows = mysqli_num_rows($res);
if ($numrows && $row <= ($numrows-1) && $row >=0){
mysqli_data_seek($res,$row);
$resrow = (is_numeric($col)) ? mysqli_fetch_row($res) : mysqli_fetch_assoc($res);
if (isset($resrow[$col])){
return $resrow[$col];
}
}
return false;
}
$f = mysqli_connect("localhost", "urbamcd9_urbweb", "MSWPGH123!!") or die ('I cannot connect to the database because: ' . mysql_error());
mysqli_select_db ($f,"urbamcd9_urbandragons");
if (empty($limit)) $limit=50;
$verbose_queries=0;
$sql = "SELECT common_name, latin_name, image_url1, ".
"year(creation_date) as year, description ".
"FROM dragon WHERE id =$_REQUEST[id]";
$result = mysqli_query($f, $sql);
if (empty($result))
{
echo mysql_error()."
\n";
}
printf ("");
printf ("",
mysqli_result($result, $i, "image_url1"));
printf (" |
");
printf ("");
printf ("%s ",
mysqli_result($result, $i, "common_name"));
printf ("(%s)",
mysqli_result($result, $i, "latin_name"));
printf (" |
");
printf ("");
printf (" %s ",
mysql_result($result, $i, "description"));
printf (" |
");
printf ("");
printf (" Copyright © Colin Scott McDonald",
mysqli_result($result, $i, "year"));
printf (" |
");
?>
|
|