<?
$number_of_cells = 9;
$number_of_cells_per_row = 4;
$number_of_rows = ceil($number_of_cells / $number_of_cells_per_row);
$cell_count = 0;
$display_count = 0;
while($row_count!=$number_of_rows){
for($j=1;$j<=$number_of_cells_per_row;$j++){
$cell_count++;
if($cell_count<=$number_of_cells){
echo $display_count+$j." ";
}else{
echo "X ";
}
}
$display_count=$display_count+$j-1;
$row_count++;
echo "end of row\n";
}
?>//Before this, make a msyql_query return a value to variable $result.
while ($row = mysql_fetch_array($result))
{
$value = $row['column_name'];
//do this as much as necessary to retrieve
//the data for this particular result.
?>
<tr><td>Put data here.</td></tr>
<?php
}
?>compuXP said:
<?php
mysql_connect ("localhost", "username", "password")
or die("MySQL Error : <b>" . mysql_error(); . "</b>");
mysql_select_db ("dbname")
or die("MySQL Error : <b>" . mysql_error(); . "</b>");
// finally we start the query
$sql = mysql_query("SELECT * FROM tablename");
while ($result = mysql_fetch_array($sql)) {
// Escaping from php mode to html mode
?>
<table widht="90%" align="center" cellpadding="1" cellspacing="1" border="0">
<?php
// back to php mode
print "<tr>";
print "<td>data :" . $result['columnname'] . "</td>";
print "<tr>";
}
// Escaping from php mode to html mode
?>
</table>
<?php
// back to php mode
if (count($result) < 1) {
die ("<b>Error : No record are to be found in the database table</b>");
}
?>
compuXP said:Actually, lux, it works fine
// setup the database query...
$query = "Your Query Here";
$result = mysql_query($query);
// Extract info for each result...
while($row = mysql_fetch_array($result)){
// give a name to each of the database table fields...
$variableone = $row["field 1"];
$variabletwo = $row["field 2"];
$variablethree = $row["field 3"];
// display the results...
echo "<div class=\"rowdiv\">
<div class=\"tddivone\">$variableone</div>
<div class=\"tddivtwo\">$variabletwo</div>
<div class=\"tddivthree\">$variablethree</div>
</div>";
} $result = mysql_query ($query);
echo ('<table border="1">');
$total_records = mysql_num_rows($result);
$cell_max=4;
$records = 1;
$cell_num=1;
while ($returned_row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ($cell_num==1){
echo ('<tr>');
}
if ($records <= $total_records){
echo ("<td><p>{$returned_row[name]}, {$returned_row[img_name]}</p></td>\n");
$records++;
$cell_num++;
//put empty td's where needed
if (($records > $total_records) and ($cell_num < $cell_max)){
for ($remaining = $cell_num; $remaining < $cell_max; $remaining++){
echo ("<td>ย </td>");
}
}
if ($cell_num==$cell_max){
echo ('</tr>');
$cell_num=1; //resets $cols after every 3
}
}// end if records
}// end of while loop
echo ('</table>');luxinterior said:
