MySQL/PHP - Passing/Using Multiple Variable Values

  • Nigel10
  • Born
  • Born
  • Nigel10
  • Posts: 1

Post 3+ Months Ago

I would be grateful for any help with this problem using PHP with a MySQL database....

I have a search form facility based on a drop-down list (of products). I want searchers to be able to select more than one product from the drop-down to be used as search criteria. I have set up the form to allow multiple selections.

The variable values get passed in the form, e.g.

AdvancedResults.php?Products=AC&Products=BA

but it is only the second value that is 'held' and can be used.

How can I pass multiple values for a single variable to enable results from the database to be generated on a 'this value AND that value' basis?????

Many thanks
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Axe
  • Genius
  • Genius
  • User avatar
  • Posts: 5739
  • Loc: Sub-level 28

Post 3+ Months Ago

you can't select multiple items in a drop-down list, only a regular list box.
  • diverdan
  • Beginner
  • Beginner
  • diverdan
  • Posts: 46
  • Loc: Alabama, USA

Post 3+ Months Ago

http://www.phpnoise.com/tutorials/6/4

you have to make the form item an array

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 114 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.