Rommeo Posted August 10, 2008 Share Posted August 10, 2008 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. Quote Link to comment Share on other sites More sharing options...
thebadbad Posted August 10, 2008 Share Posted August 10, 2008 Maybe there's whitespace around $_POST['name']. Try to trim() it. Quote Link to comment Share on other sites More sharing options...
Rommeo Posted August 10, 2008 Author Share Posted August 10, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.