[PHP-DB] Help with mysql and php 4.03

[Tobbe]

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




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Cookies

[Tobbe]

Hi !!

I'm trying to but down 2 variables ($iCount and $sPhone) into a cookie and I
used the code example from the php manual from php.net put I only get the
error messages (down below)

And how do i get back the var in to the page

or is there another beter way to save the variables when reloading the page


___

   setcookie (cookie[two], $iCount);
   setcookie (cookie[one], $sPhone);
   if (isset ($cookie)) {
   while (list ($name, $value) = each ($cookie)) {
   echo $name == $valuebr\n; } }

__
Warning: Cannot add header information - headers already sent by (output
started at c:\program files\apache group\apache\htdocs\masscot\delete.php:5)
in c:\program files\apache group\apache\htdocs\masscot\delete.php on line 51

Warning: Cannot add header information - headers already sent by (output
started at c:\program files\apache group\apache\htdocs\masscot\delete.php:5)
in c:\program files\apache group\apache\htdocs\masscot\delete.php on line 52


Thanks / Tobbe



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]