PAGE-2: Question~about Mysql related to error, mysql, queryalter, code

no9t9

Dec 2 2005, 04:55 PM

You need to provide more information. How can we tell what is wrong from a single line of code? What is the error message you are getting?? Do you even have a table called xxx and in that table is there a column called no?

Reply

kakingho

Dec 5 2005, 02:34 PM

QUOTE(no9t9 @ Dec 3 2005, 12:55 AM)

You need to provide more information. How can we tell what is wrong from a single line of code? What is the error message you are getting?? Do you even have a table called xxx and in that table is there a column called no?

Of course i have that table and colunm.
I had said before

QUOTE

CODE

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

Why i cant run the above code?!

But i can directly type and run this code in phpmyadmin's sql query

CODE

ALTER TABLE `xxx` ORDER BY `no`;

Actually, there is only a main code.
You asked the above question seem to be kidding me.

Why don't you read my article completely before replying.
Why don't you ask me whether my connection password is correct or not.

Anyway, forgive my non-enough information.

Here is the whole file.
There is no error message with nothing happen.

CODE

<?
$ip="localhost";
$user="xxx";
$pw="xxx";

$link=mysql_connect($ip,$user,$pw)or die ("Could not connect");

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

mysql_close($link);
?>

But i can directly type and run this code in phpmyadmin's sql query

CODE

ALTER TABLE `xxx` ORDER BY `no`;

So I want to know whether php can use order function.
What's going on??!

Reply

no9t9

Dec 6 2005, 02:15 AM

of course i will ask stupid questions if you simply post a statement like "what's wrong... Please correct..." Do you expect people to be mind readers? People need information to in order to resolve problems.

1) in your sql query statement you don't need the quotes around the table name or the column name (but this should't be causing the problem).
2) you talked about user name and password... well did you check them? do they match in your control panel? did you grant permissions to that user to your database you are trying to access?
3) if there is no error message how do you know there was an error? if you've already run the query in phpmyadmin, the table will already have been ordered according to the query. if you run the same query again, nothing will happen
4) make sure you are selecting the right database in your mysql_select_db function
5) the code looks fine to me, so it is not a coding issue
6) use mysql_error funtion so that it tells you what the error is (if there is one).
7) And last, I used the 'ALTER TABLE xxx ORDER BY yyy' function and it works fine.

CODE

<?
$ip="localhost";
$user="xxx";
$pw="xxx";

$link=mysql_connect($ip,$user,$pw) or die ("Error:".mysql_error());

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

mysql_close($link);
?>

Reply

kakingho

Dec 7 2005, 10:02 AM

Here is my full report.

User name , password, permission,etc ..
all are normal~

1. can run successfully ( this code is for testing only)

CODE

<?
$ip="localhost";
$user="xxx";
$pw="xxx";

$link=mysql_connect($ip,$user,$pw) or die ("Error:".mysql_error());

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

mysql_query("UPDATE xxx SET
ip='test' ,password='test' where no=41");

mysql_close($link);
?>

2. can run this code in phpmyadmin's sql query directly

CODE

ALTER TABLE `xxx` ORDER BY `no`

3. cannot run this code in phpmyadmin's sql query and a error is shown

CODE

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

error message

QUOTE

#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 'mysql_query(ALTER TABLE `xxx` ORDER BY `no`)' at line 1

4. After run this file, a error is shown.

CODE

<?
$ip="localhost";
$user="xxx";
$pw="xxx";

$link=mysql_connect($ip,$user,$pw) or die ("Error:".mysql_error());

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

//mysql_query("UPDATE xxx SET
ip='test' ,password='test' where no=41");

mysql_close($link);
?>

error message:

QUOTE

Parse error: parse error, unexpected T_STRING in /home/xxx/public_html/test.php on line 9

line 9 means

CODE

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

* I manage the table into descending order before every testing.
* phpmyadmin version: 2.6.4-pl2
* php version: 4.3.10
* PERL version: 5.8.4

please help to solve this strange problem~~

Reply

pawitp

Dec 7 2005, 10:46 AM

Everyone mentioned it! You used

CODE

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.

CODE

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

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

Reply

no9t9

Dec 7 2005, 06:22 PM

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.

Reply

kakingho

Dec 9 2005, 02:14 PM

QUOTE(pawitp @ Dec 7 2005, 06:46 PM)

Everyone mentioned it! You used

CODE

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.

CODE

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

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

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~

CODE

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

All of following codes CANNOT work.

CODE

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

CODE

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

CODE

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

CODE

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

CODE

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

CODE

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

Reply

leiaah

Dec 17 2005, 09:49 PM

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);

Reply

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute your information that might help someone here. Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE

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

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