[RESOLVED] Get Dropdown Values

damienmcd

HI,

I am having trouble getting the values from a dropdown <SELECT>list and using the selected value as a part of my SQL statement.

I am using the following in my PHP:

$field = $_POST['field_drop'];


// sending query for data
$result1 = mysql_query("SELECT '$field' FROM mail WHERE date BETWEEN '$start_date' AND '$end_date' ORDER BY date ASC");
if (!$result1) {
    die("Query to show fields from table failed");
}

and the following form in my HTML:

			<SELECT name="field_drop">
				<OPTION VALUE="sentwebmails">Sent Webmails</OPTION>
				<OPTION VALUE="sentfromsitedotcom">Sent from site.com</OPTION>
				<OPTION VALUE="senttositemode">Sent to siteMode</OPTION>
				<OPTION VALUE="receivedtositedotie">Received to site.ie</OPTION>
				<OPTION VALUE="rejected">Rejceted</OPTION>
				<OPTION VALUE="total">Total</OPTION>
			</SELECT>
<input type="submit" value="Field">

If I just try print the output using <?php print $field ?> within my HTML it will print the selected option but the SQL querl will not bring back any data.

If anyone can help me I would be greatly appreciative.
Thanx in advance!!

OOP

try to modify you code as follows

$field = $_POST['field_drop']; 


// sending query for data 
$result1 = mysql_query("SELECT '".$field."' FROM mail WHERE date BETWEEN '$start_date' AND '$end_date' ORDER BY date ASC"); 
if (!$result1) { 
    die("Query to show fields from table failed"); 
}

SoulAssassin

This is a little confusing.
I take it the values in your 'field_drop' form, is real fields in your 'mail' table?
Then you are trying to select only that field from your mail table, ad do what with?
What is it that you are trying to do? Maybe explain a little better.

damienmcd

Got it working and it was the biggest n00b mistake I have ever made!

What I had:

$result1 = mysql_query("SELECT '$field' FROM mail WHERE date BETWEEN '$start_date' AND '$end_date' ORDER BY date ASC");

What I should have had (The same except I took the quotes away from the $field variable):

$result1 = mysql_query("SELECT $field FROM mail WHERE date BETWEEN '$start_date' AND '$end_date' ORDER BY date ASC");

Thanx for the help anyway guys!!!