¹ØÓÚmysql²éѯ·µ»ØÊý×éµÄÒ»¸öСÎÊÌâ - PHP / »ù´¡±à³Ì
ÎÒÓÐÒ»¸ö²éѯ
$arr_status = array('1' => 'ÉêÇëÖÐ', '2'=>'´¦ÀíÖÐ', '3' => 'ÒÑ·¢»õ', '4' => 'ÒÑÍË¿î');
$lotterylist = array();
$sqltext = "SELECT* from {$tablepre}exchange WHERE uid = '$discuz_uid' ORDER BY exchangetime DESC LIMIT $start_limit, $tpp";
$query = $db->query($sqltext);
while($lottery = $db->fetch_array($query)) {
$lotterylist[$lottery['giftid']] = $lottery;
$lotterylist[$lottery['giftid']]['status_name'] = $arr_status[$lottery['status']];
$lotterylist[$lottery['giftid']]['exchangetime'] = date('m-d H:i',$lottery['exchangetime']);
}
Íê³ÉÖ®ºó£¬ÎÒÓÃcount($lotterylist)µÃµ½µÄ½á¹ûÊÇ4
µ«ÊÇÎÒprint³ö$sqltext£¬Äõ½Êý¾Ý¿âÈ¥Ö´ÐУ¬µÃµ½µÄ¼Ç¼½á¹ûÓÐ9Ìõ¡£Õâ¾ÍºÜÆæ¹ÖÁË¡£µ½µ×ÊÇÔõô»ØÊÂÄØ£¿
¹þ¹þ£¬ÕæÊÇÈç´Ë¡£Ð»¹ýÁË
Ïà¹ØÎÊ´ð£º
±±¾©2ÄêPHP¾ÑéÇó¼æÖ°
½Ó·Ö
·¹ý½Ó·Ö£¡.¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
jf~~~~~~~~~~~~~~Ö§³Ö
ßÀ¡£¡£ÎÒÃÇÐèÒª¼æÖ°£¬¿ÉÊÇÔõôÁªÏµÄãѽ£¿
¶¥¡£¡£¡£ »Ø¸´ÄÚÈÝ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
º¼ÖÝÄãÈ¥²»È¥°¡ ¡£¡£¡£¡£¡ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
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)ÖеÄÊý¾ ......
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ã滺´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......