mysql and php problem

[g0liatH]

Hi,

In my newsscript, every post gets a unique id (a number) and now I want to make it so that this number is saved in a variable, so that people can enter a url:

http://www.blah.com/blah.php?id=1

now this is my first problem: it seems that it is not possible to start the content of a variable with a number.

$q = mysql_query("SELECT * FROM $table WHERE id = ");

This is my second problem: I don't know what I should enter in id, I tried '".$id."' but this isn't working, I only see a white screen (probably because of the first problem)

Help is much appreciated!

[bastien]

well you can start with a list or a random post, its up to you...

if (!isset($GET['id'])){
$q = ""SELECT FROM $table order by Rand()";
}else{
$q = "SELECT FROM $table WHERE id = ".$GET['id'];
}

$result = mysql_query($q);

and the answer to your second questions is, as above, use $_GET['id'] to access the url values....remember to validate the data to ensure correctness

[g0liatH]

oh right, I forogt the GET_ statement completely :mad:

hmm now I get this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site51/fst/var/www/html/td/mainnew/content.php on line 13

[bastien]

check your db connection info