[RESOLVED] PHP/DATABASE HELP

[msnhockey]

hi everyone,

i get this message now everytime i try to update into the db

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = '0000000077'' at line 1

any help is appriciated

mike

[Piranha]

Without more information all that is possible to say is that there is an error in the sql syntax. If you post the query we will be able to help you out further. It would be good to know if it is one query that causes the problem or if it is multiple queries, also if the query works with a database manager (phpmyadmin as an example). Information about what database and what version is also important.

[msnhockey]

since the code is abit long i have it as a .txt file here
http://msnhockey.com/mods/error.txt

hope you can see something as i have gone over piles of times

thanks

mike

[Piranha]

I can't be bothered to look through that much code to find a error in a query. You have to find what query it is and post it here. And post the rest of the information I asked for in the previous thread.

[msnhockey]

thats the problem.. i am trying to find which one first. i knew it was alot of code

thanks

mike

[Piranha]

Try to echo each sql statement and run from a database manager (like phpmyadmin) to find the query that is not working.

[msnhockey]

ok i will give that a shot..

thanks

mike

[msnhockey]

hey,

when i put the echo feature here it comes up with Resource ID #7

	$result_tn = mysql_query("SELECT id,name FROM teams WHERE id = '".$selectteam."'");
	$selectteam_name = mysql_result($result_tn,0,"name");

echo $result_tn;

[msnhockey]

i know the problem is with here somewhere

                 $test = $lname[$key];
                 $count_id = mb_strlen ($key);
		           if($test && $count_id > 4) {

$sql2 =  "UPDATE players SET ";
$sql2 .= "lname = '$lname[$key]', fname = '$fname[$key]', ";
$sql2 .= "position = '$position[$key]', number = '$number[$key]', ";
$sql2 .= "dob = '$dob[$key]', pob = '$pob[$key]', weight = '$weight[$key]', height = '$height[$key]', info = '$info[$key]', salary = '$salary[$key]', fint = '$fint[$key]', status = '$staus[$key]', captain = '$captain[$key]', shoots = '$shoots[$key]', email = '$email[$key]', phone1 = '$phone1[$key]', phone2 = '$phone2[$key]', address = '$address[$key]', b_color = '$b_color[$key]', ";

				$sql2 .= "WHERE id = '$key'";

where you see this is where is error shows $sql2 .= "WHERE id = '$key'";

mike

[msnhockey]

hey piranha,

I would like to thank you for your help. I figured it out by using so code i back up. i had an extra , in there. it looked right as the other syntax's all had commas in the same spot.

again thanks

mike

i will close this as resolved

[Piranha]

msnhockey wrote:

$result_tn = mysql_query("SELECT id,name FROM teams WHERE id = '".$selectteam."'");
$selectteam_name = mysql_result($result_tn,0,"name");
echo $result_tn;

If you do it like this instead it is much easier to look for bugs.

$sql = "SELECT id,name FROM teams WHERE id = '".$selectteam."'"; // This is the query
echo $sql; // This will show the query as the database gets it, a good way to find bugs.
$result_tn = mysql_query($sql);
$selectteam_name = mysql_result($result_tn,0,"name");
echo $result_tn; // This won't work since it is a result.

[msnhockey]

i will put the code in.

thanks alot

mike