Can't you make a form?
Lets say you have a lexical database for categories like:
1     Anime
2     Action

then in the form so:
<select name='cat'>
$query = "select * from categories";
$result = run_query($query);
while($row = fetch_array($result)
        echo "<option value=$row[0]>$row[1]</option>";

This would send to the form action page the numerical representation of 
the categoried selected from the drop down list.


Chuck PUP Payne wrote:
> 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

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to