Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HOW to: please??!


string

Recommended Posts

how do i make the result of this quey to be displayed on the inde.php TEXT_MAIN

this query will create a table that is just placed on top of the header, i'm going crazy with this..

 

please help!

BTW: query and data exracted are ok, it's just teh formatting thats makeing me nuts!

 

 

 

$customer_query=tep_db_query($sql);

$num_rows=tep_db_num_rows($customer_query);

 

if ($num_rows == 0) {

// do nothing as no user is logged

} else {

 

echo "<TABLE ALIGN=\"CENTER\" BORDER=\"1\">";

echo "<TR><TH>Sender</TH><TH>Tracking Num.</TH><TH>Delivery to the Box</TH></TR>";

 

// We carry out the table population using a 'while' loop

 

while ($row= tep_db_fetch_array($customer_query))

{

$id=$row["sender"];

$var_1=$row["tracking"];

$var_2=$row["deliverybox"];

 

// We display the results under the correct headings

 

 

echo "<TR><TD>$id</TD><TD>$var_1</TD><TD>$var_2</TD></TR>";

 

}

 

}// End else while

 

mysql_free_result($customer_query);

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...