Back

MySQL with PHP

<?php

$conn = mysql_connect('LOCALHOST', 'USERNAME', 'PASSWORD')
	or die ('Error connecting to mysql');

mysql_select_db('DATABASE_NAME');

?>

$results = mysql_query("SELECT * FROM name;");

while ($row = mysql_fetch_assoc($results)) {
    echo $row['first'] . ' '. $row['last'];
}

mysql_close($conn);

Back