Passing 2 URL Variables

rubbersoul

I want to pass 2 URL variables when I click submit. I want to pass a system= url variable and an id=......right now I can only do one or the other....my code:

<?php require_once('Connections/uptime.php'); ?>
<?php
mysql_select_db($database_uptime, $uptime);
$query_Recordset1 = "SELECT * FROM system ORDER BY sys_name ASC";
$Recordset1 = mysql_query($query_Recordset1, $uptime) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Choose System</title>
</head>

<body>
<p>Please choose your system:</p>
<form name="form1" method="get" action="index.php">
<select name="system" id="system">
<?php
do {

?>
<option value="<?php echo $row_Recordset1['sys_name']?>"><?php echo $row_Recordset1['sys_name']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
<input type="submit" name="Submit" value="Submit">
</form>
<p> </p>
<p> </p>
<p>  </p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

devinemke

since your form method is GET all of the variables sent will be URL query string variables. if you want to add more you can either add hidden varibales to your form or tack them on to the action tag of the form.

action="index.php?var1=one&var2=two&var3=three

rubbersoul

Ya but it has to be dynamic. I mean.....right now with the code I supplied I have a drop down menu and button. The drop down is getting it's values from a recordset....the recordeset is set up like:

System ID
sysA 1
sysB 2

etc....etc....

So when I select sysA and press 'submit' it sends the value...
system=sysA
However I also want it to send the value
ID=1

Understand?🙁

devinemke

perhaps you could stuff both the sys_name and the ID in the select box using the "|" delimiter:

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1))
{
	echo '<option value="$row_Recordset1['ID'] . '|' . $row_Recordset1['sys_name'] . '">' $row_Recordset1['sys_name'] . '</option>';
}

then use [man]explode[/man] to separate the ID from the sys_name.

PyroX

Or,just use the ID and look it up on the next page.

rubbersoul

Or,just use the ID and look it up on the next page.

??? Don't get that!

Weedpacket

Well ... you've got the ID, right? You've got a table in your database that lists IDs and Systems, right? If you've got the ID, you can look at the table and see what System is listed alongside, right?

So if you're table looks like

system_name | ID
------------+----
sysA        | 1
sysB        | 2

and you're given an ID of 2, you can look in the table and go "Ah, they selected sysB"! I mean, what else could it be?

It would also be safer than using both, because it gives someone somewhere a chance to break your code by returning fields that don't match.

rubbersoul

Well that's what I wanted to do.....but I have no clue how to do it!! Hence, the reason I'm here! I gave it an idea column so that I could relate like that....but how do I do it! You can see my code above.....I pass the ID variable....but it displays the ID number (i.e. 2) how do I write the code that says "If you pass an ID variable of 2...Look in the table and see that it's Sys😎.....?????

rubbersoul

OK> I'm gonna try and make myself a little more clear as this is really stumping me....

I have 2 page in PHP. The first is just a drop down menu that get's it's valuse from a table that is set up like this:

Tbl1
Sys name: Sys ID:
hello 1
goodbye 2

I select either hello or goodbye from the drop down menu and it redirects me to my second php page which is a record insert page.
When it goes to that page it sends a URL variable called system...

On the second page I have a couple of fields that will be used to insert records into another table called Tbl2 set up like this:

Tbl2
ID: date: description:

Now, as it stands I can select say hello and it redirects me to my insert page and I see my URL variable hello in a textbox....I also have some ediatble text feilds for my date and description. In here I'll put say 2004-09-09 Working on hello.....

So what I want when I click submit is for my second table to be populated as such:

ID: date: description:
1 2004-09-09 Working on hello

Right now...I get the second 2 fields....but I can't seem to get the URL variable that I sent over to translate itself as it's ID # as insert the record. At first I had both ID fields as primary keys....but the problem with that is a may have 10 entries for hello on the same day and I can't have a duplicate key (i.e. 10 1's in a row)....I'm stuck! I tried a bunch of diffrent SQL queries in my recordset....I really don't know how to do this! Any help?

steelheart38

in the insert page maybe u could again query Tbl1 using the $system which u have passed from the first page

$sql = "SELECT id from Tbl1 WHERE sys_name=$system";
$query_result = mysql_query($sql);

// i'm really not familiar with retrieving the result
//but u may use either of these though i believe it is redundant)
$sys_id = mysql_result($query_result,0);

// or u could use
$row = mysql_fetch_assoc($query_result);

$sys_id = $row[id];

then u pass this $sys_id to the page where u will have the INSERT sql statement

im not that familiar with the codes really but the idea is :on the 2nd page u could make a query and retrieve the corresponding sys_id given $system from the previous page and use that result $sys_id to insert the data