note 76044 added to faq.databases

To access a SQL database you can just use this code: <?php $db = mysql_connect ("localhost", "<userName>", "<password>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("<database_name>"); $sql = "SELECT * FROM table"; $res = mysql_query($sql, $db) or die(mysql_error()); while ($row = mysql_fetch_object($res)) { print $row->column1; print <br />; print $row->column2; } mysql_free_result ($res); ?> ---- Server IP: 193.190.198.20 Probable Submitter: 87.67.34.77 ---- Manual Page -- http://www.php.net/manual/en/faq.databases.php Edit -- https://master.php.net/note/edit/76044 Del: integrated -- https://master.php.net/note/delete/76044/integrated Del: useless -- https://master.php.net/note/delete/76044/useless Del: bad code -- https://master.php.net/note/delete/76044/bad+code Del: spam -- https://master.php.net/note/delete/76044/spam Del: non-english -- https://master.php.net/note/delete/76044/non-english Del: in docs -- https://master.php.net/note/delete/76044/in+docs Del: other reasons-- https://master.php.net/note/delete/76044 Reject -- https://master.php.net/note/reject/76044 Search -- https://master.php.net/manage/user-notes.php