Re: multi-table query error...
Fabio Vaona wrote:
> On the server I run whm/cpanel, I saw into server software configuration that I can switch from 4 to
> 4.1 mysql version...
> Is this change safe?
> I don't wanna switch to 4.1, update the software on the server and than have problems with my old
> domains...
I would be very careful with this. I ran into several issues (admittedly because of my own sloppy SQL) when going from 4.0 to 4.1
You can also write your query with a (4.0 compatible) join, something like (untested):
SELECT
db_qw_db.qid
FROM db_qw_db
JOIN db_qw_site_addr ON db_qw_site_addr.qid = db_qw_db.qid
WHERE
db_qw_db.active = '1' AND db_qw_db.status = '0'
AND db_qw_site_addr.address like '%$province_ricerca[$prov]%'
--
felix
Please use
BBCode to format your messages in this forum.