windows 7 x64
php v 5.3.1
MySQL client version: 5.1.41
I was trying to get this:
"SELECT name, CONCAT_WS('<br />', address1, address2), city, state,
stores.zip_code, phone, store_image,ROUND(return_distance($lat, $long, latitude, longitude))
AS distance FROM stores LEFT JOIN zip_codes USING (zip_code) ORDER BY distance ASC LIMIT 3"
to work in my distance.php script (store_image was an added field).
It took me a while to debug this problem, but I eventually got it to work. My 'someuser' (and I'm guessing others who jumped from your PHP6 MYSQL5 book to this one) doesn't have the same privileges to mysqli functions as the 'root' user does, so I couldn't get this script to run outside the admin programs.
I don't want to give 'someuser' ALL PRIVILEGES, so which additional privileges do I need to enable for 'someuser'(currently SELECT, INSERT, UPDATE, DELETE, FILE)?
Thanks for the great books (and any help),
~Randy