Hi!
My problem is with pulling data from the db.. Here's the flow and where the breakdown is:
Page 1: HTML form in php to create event
Page 2: Displays data entered
Page 3: Display list of events
Page 4: When event is clicked, page 4 displays the info
Page 5: Can edit event information
Page 4 displays all information correctly. Page 5 doesn't display most of the data when pulling from page 4. When I click the Refresh button, all data is then imported correctly. I am not sure how I managed to do this. I have tried using $POST, $GET, and $row to get the data (an obvious noob attempt to get the code to work) Here is some relevant code from page 4 and page 5:
Page 4:
$id = $_GET['id'];
// The ID is passed through the URL to specify the row,
// Or it is set in the previous script.
$query = "SELECT * FROM diw_alpha WHERE id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
<tr>
<td>Event ID Number</td>
<td >'.$row['id'],'</td >
</tr>
<tr>
<td >DIW Title</td>
<td>'.$row['diwtitle'].'</td>
</tr>
<tr>
<td >Event Status</b></td>
<td>'.$row['eventstatus'].'</td>
</tr>
<tr>
<td >Account Manager</td>
<td>'.$row['dropdownacctmgr'].'</td>
</tr>
and Page 5:
$query = "SELECT * FROM diw_alpha WHERE id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
<TR>
<TD>Event ID</TD>
<TD>'.$_GET['id'].'</TD>
</TR>
<TR>
<TD>DIW Title:</TD>
<TD><input type="text" name="newtitle" size="32" value="'.$row['diwtitle'].'"></TD>
</TR>
<TR>
<TD>Event Status:</TD>
<TD><select name="neweventstatus">
<option value="'.$row['eventstatus'].'">
<option>In Progress</option>
<option>Scheduled</option>
<option>Awaiting Billing</option>
<option>Post-Production</option>
<option>Completed</option></select>
</TD>
</TR>
