Year shouldn't be a multiple
At the beginning of the second two selects:
<option value='blank'></option>
in your check:
if ( isset($_GET['state'] && $_GET['year']<>'blank' && $_GET['term']<>'blank')
{
//ok, they selected something in all three of those so lets run
some code here
} else {
//they didn't populate all three selects, spit an error message at them
}
On Mon, 18 Oct 2004 07:00:36 -0700, bruce <[EMAIL PROTECTED]> wrote:
> the code is pretty much as i provided. the issue is that the query seems to
> insert a value into the query string for the select lists, even though i
> don't actually select an item.
>
> i'm trying to figure out what has to happen to allow the select vars to be
> '' if the user hasn't selected anything.
>
> this should be pretty straight forward, but i'm missing something...
>
> thanks
>
> -bruce
>
>
>
>
> -----Original Message-----
> From: Greg Donald [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 17, 2004 6:14 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] probs generating multiple drop down select lists
> within a single form
>
> On Sun, 17 Oct 2004 17:23:14 -0700, bruce <[EMAIL PROTECTED]> wrote:
> > i have a prob/issue that i can't see.. i'm trying to geneate a page with
> > multiple lists so that the user has to select an item from all 3 lists in
> > order to access the next page...
> >
> > the 1st select/list allows the user to select either one or more items.
> the
> > 2nd/3rd select lists require the user to select only a single item from
> the
> > lists.
> >
> > ie:
> > list1 list2 list3 >submitBTN<
> >
> > the user would select the items from all three lists, and hit the
> selectBTN,
> > to go to the next page...
> >
> > the prob that i'm having is that if i simply select item(s) from the 1st
> > list, then the code allows the user to continue...in other words, the app
> > looks as though the user has selected an item from the 2nd/3rd even though
> > they haven't been selected... in examining the code, it appears that the
> > last item in the 2nd/3rd lists is being somehow read/inserted into the
> > items, and are somehow included in the querystring...
> >
> > my code is:
> >
> > /*
> > generate the state list
> > */
> > echo"
> > <div style='position:absolute; top:320px; left:50px; width:400px;'>
> > <form name='test' method='get' action='$foo.php'>
>
> Why $foo here? Maybe not enough context for me to understand the
> reason, I dunno.
>
> > <div style='position:relative; top:10px; left:10px;'>
> > <select multiple size=10 name='state[]'>
> > ";
> >
> > $state_query = "select * from stateTBL";
> > $res = mysqli_query($link, $state_query);
> > //$res = mysql_query($query);
> >
> > //go ahead and process/populate the drop down
> > //menu
> > echo "<option value ='*'>All States</option>\n";
> > while($row = mysqli_fetch_array($res, MYSQL_ASSOC))
> > {
> > echo "<option value
> > ='".$row['val']."'>".$row['name']."</option>\n";
> >
> > }
> >
> > echo"
> > </select>
> > </div>
> > ";
> >
> > /*
> > generate the year list
> > */
> > echo"
> > <div style='position:absolute; top:10px; left:240px; width:100px;'>
> > <select multiple size=1 name= 'year'>
> > ";
>
> Did you mean year[] here? Otherwise why multiple?
>
> > $year_query = "select * from yearTBL";
> > $res = mysqli_query($link, $year_query);
> > //$res = mysql_query($query);
> >
> > //go ahead and process/populate the drop down
> > //menu
> > while($row = mysqli_fetch_array($res, MYSQL_ASSOC))
> > {
> > echo "<option value
> > ='".$row['year']."'>".$row['year']."</option>\n";
> > }
> >
> > echo"
> > </select>
> > </div>
> > ";
> >
> > /*
> > generate the terms list
> > */
> > echo"
> > <div style='position:absolute; top:10px; left:325px; width:100px;'>
> > <select name= 'term'>
> > ";
> >
> > $term_query = "select * from termTBL";
> > $res = mysqli_query($link, $term_query);
> > //$res = mysql_query($query);
> >
> > //go ahead and process/populate the drop down
> > //menu
> > while($row = mysqli_fetch_array($res, MYSQL_ASSOC))
> > {
> > echo "<option value
> ='".$row['ID']."'>".$row['term']."</option>\n";
> > }
> >
> > echo"
> > </select>
> > </div>
> > ";
> >
> > $blah = $userdata['session_id'];
> >
> > echo"
> > <div style='position:relative; top:-150px; left:475px;'>
> > <input type='submit' name='sub1' value='submit'>
> > </div>
> > <input type ='hidden' name='sid' value='$blah'>
> > <input type='hidden' name='display' value='state'>
> > </form>
> > </div>
> > ";
> >
> > in foo.php, i simply display the $_GET['state'],
> $_GET['year'],$_GET['term']
> > vars to see what they are...
> >
> > if i make all the select vars for the query terms arrays, it works as it
> > should, in that if all three lists aren't selected, then the user can't
> > proceed. however, if i use the select <select name = 'foo'> for the
> 2nd/3rd
> > lists, then the logic screws up...
> >
> > any idea why this is occuring....
> >
> > is there a better way/example of using multiple drop down lists within a
> > single form.....
>
> Possibly. I'd recommend using print_r($_GET) to see your form
> submissions. To make sure your actually getting what you want to be
> getting.
>
> > any thoughts/comments/pointers would be helpful.. i'm pretty sure that the
> > issue/prob is rather straight forward/simple, but i can't see it right
> > now....
>
> Not sure exactly what is broken, is that your entire script as posted?
>
> --
> Greg Donald
> Zend Certified Engineer
> http://gdconsultants.com/
> http://destiney.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
