connecting to mysql

REDNINE

hell everyone, iam going thru the pains of learning php, mysql and have zero experiance :rolleyes:
so i cant connect to mysql ,
/ Open the mysql connection
$dbc = mysql_connect("$sql_host", "$sql_user", "$sql_password");
if(!$dbc) {
print_error("Could not connect to mysql: " . mysql_error());
}
if (!mysql_select_db($sql_dsname)) {
print_error("Could not select the database: " . mysql_error());
}

this is the script i am using but no matter what i do it will not work. this is the error i get, it says, fatal error: call to undefined function mysql_connect()

so i tried to reconfigure a little here and there but didnt really understand what im supposed to do to get php and mysql together.
i am currently running php5.1 and mysql 5.0.

so no matter what i do to the script i get the same error so i beleive that php doesnt know where mysql is or what it is. is this a bad install or a config prob?
thanks for the help !!!

NFClimber

It sounds like the mysql extension is not enabled in the php.ini file. Did you remove the semicolon in the line that says:

;extension=php_mysql.dll

You have to remove this, and then make sure that the dlls are in the specified extension directory. To do a quick check if mysql is enabled, make a small php file and use this function:

phpinfo();

It will display all the info about your php server, and if mysql is enabled, it should have a section with information on it.

Hope that helps.

REDNINE

ok i deleted the semi-colon, and checked in php info and found that there is no mention of mysql whatsoever, did not know how to check to see if the .dll is in the right locations, my guess is that they are not.
thanks for your time and i will look more into the .dll locations anymore help will be greatly appreciated!
thanks a bunch! 🙂

REDNINE

ok i think i found what you mean . the mysql.dll is in the ext folder , i looked again in php.ini and did find mentions of mysql, dont know if thats what i was looking for or if someting diffrent,
i also indicated where the extensions are in the, extension_dir =, but not sure if it was necessary, i just put the location in there D:\development\php\ext"
yet still no joy oh well i will keep at it , thanks!

REDNINE

http://www.faqts.com/knowledge_base/view.phtml/aid/34662/fid/33
ifound this link to get mysql working ,and it is! i know have some new walls to break down, but hey im moving forward : ) so i will post my progress for posterity and other new guys : )

REDNINE

Could not connect: Can't connect to MySQL server on 'localhost' (10061)PHP Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in D:\development\apache\Apache2\htdocs\ES stats\~phpdesigner_output_tmp.php on line 2

Ok this is the latest error message i get, so i assume i enabled mysql, so now it just wont connect, i am sure that this is also a config issue . any suggestions? thanks in advance !!! 🙂