Using PHP with MySQL - Basic code required

[suprsnipes]

Hi,

 

This is my first post on this forum. I have been using PHP for about a week. I recently set up a database in MySQL and I'm trying to learn the basics.

 

I was hoping that a member of this forum could give me a friendly nudge in the 'right' direction.

 

I need to make a connection to MySQL database using PHP. I want to know how to run a basic 'if' statement and display the result on the screen for each row of data that meets the criteria...

 

Is this possible?

[Ken2k7]

For the most part, yes.

 

You can use mysql_connect to connect to the host, mysql_select_db to select the database name you want to use, mysql_query to run SQL queries.

 

You'll have to learn how to write SQL if you don't already know. Hope this helps.

[suprsnipes]

Thanks.

 

I have managed to get a connection to the database.

 

Basically to get the ball rolling I want to query the database to return the value in the price field if the value in the type field is equal to "N".

 

How would I go about this?

[Ken2k7]

You should really Google tutorials on this or else you will have tons and tons of questions asking people to write stuff for you.

 

The SQL will go somewhat like this -

SELECT * FROM tablename WHERE type='N'

 

Run that through mysql_query. And then use a while loop with mysql_fetch_assoc. Please read the examples in the manuals. They help. Otherwise, you'll just feel inferior by asking more questions the manual examples would have answered.

 

Hope this helps.

[aashcool198]

The best thing is you right away start to read some sql tutorial. its very simple and won't take much time and then read about php and Mysql.  Than will start the real fun of coding and Questions.

 

Best wishes!

[Axeia]

I recommend w3schools > php/mysql as it's brief explaining what you actually want to know and includes examples. Unlike most tutorials that just give you a bunch of non interesting info about the history of mysql and what not.