| | |||||
| ||||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
![]() |
| | LinkBack | Thread Tools |
| | THREAD STARTER #1 (permalink) |
| Senior Member Join Date: Jan 2006 Location: Portland, Oregon
Posts: 2,102
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Mysql/PHP issues using WHERE I'm currently using the following code to select and get info from the database: (I am using mysql 5 and php 5) PHP Code: Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order WHERE status='pending'' at line 1 ????: NamePros.com http://www.namepros.com/programming/361370-mysql-php-issues-using-where.html Any help is much appreciated |
| |
| | #2 (permalink) |
| NamePros Member Join Date: Jun 2007
Posts: 52
![]() | Replace PHP Code: PHP Code:
__________________ |
| |
| | THREAD STARTER #3 (permalink) |
| Senior Member Join Date: Jan 2006 Location: Portland, Oregon
Posts: 2,102
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Thanks a bunch, rep added!
__________________ HostingFuze.com Premium Master Reseller Services | 99.9% Uptime Guaranteed SLA | Starting at $4.95/mo Basic Reseller Hosting @ HostFz.com - Services starting as low as $1.95/mo! |
| |
| | #4 (permalink) |
| NamePros Regular Join Date: Jun 2006 Location: Sydney
Posts: 251
![]() ![]() | Camron, it would be good pratice to put `` around your field names, the better you get at creating complex queries, the easier it be to make mistakes, or use "keywords" in your queries. =)
__________________ Site Armory, tools for your website | Webmaster SEO Forums | PHP Tutorial and coding forums |
| |