zhangy Posted July 3, 2009 Share Posted July 3, 2009 On my windows server things were working fine, but once I tranfered to linux the following doesnt work. anyone know why? $result = mysql_query("SELECT * FROM $table WHERE col_1='lame' AND submission_date BETWEEN UNIX_TIMESTAMP(DATE_SUB( CURDATE( ) ,INTERVAL 30 DAY )) and UNIX_TIMESTAMP( ) ORDER BY submission_id DESC"); Link to comment https://forums.phpfreaks.com/topic/164678-server-change-change-things-wtf/ Share on other sites More sharing options...
flyhoney Posted July 3, 2009 Share Posted July 3, 2009 What do you mean by "doesn't work"? We're going to need as much information as you can give us. Link to comment https://forums.phpfreaks.com/topic/164678-server-change-change-things-wtf/#findComment-868422 Share on other sites More sharing options...
zhangy Posted July 3, 2009 Author Share Posted July 3, 2009 I mean nothing displays. Its supposed to select information from database and output onto webpage. But nothing shows up. Link to comment https://forums.phpfreaks.com/topic/164678-server-change-change-things-wtf/#findComment-868431 Share on other sites More sharing options...
flyhoney Posted July 3, 2009 Share Posted July 3, 2009 Put some debugging print statements in there. There are tons of questions you can ask. Are you connecting to the database? Is error reporting turned on? What resource id are you getting from mysql_query? Is there an error in mysql_error()? Link to comment https://forums.phpfreaks.com/topic/164678-server-change-change-things-wtf/#findComment-868433 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.