Hi, thanks for earlier replies regarding php resources. I am currently
hitting a brick wall on the script below due to my lack of understanding of
php coupled with my lack of knowledge about globals.
I replaced $id with $_GET['id'] in line 5 which now allows the user to reach
the script to evaluate when presented with testpage.php?id=n. It now falls
over when it tries to run the query part :

WHERE id=$id

I tried to submit this instance with $_GET['id'] in the query which also
fails. In the $_GET['id'] where is the value for id now stored?
Can anyone see where i have gone wrong?

my source:

$db = mysql_connect("localhost", "root");
// display individual record
if ($_GET['id']) { 
$result = mysql_query("SELECT * FROM address WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("Name: %s\n<br>", $myrow["name"]);
printf("Address: %s\n<br>", $myrow["address"]);
printf("Home Number: %s\n<br>", $myrow["hnum"]);
printf("Work Number: %s\n<br>", $myrow["wnum"]);

} else { 
// show employee list
$result = mysql_query("SELECT * FROM address",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do { 
printf("<a href=\"%s?id=%s\">%s</a><br>\n", $_SERVER['PHP_SELF'],
$myrow["id"], $myrow["name"]);
} while ($myrow = mysql_fetch_array($result));
} else { 
// no records to display
echo "Sorry, no records were found!";
Mike Karthauser 
Managing Director - Brightstorm Ltd

Email       >> [EMAIL PROTECTED]
Web         >> http://www.brightstorm.co.uk
Tel         >> 0117 9426653 (office)
               07939 252144 (mobile)

Snailmail   >> Unit 8, 14 King Square,
               Bristol BS2 8JJ

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to