[PHP-DB] Query syntax error?
Hello, I have a query on a page that used to work fine, but is now generating an error. I assume that the version of php or mysql was updated on the webhost server or something like that? Here is the query: select count(places_data.place_id) as areacount, boroughs.borough_name as boroname, area.area_name as areaname, area.area_id as areaid from places_data a inner join boroughs b on a.area_fid = b.area_id inner join area c on c.borough_fid = b.borough_id where places_data.on_off_fid = 2 . $cat_query . group by c.area_name order by b.borough_name ASC, c.area_name ASC And here is the error message: Unknown column 'places_data.place_id' in 'field list' But place_id is a field in places_data table. Any ideas? Thanks! Harvey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Query syntax error?
Thanks, I got it working now, had to use the a/b/c thing a few times -Original Message- From: jose [mailto:jojap...@gmail.com] Sent: Thursday, January 13, 2011 9:52 AM Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Query syntax error? you have renamed places_data table to 'a' 2011/1/13 Harvey har...@harveyk.com: Hello, I have a query on a page that used to work fine, but is now generating an error. I assume that the version of php or mysql was updated on the webhost server or something like that? Here is the query: select count(places_data.place_id) as areacount, boroughs.borough_name as boroname, area.area_name as areaname, area.area_id as areaid from places_data a inner join boroughs b on a.area_fid = b.area_id inner join area c on c.borough_fid = b.borough_id where places_data.on_off_fid = 2 . $cat_query . group by c.area_name order by b.borough_name ASC, c.area_name ASC And here is the error message: Unknown column 'places_data.place_id' in 'field list' But place_id is a field in places_data table. Any ideas? Thanks! Harvey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Hiding Admin Link
You can start by creating a login system http://www.phpeasystep.com/workshopview.php?id=6 Then you can do an if/then statement to show the link only to people who have logged in... On 4/30/2009 10:29 PM, Joey Hendricks wrote: Hello, I am very new at PHP so I will try to explain my question the best I can. I was wondering if there was a way to have a link show only to the owner of the site? Like having a Admin link for editing posts, but hidden to all users except the owner. Thank you very much for your time!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php generators
Dreamweaver has some php generation. That's how I started to learn. I am not an expert by any means, and I am sure that experts will not like the code, but for a beginner, I found it totally fine On 4/28/2009 12:40 PM, conor mahaney wrote: Hello Everyone, I am a beginner with PHP and Mysql and have dived into a project that may be to much for me right now. I am still learning php and do not have enough knowledge to accomplish what I am trying to. I have been looking into PHP code generators and was wondering if anyone has any thoughts or suggestions, also if anyone knows of any good resources for learning Thanks _ Rediscover HotmailĀ®: Get e-mail storage that grows with you. http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Storage2_042009 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] currency formating
On Tue, 2002-01-01 at 00:08, Webmaster wrote: Yea i have read that but did not think it was what i needed considering it is for an automated billing system and the customer may not like it if they are charged and extra .50 cents or so every month. Their has got to me another alternative. Well, round wouldn't do that, but what you're looking for is number_format(). Billy -- 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]