query database 3 fields

alternative

i want to select spesific data from the database by using

http://127.0.0.1/nice.php?id=1&countid=2

http://127.0.0.1/nice.php?id=1&countid=2&subid=5

like that..anybody can help me?

i put the code as
select * from customer
where id=1
and countid=2
and subid=5

like that...but cant work

thanx in advance

leatherback

Hi,

try something like:

if(isset($GET['id']))
{
$id = $GET['id'];
}

(You need to do this in order to acces the $id. (I am not sure wether you need the '' in $_GET[] though: I am not home right now.. Don't have the codes here..

Then, in the query:
select * from customer where id='$id';

The same for all the other variables you might want to grab from the URL.

Good luck.

bad76

Hi,
you have to make a select string with this value.

you write some like this:

$query="select * from customer where id=".$id."and countid=".$countid;
if(isset($subid)) $query.=" and subid=".$subid;

see you