[tapir]

Hi all, I'm hoping that someone can help me out (again!)
The project: A PHP contacts/address book.
page 1: search for a contact, page displays basic info, inlcuding a link to page 2 that will display full results for the selected contact.

The problem: Value does not appear to be passed from page 1 to page 2.

The link on page 1 opens page 2 correctly, but there are no details shown, just table headings. The value I wish to pass is 'UID' from the selected contact, so my link code on page 1 is:

PHP Code:

<a href="view2.php?UID=$UID"> 

Page 2 is using the following code to get the UID value:

PHP Code:

$UID=$_GET['UID']; 

The SQL is a simple

PHP Code:

$sql2="SELECT title, first_name, last_name FROM users where UID = '$UID' "

or die ("Could not execute select"); 

If I substitute $UID in the SQl for a known UID, the page displays the correct results.

Any thoughts on this please?

Thanks in advance

:t:

[JBChris]

Just a thought: are you inside of a function when you're calling the SQL???

[tapir]

Originally Posted by JBChris

Just a thought: are you inside of a function when you're calling the SQL???

Afraid not, the SQL is simply part of the whole PHP page, and not a function.

[ben.periton]

<a href="view2.php?UID=$UID">

Should that not be
<a href="view2.php?UID=<?=$UID?>">

Else it could be trying to lookup where the UID = UID

[NeverMind]

another note:

PHP Code:

$sql2="SELECT title, first_name, last_name FROM users where UID = '$UID' "

or die ("Could not execute select"); 

the or die() part is redundant!
because you are constucting PHP to die if it fails to define the variable, which will never happen!
instead try the or die() on mysql_query()

[tapir]

Hmm, I've tried the suggestion above,

PHP Code:

<a href="./view2.php?UID=<?=$UID?>">'

and still no joy. I notice that when I put the mouse cursor over the link, the URL is the code above, and not the UID value that I'm trying pass to the next page. Any further suggestions>

And NeverMind - thanks for the tip regarding the 'or die' code - I'll bare that in mind.

:t:

[ben.periton]

is this a php file? also, is $UID actually being set in this page?

[tapir]

This is the code I used to pass the value to the next page:

PHP Code:

<TD><a href="view2.php?UID=' . $row['UID'] . '">'.$row['UID'].'</a></TD> 

So I was on the tracks....but not far enough down

thanks for all your input

:t:

[Merovingian]

you can also urlencode() the passing variables so that it's not visible... Just a thought