mysql °´±íÍ·ÅÅÐò ÓÐÕâÑùµÄÒ»¸ö±í table name age heigth 'beibei' 20 167 'jingjing' 26 170
ĬÈϰ´name½µÐò£¬µãageʱ°´ÉýÐòLZɶÒâ˼£¿ Èç¹ûÏësql·µ»ØµÄ½á¹û¼¯ÊÇÅÅÐòºÃµÄ£¬¹¹ÔìÒ»¸ösqlÓï¾ä´ø¸öorder by¾ÍÐÐÁ˰¡ È磺¡°select * from table order by name desc¡± ²éѯ³öµÄ½á¹ûÈç: name age heigth 'beibei' 20 167 'jingjing' 26 170 µ±µã»÷±íÍ·nameʱÉýÐòÅÅÐò,µ±µã»÷ageÊǰ´½µÐòÅÅÐò£¬µãµÚ¶þ´Îʱ°´ÉýÐò ÄãÖ»ÐèÒª¸ü»»¡°order by name desc¡±ÕâÒ»¶Î¾ÍOKÁ˰¡ nameÉýÐòÅÅÐò£ºorder by name asc age°´½µÐòÅÅÐò£º order by age desc age°´ÉýÐòÅÅÐò£º order by age asc Êǵã»÷±íÍ·ÅÅÐò
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......