url values and query

[hermzz]

i put this piece of code:

$result = mysql_query("SELECT * FROM `post` WHERE `postid` LIKE $id");

this gives me a invalid supplied arrgument. this is supposed to get all the entries which have a certain postid. $id comes from a url stated like this:
http://www.mypage.com/page.php?status=post&id=3
do i have to do something before retrieving the values or just because they are up in the url status equals post and id equals 3?

[nnichols]

Run your queries like this -

$sql = "SELECT * FROM `post` WHERE `postid` LIKE $id";
$result = @mysql_query($sql) or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

At least this way you can see if there is an error in your sql due to a variable not being passed.

Hope this helps 😉