MySQL Limit nece !!!
10.01.2007. u 21:30 · pre 240 meseci
#1
poz svima
ne znam zasto nece ovoj limit na ovoj primer, pokazuje mi samo 1 rekord.
ne znam zasto nece ovoj limit na ovoj primer, pokazuje mi samo 1 rekord.
Code:
$q1 = "select * from bsoft_catalog, bsoft_categories, bsoft_cd WHERE bsoft_catalog.ItemID = bsoft_catalog.ItemID and bsoft_categories.ItemCategory = CategoryID and bsoft_cd.ItemCd = CdID ORDER BY bsoft_catalog.ItemID ASC LIMIT 4";
$r1 = mysql_query($q1) or die(mysql_error());
$q1 = "select * from bsoft_catalog, bsoft_categories, bsoft_cd WHERE bsoft_catalog.ItemID = bsoft_catalog.ItemID and bsoft_categories.ItemCategory = CategoryID and bsoft_cd.ItemCd = CdID ORDER BY bsoft_catalog.ItemID ASC LIMIT 4";
$r1 = mysql_query($q1) or die(mysql_error());