need help with tables

ckdoublenecks · #1 (**permalink**) 04-02-11, 08:53 PM

I want to read records from the database and print these tables but I need help

PHP Code:


			
<?php
mysql_connect(localhost,root,"");
mysql_select_db(oodb) or die( "Unable to select database");
$query=" SELECT * FROM oocust";
$result=mysql_query($query);
$num=mysql_numrows($result);
?><HTML><HEAD>
<script type="text/javascript">
var monthNames = [ "January","February","March","April","May","June","July",
                   "August","September","October","November","December"     ];
var today = new Date();  
var mmyy = monthNames[today.getMonth()] + " / " + today.getFullYear();
</script>
</HEAD><BODY  bgcolor="#CCCC99" background="oldorchard.jpg"><b><center>
<font size=+2><b> Old Orchard Invoice </font>Date: 
<script type="text/javascript">document.write(mmyy);</script></center><?php>
echo "<TABLE BORDER="0" CELLPADDING="5" CELLSPACING="5" background="oldorchard.jpg">
<TD>
<TABLE BORDER="0" CELLPADDING="10" CELLSPACING="10" background="oldorchard.jpg">
<TD>
<TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" background="oldorchard.jpg">
    <TD>
<input type=text size=25 value="Old Orchard Plumbing"><br>
<input type=text size=25 value="2210 E. Hogan Hollow Road"><br>
<input type=text size=25 value="Margate, Fl  33063"><br></TD>
      <TR>
   <td>
<input type=text size=3 value="Bill To:"><br>
<input type=text size=25 value="$bname"><br>
<input type=text size=25 value="$bstreet:">><br>
<input type=text size=25 value="$bcity"><br>
<input type=text size=25 value="$contact"><br></TD>
      <tr>
   <td>
<input type=text size=5 value="Ship To:"><br>
<input type=text size=25 value="$sname:"><br>
<input type=text size=25 value="$street"><br>
<input type=text size=25 value="$scity"></td>
</TR>
      </TABLE>
      </TD>
     <TD>
<input type=text size=25 value="Invoice No: $invnum"><br>
<input type=text size=25 value="Date: $mm/dd/yyyy"><br>
<input type=text size=25 value="Terms: $terms"><br>
<input type=text size=25 value="Due Date: $duedate"><br>
<input type=text size=25 value="Order No: $ordernum"><br>
<input type=text size=25 value="Territory:"><br>
<input type=text size=25 value="Salesperson:"><br>
</TD>
</TABLE>
</TD>
<TD align=center><img src="dave pic.jpg" width=250 height=350></td>
</TABLE>

echo "</tr>";
<hr>
echo "</table>";mysql_close();
?> </b></BODY></HTML>

ckdoublenecks · #2 (**permalink**) 04-04-11, 01:33 PM

I want to read records from the database and print these tables but I need help - I've trimmed this way down trying to resolve. The only fields that print out are invnum and ordernum and I get this message:

Quote:

while ( = mysql_fetch_assoc(Resource id #5) ) { echo '

<?php?>
<HTML><HEAD>
<script type="text/javascript">
var monthNames = [ "January","February","March","April","May","June", "July",
"August","September","October","November","Decembe r" ];
var today = new Date();
var date = monthNames[today.getMonth()] + " - " + today.getDate() + " - " + today.getFullYear();
</script>
</HEAD><BODY>
</center><div align=right>
<script type="text/javascript">document.write(date);</script>
</div>
<?php
mysql_connect(localhost,root,"");
mysql_select_db(numbersdb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$invnum = $_POST['invnum'];
}
mysql_query("UPDATE numbdata SET invnum=invnum+1");
$result=mysql_query("select invnum from numbdata") or die ("Error - could not retrieve invoice number from database");
$data=mysql_fetch_assoc($result);
echo "Invoice No: ".$data['invnum'];
mysql_close();
mysql_connect(localhost,root,"");
mysql_select_db(oodb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$ordernum = $_POST['ordernum'];
$query=" SELECT * FROM oocust";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
$bname = $_POST['bname'];
$sname = $_POST['sname'];
$terms = $_POST['terms'];
echo "<form action='#' method='post'>
while ($row = mysql_fetch_assoc($result) )
{
echo '<TABLE BORDER=0 CELLPADDING=5 CELLSPACING=5 background='oldorchard.jpg'>
<TD>
<TABLE BORDER=0 CELLPADDING=10 CELLSPACING=10 background='oldorchard.jpg'>
<TD>
<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=1 background='oldorchard.jpg'>
<TD>
<input type=text size=25 value='Old Orchard Plumbing'><br>
<input type=text size=25 value='2210 E. Hogan Hollow Road'><br>
<input type=text size=25 value='Margate, Fl 33063'><br>
</TD>
<TR>
<td>
<input type=text size=4 value='Bill To:'><br>
<input type=text size=25 value='$bname'><br>

<tr>
<td>
<input type=text size=5 value='Ship To:'><br>
<input type=text size=25 value='$sname'><br>

</TR>
</TABLE>
</TD>
<TD>
<input type=text size=5 value='Terms: '>
<input type=text size=12 value='$terms'><br>
<input type=text size=10 value='$ordernum'><br>
</TD>
</TABLE>
</TD>
<TD align=center><img src='dave pic.jpg' width=250 height=350></td>
</TABLE>
<tr>
</tr>
</table>";
echo "</form>";
}
else{echo "No listing for order no. $ordernum.<br />Select another?<br />";}
}
?>
<form method="post" action="#">
<br />
<input type="text" name="ordernum"/> <p>
<input type="submit" name="submit" value="+"/>
</form>