CODEWITHSUNDEEP
phphtmlmysqlsql
Arw50452
Arw50452

Reputation: 325

Populating an HTML Table from SQL DB with PHP

I'm attempting to populate a table in HTML with data from a DB. It's not working properly (a blank white page is displayed), but I can't find the source of the error. 

<?php    
$sql = "SELECT * FROM Orders";
$result = mysql_query($sql)or die(mysql_error());

echo "<table>";
while($row = mysql_fetch_array($result)){
  $order_id = $row['orderID'];
  $order_due = $row['order_due'];
  $order_subject = $row['order_subject'];
  $order_level = $row['order_level'];
  $order_pages = $row['order_pages'];
  $order_cost = $row['order_cost']); 
  echo "<tr><td>".$order_id."</td><td>".$order_due."</td><td>".$order_subject."</td><td>".$order_level."</td><td>".$order_pages."</td><td>".$order_cost."</td></tr>";   
}
 echo "</table>";
 ?>

Upvotes: 1

Views: 2487

Answers (2)

Mihai
Mihai

Reputation: 26784

$order_cost = $row['order_cost']);

you have an extra paranthesis

Also change this

while($row = mysql_fetch_array($result))

to

while($row = mysql_fetch_assoc($result))

Upvotes: 1

deathek
deathek

Reputation: 31

I think you need to change third line to:

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

(space before "or")

Upvotes: 0

Related Questions