請問sql找資料 條件 2個 時語法該怎麼打

foreveriori

請問sql找資料 條件 2個 時語法該怎麼打

query_sql "SELECT `value` FROM `char_reg_num_db` WHERE `char_id` = "+getpartyleader(getcharid(1),2)+" AND 'Cooldown22'="+.@Cooldown;

我這樣寫失敗了，請教各位前輩應該是那邊錯了？我想取得隊長的變數值 Cooldown22

emistry

1. WHERE `column1` = number1 AND `column2` = number2

複製代碼

goddameit

你的 char_reg_num_db 表單裡面有 Cooldown22 這欄位嗎?

foreveriori

前輩只有 char_id key index value 這四個欄位



Cooldown22是 key欄位的

foreveriori

呃這樣寫 query_sql "SELECT `value` FROM `char_reg_num_db` WHERE `char_id` `key` = "+getpartyleader(getcharid(1),2)+" 'Cooldown22'="+@Cooldown;

query_sql "SELECT `value` FROM `char_reg_num_db` WHERE `char_id` = "+getpartyleader(getcharid(1),2)+" AND `key`='Cooldown22' ="+.@Cooldown;

query_sql "SELECT 1 FROM `char_reg_num_db` WHERE `key` = 'Cooldown22' AND `char_id` IN ( SELECT `char_id` FROM `char` WHERE `account_id` = "+ getpartyleader(getcharid(1),2)+")",.@Cooldown;


也失敗，其實我弄了六個小時了....

sinya

foreveriori 發表於 2015-6-19 12:48 AM
呃這樣寫 query_sql "SELECT `value` FROM `char_reg_num_db` WHERE `char_id` `key` = "+getpartyleader(g ...

這樣

query_sql("SELECT `value` FROM `global_reg_value` WHERE `char_id` = "+getpartyleader(getcharid(1),2)+" AND `str` = 'Cooldown22'",.@value);

取出的值會存到 .@value 變數

foreveriori

sinya 發表於 2015-6-19 01:03 AM
這樣

query_sql("SELECT `value` FROM `global_reg_value` WHERE `char_id` = "+getpartyleader(getch ...

可以了非常感謝SINYA前輩   (淚奔....

終於....