2 mysql_connect("localhost", "db user", "db pass")
3 or die("DB CONNECT ERROR: " . mysql_error());
4 mysql_select_db("db name")
5 or die("DB SELECT ERROR: " . mysql_error());
6 $query = "SELECT fname, lname, email FROM table ORDER BY lname";
7 $result = mysql_query($query)
8 or die("DB SELECT ERROR: " . mysql_error());
9 while($row = mysql_fetch_array($result))
11 $lname = $row['lname'];
12 $fname = $row['fname'];
13 $email = $row['email'];