jd2007 Posted August 21, 2007 Share Posted August 21, 2007 i use mysql for php...as a php coder, is all the stuff here http://www.w3schools.com/sql/default.asp enough...thnx Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/ Share on other sites More sharing options...
flappy_warbucks Posted August 21, 2007 Share Posted August 21, 2007 Noo thats a Tutorial, it will show you the basics but the more advanced stuff you really do need to get a book on the subject. Hit Amazon and see what comes up Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-329676 Share on other sites More sharing options...
jd2007 Posted August 21, 2007 Author Share Posted August 21, 2007 $this->que="select $this->id, $this->title, $this->thumb from $this->table order by $this->table2.$this->past desc limit 5"; why do i get this error? 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 'desc limit 5' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-329714 Share on other sites More sharing options...
MadTechie Posted August 21, 2007 Share Posted August 21, 2007 Noo thats a Tutorial, it will show you the basics but the more advanced stuff you really do need to get a book on the subject. Hit Amazon and see what comes up Humm.. well the manual seams to have suite quite well, a book can be just another lite of Tutorials..! the understanding of why it works is important. Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-329718 Share on other sites More sharing options...
mattison Posted August 21, 2007 Share Posted August 21, 2007 to be honist i would google some Mysql e-books, allways works for me Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-330129 Share on other sites More sharing options...
lemmin Posted August 21, 2007 Share Posted August 21, 2007 I have no idea if this matters, but try to capitalize those key words. SELECT, FROM, ORDER, BY, DESC, LIMIT. Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-330134 Share on other sites More sharing options...
448191 Posted August 21, 2007 Share Posted August 21, 2007 I have no idea if this matters, but try to capitalize those key words. SELECT, FROM, ORDER, BY, DESC, LIMIT. If you have no idea, don't post. :'( Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-330153 Share on other sites More sharing options...
lemmin Posted August 21, 2007 Share Posted August 21, 2007 Since I did not see anything else that could be wrong with it other than DESC needing to be capitalized, I figured it would be worth a try. Quote Link to comment https://forums.phpfreaks.com/topic/65943-what-is-the-best-way-to-learn-everything-in-mysql-i-use-mysql-for-php/#findComment-330278 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.