Sorting MySQL data in a GRID

Submitted by:Pitter Alderson

Date added:23 October, 2012

Category:MySQL

MySQL code example for sorting data in a GRID

Tags: sorting data

Code Snippet:

<?php
//basic mysql connection, you'd want to use a DB class or something
$connect = @mysql_connect("localhost","username","password") or die("Could not connect to server.");
$db = @mysql_select_db("database") or die(mysql_error());
$query = "SELECT * FROM table";
$result = @mysql_query($query) or die("Could not execute query");
$check = mysql_num_rows($result);
if ($check == 0) {
echo "Table is empty.";
} else {
?>
<table>
<?php
$i = 1;
while ($row = mysql_fetch_array($result)) {
if ($i == 1) {
?>
<tr>
<?php
}
?>
<td><?php echo $row['column']; ?></td>
<?php
if ($i == 7) { /* here we have 7 columns per row, if you want 10 columns just change this value to 10 instead of 7 */
$i = 0;
?>
</tr>
<?php
}
$i++;
}
?>
</tr>
</table>
<?php
}
?>
 
 

Comments