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. 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 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. 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. Link to comment https://forums.phpfreaks.com/topic/241924-mysql-between-and-problem/#findComment-1242435 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.