Hello, hoping someone will help with issue. I'm trying to display values from
database fields within html. The only thing displayed is the date. The error
is set as it is to remove the notices "undefined variable".
database fields within html. The only thing displayed is the date. The error
is set as it is to remove the notices "undefined variable".
PHP:
<?php
// error_reporting(E_ALL ^ E_NOTICE);
error_reporting(0);
mysql_connect('localhost','root','');
mysql_select_db('oodb') or die("Unable to select database");
$query="SELECT acctno,pd,payrec,orderno,
bname,bstreet,bcity,bstate,bzip,
sname,sstreet,scity,sstate,szip,
terms,duedate
FROM FROM oocust WHERE payrec = 'R' && pd = 'N'";
$result=mysql_query($query);
if(mysql_num_rows($result) )
{
while(list($acctno,$pd,$payrec,$orderno,
$bname,$bstreet,$bcity,$bstate,$bzip,
$sname,$sstreet,$scity,$sstate,$szip,
$terms,$duedate)= mysql_fetch_row($result))
{
}
}
?>
Code:
<input type="text" STYLE="color: #000000; background-color: #D4FFD4;" size=25 value="Old Orchard Plumbing">
<input type="text" STYLE="color: #000000; background-color: #D4FFD4;" size=30 value="2210 E. Hogan Hollow Road">
<input type="text" STYLE="color: #000000; background-color: #D4FFD4;" size=25 value="Margate, Fl 33063"><p>
<input type="text" STYLE="color: #000000; background-color: #D4FFD4;" size=15 value="Billing Date">
<input type="text" STYLE="color: #000000; background-color: #D4FFD4;" size=25 value="Account#"><br>
[B]<input type="text" STYLE="color: #000000; background-color: #AAFFAA;" size=15 name="Date" [COLOR="Red"]value="<?php echo date('m/d/y');?>">[/COLOR]
<input type="text" STYLE="color: #000000; background-color: #AAFFAA;" size=25 name="acctno" [COLOR="Red"]value="<?php echo $acctno;?>">[/COLOR]
[/B]