passing variables?

digby

Hi All,

I'm pretty new but hacking my way through, have a problem, wondering if you guys can help. I've had this problem a few times now.

Data is displayed in a table allowing a user to click on a link/URL to drill down on more data, so the URL is dynamic for whatever row of data your on, for example:

http://domain.com/file.php?id=11

When file.php is run, the value of $id is not 11 it is something else????? This is my problem. I check both of my php files, the one that displays the data and passes the variable and the other that is meant to take the variable and perform a query with it and they both show $id with some other number and I have no idea where it comes from?

I have lots of print $id; statements throughout my pages to tell me what value it is and it appears to be already set to something else and I am unable to pass the value?

What am I doing wrong?????????

Thanks, Digs.

:Here is my code that queries the data, displays the table and passes the $id value. It works no problem, however, at the begining of this page $id is already set to some other number? And when file.php?id=10 is opened up $id is something else, like 9!!!!!!!!

// display list from insurance

$url_text = "http://www.domain.com/file.php";
$sql = "SELECT * FROM insurance";
$result = mysql_query($sql);
printf("<table border=1 CELLSPACING=0 CELLPADDING=0>");
while ($myrow = mysql_fetch_array($result))
{
printf("<tr>");
printf("<td>%s</td>\n",$myrow["age"]);
printf("<td>%s</td>\n",$myrow["license_level"]);
printf("<td>%s</td>\n",$myrow["years_licensed"]);
printf("<td>%s</td>\n",$myrow["location"]);
printf("<td>%s</td>\n",$myrow["driving_record"]);
printf("<td>%s</td>\n",$myrow["bike_make"]);
printf("<td>%s</td>\n",$myrow["bike_model"]);
printf("<td>%s</td>\n",$myrow["bike_plate"]);
printf("<td>%s</td>\n",$myrow["insurance_company"]);
printf("<td>%s</td>\n",$myrow["insurance_period"]);
printf("<td>%s</td>\n",$myrow["premium"]);
printf("<td>%s</td>\n",$myrow["multiple_vehicles"]);
printf("<td>%s</td>\n",$myrow["insurance_type"]);
printf("<td><a href=\"%s?id=%s\">%s</a></td>\n",$url_text,$myrow["id"], $myrow["problems"]);
printf("<td>%s</td>\n",$myrow["rating"]);
printf("<td>%s</td>\n",$myrow["recommend"]);
printf("</tr>");

}
printf("</table>");

digby

I just altered my code to use another field 'age' as a variable to pass and to then perform the query in the second file, so the url looks like this assuming the 'age' entered was 31

http://www.domain.com/file.php?age=31

and it all works fine.

However, the $id value is still showing some other value and if I pass a new $id value it is not accepted, it sticks with the original value.

for example, in start.php

print $id: // shows a value of 9

http://www.domain.com/file.php?id=23 //click on this link to open up file.php passing the variable id with the value of 23

// within file.php insert this code

print $id; // still shows a value of 9 even though 23 was passed and query fails?

Why and where the f*** is the other value coming from?

Thanks, Digs.

dalecosp

There's lots of places to get a value from, and without reading your entire code, it's hard to say from whence a value cometh....

Try sticking this

$id=$_GET['id'];

at the top of your scripts to be sure that we're getting the value of the variable from your URL and noplace else...this is the proper practice these days.

HTH,