Very close here. All I get in the main option is the word "Array" with other drop down contents below.
Any ideas on what I've got wrong?
Code: Select all
function adhesiveCategory2($paperCategoryId) {
if ($paperCategoryId < 0) {
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">-- Select Option --</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
else {
$sql = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory WHERE paperCategoryId = $paperCategoryId");
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">" .list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql). "</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
}
PS, Thank you for your advice on "column exposed to the public" I will certainly have to look into that. Although this is only an internal app. i'm sure that security will eventually become a concern. tia, will.
if ($paperCategoryId < 0) {
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory"e;);
echo "e;<select name=\"e;paperCategoryId\"e;>"e;;
echo "e;<option value=\"e;\"e;>-- Select Option --</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
else {
$sql = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory WHERE paperCategoryId = $paperCategoryId");
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">" .list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql). "</option>\n";
while(list($paperCategory, $paperCa {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
else {
$sql = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory WHERE paperCategoryId = $paperCategoryId");
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">" .list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql). "</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
}
PS, Thank you for your advice on "column exposed to the public" I will certainly have to look into that. Although this is only an internal app. i'm sure that security will eventually become a concern. tia, will.ther drop down contents below.
Any ideas on what I've got wrong?
Code: Select all
function adhesiveCategory2($paperCategoryId) {
if ($paperCategoryId < 0) {
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">-- Select Option --</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
else {
$sql = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory WHERE paperCategoryId = $paperCategoryId");
$sql_query = mysql_query("SELECT paperCategory, paperCategoryId FROM aupapercategory");
echo "<select name=\"paperCategoryId\">";
echo "<option value=\"\">" .list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql). "</option>\n";
while(list($paperCategory, $paperCategoryId)=mysql_fetch_array($sql_query)) {
$paperCategory = stripslashes($paperCategory);
echo "<option value=\"$paperCategoryId\">$paperCategory</option>\n";
}
echo "</select>";
mysql_free_result($sql_query);
}
}