Question~about Mysql ALTER TABLE `xxx` ORDER BY `no`;

[no9t9 0]

I didn't see that you were using ` instead of ' ... but after seeing the error output is is obviuos.You should never use ` as a quote! You don't need the quotes around the table and column name anyway. Just remove them.That should fix it.

[kakingho 0]

Everyone mentioned it! You used

mysql_query(ALTER TABLE `xxx` ORDER BY `no`) or die ("Error:".mysql_error());

when you're supposed to have the quotes!

 

Try this on line 9.

mysql_query("ALTER TABLE 'xxx' ORDER BY 'no'") or die ("Error:".mysql_error());

P.S. Please understand this! Replace the line, OK?

211490[/snapback]

pawitp, by using Post #8 data,

I tested different kind of quotes and I now find that quotes MUST NOT be added around table and colunm.

 

However, in this topic, many visitors just asked me to change the quote's sign or omit the semi colon.

So I think many people miss this rule.

>> quotes MUST NOT be added around table and colunm.

By the way , thanks for no9t9's help~~

Hope no one make this mistake again ~

 

----------------------------------------------------------------------

SUMMARY

Only this code can run~

mysql_query('ALTER TABLE xxx ORDER BY no');

All of following codes CANNOT work.

mysql_query(ALTER TABLE `xxx` ORDER BY `no`;);

mysql_query(ALTER TABLE `xxx` ORDER BY `no`);

mysql_query('ALTER TABLE `xxx` ORDER BY `no`');

mysql_query('ALTER TABLE \'xxx\' ORDER BY \'no\'');

mysql_query("ALTER TABLE `xxx` ORDER BY `no`");

mysql_query("ALTER TABLE 'xxx' ORDER BY 'no'");

[leiaah 0]

Are you trying to update the actual items in your table or just the whole table? Maybe Alter is not the right word to use, try UPDATE if you want to "update" or edit items in table xxx. I'm not sure with this one but you can give it a try.$query = "update xxx set field1='field1_entry' where ID='1' "; mysql_query($query);