How to do pass on information...
| From: | Chuck PUP Payne | Date: | Sun, 08 Sep 2002 01:47:50 +0000 |
| Subject: | How to do pass on information... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-115635@lists.php.net to get a copy of this message | ||
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