#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    24
    Rep Power
    0
    Hi,

    I wanted to use a drop down menu as a list of choices to query a mySQL database. I havent used php/mySQL too much and im not sure how to go about doing this.

    What i have done is created the drop down menu using the select tag and listing the options with each one having the same name and different value's i have it set up using a buttin to "submit" the choice to a php form(that query's a mySQL database) but the value is not being passed on to the form.

    You can see what i am talking about here - http://www.djriyad.com/matrix/pastevents.htm

    on the send page... i tried to print the value that is being bassed between 'blah' & 'blah' but it is not there...

    Any help would be appreciated.

    Thanks,

    CMatrix
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    24
    Rep Power
    0
    forgot 2 mention that there is only data up for april 1999 right now...
  4. #3
  5. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    I went to the target page, manually pasting in month=1999-04-% and got data. I'm not sure what the problem is???
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    24
    Rep Power
    0
    thanks alot... that helped me discover the problem i used the incorrect 'name' for the drop down menu so it wasnt passing the date values in...

    cmatrix

Similar Threads

  1. MySQL output to table using phpBB
    By CCCMTech in forum PHP Development
    Replies: 0
    Last Post: February 2nd, 2004, 02:43 PM
  2. MySQL query using DB driven drop down menu
    By msg270 in forum PHP Development
    Replies: 3
    Last Post: January 22nd, 2004, 04:41 PM
  3. Syntax error in INSERT INTO query
    By Lee Miles in forum Visual Basic Programming
    Replies: 6
    Last Post: December 19th, 2003, 07:37 AM
  4. nested query and MySQL query
    By lucipher in forum MySQL Help
    Replies: 1
    Last Post: November 19th, 2003, 10:49 AM
  5. Replies: 1
    Last Post: November 14th, 2003, 02:53 AM

IMN logo majestic logo threadwatch logo seochat tools logo