[RESOLVED] URL parameter funny

seanlyons

This is freaking me out.

I have a master/detail page arrangement. Clicking a link from mater page, passes the id column as a URL parameter and opens the detail page which uses the URL parameter to query and insert data.

Great. As long as the URL parameter is a number less than 7?

If I change the query on the master page to be a fixed value, it can open any row. But not if it's passed as a URL parameter. Please help.

devinemke

post code

LoganK

Yes, please post some code. If the URL parameter is ID then it should be simply: "SELECT * FROM tablename WHERE id='{$_GET['id']}'". But obviously you'd want to do some sanitizing first.

seanlyons

Sorry.

Code to assign the URL parameter

<a href="itas1.php?recordID=<?php echo $row_rsContent['id']; ?>&sectionID=<?php echo $row_rsContent['section']; ?>" class="mule">view</a>

Then the code on the next page with uses the recordID

 $colname_rsContent_Update = "1";
if (isset($_GET['recordID'])) {
  $colname_rsContent_Update = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_itas, $itas);
$query_rsContent_Update = sprintf("SELECT * FROM main_content WHERE id = %s", $colname_rsContent_Update);
$rsContent_Update = mysql_query($query_rsContent_Update, $itas) or die(mysql_error());
$row_rsContent_Update = mysql_fetch_assoc($rsContent_Update);
$totalRows_rsContent_Update = mysql_num_rows($rsContent_Update);

The starnge part is that it works fine when you try to look at the first 6 rows of the table, and then blank pages show up for anything with a recordID over 6. There doesn't seem to be any logic to it!

LoganK

Have you tried to echo($_GET['recordID']); and echo ($colname_rsContent_Update); to see what values are being placed in those two?

seanlyons

This is really driving me nuts.

I use the following code to echo the values you suggested

<?php echo $_GET['recordID']; ?><?php echo $row_rsContent_Update['id']; ?>

And When accessing rows with an ID of less than 5, i get as expected, 2 copies of the same number....great.

As soon as the row number is greater than 6, the page displays blank! No code at all. All of the source is gone.

All that remains of the page is

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>

What the heck could be allowing the code to load normally as long as recordID variable is less than 7 but not be processed if greater than 7.

seanlyons

Writing another page, using the same recordID to build another records set works fine.

   

$colname_rsMain_Content ="1"; 
if (isset($_GET['recordID'])) 
{ 
$colname_rsMain_Content = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']); 
} 
mysql_select_db($database_itas, $itas); 
$query_rsMain_Content = sprintf("SELECT * FROM main_content WHERE id = %s", $colname_rsMain_Content); 
$rsMain_Content = mysql_query($query_rsMain_Content, $itas) or die(mysql_error()); 
$row_rsMain_Content = mysql_fetch_assoc($rsMain_Content); $totalRows_rsMain_Content = mysql_num_rows($rsMain_Content);

Any value of recordID works without issue. What the hell am I doing wrong on the other page?

jansky

What is the field type of your ID in your table??

seanlyons

Fixed it. Another query at the end of the script was trying to access a table of data which had same name fields and null data. Enough to screw up the query I suppose. Thanks for everyones input.

LoganK

Congrats!