Help with mysql and php 4.03
| From: | Tobbe | Date: | Wed, 09 May 2001 12:35:26 +0000 |
| Subject: | Help with mysql and php 4.03 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9189@lists.php.net to get a copy of this message | ||
Hi I'm trying to put up some php files I have created that is working
normaly at php local server with php 4.04 and mysql 3.23.36
but it won´t work at the servr where the client will have it
with php 4.03 and mysql 3.22.32
the thing that won´t work is when I got a sql query that contains a inner
join statement
that wont work with 3.22.32 is there any one that knows if it can´t handle
inner join statemaents or are the loking diffrentlie
the inner join statement that I have is below
$result = mysql_query("SELECT * From city
inner join state_prov on state_prov.state_id = city.state_id
inner join area_phone on area_phone.city_id = city.city_id
inner join phone_nr on phone_nr.phone_id= area_phone.phone_id
inner join netwrk on netwrk.net_id = area_phone.net_id
inner join country on country.country_id = state_prov.country_id
inner join areacode on areacode.area_id = area_phone.area_id
ORDER BY '$sSort'");
Thanks / Tobbe