Placing sales figures into table

[mikebyrne]

I want to put my sales figures into the table below. The table name is Sales which is linked by using

 

  require_once('adminconnect.php');
  $tbl2 = 'sales';

 

The fields in the table are Date, Total Orders & Revenue. What would the php be to place this into a table?

 

 

<form>	
<!-- data title start -->
<div id="containerBg2">
	<div class="padTop2"><!-- --></div>

	<div class="clr"><!-- --></div>
	<div class="titleBox">
		<table width="850" border="0" cellspacing="0" cellpadding="0">
			<tr align="left">
				<td width="33"> </td>
				<td width="87"><a href="#">date</a></td>
				<td width="43" align="right"><a href="#">orders</a></td>
				<td width="118" align="right"><a href="#">revenue</a></td>

				<td width="569"> </td>
		  </tr>
	  </table>
	</div>
	<div class="clr"><!-- --></div>
</div>
<div class="clr"><!-- --></div>
<!-- data title finish -->



<!-- 1px space start -->

<div id="containerBg1">
	<div class="padTop1"><!-- --></div>
	<div class="clr"><!-- --></div>
</div>
<div class="clr"><!-- --></div>
<!-- 1px space finish -->



<!-- data top start -->
<div id="containerBg3">
	<div class="padTop1"><!-- --></div>

	<div class="clr"><!-- --></div>
</div>
<div class="clr"><!-- --></div>
<!-- data top finish -->



<!-- data content start -->
<div id="containerBg4">





<!-- data btm start -->
<div id="containerBg3">
	<div class="padTop1"><!-- --></div>
	<div class="clr"><!-- --></div>
</div>

<div class="clr"><!-- --></div>
<!-- data btm finish -->





<!-- btm start -->
<div id="containerBg1">
	<div class="padTop15"><!-- --></div>
	<div class="clr"><!-- --></div>
</div>
<div class="clr"><!-- --></div>
<div id="container">

	<div id="line"><!-- --></div>
</div>
<div class="clr"><!-- --></div>
<div class="padTop16"><!-- --></div>
<div class="clr"><!-- --></div>
<!-- btm finish -->

</form>

[revraz]

Query the DB, do a SELECT *, use a while loop and mysql_fetch_array, then echo each row like

 

echo $row[0];

echo $row[1];

 

etc

[mikebyrne]

Like

 

<?php

include('adminconnect.php');
$sql = mysql_query("SELECT Date, Total Orders, Revenue FROM sales ");
while( $row = mysql_fetch_array($sql) ) {

?>

<tr align="left">  
<td width="87" align="center"><?php echo $row['Date'];?></td>
<td width="43" align="Left"><?php echo $row['Total Orders'];?></td>
<td width="118" align="center"><?php echo $row['Revenue'];?></td>
</tr>


<?
}
?>
</table>

 

[revraz]

You tell me 

 

Use <?php on that second tag though instead of just <?

[mikebyrne]

getting the error

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Admin_files\Sales.php on line 152

 

line 152 refers above the first ?>

[revraz]

Your query isn't valid.  Just do a SELECT *

 

You can also add a mysql_error() after your query to find the error.

[mikebyrne]

How do i get the figures in line with my headings and also appear row by row as opposed to next to each other?

[revraz]

TR is for a new Row

TD is for data in a Row

[mikebyrne]

yeah i know that my code is

 

<tr align="left">  
<td width="87" align="center"><?php echo $row['Date'];?></td>
<td width="43" align="Left"><?php echo $row['Total Orders'];?></td>
<td width="118" align="center"><?php echo $row['Revenue'];?></td>
</tr>

 

It goes through the loop but puts the results next to each other as opposed to on  new row

[Aureole]

EDIT: Nevermind, I didn't read your post properly...

[mikebyrne]

Still cant get it to post the results underneath each other!!

[revraz]

Post a screenshot of what you mean.

[mikebyrne]

How do i insert a screenshot between the image tags???

[mikebyrne]

The results are printing out like:

 

 

date  orders  revenue 

2008-02-05 50 13000 2008-02-06 56 17000

 

But id like them to be something like

 

date  orders  revenue 

  2008-02-05 50            13000

  2008-02-06 56            17000

[Aureole]

Use a table.