kakingho

..thx a lot~~successful!

The above method is only to add "ok" at the end (DO NOT write on a new line) I want to know... How to add data on a new line and at the end of txt file??! thx~

test.php <?php$abc='123';include 'index.htm';?> index.htm <table width="200" border="1"> <tr> <td>$abc</td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> it shows this pic http://i19.photobucket.com/albums/b190/kakingho/abc.jpg but i want to show this http://i19.photobucket.com/albums/b190/kakingho/123.jpg i want to separate main php codes in php file and main website structure in htm file~ how to do that?! i dont want to type this in htm file, any other method?? <table width="200" border="1"> <tr> <td><?PHP $abc; ?></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> thx~ Notice from BuffaloHELP: Please limit your picture's width to no more than 640px

I want to install whois system in my website in which my visitors can search other websites' information.I want to have php source code of it.Is it free of charge? What is the official website of WHOIS??!thx~

thx a lot

Your method is good to deal with large data.Are there any other easy methods to show only 1 record with corresponding no. easily?

For example...a table have 2 columns, 100 rowsfor column i.e. no, nameI want to get corresponding name when no=17How to write this php coding??

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

Here is my full report. User name , password, permission,etc .. all are normal~ 1. can run successfully ( this code is for testing only) <?$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 SETip='test' ,password='test' where no=41");mysql_close($link);?> 2. can run this code in phpmyadmin's sql query directlyALTER TABLE `xxx` ORDER BY `no` 3. cannot run this code in phpmyadmin's sql query and a error is shown mysql_query(ALTER TABLE `xxx` ORDER BY `no`) error message 4. After run this file, a error is shown. <?$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 SETip='test' ,password='test' where no=41");mysql_close($link);?> error message: line 9 means 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~~

It is better if there is a editting power for people to edit their own topics.

Of course i have that table and colunm.I had said before 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. <?$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 ALTER TABLE `xxx` ORDER BY `no`; So I want to know whether php can use order function.What's going on??!

So.....what's wrong with the code??Please correct it~~

well~ 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'"); I finished testing.All of above cannot work!! I want to know whether php can use order function.

For the web-based game,i think it is not really bad graphic. Of compraing with install- game, it is really bad

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 ALTER TABLE `xxx` ORDER BY `no`; Notice from jlhaslip: Modified title