Hi,
For some reason, my database results is not going into the table.... Can anyone see the problem... The select query should select all the products from the products DB, and display the relevant info with a text field beside it.....
$query = mysql_query("SELECT ProductId, name, price FROM products")
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($query);
print "<table width=500 border=10 bgcolor=FFFFFF>\n";
print"<th><b>Barcode</b></th><th><b>Name</b></th><th><b>Price</b></th><th><b>Quantity</b></th>\n";
while ($get_info = mysql_fetch_row($query))
{
print "<tr>\n";
print "\t".'<td style="font-family: arial, sans-serif;font-size: 1;">'. $get_info['ProductId'] .'</td>'."\n";
print "\t".'<td style="font-family: arial, sans-serif;font-size: 1;">'. $get_info['name'] .'</td>'."\n";
print "\t".'<td style="font-family: arial, sans-serif;font-size: 1;">'. $get_info['price'] .'</td>'."\n";
print "\t".'<td><input type="text" value="'.
$get_info['price'] .' name="ProductId[]" /></td>'."\n";
print "</tr>\n";
}
print "</table><p>\n";
