Page refresh after updating db

[tcscottc]

I have 2 databases. One has a user's selected players. The second has list of all players. The web page brings up list of all players (from 2nd db) and creates drop down boxes, with the selected player (from 1st db) selected. works great.

user selects different player from dropdown and SUBMITs form which updates db1. works fine. page re-loads, but the new selected player is not "selected" on the page. if I refresh the page it then works. the db updating is working properly, i'm just missing something to have the dropdown selections update when the submit button is clicked. I know this may not a PHP issue necessarily but any ideas???

the code:

function get_players($pos, $pos1) {
global $userid;

$link_id = db_connect($default_dbname);
$query2 = "SELECT * FROM lineups WHERE userid = '$userid' AND week = 1";
$result2 = mysql_query($query2);
$item = mysql_fetch_array($result2);
if(!$result2) error_message(sql_error());
$selplayer = $item["$pos1"];

$query = "SELECT name FROM players WHERE week1 = '1' AND position = '$pos' ORDER BY name ASC";
$result = mysql_query($query);
if(!$result) error_message(sql_error());	

while ($row = mysql_fetch_row($result)) {
	$name = $row[0];
	$selected = "";
	if ($name == ltrim($selplayer)) {$selected = "selected";}
	echo "<option $selected value=\" $name \" > $name </option>\n";
}

}

...

<form action="<? echo $PHP_SELF ?>" method="POST" name="lineups">
<input type="hidden" name="action" value="setlineup">
<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tr>
<td align="right" width="40%"><font
color="#000000" face="Arial"
size="2">Username:&nbsp;</font><br> <br></td>
<td width="60%"><? echo $username ?><br><br></td>
</tr>
<tr>
<td align="right" width="40%"><font
color="#000000" face="Arial" size="2">QB:&nbsp;</font></td>
<td width="60%"><select size="1" name="qb">
<? get_players("QB","qb"); ?>

</select></td></tr>

etc. code repeats for each position...

the form "action" is to a different function, but that part is working
OK...

Thanks in advance.

[diego25]

Which order are you doing things? Updating db1 and then output form, OR output form and then update db1? I hope you're doing the first one 🙂

If that's not the problem, can we also see the code for the part that you insert AND output form?

Diego

[tcscottc]

Here's the code including the code to update the database. everything is updating in the database fine...

function get_players($pos, $pos1) {
global $userid;

$link_id = db_connect($default_dbname);
$query2 = "SELECT * FROM lineups WHERE userid = '$userid' AND week = 1";
$result2 = mysql_query($query2);
$item = mysql_fetch_array($result2);
if(!$result2) error_message(sql_error());
$selplayer = $item["$pos1"];

$query = "SELECT name, team FROM players WHERE week1 = '1' AND position = '$pos' ORDER BY name ASC";
$result = mysql_query($query);
if(!$result) error_message(sql_error());	

while ($row = mysql_fetch_row($result)) {
	$name = $row[0];
	$team = $row[1];
	$namelong = $name . " (" . $team . ")";
	$selected = "";
	if ($name == ltrim($selplayer)) {$selected = "selected";}

// echo $pos . "/" . $pos1 . "==" . $name . "<-->" . $selplayer . "(" . $selected . ")";
echo "<option $selected value=\" $name \" > $namelong </option>\n";
}
}

function create_lineup() {
global $userid, $qb, $rb1, $rb2, $wr1, $wr2, $wr3, $te, $pk, $def, $week;

$link_id = db_connect($default_dbname);
$query = "SELECT userid FROM lineups WHERE userid = '$userid' AND week = $week";
$result = mysql_query($query);

if(!mysql_num_rows($result)) 	
	$query = "INSERT INTO lineups VALUES ('$userid',$week,'$qb','$rb1','$rb2','$wr1','$wr2', '$wr3','$te','$pk','$def')";
	else 
	$query = "UPDATE lineups SET
		userid = '$userid', 
		week = $week, 
		qb = '$qb',
		rb1 = '$rb1',
		rb2 = '$rb2',
		wr1 = '$wr1',
		wr2 = '$wr2',
		wr3 = '$wr3',
		te = '$te',
		pk = '$pk',
		def = '$def' WHERE userid = '$userid' AND week = $week";
	$result = mysql_query($query);
	if(!$result) error_message(sql_error());

}

...

<form action="<? echo $PHP_SELF ?>" method="POST" name="lineups">
<input type="hidden" name="action" value="setlineup">
<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tr>
<td align="right" width="40%"><font color="#000000" face="Arial" size="2">Username:&nbsp;</font><br> <br></td>
<td width="60%"><? echo $username ?><br><br></td>
</tr>
<tr>
<td align="right" width="40%"><font color="#000000" face="Arial" size="2">QB:&nbsp;</font></td>
<td width="60%"><select size="1" name="qb">
<? get_players("QB","qb"); ?>
</select></td>
</tr>
<tr>
<td align="right" width="40%"><font color="#000000" face="Arial" size="2">RB1:&nbsp;</font></td>
<td width="60%"><select size="1" name="rb1">
<? get_players("RB","rb1"); ?>

</select></td>
</tr>

etc. for the rest of the positions...then the form finished up with...

              <input type="submit" value="Submit Lineup"><br>
             </td>
             </tr>
 </table>
             </form>

...

Right now, on the page I have a second form

<form action="<? echo $PHP_SELF ?>" method="GET" name="refform">
<input type="submit" value="Refresh page">
</form>

which after submitting the new players in the lineups form, clicking this form updates the page again (not the db) and the new players are now "selected" in the drop downs.

Hope that helps!

[tcscottc]

forgot to post the case stmt from the end of the pgm...

switch($action) {
case "setlineup":
create_lineup();
break;
default:
break;
}

[diego25]

Is your case statement after the form? If it is, then I've already told you the problem in my first post 🙂

Diego

[tcscottc]

Thanks Diego! I misinterpreted what you were asking in your original post. Moving the case statement did the trick. Thanks so much for your assistance.