[問題] MySQL語法問題

看板Web_Design作者jamesemaj (小歐肥不肥)時間9年前 (2014/12/16 16:54)推噓4(4推 0噓 8→)

留言12則, 6人參與討論串1/1

我想做一個語法類似選取月份後她可以echo出在這選取的月份之間的DATA 但是一直都跑不出值後來我逐行debug 發現了在某一條 $Recordset1 = mysql_query($sql_query); 這條沒有值跑出來我再想應該是我SQL語法寫錯以下是我body的程式碼 <body> <form id="form1" name="form1" method="post" action="test_2.php"> <label for="m1"></label> 月份</p> <input name="m1" type="text" id="m1" value="1" /> <p>到</p> <input name="m2" type="text" id="m2" value="5" /> <p> <input type="submit" name="submit" id="submit" value="送出" /> </p> </form> <form id="form2" name="form2" method="post" action=""> <p> <?PHP $timea = $_POST['m1']; $timeb = $_POST['m2']; $sql_query = "SELECT * FROM `userdata_3` WHERE `month1` BETWEEN ".$timea." AND ".$timeb.""; //下面這行沒值 $Recordset1 = mysql_query($sql_query); $row_Recordset1 = mysql_fetch_assoc($Recordset1); echo $row_Recordset1['username']; ?> </form> </body> 麻煩各位提點了謝謝! -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.184.237.148 ※ 文章網址: http://www.ptt.cc/bbs/Web_Design/M.1418720097.A.814.html

→

bibo9901

12/16 17:05, , 1^F

12/16 17:05, 1^F

→

bibo9901

12/16 17:05, , 2^F

12/16 17:05, 2^F

→

bibo9901

12/16 17:06, , 3^F

12/16 17:06, 3^F

→

bibo9901

12/16 17:07, , 4^F

12/16 17:07, 4^F

→

jamesemaj

12/16 17:09, , 5^F

12/16 17:09, 5^F

→

jamesemaj

12/16 17:12, , 6^F

12/16 17:12, 6^F

→

jamesemaj

12/16 17:13, , 7^F

12/16 17:13, 7^F

推

pm2001

12/16 17:21, , 8^F

12/16 17:21, 8^F

我把那段 "SELECT * FROM `userdata_3` WHERE `month1` BETWEEN ".$timea." AND ".$timeb."" 改成 "SELECT * FROM `userdata_3` WHERE `month1` BETWEEN 1 AND 5" 讀的出值但我看不出我的變數錯在哪裡因為我分別echo變數都有值出現 ※ 編輯: jamesemaj (111.184.237.148), 12/16/2014 17:32:41

推

tw0517tw

12/16 18:09, , 9^F

12/16 18:09, 9^F

推

jhunkyoiori

12/16 18:41, , 10^F

12/16 18:41, 10^F

推

crossdunk

12/16 18:48, , 11^F

12/16 18:48, 11^F