RE: [PHP] Newbie question

The problem is here: $nfl_player_id = mysql_query("SELECT player_id FROM nfl_players WHERE first_name='$aqfl_player_first' AND last_name='$aqfl_player_last' AND position='$aqfl_player_position' AND nfl_team='$aqfl_player_nfl_team'"); mysql_query does not return the ID, but the handle of the connection. What you need to do is fetch the results that the query has generated. You can replace the above code with this one: //start $result = mysql_query("SELECT player_id FROM nfl_players WHERE first_name='$aqfl_player_first' AND last_name='$aqfl_player_last' AND position='$aqfl_player_position' AND nfl_team='$aqfl_player_nfl_team'"); $row_id=mysql_fetch_array($result); $nfl_player_id = $row_id[0]; //end This will get you the right ID and should allow to do the update, unless there are other pbs :) Sincerely, Pavel Kharitonov Project Manager Intechnic Corporation http://www.intechnic.com Phone: (847) 816-1231 -----Original Message----- From: Bob Eldred [mailto:reldred@viablelinks.com] Sent: Wednesday, January 09, 2002 1:54 PM To: php-general@lists.php.net Subject: [PHP] Newbie question Hi there, I'm really really new to both PHP and MySQL, so this is probably going to turn out to be an easy fix. The basis is this: I have a MySQL database with two tables in it. I'm trying to update 1 of the fields (aqfl_team) in the first table (nfl_players) with a value from a field (aqfl_team) from the second table (temp_aqfl_rosters). The PHP document looks like this: <html> <body> <?php $db = mysql_connect("localhost","root","password"); mysql_select_db("aqfl",$db); $aqfl_result = mysql_query("SELECT * FROM temp_aqfl_rosters"); echo "Updating rosters....."; $myrow = mysql_fetch_array($aqfl_result); do { $aqfl_player_first = $myrow["first_name"]; $aqfl_player_last = $myrow["last_name"]; $aqfl_player_position = $myrow["position"]; $aqfl_player_nfl_team = $myrow["nfl_team"]; $aqfl_player_aqfl_team = $myrow["aqfl_team"]; $nfl_player_id = mysql_query("SELECT player_id FROM nfl_players WHERE first_name='$aqfl_player_first' AND last_name='$aqfl_player_last' AND position='$aqfl_player_position' AND nfl_team='$aqfl_player_nfl_team'"); $result = mysql_query("UPDATE nfl_players SET aqfl_team='$aqfl_player_aqfl_team' WHERE player_id='$nfl_player_id'"); echo "$aqfl_player_first $aqfl_player_last updated ($aqfl_player_position, $aqfl_player_nfl_team, $aqfl_player_aqfl_team)"; } while ($myrow = mysql_fetch_array($aqfl_result)); ?> </body> </html> The end result is that I get a screenful of data (every player, NFL team, and AQFL team is correct) stating that the various players are updated, but but the field update in nfl_players is not actually done. I'm sure it's a syntax issue, but I don't know what's the actual problem. Any help? Thanks, Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net