[RESOLVED] How can i show this in the table

MitchEvans

How do I get $ProductName to show in the table, with this code it won't show (shown in blue)

$productsql = "SELECT * FROM survey WHERE id = '1'";
$productResults = mysql_query($productsql) or die(mysql_error());
$productRow = mysql_fetch_array ($productResults);
$ProductName = $productRow["requirement_txt"];
//echo $ProductName;
echo'
<FORM method="POST" action="form.php">
<table border="1">
<td>Requirement Type</td><td>Currently In Place</td><td>Required-Essential</td><td>Required-Recommended</td><tr>
<td>$ProductName</td>

mobtex

could be that your echo statement is within ' single quotes so any $variables passed to it will not show.

if you're only needing that one value from your mysql select you should consider using "SELECT reuirement_txt FROM....." rather than "SELECT FROM...." as is a wildcard and will return all the values to memory whereas select requirement_text will only return the value you need making your script run with less memory overhead.

MitchEvans

I've changed the select statement now, yes my echo has single speech marks.
So how will I get it to work here is my code:

$connection = mysql_connect($dbhost, $dbusername, $dbpass) or die (mysql_error());
$SelectedDB = mysql_select_db($dbname,$connection);

$productsql = "SELECT requirement_txt FROM survey";
$productResults = mysql_query($productsql) or die(mysql_error());
while ($productRow = mysql_fetch_array ($productResults)){
$ProductName = $productRow["requirement_txt"];}

echo'
<FORM method="POST" action="form.php">
<table border="1">
<td>Requirement Type</td><td>Currently In Place</td><td>Required-Essential</td><td>Required-Recommended</td><tr>
<td>$ProductName</td>
<td><INPUT type="radio" name="myradio" value="Currently In Place" CHECKED></td>
<td><INPUT type="radio" name="myradio" value="Required Essential"></td>
<td><INPUT type="radio" name="myradio" value="Required-Recommended"></td>
</tr>
<p>
<INPUT type="submit" name="mybutton" value="Submit">
</FORM>';
?>