Using data from selection list

XxDxX

I'm trying to use HTML form data in a MySQL query. If I require the information to be typed into the form, everything works fine:

 <form action = "<?php echo $PHP_SELF ?>" method = "POST">
<input type = "text" name = "Hostessname">
<input type = "submit" value = "Hostess">

<?php

$query1 = "SELECT * FROM Products,Inventory_transactions,Show_info_access, Sales_consultants WHERE 
Products.ProductID = Inventory_transactions.ProductID AND 
Inventory_transactions.ConsultantID = Sales_consultants.ConsultantID AND 
Inventory_transactions.ShowID = Show_info_access.ShowID AND 
Show_info_access.Hostess = '$_POST[Hostessname]' 
ORDER BY Products.SKU";

However, I'd like my form data to come from a list box. The following script successfully creates the list box, but when I submit my selection, I get an error (The requested URL /< was not found on this server).

 <?php

$query_hostess = "SELECT DISTINCT Hostess FROM Show_info_access ORDER BY Hostess";
$result_hostess = mysql_query ($query_hostess) or die ("Couldn't find hostess");
echo "<form action = '<?php echo $PHP_SELF ?>' method = 'POST'>
	<select name = 'Hostess'>\n"; 

while ($row = mysql_fetch_array($result_hostess))
{
	extract($row);
	echo "<option value = '$Hostess'>$Hostess\n";
}
	echo "</select>\n";
	echo "<input type = 'submit' value = 'Select Hostess'>
	</form>\n";



$query1 = "SELECT * FROM Products,Inventory_transactions,Show_info_access, Sales_consultants WHERE 
Products.ProductID = Inventory_transactions.ProductID AND 
Inventory_transactions.ConsultantID = Sales_consultants.ConsultantID AND 
Inventory_transactions.ShowID = Show_info_access.ShowID AND 
Show_info_access.Hostess = '$_POST[Hostess]' 
ORDER BY Products.SKU";

I'm new to PHP and I assume I must be making a pretty basic error. I hope someone can enlighten me!

devinemke

"view source" on your HTML form and make sure the HTML is getting mangled. i suspect the quotes are screwing you up. if any of the Hostess's have single quotes then that will screw up the HTML output.

XxDxX

Thanks for your insight.

I've taken a look at the source and sure enough, one of the hostess's had a quote in the name.

I've removed this quote, but I get the same result...

devinemke

as a general rule, use double quotes for all HTML tag delimiters. this allows the easy use of single quotes within tag attributes. you can always use [man]htmlspecialchars[/man] to properly escape double quotes within tag attributes.

as far as your error, it is a standard server 404. is sounds like the path specified in your form action tag is mangled.

Roger_Ramjet

Get your html right first

echo '<form action ="' . $_SERVER['$PHP_SELF'] . '" method = "POST"><select name = "Hostess">'; 

while ($row = mysql_fetch_array($result_hostess))
{
    echo '<option value = "' . $row['Hostess'] . '">' . $row['Hostess'] . '</option>';
}
    echo '</select><br />';
    echo '<input type = "submit" value = "Select Hostess" />';
   echo '</form>';

XxDxX

Problem solved!

You were right. The issue was the path specified in the form action tag. I reduced it to:

form action = '$PHP_SELF'

and it worked.

Thanks.