$kon1=92;
$kon2=115;
?>
0) {
$mysql=mysql_pconnect("localhost","aaron","") or die("Unable to connect to SQL server");
mysql_select_db("antik99",$mysql) or die("Unable to select database");
$get_kon=mysql_query("SELECT nazev1,nazev2,ulice,mesto FROM kontakt WHERE i_kontakt=$kon1",$mysql) or die("chyba v select1");
$kontakt=mysql_fetch_row($get_kon);
} ?>
Dorava
|
|
Offer |
|
$kategorie=mysql_query("SELECT zbozi.c_kategorie%100,kategorie.kategorie_us
FROM zbozi,kategorie WHERE (publ_inet='Y') AND ((i_kontakt=$kon1) OR (i_kontakt=$kon2))
AND ((zbozi.c_kategorie%100)=(kategorie.c_kategorie%100)) GROUP BY 1 ORDER BY 2",$mysql) or die("chyba v select2");
$pocet=mysql_num_rows($kategorie);
$counter=0;
while ($row=mysql_fetch_row($kategorie)) {
if ($pocet<1) {
echo("\n| $row[1] | \n ");}
else {
$counter=$counter+1;
if ($counter<=(ROUND($pocet/2))) {
if ($counter==1) { echo("\n\n");}
echo("\n| $row[1] | \n \n");
}
else { if ($counter==(1+ROUND($pocet/2))) { echo(" \n | \n\n
| \n");}
echo("\n |
$row[1] | \n
\n");
if ($counter==$pocet) { echo(" \n | ");}}}
}
?>
|