?! Form to PHP to MySQL? HELP!!!

[creatorsway]

I'm very new to this...

Ok I have a page that has a form in it and it has a single input field called ChanName which is the same value I have in MySQL database.

My action is:
<form action=channel.php4 method=POST>

Inside of channel.php4 I have the following:
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("littlewhore",$db);
$result = mysql_query("SELECT URL FROM Search where ChanName=''",$db);
}
?>

All I want to do is have the variable passed from the 1st form to become part of the Query on the the second page.

So it says:

select all records from Search that match the variable (ChanName) and display the URL that matches it...

Can someone please help? I've been reading and reading and searching everywhere!!!

Thanks!

Rob

[Anon]

The variable get passed in from the form automatically, and it's called the exact same thing as your form field. So if your form is:

<input type="text" name="ChanName">

Then your variable would be: $ChanName

So probably the only change you need to make is this:

$result = mysql_query("SELECT URL FROM Search where ChanName='$ChanName'",$db);

[creatorsway]

Brian!
Thank you MUCH!
That's it.
It works like a champ now.
Only thing left to do now is try to figure out how to get the resulting URL to a button in flash...

Almost there!!!
Thanks again!