how to use MySQL software?

[wilbasket23]

hello everyone
can anyone help me, i am trying to doing a project which require to use a database management program to do my project. so i choose to use MYSQL. but when i look at their manual is kind of complicated to figure out what did heck they saying, is any body know any websites have tutorial on how to use MySQl. or can anyone explain the basic things about MySQl, and show me how to use the simple query string so i can write my interface which can connect to the Mysql database. please help

[mairving]

MySQL is an open-source database that is optimized for web applications and speed. It couldn't have reached it's popularity by itself though since it is command line driven. The true power of MySQL comes when hooked up with a scripting language like PHP or PERL.

Usually for connecting to the database, I use the DB_SQL class that comes with PHPLib. I will set this file in a folder below the public_html directory since it has username and passwords in it. From it, you can use some of it's functions to call database records.

For instance, at the top of the page, you would have this:

PHP Code:

require("pathto/db_mysql.inc");
$db_sql = new db_sql; 


Then for your query:

PHP Code:

$q = "SELECT * from table_name ";
$q .= "WHERE column_name='value' ";
$db_sql->query($q);
$db_sql->next_record() ; 


Then call the values that you selected by:

PHP Code:

$db_sql->p("column_name")); 


It is pretty easy to do this way.