m118 Posted July 13, 2011 Share Posted July 13, 2011 hello I need write a program related to the mysql database. it need to search begin time and endtime and contractor name. I write a program , it does not work out. Please tell me how to fix it . Begintime and endtime are in the different row. $select1="select * from nt_contract_list where begintime >='2009-08-07' and endtime <='2010-04-30' order by begintime DESC "; The program is not working , Please tell me how to fix it . Thank you very much. Quote Link to comment https://forums.phpfreaks.com/topic/241924-mysql-between-and-problem/ Share on other sites More sharing options...
AyKay47 Posted July 13, 2011 Share Posted July 13, 2011 can you post your table set up Quote Link to comment https://forums.phpfreaks.com/topic/241924-mysql-between-and-problem/#findComment-1242414 Share on other sites More sharing options...
m118 Posted July 13, 2011 Author Share Posted July 13, 2011 The data can be displayed , but it does not reach the goal. Quote Link to comment https://forums.phpfreaks.com/topic/241924-mysql-between-and-problem/#findComment-1242421 Share on other sites More sharing options...
m118 Posted July 13, 2011 Author Share Posted July 13, 2011 Thank you . Actually, it is working out. Quote Link to comment https://forums.phpfreaks.com/topic/241924-mysql-between-and-problem/#findComment-1242435 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.