[RESOLVED] Move data between two files...wrong results

[bprof]

I've created a file that displays info from DB (pid, name, email), in that file there is a link to another file to edit the selected field:

showall.php

<?php
...
print "<td align='center' width=\"20%\"  align=left><a href='display.php?pid=$pid'>$pid</td>";
...
?>

If I view the source page it shows something like this:

<td align='center' width="20%"  align=left><a href='display.php?pid=1'>1</td>

In display.php am trying to edit the info for a specific field using its id(pid), everything seems to be fine when I do the edit and commit the changes, but in the DB nothing change.

This is the first line in display.php:

$pid     = $_REQUEST['pid'];

I echoed the pid to see what value it has:
echo "This is the PID".$pid;

But it prints name and NOT pid, even though it displays the right data that is associated with this pid.

I added this line to display.php:

print_r( $_REQUEST );

It displays this result:

Array ( [pid] => 9 )

but when I assign the value

$pid     = $_REQUEST['pid'];

and echo the result

echo $pid;

it shows the name and NOT the id

Could you please help me find what makes it behave this way?

Thanks,

[tomhath]

id=1
...
$_REQUEST['pid']

Which is it, id or pid?

[bprof]

Sorry tomhath, my typo mistake, its pid.

[tomhath]

Must be something else in the script. Can you post some more of it? Preferably with the exact output.

[bprof]

Here is the script that I'm using:

showall.php

$query = "SELECT * FROM user_data";
$result = mysql_query($query);
$resultFound = false;

while ($row = mysql_fetch_assoc ($result)) {
     $pid     = $row['pid'];
     $name = $row['name'];
     $email = $row['email'];
     ...
     print "<td align='center' width=\"20%\"  align=left><a href='display.php?pid=$pid'>$pid</td>";
     ...
}
if (!$resultFound) {
    echo "No data!!";
    exit();
}

This is display.php

<?php

print_r($_REQUEST);  //Prints this : Array ( [pid] => 9 )

$pid = $_REQUEST['pid']; //Prints this : the name of the user from showall.php

$sql = "SELECT * FROM user_data WHERE pid = '$pid'";

$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows==0) {  

?>

No data!!

<?php
}
else if ($numberOfRows>0) {

$i=0;
$pid       = MYSQL_RESULT($result,$i,"pid");
$name   = MYSQL_RESULT($result,$i,"name");
$email   = MYSQL_RESULT($result,$i,"email");
}

?>

[tomhath]

It worked fine for me.
display.php

<?php
print_r($_REQUEST);  //Prints this : Array ( [pid] => 9 )

$pid = $_REQUEST['pid']; //Prints this : the name of the user from showall.php
echo "pid: $pid<p/>";

$sql = "SELECT * FROM user_data WHERE pid = '$pid'";

$result = MYSQL_QUERY($sql) or die(mysql_error());
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows==0) {  

?>

No data!!

<?php
}
else if ($numberOfRows>0) {

$i=0;
$pid       = MYSQL_RESULT($result,$i,"pid");
$name   = MYSQL_RESULT($result,$i,"name");
$email   = MYSQL_RESULT($result,$i,"email");
echo "$pid<p/>";
echo "$name<p/>";   
echo "$email<p/>";   
}

?> 

[bprof]

Does it print pid as a number and not a string?

If so, can you please help me find why it keeps giving me string value?

I tried to run it on more than one machine and all gave the same results.

[bprof]

This is really a weired thing:

now I tried this on display.php

$pid = $_REQUEST['pid'];

echo "pid: $pid<p/>"; //This printed the right value

$pid = $pid; //without this line it prints the name

echo $pid; //this is to check if it still prints the right value. It prints the right value.

When I click update button in this page, it should take the pid to a page called:

update.php

Here are the first lines of this page

$pid     = $_REQUEST['pid'];

echo "pid: $pid<p/>";  //This prints the right value for $pid. i.e 22

//because it didn't modify anything, I tried to assign the value to another variable and echoed the current value

$x = $pid; //The new variable assignment which is 22 

echo $x;  // It printed 2222

Why it did print 2222? I have no idea, it printed the right value here

echo "pid: $pid<p/>"; 

but not after the assignment. 😕

[bradgrafelman]

Are you sure it didn't just print 22 twice, with no separation betwen them? Try replacing "<p/>" with "<br/>".

[tomhath]

It looks like you have another variable named $pid that was created in another scope, or came from the session or an "include" statement. Try changing $pid to something you're sure was never used anywhere else, like $pid_from_showall

[bprof]

Thanks guys its solved now.