Trying to learn php/mysql

[Vizonz]

okay i am gonna use this post as my general help in php and mysql. instead of starting new threads when i have questions.

 

 

Okay my first thing i want to know is how would i query the database and display just something basic

 

okay i got a table called Books. 

 

and i have  5 fields in the books table

 

title | Id | Comment | Date | Writer

 

okay now i want to display  a top ten

 

how would i query the database with php  and display.

 

the last books submitted with a comment. ( so latest 10 books with comments left.

 

and then display it

 

Title - Writer - Comment  - Date

 

 

 

and since i am learning something basic like this  without coding it correct wqould it be some sort of security risk

 

[murdocsvan]

I'm going to recommend to you www.w3schools.org to learn PHP as that's where i started.

 

I know it's not helpful to what you want to know, but what you think you might need to start with may not necessarily be a GOOD place to start.

 

The first things you should learn is basic syntax, such as the echo command, how variables work and the if..then...else statement. Then move on to using arrays, looping statements etc.

 

I'd only recommend learning how to use database integration and MySQL after you've covered the basics of the PHP language.

 

I'd also recommend learning to code in SQL as that is the language you would need to learn to create a connection between PHP and MySQL