PHP variable mysql select statement problem

[jgenns]

can anyone tell me why this code don't work. I run it and I get no results even when I know the variable matches a entry in the database.

<? include("datacon.inc");
if(isset($_POST['group_name'])){
$name = $_POST[group_name];
}
$result = mysql_query("SELECT group_id FROM newsletter_group WHERE name='$name'");
$row = mysql_fetch_array($result);
$gid = $row["group_id"];
echo $gid;
?>

[mark_W]

Hey,

just out of interest, try it like this:

 
$name = $_POST['group_name']; 

You were missing the single quotes!

Mark

[jgenns]

I have done that but it still don't work

[Mike Borozdin]

Try to output the value of $name to check what you get.

[jgenns]

Ok I figured it out the problem wasn't the script it was the way the form sent the data.

Thanks for your help anyway