Getting a variable into my query - doesn't work

[bemax]

Can someone tell me what is wrong in this code! I tried many ways but it can't work. I want to get the variable $valg in my query. Here is the code:

 

$valg= $_POST['valg'];

/*$result = mysql_query("SELECT*FROM products WHERE nom= ' ".$valg." ' ") or die("SELECT Error: ".mysql_error());*/

/*$result = mysql_query("SELECT*FROM products WHERE nom= '.$valg.' ") or die("SELECT Error: ".mysql_error());*/

$row = mysql_fetch_assoc( $result );

$result = mysql_query(" SELECT * FROM products WHERE name='$valg' ") or die("SELECT Error: ".mysql_error());

while($row = mysql_fetch_assoc($result))

  {

echo $row['nom'] . " " . $row['taille']." ".$row['prix']." ";

  echo "<br />";

    }

 

Thanks

 

Bemax

[trq]

The variable should interpolate just find. However, you need a space around the * within your query for it to be valid.