[SOLVED] A weird problem about taking data..

[Rommeo]

Hi

I have a really weird problem about selecting data from mysql.

My problem is

$name = "blue";
echo "Name :".$name;
$sql1 = "SELECT * FROM tablecolors WHERE name ='$name'  ";
$results = mysql_query($sql1) or die(mysql_error());
	$row = mysql_fetch_assoc( $results ); 

$sectionid = $row['colorid'];
echo "Color section id is :".$sectionid;

Works fine.. Output is :

Name : blue

Color section id is : 3

 

But this one is not working

$name = $_POST['name'];
echo "Name :".$name;
$sql1 = "SELECT * FROM tablecolors WHERE name ='$name'  ";
$results = mysql_query($sql1) or die(mysql_error());
	$row = mysql_fetch_assoc( $results ); 

$sectionid = $row['colorid'];
echo "Color section id is :".$sectionid;

Output :

Name : blue

Color section id is :

 

Color section id is empty.. I could not find the reason why. Both codes are same only the difference is one takes data from post. I ll be glad if anyone can help.

 

Thanks in Advance.

 

[thebadbad]

Maybe there's whitespace around $_POST['name']. Try to trim() it.

[Rommeo]

thebadbad Thank you so much.

 

I was not using that function before. From now on I ll use it.

Now everthing is working fine.

Thanx