SQL syntax

NZ_Kiwis

I have this code

$result7 = mysql_query ("update results_comptable set comp_run_id = '$comp_run_id', team_pld = '$team_pld', team_w = '$team_w', team_d = '$team_d', team_l = '$team_l', team_b = '$team_b', team_f = '$team_f', team_a = '$team_a', team_pts = '$team_pts', team_diff = '$team_dif' where team_id = $team1_id & comp_run_id = $comp_run_id") or die("INSERT error6: ".mysql_error());

But i get this error
editedINSERT error6: You have an error in your SQL syntax near '' at line 1

Any ideas why??

drew010

save the entire sql query to a variable and echo it out to see what the final result is

planetsim

Try formatting your SQL Query to see what line its actually on as LINE 1 is your entire query it isnt much help. Also trying this in PHPMyAdmin may help you.

$result7 = mysql_query ("UPDATE results_comptable SET 
                        comp_run_id = '$comp_run_id', 
                        team_pld = '$team_pld', 
                        team_w = '$team_w', 
                        team_d = '$team_d',                         

                        team_l = '$team_l', 
                        team_b = '$team_b', 
                        team_f = '$team_f', 
                        team_a = '$team_a', 
                        team_pts = '$team_pts', 
                        team_diff = '$team_dif' 
                        WHERE team_id = $team1_id
                        AND comp_run_id = $comp_run_id
                        ") or die("INSERT error6: ".mysql_error());

thorpe

in this section;

where team_id = $team1_id & comp_run_id = $comp_run_id

change the & to && or use AND instead.

leatherback

Without knowing what is in the query, it is almost impossible to tell.
I fell it is in your where statement though. I think one of the passed variables is not set. Use quotes around the vars might help. Also, I would not use & in a query string, but "and".