How to seperate results in mysql $query?

Add error_reporting(E_ALL), as the first line of your php file, just after the <?php That will show you a few errors to start with. I have seen your query a week ago, and you still have the same mistakes. Your line 6 is your first error (logical and construct)

$result = mysql_query("SELECT * FROM {$table}"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<table><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td>{$field->name}</td>"; } echo "</tr>"; while($row = mysql_fetch_row($result)) { // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell){ echo "<td>$cell</td>"; } } echo "</tr>\n"; mysql_free_result($result);

$result = mysql_query("SELECT * FROM {$table}"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<table><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td>{$field->name}</td>"; } echo "</tr>"; while($row = mysql_fetch_row($result)) { // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell){ echo "<td>$cell</td>"; } } echo "</tr>\n"; mysql_free_result($result);