Can't you make a form?
Lets say you have a lexical database for categories like:
ID NAME
1 Anime
2 Action
etc...
then in the form so:
<select name='cat'>
<?php
$query = "select * from categories";
$result = run_query($query);
while($row = fetch_array($result)
{
echo "<option value=$row[0]>$row[1]</option>";
}
free_result($result)
?>
</select>
This would send to the form action page the numerical representation of
the categoried selected from the drop down list.
-Brad
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
