Mysql MySQL 4.0.25 & MySQL 3.23.53

[davehaz]

I just setup a site with Mysql 4, my live site running mysql3, there are some differences in the results i get when doing queries, can anybody tell my what I might do to get the same results. What information would you need, my query?

tia.

[Kid Charming]

For best results, you really should have the same setup on your development and live servers. At this point, there's really no reason not to be running at least 4.0, anyhow.

As for differences between the versions, some are going to be unavoidable -- it will be impossible to run the same query on both systems and get the same results. Without specifics, though, I can't really say more than that.