trying to display database
Posted: 24. July 2010 18:11
I'm using Xampp, have created and populated a database "addtransdb" with a table "addtransinfo" and am trying to use the below program to display the table. It displayed when I created the table (generated by: phpmyadmin 3.2.4 / MYSQL 5.1.41 - SQL quert: SELECT * FROM 'addtransinfo' LIMIT 0,30 ; ) so I guess the problem is here in my program? I'm runnning win2000 prof,
<?php
$username="me";
$password="mine";
$database="addtransdb";
mysql_connect("localhost", "root", "");
@mysql_select_db($database) or die( "Unable to select database");
$query=" SELECT * FROM 'addtransinfo';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<html><HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><!-- this program is designed to show the database contents in a table
<META content="MSHTML 6.00.2800.1649" name=GENERATOR>
<META content="MSHTML 6.00.2800.1649" name=GENERATOR></HEAD>
<BODY><B><FONT size=+2>Project: Hammock Oaks In-house transfers & Add-ons</FONT>
<FORM>
<TABLE cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TH>Appl</TH>
<TH>.</TH>
<TH>.</TH>
<TH>.</TH>
<TH>Race &</TH>
<TH>Ethnic-</TH>
<TH>.</TH>
<TH>Displ.</TH>
<TH>Income</TH>
<TH>B/r s </TH>
<TH>Movein</TH>
<TH>Removal</TH>
<TH>.</TH>
<TH>.</TH>
<TR>
<TH>#</TH>
<TH>Date</TH>
<TH>Time</TH>
<TH>Name</TH>
<TH>Gender</TH>
<TH>City</TH>
<TH>LH %</TH>
<TH>Y/N</TH>
<TH>Level</TH>
<TH>Needed</TH>
<TH colSpan=2>Date</TH>
<TH>Code</TH>
<TH>Comments</TH></TR></TBODY></TABLE>
<?php
$i=0;
while ($i < $num) {
if ($num==0) {
echo "the database contains no contacts yet";
} else {
$appl=mysql_result($result,$i,"appl");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$name=mysql_result($result,$i,"name");
$racegend=mysql_result($result,$i,"racegend");
$ethnicity=mysql_result($result,$i,"ethnicity");
$laborhsg=mysql_result($result,$i,"laborhsg");
$displ=mysql_result($result,$i,"displ");
$incomelevel=mysql_result($result,$i,"incomelevel");
$brneeded=mysql_result($result,$i,"brneeded");
$moveindate=mysql_result($result,$i,"moveindate");
$removaldate=mysql_result($result,$i,"removaldate");
$code=mysql_result($result,$i,"code");
$comments=mysql_result($result,$i,"comments");
?>
<?php
<tr><TD><? echo $appl; ?></TD><TD><? echo $date; ?></TD><TD><? echo $time; ?></TD><TD><? echo $name; ?></TD><TD><? echo $racegend; ?></TD><TD><? echo $ethnicity; ?></TD><TD><? echo $laborhsg; ?></TD><TD><? echo $displ; ?></TD><TD><? echo $incomelevel; ?></TD><TD><? echo $brneeded; ?></TD><TD><? echo $moveindate; ?></TD><TD><? echo $removaldate; ?></TD><TD><? echo $code; ?></TD><TD><? echo $comments; ?></TD></TR>
<?php
$i++;
}
echo "</table>";
$i++;
}
?>
</B></FORM>
<P></P></BODY></HTML>
<?php
$username="me";
$password="mine";
$database="addtransdb";
mysql_connect("localhost", "root", "");
@mysql_select_db($database) or die( "Unable to select database");
$query=" SELECT * FROM 'addtransinfo';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<html><HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><!-- this program is designed to show the database contents in a table
<META content="MSHTML 6.00.2800.1649" name=GENERATOR>
<META content="MSHTML 6.00.2800.1649" name=GENERATOR></HEAD>
<BODY><B><FONT size=+2>Project: Hammock Oaks In-house transfers & Add-ons</FONT>
<FORM>
<TABLE cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TH>Appl</TH>
<TH>.</TH>
<TH>.</TH>
<TH>.</TH>
<TH>Race &</TH>
<TH>Ethnic-</TH>
<TH>.</TH>
<TH>Displ.</TH>
<TH>Income</TH>
<TH>B/r s </TH>
<TH>Movein</TH>
<TH>Removal</TH>
<TH>.</TH>
<TH>.</TH>
<TR>
<TH>#</TH>
<TH>Date</TH>
<TH>Time</TH>
<TH>Name</TH>
<TH>Gender</TH>
<TH>City</TH>
<TH>LH %</TH>
<TH>Y/N</TH>
<TH>Level</TH>
<TH>Needed</TH>
<TH colSpan=2>Date</TH>
<TH>Code</TH>
<TH>Comments</TH></TR></TBODY></TABLE>
<?php
$i=0;
while ($i < $num) {
if ($num==0) {
echo "the database contains no contacts yet";
} else {
$appl=mysql_result($result,$i,"appl");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$name=mysql_result($result,$i,"name");
$racegend=mysql_result($result,$i,"racegend");
$ethnicity=mysql_result($result,$i,"ethnicity");
$laborhsg=mysql_result($result,$i,"laborhsg");
$displ=mysql_result($result,$i,"displ");
$incomelevel=mysql_result($result,$i,"incomelevel");
$brneeded=mysql_result($result,$i,"brneeded");
$moveindate=mysql_result($result,$i,"moveindate");
$removaldate=mysql_result($result,$i,"removaldate");
$code=mysql_result($result,$i,"code");
$comments=mysql_result($result,$i,"comments");
?>
<?php
<tr><TD><? echo $appl; ?></TD><TD><? echo $date; ?></TD><TD><? echo $time; ?></TD><TD><? echo $name; ?></TD><TD><? echo $racegend; ?></TD><TD><? echo $ethnicity; ?></TD><TD><? echo $laborhsg; ?></TD><TD><? echo $displ; ?></TD><TD><? echo $incomelevel; ?></TD><TD><? echo $brneeded; ?></TD><TD><? echo $moveindate; ?></TD><TD><? echo $removaldate; ?></TD><TD><? echo $code; ?></TD><TD><? echo $comments; ?></TD></TR>
<?php
$i++;
}
echo "</table>";
$i++;
}
?>
</B></FORM>
<P></P></BODY></HTML>