Passing vaules with the URL (master detail page)

[voice3]

Please can anybody help me, I am having trouble when I try to past a vaule in the form of a "ID" via the URL. It seems to past it OK, but I want to use the value to pull the info from a MYSQL database.

THE MASTER PAGE

<?php
dbConnect('ceolweb');
mysql_select_db("ceolweb");

$sql = "SELECT * FROM ceolweb_perform ";
$query = mysql_query($sql) or die ("cannot query datebase.<br>".mysql_error());
while ($result = mysql_fetch_array($query)){
$day = ($result["day"]);
$month = ($result["month"]);
$year = ($result["year"]);
$place = ($result["place"]);
$perform_ID = ($result["perform_ID"]);
echo "$day $month $year &nbsp;&nbsp; $place [<a href='edit_date2.php?SessionID=$SESSION[SessionID]&perform_ID=$perform_ID'>edit</a> | <a href='delete_date.php?SessionID=$SESSION[SessionID]perform_ID=$perform_ID'>Delete</a>]<br>";
}

?>

THE DETAIL PAGE

<?php

dbConnect('ceolweb');
mysql_select_db("ceolweb");

$sql = "SELECT * FROM ceolweb_perform WHERE perform_ID = $perform_ID";
$result = mysql_query($sql) or die ("cannot query datebase.<br>".mysql_error());
$myrow = mysql_fetch_array($result);

?>
<form action="edit_date2.php?SessionID=<?php echo $SESSION[SessionID] ?>" method="post" name="edit2" id="edit2">
<table width="544" border="0">
<tr>
<td width="486"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="perform_ID" type="hidden" id="perform_ID" value="<?php echo $HTTP_GET_VARS["perform_ID"]?>">
Location </font></div></td>
<td width="48"></td>
</tr>
<tr>
<td><div align="center"> <font size="2" face="Arial, Helvetica, sans-serif">
<input name="place" type="text" id="place" size="40" maxlength="100" value="<?php echo $myrow["Place"] ?>">
</font></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">Date</font></div></td>
<td>&nbsp;</td>
</tr>
<?php echo $place; ?>
<tr>
<td><div align="center"> <font size="2" face="Arial, Helvetica, sans-serif">
<select name="day" id="day">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
&nbsp;
<select name="month" id="month">
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
&nbsp;
<select name="year" id="year">
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
</select>
</font></div></td>
<td></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">Details</font></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="center">
<textarea name=" information" cols="50" rows="5" id="<"reviews"><?php echo $result["information"] ?></textarea>
</div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><input name="valid_userID" type="hidden" id="valid_userID" value="<?PHP echo $SESSION[valid_user_ID]?>"></td>
<td>&nbsp;</td>
</tr>
<tr>
<td> <div align="center">
<input name="submit" type="submit" id="submit" value="Submit">
&nbsp;
<input name="Reset" type="reset" id="Reset" value="Reset">
</div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><div align="center"><a href="edit_date.php?SessionID=<? echo $SESSION[SessionID] ?>">Edit
Date</a>| Delete Date</div></td>
<td>&nbsp; </td>
</tr>
</table>

    </form>

[raymie]

Firstly could you please reedit your original post and place the code within the php code tags as used in this board, it makes the code much easier to read.

Your problem may be because register_globals is set to off. This is the default value from version 4.2.0 and upwards.

When you pass a variable via the URL this is called the GET method, a variable named ID for example should be referred to as $_GET['ID'] and not just $ID.

[Rohan_Hill]

If you want it to go via the URL, then instead of this:

<form action="edit_date2.php?SessionID=<?php echo $SESSION[SessionID] ?>" method="post" name="edit2" id="edit2">

You should do this:

<form action="edit_date2.php" method="GET" name="edit2" id="edit2">
<input type="hidden" name="SessionID" value="<?php echo $SESSION[SessionID] ?>">