Connecting Mysql to a form

bbepristis

can someone please help me I am trying to make a form print the values from a mysql database table here is what i have and right now it is printing my header and my footer nothing inbetween

<?php include('header.php');
/SESSION_START();/
if (!isset($SESSION['username'])) {
$username= $SESSION['first_name'];
header ("Location: http://www.upbeataudio.com/dealers/dealer_support.php");
exit();
} elseif (!isset($_SESSION['first_name'])) {
$query = "SELECT * FROM distributor WHERE username = '$username'";
$result = @ ($query);
$row = mysql_fetch_array ($result, MYSQL_NUM);

} else { // No match was made.
$query = "SELECT * FROM retail WHERE username = '$username'";
$result = @ ($query);
$row = mysql_fetch_array ($result, MYSQL_NUM);
}
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<td bgcolor=\"white\">");
printf("<table width=\"780\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">");
printf("<tr> ");
printf("<td width=\"4\" background=\"images/left_border.gif\"><img src=\"images/dot_clear.gif\" width=\"4\" height=\"10\" vspace=\"0\" hspace=\"0\" border=\"0\"></td>");
printf("<td width=\"230\" background=\"images/left_bg.gif\" valign=\"top\"><img src=\"images/left_circle.jpg\" width=\"205\" height=\"245\" vspace=\"0\" hspace=\"0\" border=\"0\"></td>");
printf("<td width=\"510\" background=\"images/home_bg.jpg\" bgcolor=\"white\" valign=\"top\"><p> </p>");
printf("<p> </p>");
printf("<form name=\"Order Form\" method=\"post\" action=\"orderform.php\">");
printf("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");
printf("<tr>");
printf("<td width=\"38%\"><div align=\"right\">Print Materials QTY:");
printf("<input name=\"Print Materials\" type=\"text\" size=\"03\" maxlength=\"04\" Value=\"0\">");
printf("</div></td>");
printf("<td colspan=\"2\">Training Materials QTY:");
printf("<input name=\"Training material\" type=\"text\" size=\"03\" maxlength=\"04\" value=\"0\"></td>");
printf("<tr>");
printf("<tr>");
printf("<td colspan=\"3\"><div align=\"center\">Point-Of-Sale Display Box Qty:<input name=\"point of Sale Display Box\" type=\"text\" size=\"03\" maxlength=\"04\" value=\"0\">");printf("</div></td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">Company:</div></td>");
printf("<td colspan=\"2\"><input type=\"text\" name=\"Company\" Value=\"%s\">", $Company);
printf("<br></td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">Contact Name: </div></td>");
printf("<td colspan=\"2\"><input type=\"text\" name=\"Contact name\" Value=\"%s\">", $contact);
printf("<br></td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">Street Address: </div></td>");
printf("<td colspan=\"2\"><input type=\"text\" name=\"address1\" Value=\"%s\">", $address);
printf("<br></td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">City State, Zip: </div></td>");
printf("<td colspan=\"2\"><input name=\"City\" type=\"text\" size=\"30\" maxlength=\"50\"Value=\"%s\">", $city);
printf("<input name=\"state\" type=\"text\" size=\"03\" maxlength=\"02\"Value=\"%s\">", $state);
printf("<input name=\"Zip\" type=\"text\" size=\"10\" maxlength=\"10\"Value=\"%s\"></td>", $zip);
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">Phone number: </div></td>");
printf("<td colspan=\"2\"><input type=\"text\" name=\"phone\" Value=\"%s\"></td>", $phone);
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\">E-mail:</div></td>");
printf("<td colspan=\"2\"><input type=\"text\" name=\"Email\" Value=\"%s\"></td>", $email);
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\"></div></td>");
printf("<td colspan=\"2\"> </td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\"></div></td>");
printf("<td width=\"16%\"><div align=\"right\">");
printf("<input type=\"submit\" name=\"Submit\" value=\"Submit\">");
printf("</div></td>");
printf("<td width=\"46%\"><input type=\"reset\" name=\"Reset\" value=\"Reset\"></td></tr>");
printf("<tr>");
printf("<td><div align=\"right\"></div></td>");
printf("<td colspan=\"2\"> </td>");
printf("</tr>");
printf("<tr>");
printf("<td><div align=\"right\"></div></td>");
printf("<td colspan=\"2\"> </td>");
printf("</tr>");
printf("</table>");
printf("</p></form></td>");
}while ($myrow = mysql_fetch_array($result));
}
include('footer.php');
?>

AstroTeg

First, do you see your tables you're printf-ing? If not, then your query isn't returning any rows (I'd print the query to the browser and then copy it into phpmyadmin or some tool where you can manually run the query and see what results you get back). If this works, then verify you can see your table. Since you're using mysql_fetch_array(), your query data will be all in $myrow. So to get the data out, you use the associative array approach: $myrow['Company'] instead of $Company.

bbepristis

first of all I dont understand what you are saying about the printf's I have done all my tables in printf statements. secound of all I have tryed that no luck it appears that when you login to this area it is creating a session and I cannot pull any variable from that session hence the mysql querry has no search criteria so I need to figure out how to create a cookie or send variables with the url