Passing Record ID Problem

[vozzek]

Hi again all,

Quick php/Dreamweaver problem: I've got an add_inventory.php page that populates my database keyed off of 'id'. When I built the record insertion form it asked for a destination, which I put in as show_inventory.php. I built this page later on, to show certain fields the user just entered.

Added a recordset to the add page (rs_add_inventory), only choosing the 'id' field. I need to pass that parameter to the show page, so it can display all the fields. So going into the code, I saw Dreamweaver had written the following lines of code:

$insertGoTo = "show_inventory.php"
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];

I modified the top line of code to read as follows, thinking it would pass the parameter:

$insertGoTo = "show_inventory.php?recordID=<?php echo $row_rs_add_inventory['id']; ?>";

Can anyone see what I did wrong? I'm getting a Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

I'm kinda new at this, so any help would be appreciated.
Thanks in advance!

[brettl]

Not sure what you're trying to do, but see if this helps.

$insertGoTo = "show_inventory.php?recordID=".$row_rs_add_inventory['id'];
 

[vozzek]

Ah, I should probably smack myself in the forehead for not trying concatenation. Thanks!

However, it still doesn't pass the 'id' value. I think your syntax is 100% correct but unfortunately since this is the posting form, the 'id' value hasn't actually been defined yet (at the time). It's a self-incrementing element of the database, so I guess maybe it happens after the posting? I think I'm trying to do the database call before the element is populated...

Still confused.

[brettl]

$insertGoTo = "show_inventory.php"
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];

Did you close the open { in your if?

[vozzek]

Yes, sorry - that's the next line. I closed the if.