[RESOLVED] Want to put list results into table

[mcubedma]

Hi. Hope someone can help me with my php code. This is a piece of the code that is retrieving data from a MySQL database. The code works to list the results, but I would like to display them in a table. i would appreciate any suggestions. Thank you.

//get all car_desc
$get_car_sql = "SELECT car_id, year,  model,  body_num,  engine_num,  designer,  builder,  body_style, cond FROM car_desc
                WHERE mbr_id = '".$_POST["sel_id"]."'";
$get_car_res = mysqli_query($mysqli, $get_car_sql) or die(mysqli_error($mysqli));

if (mysqli_num_rows($get_car_res) > 0) {

	while ($car_info = mysqli_fetch_array($get_car_res)) {
		$car_id = stripslashes($car_info['car_id']);
		$year = stripslashes($car_info['year']);
		$model = stripslashes($car_info['model']);
		$body_num = stripslashes($car_info['body_num']);
		$engine_num = stripslashes($car_info['engine_num']);
		$designer = stripslashes($car_info['designer']);
		$builder = stripslashes($car_info['builder']);
		$body_style = stripslashes($car_info['body_style']);
		$cond = stripslashes($car_info['cond']);

		$display_block .= "<p>$car_id<br>$year<br>$model<br>$body_num<br>$engine_num<br>$designer<br>
		$builder<br>body_style<br>$cond</p>";
	}

}

//free result
mysqli_free_result($get_car_res);

[TheDefender]

Not too clear on how you want your table to be structured, but this should get you started and at the very lest, give you an idea of what to do.

//get all car_desc
$get_car_sql = "SELECT car_id, year, model, body_num, engine_num, designer, builder, body_style, cond FROM car_desc
WHERE mbr_id = '".$_POST["sel_id"]."'";
$get_car_res = mysqli_query($mysqli, $get_car_sql) or die(mysqli_error($mysqli));

if (mysqli_num_rows($get_car_res) > 0) {

echo '<table>';
echo '<tr>';
echo '<th>Car ID</th><th>Year</th><th>Model</th><th>Body Number</th><th>Engine Number</th><th>Designer</th><th>Builder</th><th>BOdy Style</th><th>Condition</th>';
echo '</tr>';

while ($car_info = mysqli_fetch_array($get_car_res)) {
	$car_id = stripslashes($car_info['car_id']);
	$year = stripslashes($car_info['year']);
	$model = stripslashes($car_info['model']);
	$body_num = stripslashes($car_info['body_num']);
	$engine_num = stripslashes($car_info['engine_num']);
	$designer = stripslashes($car_info['designer']);
	$builder = stripslashes($car_info['builder']);
	$body_style = stripslashes($car_info['body_style']);
	$cond = stripslashes($car_info['cond']);

echo '<tr>';
echo '<td>$car_id</td><td>$year</td><td>$model</td><td>$body_num</td><td>$engine_num</td><td>$designer</td><td>
$builder</td><td>body_style</td><td>$cond</td>';
echo '</tr>';
}

echo '</table>';

}

//free result
mysqli_free_result($get_car_res);

[mcubedma]

Thanks for the reply. This looks much closer, but my database values are not printing in the table. Here is what I am getting:
Car ID Year Model Body Number Engine Number Designer Builder Body Style Condition
$car_id $year $model $body_num $engine_num $designer $builder $body_style $cond
$car_id $year $model $body_num $engine_num $designer $builder $body_style $cond

Do you have any idea what I am missing?

Thanks!

[mcubedma]

I figured it out. I needed double quotes instead of single quotes in the echo statements. Thanks for your help, Defender.

[TheDefender]

My apologies to you on that... I'm not really sure why I missed that. I wasn't that tired last ngiht. ;-) Either way, glad you got it figured out.