What is corret way to connect to MySQL?

Answer 1

Typo? Your question has msyql_select_db instead of mysql_select_db - note the swap of the s and y in mysql.

Answer 2

$connect = mysql_connect('host', 'user', 'pass);
           mysql_select_db('database', $connect);

That's how you connect to a database.

You also spelled mysql wrong.

Getting Fatal error: Call to undefined function msyql_select_db() with mysql_connect('localhost', 'name', 'pass'); <<msyql>>_select_db('dbname');

Arrows around the error.

Answer 3

you spelled your function incorrectly mysql not msyql

Answer 4

I do not understand your question, but maybe this will help.

$session = mysql_connect('host','username','password');

mysql_select_db('database', $session);

$resultset = mysql_query('SELECT * FROM TABLE', $session);

$result = mysql_fetch_assoc($resultset);

Good luck...

Answer 5

May want to change localhost to '127.0.0.1' as well...I've had issues with that before.

Answer 6

Try:

$result= mysql_query('SELECT DISTINCT username FROM users'); 
$somethings= array(); 
while ($row= mysql_fetch_assoc($result)) { 
    $somethings[]= $row['something']; 
}

Basically changing $results to $result.