GET

[Toy]

I'm doing a PHP project and i'm pretty new to the thing so I need help.

 

I have a table with ID's in every row and I wan't to use the GET function.

 

/index.php?id=1 will display the content of the let's say name in the same row as the ID.

 

If there's no id= specified or it's invalid it'll just show the ordinary frontpage, like that.

 

[AbraCadaver]

if(isset($_GET['id'])) {
   // do sql query using id and display
} else {
   // display ordinary frontpage
}

[Toy]

if(isset($_GET['id'])) {
   // do sql query using id and display
} else {
   // display ordinary frontpage
}

 

I'm pretty sure that that'll do it!

 

Thank's man you're a lifesaver.

[Toy]

Just one more thing, I have this code in the "if id is selected".

 

if(isset($_GET['id'])) {

$result = mysql_query("SELECT * FROM table");

while($display = mysql_fetch_array($result))

  {

echo $display['title'];

  }

} else {

 

Will display all the titles in the database, I want it to show and recognize from which ID is selected!

[wildteen88]

You'll need to alter your SQL query to include a WHERE clause

$result = mysql_query("SELECT * FROM table WHERE title_ild='" . mysql_real_escape_string($_GET['id'] . "'");

 

Change title_id to the id column in your table.

[Toy]

You'll need to alter your SQL query to include a WHERE clause

$result = mysql_query("SELECT * FROM table WHERE title_ild='" . mysql_real_escape_string($_GET['id'] . "'");

 

Change title_id to the id column in your table.

 

I got the error: Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\index.php on line 14

 

I don't really know why, the code that you just wrote looks good to me? Any help? :S

[wildteen88]

Oops. I didn't close the function properly

$result = mysql_query("SELECT * FROM table WHERE title_id='" . mysql_real_escape_string($_GET['id']) . "'");

 

Remember to change title_id to your actual id column