Multiple Issues - HELP. - PHPBuilder Forums

Multiple Issues - HELP.

Shamrox

Ok, I need a bit of help. I created this page to best describe what i'm trying to do.

http://www.metrodesignworks.com/moms/main2.php

I appreciate any help you can give.

thorpe

page not found. how about you just tell us what the problem is?

Shamrox

Hmm, works fine here. Ok, here goes...

Two drop downs on page.
Both drops are populated from database.
These drops would have the same values, but display different
names. So the user could select either by the ID number (first drop) or the Name (second drop).

Each time an item was selected, it would be added to the textbox below the drops, creating a string of ID's that would be passed to the query to create a mailing list using the below query.

SELECT DISTINCT firstname, lastname, street1, street2, city, state, zipcode, zip4, country, countrycode, MAX(quantity) FROM moms_customer, moms_lists WHERE moms_customer.custnumber = moms_lists.custnumber AND pubid = (string of ID's from textbox) GROUP BY lastname

What I don't know how to do is get the multiple selections to go into that textbox, and then pass it to the next page containing the above query and use it for output. HELP!!

thorpe

sounds more like a javascript issue to me. it would be the long way around doing this server side.

Shamrox

Yeah, I have played with the javascript a bit, almost there but not complete. So, say I get that down, and I have a textbox filled with a string of ID's...what next? What's the code need to look like to pass that string to the Query that I posted?

thorpe

if you can get the values into a string like...

$vals = '22,43,55,45,87';

your query might be something like...

$query = "SELECT DISTINCT firstname, lastname, street1, street2, city, state, zipcode, zip4, country, countrycode, MAX(quantity) FROM moms_customer, moms_lists WHERE moms_customer.custnumber = moms_lists.custnumber AND pubid = IN($vals) GROUP BY lastname";

matto

<?

if(isset($_POST['ok']))	// submit button pressed
{
	$_POST['display'] = trim($_POST['display']);
	if($_POST['display'] == '')
	{
		die("nothing chosen.");
	}
	else 
	{
		$sql = "SELECT DISTINCT firstname, lastname, street1, street2, city, state, zipcode, zip4, country, countrycode, MAX(quantity) FROM moms_customer, moms_lists WHERE moms_customer.custnumber = moms_lists.custnumber AND pubid IN($display) GROUP BY lastname";
		die($sql);
	}
}

?>
<html>
<head>
<script>

function addToField(selbox)
{
	selectedIndex = selbox.options.selectedIndex;
	selectedValue = selbox.options[selectedIndex].value;

if(selectedValue == "" || isNaN(selectedValue))
	return;

if(document.myForm.display.value != "")
	document.myForm.display.value += ",";

document.myForm.display.value += selectedValue;
}

</script>
</head>
<body>
<form name="myForm" method="POST" action="<?=$_SERVER['PHP_SELF'] ?>">
<select size="1" name="select1" onChange="addToField(this);">
<option>Choose:</option>
<option value="1">one</option>
<option value="2">two</option>
<option value="3">three</option>
<option value="4">four</option>
</select>
<select size="1" name="select2" onChange="addToField(this);">
<option>Choose:</option>
<option value="1">un</option>
<option value="2">deux</option>
<option value="3">trois</option>
<option value="4">quatre</option>
</select><br />
<input type="text" name="display"><br />
<input type="submit" name="ok" value="Ok">
</form>
</body>
</html>

important note!!!
I wrote this due to technical interest, but you should NEVER just insert user input into an sql statement (risk of sql injection! huge security leak!) UNLESS it is in a highly secured private area where no ordinary and unknown user has access.

a more secure alternative would be to use a multiple select box:
<select name="blah[]" size="5" multiple="multiple">

this creates a listbox where one can choose many items by holding the Strg key when clicking.

the brackets after the name ensure php will receive value in form of an array.

Shamrox

Thanks for the heads up. It is def going to be in a secure environment, internal use only, but i think I'll use the multi select box anyway.

Shamrox

Matto, just tried that code, adjusted it to pull the drops from the database and it worked like a charm.

YOU ARE THE MAN!!!! Thanks.