Posted by Smiley on 04/13/06 00:44

<compuslave@gmail.com> wrote in message
news:1144874383.759151.100850@i40g2000cwc.googlegroups.com...
>
> Also I dont know where to start with this. I was able make a form that
> stored the info in a database but I have no idea how to use that same
> form to search with. Any links to docs scripts or good ol advice is
> much appreciated.
>

If you're able to store the info in the database, you're already half there.
You've just got to repeat the process, only change your SQL statement into a
"Select" statement rather than "Insert" - eg:

Select * from choices where color='red'

Just run through the same commands you used for the insert then add
something like this:

while($arr=mysql_fetch_array($qry))
{
$username = $arr['username'];
echo "$username<BR>";
}

That will go through each of the results and display the username from the
database.

[Back to original message]