Loop in mysql query.

[Zepo.]

$fields=mysql_query("SELECT id,name FROM customfields");
while(list($id,$name)=mysql_fetch_row($fields)){
$extrasql.=",$name='$member[$name]'";
}

mysql_query("UPDATE members SET 
name='$member[name]',
country='$member[country]',
password='$member[password]',
photo='$member[photo]',
about='$member[about]',
intrests='$member[intrests]',
aim='$member[aim]',
website='$member[website]'
$extrasql
WHERE name='{$_COOKIE['user']}'") or die(mysql_error());

 

Reads 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 'ID='N/As',PSN ID='TheZepos' WHERE name='Zepo.'' at line 10.

[Northern Flame]

try putting each entry in the array into its

own variable and then try putting it in again,

so do something like

 

$name = $member['name'];

$country = $member['country'];

etc.

 

then

 

mysql_query("UPDATE members SET

name='$name',

country='$country',

etc....

");

[Zepo.]

It worked before i put the extrasql in there, so im pretty sure thats the problem.

[Northern Flame]

yea its because you have put

 

$member[name]

instead of

$member['name']

 

see the difference?

 

and if you were to add the ' to

the query it would confuse the

query because you already have

one open. thats why i asked you

to put it in a variable so that you

wouldnt need to use the '

[Zepo.]

I dont see how this is relevant to the issue im having,i couldnt do that because the data's ina loop and its a variable.

[Northern Flame]

because the error you are receiving seems to be

a syntax error, and i was explaining to you what

you formatted incorrectly....

[Zepo.]

because the error you are receiving seems to be

a syntax error, and i was explaining to you what

you formatted incorrectly....

But it works fine without the $extrasql variable in there is what im trying to explain, so formatting isn't an issue.

[Northern Flame]

oh i see what you're saying,

 

um....

for now i dont have any other solutions,

ill try to come up with something for you

[Zepo.]

The error makes no sense because it looks right IMO.

[sasa]

can you echo $extrasql

[Zepo.]

$extrasql echos

,PSN ID='TheZepo',Live ID='N/A'

[sasa]

try

extrasql.=",`$name`='$member[$name]'";