PHP: Display rows value same with all union limit

sibtain

New Member
\[code\]<? // Connect database include("cat-config.php"); // Get all records in all columns from table and put it in $result. $result=mysql_query(" (select * from stok_lukisan where `Ukuran` LIKE '20x25' AND `Kategori` LIKE '1' ORDER BY `Kode` ASC limit 3) union all (select * from stok_lukisan where `Ukuran` LIKE '30x40' AND `Kategori` LIKE '1' ORDER BY `Kode` ASC limit 4) union all (select * from stok_lukisan where `Ukuran` LIKE '20x50' AND `Kategori` LIKE '1' ORDER BY `Kode` ASC limit 5) "); /*Split records in $result by table rows and put them in $row. Make it looping by while statement. */ while($row=mysql_fetch_assoc($result)){ echo '<table><tr>'; echo "<td align='center'>$row[Kode]<br><a href='http://stackoverflow.com/questions/3896931/$GAMBAR_URL/$row[Gambar]' rel='lightbox' title='Kode Lukisan: $row[Kode]'><img src='http://stackoverflow.com/questions/3896931/$GAMBAR_URL/$row[Gambar]'><br> Rp.$row[Harga]<a href=http://stackoverflow.com/"javascript:;\" onclick=\"simpleCart.add('name=$row[Kode]', 'price=$row[Harga]','size=tiny','quantity=1','thumb=$GAMBAR_URL/$row[Gambar]');\"><br><img src='http://stackoverflow.com/questions/3896931/images/buy.gif'><p></a>"; $rows = 1; while ($row = mysql_fetch_assoc($result)) { echo "<td align='center'>$row[Kode]<br><a href='http://stackoverflow.com/questions/3896931/$GAMBAR_URL/$row[Gambar]' rel='lightbox' title='Kode Lukisan: $row[Kode]'><img src='http://stackoverflow.com/questions/3896931/$GAMBAR_URL/$row[Gambar]'></a><br> Rp.$row[Harga]<a href=http://stackoverflow.com/"javascript:;\" onclick=\"simpleCart.add('name=$row[Kode]', 'price=$row[Harga]','size=tiny','quantity=1','thumb=$GAMBAR_URL/$row[Gambar]');\"><br><img src='http://stackoverflow.com/questions/3896931/images/buy.gif'><p></a>"; ++$rows; if ($rows %4 == 0) { echo '</tr><tr></tr> </table></tr><tr><table><tr>'; } } } ?>\[/code\]how to display on page with every single rows of php loops in accordance with a limit that has been set in the union all.on php page result like this:\[code\]1001 - 1002 - 1003 (<---- 3 record on rows)2001 - 2002 - 2003 - 2004 (<---- 4 record on rows)3001 - 3002 - 3003 - 3004 - 3005 (<---- 5 record on rows)\[/code\]thanks....
 
Back
Top