[SOLVED] how to get information from url

[cs1h]

Hi,

 

I am using the get method on my form to send information to my proccesing script, but i don't know how to take the information from the url and so that i can search for it in the database using a piece of code like this,

$sql = "SELECT * FROM items WHERE id=$art";

 

Can any one tell me how to do this,

 

Cheers

Colin

[Fadion]

<?php
$art = $_GET['id'];
$sql = "SELECT * FROM items WHERE id=$art";
$results = @mysql_query($sql) or die(mysql_error());
?>

[chocopi]

to get a info from the url you use $_GET

 

http://www.somesite.com/index.php?art=hello

 

<?php

$art = $_GET['art'];
$sql = "SELECT * FROM items WHERE id=$art";

?>

 

~ Chocopi

[redarrow]

@ <<<<< take that away what the point in the die then.

[redarrow]

url example

<?php
example.php?id=$art
?>

 

<?php
if($_GET['id']=="$art"){

$x = $_GET['art'];

$sql = "SELECT * FROM `items` WHERE id='$x'";

$results = mysql_query($sql) or die(mysql_error());

// echo required info.

}else{

header("location: index.php");

exit;

}
?>