<?php

$link = mysql_connect("localhost", "user_name", "password")
   or die("Could not connect : " . mysql_error());

mysql_select_db("database_name") or die("Could not select database");

$query = "INSERT into users (uname) VALUES ('John')";
echo "$query<br>\n";
mysql_query($query);


$query = "SELECT u_name, u_pass FROM users";
$result = mysql_query($query);

/* Printing results in HTML */
while ($row = mysql_fetch_row($result)) {
   echo "\"$row[0],$row[1]\",<br>";
}

?>