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.


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

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 118 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.