
Untitled
By: a guest on
May 4th, 2012 | syntax:
None | size: 1.13 KB | hits: 16 | expires: Never
How to split MySQL table records in half to display on each side of a page
$numRows=mysql_num_rows(mysql_query("SELECT * FROM cultures"));
$half = $numRows/2;
$result = mysql_query("SELECT * FROM cultures ORDER BY name ASC LIMIT ".$half);
while($row = mysql_fetch_array($result)) {
$url = "artists.php?culture=".ucfirst($row['name']);
echo '<div class="homepage_culture_item">
<a href="'.$url.'"></a>
<img src="/images/flags/'.$row['name'].'.png" style="width: 30px; vertical-align: middle; margin-right: 10px;" />'.$row['name'].'
</div>
<br />';
}
$half = floor($numRows/2);
$result = mysql_query("SELECT * FROM cultures ORDER BY name ASC");
$half = floor(mysql_num_rows($result)/2);
$count = 0;
// First side.
while($count <= $half
&& $row = mysql_fetch_array($result))
{
// ...
$count++;
}
// ...
// Second side.
while($row = mysql_fetch_array($result))
{
// ...
}
$result = mysql_query("SELECT * FROM cultures ORDER BY name ASC");
$i = 0;
while($row = mysql_fetch_array($result)){
$i++
if($i % 2){
//echo right aligned div
}
else{
//echo left aligned div
}
}