What is the best way to learn everything in mysql ? i use mysql for php...

[jd2007]

i use mysql for php...as a php coder, is all the stuff here http://www.w3schools.com/sql/default.asp enough...thnx

[flappy_warbucks]

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

[jd2007]

$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

[MadTechie]

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.

[mattison]

to be honist i would google some Mysql e-books, allways works for me

[lemmin]

I have no idea if this matters, but try to capitalize those key words. SELECT, FROM, ORDER, BY, DESC, LIMIT.

[448191]

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.  :'( 

[lemmin]

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.