i need 3 rows of data same table using same query on same page 3 different places. use following query 3 times on single page 3 rows of data , shows on each place . makes page load slow. there way 9 rows of data using single query , use splitting 3 rows of data @ 3 different places on same page??
here query:
$result = mysql_query("select * table order rand() limit 3 "); while ($row = mysql_fetch_array($result)){ $a1=$row['a1']; $a2=$row['a2']; $a3=$row['a3']; $a4=$row['a4']; $a5=$row['a5']; echo "<div class=\"col-sm-4\"><div class=\"product-image-wrapper\"><div class=\"single-products\"><div class=\"productinfo text-center\"><a3 src=\"$a3\" alt=\"$a1\"><h2>$a4</h2><h5>$a1</h5><a a2=\"$a2\" target=_blank class=\"btn btn-default add-to-cart\"><i class=\"fa fa-shopping-cart\"></i>$a5</a></div></div></div></div>\n"; }
sure, put results array , use array cherry-picking index (0-8). make sure there's enough elements!
$result = mysql_query("select * table order rand() limit 9 "); $ninerows = []; while ($row = mysql_fetch_array($result)){ $ninerows[] = $row; } //first usage $item = $ninerows[0]; echo "<div class=\"col-sm-4\"><div class=\"product-image-wrapper\"><div class=\"single-products\"><div class=\"productinfo text-center\"><a3 src=\"$item['a3']\" alt=\"$item['a1']\"><h2>$item['a4']</h2><h5>$item['a1']</h5><a a2=\"$item['a2']\" target=_blank class=\"btn btn-default add-to-cart\"><i class=\"fa fa-shopping-cart\"></i>$item['a5']</a></div></div></div></div>\n"; //second usage $item = $ninerows[1]; echo "<div class=\"col-sm-4\"><div class=\"product-image-wrapper\"><div class=\"single-products\"><div class=\"productinfo text-center\"><a3 src=\"$ninerows[1]['a3']\" alt=\"$ninerows[1]['a1']\"><h2>$item['a4']</h2><h5>$item['a1']</h5><a a2=\"$ninerows[1]['a2']\" target=_blank class=\"btn btn-default add-to-cart\"><i class=\"fa fa-shopping-cart\"></i>$item['a5']</a></div></div></div></div>\n"; 
Comments
Post a Comment