help with request from URL.

[aron]

hi all. just need a little help with a request.

my code has this in it

$id = $_REQUEST['id'];

$sql_client = "SELECT * FROM card_details WHERE id = $id";
$result_client = mysql_query($sql_client,$connection) or die ("No Category Selected");

now my url looks like this.

mydomain.com.au/page.php?id=2

when its like that it works fine.

but when i first come to my page it looks like this

mydomain.com.au/page.php

how can i ingnore the script if no ?id exsits

cheers aron.

[Weedpacket]

Use [man]isset[/man] to see if $_GET['id'] is set or not. If it isn't, then skip that code.

[aron]

ok i did this

$alpha_letter = strtolower($_GET["alpha_letter"]);
$category_id = $_REQUEST['category_id'];

if (!isset($alpha_letter)) {

$sql_category = "SELECT * FROM `categories` WHERE `cat_name` LIKE '$alpha_letter%'";
$result_category = mysql_query($sql_category,$connection) or die ("Could not connect to database1");
//echo $sql_category;

}

now if i go to my url

mydomain.com.au/page.php

it works correctly but if i click a button on the page ( the letter "a") i get a blank page the isset should be set now and it should run the code.

mydomain.com.au/page.php?alpha_letter=a

what have i done wrong

[Weedpacket]

First of all, use [man]isset[/man] on $_GET['alpha_letter']; because if that variable doesn't have a value, there's no point trying to do anything with it like strtolower() or assigning its value to another variable.

Second, what you've written will only do the query if the variable is not set. That's what the '!' means. You want it to happen if it is set. (And, as it happens, in what you've written, $alpha_letter is always going to be set, so the query will never run.)

[aron]

ahh right i got it thanks for that.