php connection to mysql

[Anon]

Can anybody point me in the right direction for getting some examples of php connecting with mysql. I'm close but need some help. Thanks in advance.

[cwwesley]

mysql_connect("localhost","user","password");
mysql_select_db( "database_name" );

$cursor = mysql_query("select column1,
column2 from table_name");

if( mysql_num_rows( $cursor ) <= 0 ){
echo( "YOUR QUERY HAS NO RESULTS" );
} else {
while(
list( $column1, $column2 ) =
mysql_fetch_row( $cursor ) ){
echo( "Column 1 is $column1<br>" );
echo( "Column 2 is $column2<br>" );
}
}

mysql_close();

[Anon]

Take a look at http://phplib.netuse.de/index.php3.

PHPLIB has an include script which you could use mysql_DB.inc. It has all that you need and is oop.

Scott

[Anon]

I'm sure this isn't a first, answering my own question. I found an excellent article on getting up and running with php code and an mysql database. The tutorial guides you from installation of php and mysql right up to running the first php that interacts with a database. Enjoy.

http://www.weberdev.com/ViewArticle.php3?ArticleID=22

PJ