Zergman

I've tried that but can't seem to get the array working. That script is the only thing i've gotten to work. Just need it comma separated to put in my sql statement. Its pulling the values from a multiple select drop box.

How can I covert this to give me a comma separated value? @$color= $_GET['color']; if( is_array($color)){ while (list ($key, $val) = each ($color)) { echo "$val <br>"; } }//else{echo "not array";}

Are you referring to the name="validmenu[]" ? Wasn't sure on the [], read somewhere it was needed for the array but I couldn't tell ya. Removing the [] doesn't seem to affect it

Thanks for the correction xtopolis So this is where it stands right now. Information and help pulled from here and the php manual. This is what I got to gather the data from the listbox and create a comma seperated array. $list = array($_GET['validmenu']); $array = implode(",", $list); echo $array; It gathers only 1 option from the listbox even if I select 2 or more. Read somewhere that in the select box, I need to do a [] in the name. Not sure on this. <select name="validmenu[]" class="inputbox" id="validmenu" size="4" multiple> In my sql statement, im using valid IN ('$array') With all this, when I try it out, the listbox will take only 1 option that I select and puts it in the sql statment as it should. So it looks like my problems are in getting the data into the comma seperated array. .... I think. ugh

This is where my lack of experience shows. Getting syntax error on $list = array('$_GET['validmenu']'); and $list = "$_GET['validmenu']"; Not sure whats wrong

Just going through the implode() manual, would this be better? $list = array('$_GET['validmenu']'); $array = implode(",", $list);

I really appreciate the advise fenway, really do. I am by no means knowledgeable with this stuff ... which is why I do stuff like my search stuff. I just know what I know right now, but always trying to learn how to do stuff better as I go I'll look into that for sure! So should this work then? $list = "$_GET['validmenu']"; $array = implode(',',$list); Sorry for asking, but having a hard time finding out the proper information for this and I don't have access right now to my test server

Not sure what you mean by the sql statement im generating. If you mean the sql statement itself, this is it. SELECT * FROM `data` WHERE tdate between '$startdate%' and '$enddate%' AND t2agent LIKE '$t2agent%' AND flagentTID LIKE '$flagent%' AND resolution LIKE '$conclusion%' AND rescomments LIKE '$conclusioncomments%' AND prov LIKE '$prov%' AND valid IN ('$valid') AND level1 LIKE '$level1%' AND level2 LIKE '$level2%' AND level3 LIKE '$level3%' AND notes LIKE '$notes%' ORDER BY tdate When I echo the sql statement after a query, it only shows the last option I select in the list box, nothing else before that. SELECT * FROM `data` WHERE tdate between '2008-10-30%' and '2008-11-06%' AND t2agent LIKE '%' AND flagentTID LIKE '%' AND resolution LIKE '%%' AND rescomments LIKE '%' AND prov LIKE '%' AND valid LIKE 'Improper Abstract%' AND level1 LIKE '%%' AND level2 LIKE '%' AND level3 LIKE '%' AND notes LIKE '%' ORDER BY tdate There were 2 other options I selected before Improper Abstract

This is what I got so far from the gigerweb, not working as im sure you'll see. Due to my extreme lack of php or programming knowledge, not sure what im doing here. $list = "$_GET['validmenu']"; $array = explode(',',$list); As the good ol' Captain from the Simpsons would say, "Arr... I don't know what im doin"

k, just realized I have no idea how to make a comma-separated array :/

Okay, realized my array wasn't properly done. Not comma-separated Still working on that. Tested my IN() and its working when I directly enter the values into the sql statement so its just the array I need to fix

tried to do ...valid IN ('$val')... in my sql but search is coming up with nothing now

Thanks fenway I did this for the array and its gathering it fine @$validity= $_GET['validmenu']; if( is_array($validity)){ while (list ($key, $val) = each ($validity)) { echo "$val <br>"; } }//else{echo "not array";} But not sure on how to do the in() thing. Checked google and not coming up with much. Got any resources on it that you could share?

I have a listbox in my search page. What I would like to enable is to allow people to select multiple things from the list to add into the search query. Right now, it will only allow 1 item to be searched even if multiple items are selected. How do I go about changing it? Is it to do with the sql statement or the actual list box? SQL "SELECT * FROM `data` WHERE tdate between '$startdate%' and '$enddate%' AND t2agent LIKE '$t2agent%' AND flagentTID LIKE '$flagent%' AND resolution LIKE '$conclusion%' AND rescomments LIKE '$conclusioncomments%' AND prov LIKE '$prov%' AND valid LIKE '$valid%' AND level1 LIKE '$level1%' AND level2 LIKE '$level2%' AND level3 LIKE '$level3%' AND notes LIKE '$notes%' ORDER BY tdate" Box <select name="validmenu" class="inputbox" id="validmenu" size="5" multiple> <option value="%" selected="selected">All</option> <option value="*Valid*">*Valid*</option> <option value="Behaviour">Behaviour</option> <option value="Improper Abstract">Improper Abstract</option> <option value="Improper Route">Improper Route</option> <option value="Invalid STN">Invalid STN</option> <option value="Kudos">Kudos</option> <option value="Other">Other</option> <option value="Policy/Procedure">Policy/Procedure</option> <option value="Poor Ticket Creation">Poor Ticket Creation</option> <option value="Troubleshooting">Troubleshooting</option> </select>

Fantastic stuff! Thanks you guys for the help

Awesome stuff, works like a charm. Thanks guys for the help, both suggestions work fantastic! Just curious now more than anything. Can either of these examples be adapted to more than 2 queries? Say I have a group of 8 queries that I want to calculate the percent. Can I just expand on these or are these meant for only 2?

So if I get the total amount of records from each query and set them as a variable, I can do something like this? $resolved = $_GET['$totalRows_rsdatadisplayrouted']; $routed = $_GET['$totalRows_rsdatadisplayresolved']; then $percent = round ( ( ($resolved/$routed) *100) , 2);

The amount of each varies a lot from month to month, but neither is always the lowest/highest. Im just grabbing the total amount of records from each of the queries above. $totalRows_rsdatadisplayresolved = mysql_num_rows($rsdatadisplayresolved); and $totalRows_rsdatadisplayrouted = mysql_num_rows($rsdatadisplayrouted);

Thanks for the quick reply! I sorta see what your doing, can't picture how to use it in my head. Here are 2 queries that I want to calculate the percent. SELECT * FROM `data` WHERE MONTH(`tdate`) = '$month' AND YEAR(`tdate`) = '$year' AND`data`.status = 'Resolved' SELECT * FROM `data` WHERE MONTH(`tdate`) = '$month' AND YEAR(`tdate`) = '$year' AND`data`.status = 'Routed' Any examples would be greatly appreciated

So I have a bunch of queries on a page and what I want to do is calculate the percent of each one from the total. Say each record has a column with either Value1 or Value2. All of them have either one. I just want to output the percent of each. Value1 = 68% Value2 = 32% Is this done easier via php or mysql?

nevermind, found one that works good. http://www.felgall.com/javatip2.htm Just need a tid bit of advise though. I just need one other field validated and I don't know how to modify this code to validate it. Damn my newbish brain. Here's the field I need validated other than the radio buttons. <input name="Agent_TID" type="text" class="inputbox" id="Agent_TID" value="" size="15" maxlength="6" /> Here's the script function valbutton(thisform) { // place any other field validations that you require here // validate myradiobuttons myOption = -1; for (i=thisform.myradiobutton.length-1; i > -1; i--) { if (thisform.myradiobutton[i].checked) { myOption = i; i = -1; } } if (myOption == -1) { alert("You must select a radio button"); return false; } alert("You selected button number " + myOption + " which has a value of " + thisform.myradiobutton[myOption].value); // place any other field validations that you require here thisform.submit(); // this line submits the form after validation }

Can someone point me to a simple, easy to implement script? Been hitting up google, but there are SO many of them, some don't sound too good.

Thanks for the quick reply. Don't get me wrong, I don't mind using javascript to validate the radio buttons if necessary but what Dreamweaver does behind the scenes is up to it hehe. P.S. I still use Dreamweaver to help me since i'm all self taught, but passed a mile stone yesterday when I went notepad++ 100% since I forgot my laptop at home. Learned a lot!

Not sure if this is the right area, my apologies if it isn't. On my form, I have a couple radio buttons. I don't have them preselected so I need to validate them when the form is submitted. <form action="<?php echo $editFormAction; ?>" method="post" name="myform" id="myform" onsubmit="MM_validateForm('Agent_TID','','RisNum');return document.MM_returnValue"> AB<input name="radio" type="radio" id="abradio" value="AB" /> BC<input type="radio" name="radio" id="bcradio" value="BC" /> I found a bunch of javascript that would do it but would rather not have to use java if not necessary. Any help would be appreciated.

Beautiful, thanks for the help!