[RESOLVED] Trouble transferring to new host

middleman666

Hi All,

I have just transferred a site to a new host, this included a MySQL database which seems to have transferred fine, but now I see I have a problem...

The site should display entries from the database where the Date value is more that today's date, but for some reason, All the entries are being displayed.

I thought the Date value must have been reset to today's date when I uploaded the database, but everything seems as it should be.

The query I'm using to display these entries is this:

//Today
$today = date('Y-m-d H:i:s' );

  //SQL Query  

  $query = "SELECT *, 
            DATE_FORMAT(Date,'%a, %D %M, %Y') AS readdate,
            DATE_FORMAT(Date,'%H:%i') AS time FROM Shows 
            WHERE Date >= \"%$today%\" 
            ORDER BY Date ASC";

It worked fine on the old host. The only difference between this host and the old one is the version of MySQL:
Old Host: MySQL version 4.0.27-standard
New Host: MySQL version 4.1.10a

Does anyone know what could be causing all the entries to read out?

Thanks.

etully

After you assign $query, print the value. Do the same on the old server. Check to see how they are different.

Print the value of $query on the old server and then manually run that query on the new server. This will tell you whether the query is getting constructed wrong or if there is a fundemental difference between PHP, MySQL, or the OS itself on the two machines.

Once you know what's causing the queries to return different results, then you are half way to fixing it.

middleman666

New Host Print Query:
SELECT *, DATE_FORMAT(Date,'%a, %D %M, %Y') AS readdate, DATE_FORMAT(Date,'%H:%i') AS time FROM SPCshow WHERE Date >= "%2007-07-16 10:44:49%" ORDER BY Date ASC

I ran this using PHPMyAdmin and got all entries, but then I took out the % from the Date and it seems to be working.

Old Host Print Query:
SELECT *, DATE_FORMAT(Date,'%a, %D %M, %Y') AS readdate, DATE_FORMAT(Date,'%H:%i') AS time FROM SPCshow WHERE Date >= "%2007-07-16 09:44:49%" ORDER BY Date ASC

I tried to run this on my old host, but it just returned 'Page cannot be display'... - one of many reasons I changed host.

Cheers for your help etully!