I am trying to learn working with MySQL databases through PHP but I'm having some problems. I've written this simple scipt which takes a table named "contacts" and first enters some information into the table. Then, it attempts to read and display the data in the table.
Here's the full code:
PHP Code:
<?php
$username = "username";
$password = "password";
$database = "hhsrobotics_circuitrunners_com_-_ContactList";
$link = mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO contacts VALUES ('','John','Smith','555-555-5555','444-444-4444','333-333-3333','johnsmith@email.com','http://www.johnsmith.com')";
mysql_query($query);
$result = mysql_query("SELECT * FROM contacts",$link);
$num = mysql_numrows($result);
$i=0;
while ($i < $num) {
$first = mysql_result($result,$i,"first");
$last = mysql_result($result,$i,"last");
$phone = mysql_result($result,$i,"phone");
$mobile = mysql_result($result,$i,"mobile");
$fax = mysql_result($result,$i,"fax");
$email = mysql_result($result,$i,"email");
$web = mysql_result($result,$i,"web");
echo "<b>$first $last</b><br>Phone: $phone<br>Mobile: $mobile<br>Fax: $fax<br>E-mail: $email<br>Web: $web<br>";
$i++;
}
mysql_close();
?>
The problem is that I keep getting argument errors with the lines
PHP Code:
$result = mysql_query("SELECT * FROM contacts",$link);
PHP Code:
$num = mysql_numrows($result);
and all of the
PHP Code:
$first = mysql_result($result,$i,"first");
lines.
Oh, and there is a primary key in the first part of the table named "id" which is not displayed to the user, and its set to Auto_incriment so the data doesn't have to be entered for it.