what's wrong?
Posted: Thu Dec 30, 2004 4:00 am
I have a script:
First loop is normal, but others didn't print anything. What's wrong?
Code: Select all
<?php
$db_prisijungimas = mysql_connect("localhost", "username", "pass")
or die("Negalime prisijungti prie duombazes" . mysql_error());
mysql_select_db ("stebuklas", $db_prisijungimas)
or die("Nerandu duombazes" . mysql_error());
$kategorijos = "SELECT id, name FROM logo_categories;";
$query_results = mysql_query ($kategorijos, $db_prisijungimas)
print"<center>";
while ($row = mysql_fetch_object ($query_results))
{
print("<a href="$PHP_SELF?id=" . $row -> id . " " >" . $row -> name ."</a>");
print(" | ");
}
print("</center>");
if(!isset($_GET['id']))
{
print "</br></br></br>";
$logo = "SELECT id,cat_id FROM logo;";
$logo_results = mysql_query ($logo, $db_prisijungimas) or die(mysql_error());
while ($rows = mysql_fetch_object($logo_results))
{
print ("<a href="www.myweb.com". $rows -> id ." .gif "");
}
}
else
{
$logo = "SELECT id,cat_id FROM logo WHERE cat_id = ". $_GET['id'] . ";";
$logo_results = mysql_query ($logo, $db_prisijungimas) or die(mysql_error());
while ($rows = mysql_fetch_object($logo_results))
{
print ("<a href="www.myweb.com". $rows -> id ." .gif "");
}
}
?>