[問題]關於MYSQL之用法

[神僕]

經常見到有MOD要用到SQL
但我不知如何做,請大大幫忙

#
#-----[ ACTION: EXECUTE]-----------------------------------
#
#
SQL QUERY:
ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100);
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);

[依夢兒]

搜尋 phpMyAdmin 。

[神僕]

當我按"會員列表 "時出現了

Parse error: parse error, unexpected '.', expecting ')' in /home/virtual/site94/fst/var/www/html/forum/memberlist.php on line 245

而我的code是\r
'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),.($userdata['user_level']==ADMIN)?'<a href="' . append_sid("delete_users.$phpEx?mode=user_id&del_user=$user_id") . '"><img src="' . $images['icon_delpost'] . '" alt="' . $lang['Delete'] . ' '.$username.'" title="' . $lang['Delete'] . ' '.$username.'" border="0" /></a> ':'')


請問知不知發生什麼事嗎?

[messagebox]

當我按"會員列表 "時出現了

Parse error: parse error, unexpected '.', expecting ')' in /home/virtual/site94/fst/var/www/html/forum/memberlist.php on line 245

而我的code是\r
'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),.($userdata['user_level']==ADMIN)?'<a href="' . append_sid("delete_users.$phpEx?mode=user_id&del_user=$user_id") . '"><img src="' . $images['icon_delpost'] . '" alt="' . $lang['Delete'] . ' '.$username.'" title="' . $lang['Delete'] . ' '.$username.'" border="0" /></a> ':'')


請問知不知發生什麼事嗎?

你確定你貼對~~
你貼的語法$i + ( $HTTP_GET_VARS['start'] + 1 ),這裡不該用句點接在一起~.($userdata

而且($userdata['user_level']==ADMIN)判斷後的傳回值你要丟給誰~應該是\r
某變數 = ($userdata['user_level']==ADMIN) ? 'true' : 'false';

基本上不是你刪了不該刪的東西~就是貼了不該貼的東西~~

整個檔案還原~~重搞比較快~~

[wencong]

貼在\r
'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),
最後面的逗號之前..

變成

'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ).(($userdata['user_level']==ADMIN)?'<a href="' . append_sid("delete_users.$phpEx?mode=user_id&del_user=$user_id") . '"><img src="' . $images['icon_delpost'] . '" alt="' . $lang['Delete'] . ' '.$username.'" title="' . $lang['Delete'] . ' '.$username.'" border="0" /></a> ':''),