Hi,

I would like to know if there is a way that I can pass on an information
from a pull down menu into a sql query. Right now I have to right a PHP page
for each piece I am wanting to pass on. Example I have a movie database and
now if I want to see what is in my Anime Category that starts with "A" I
have to create a page like this:

Select * FROM database WHERE category = 'anime' AND title like 'A%'

I know I have to do an array? Would it be like this?

$category 
$letter 

Select * FROM database WHERE category = '$category' and title is like
'$letter'

But it get to the sql statement is where I am lost.

Chuck Payne
Magi Design and Support


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to