|
Try this:
$DBLINK = mysql_connect($DBHOST, $DBLOGIN, $DBPASSWORD);
mysql_select_db($DBNAME, $DBLINK);
$result = mysql_query("SELECT * FROM galleries WHERE ID = $gid",$DBLINK);
if ($myrow = mysql_fetch_array($result)) {
do {
$result2 = mysql_query("SELECT * FROM templates WHERE ID = 1",$DBLINK);
if ($mytemplate = mysql_fetch_array($result2)) {
do {
extract($myrow);
echo $modelname, $modeldir, $format;
} while ($mytemplate = mysql_fetch_array($result2));
} else {
echo "Sorry, no templates were found!";
}
} while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, no records were found!";
}
?>
|