[RESOLVED] embeding data in table

whitewolfspirit

Ok, I know it is something I am overlooking, but I have been at this for hours. I can't see to figure out what I am doing wrong. I have a very small database. 5 columns and 2 rows. I can connect to it and I can get the data to display. I just cannot get it to display in a table. I need it to display in 3 column table with the center column split into two rows. Here is what I have so far...

	<?php

$username = "***";
$password = "***";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
$selected = mysql_select_db("cars",$dbh)
or die("Could not select cars");

$query = "SELECT thumb, date, make, price FROM inventory";
$result = mysql_query($query);

while(list($thumb,$year,$make,$price)= mysql_fetch_row($result))
?>

	<tr>
		<td width="100" rowspan="2"><?php echo $thumb ?></td>
		<td><?php echo $year ?></td>
		<td rowspan="2" width="100"><?php echo $price ?></td>
	</tr>
	<tr>
		<td><?php echo $make ?></td>
	</tr>
</table>

</div>

</html>

Any help would be greatly appreciated.

White Wolf

bogu

Change this line:

$result = mysql_query($query);

to this

$result = mysql_query($query) or die(mysql_error());

Before parsing the results, check if the select return some results:

if(mysql_num_rows($result))

Delimit the while block using curly brackets {}
Where do you open the table tag?
This cell

<td><?php echo $make ?></td>

need to have colspan ...

tomhath

Looks like your WHILE loop is missing the {} braces. That will cause it to read all the rows in the result, then exit the loop and try to display the HTML table with the column variables not set.