Small PHP snippet help

[Kayz]

Hi all...my project is nearing its deadline tommorow jsut need some small snippet help now.

 

 

As you can see from the code below its reading from the database fine, it will show two of the first entries in the db. Theres a small peice of code i remember but cant find it, where you can add to the bottom of the script where if there are new entries it will add to the list automatically.

 

Any help would be appreciated.

 

 

<?php
/*reading the data we have just entered */
$connect = mysql_connect("*****","****","****");
if (!$connect)
die ("Could Not Connect to the Database");
mysql_select_db("mdb_am663", $connect);
$result = mysql_query("SELECT * FROM contacts",$connect);
printf("membership id: %s<br>\n", mysql_result($result,0,"member_id"));
printf("First Name: %s<br>\n", mysql_result($result,0,"firstname"));
printf("Last Name: %s<br>\n", mysql_result($result,0,"surname"));
printf("Contact No.: %s<br>\n", mysql_result($result,0,"contact_no"));
printf("House Name/No.: %s<br>\n", mysql_result($result,0,"housename_no"));
printf("Address Line 1: %s<br>\n", mysql_result($result,0,"address_line1"));
printf("Address Line 2: %s<br>\n", mysql_result($result,0,"address_line2"));
printf("Address Line 3: %s<br>\n", mysql_result($result,0,"address_line3"));
printf("City or County: %s<br>\n", mysql_result($result,0,"city_county"));
printf("Postcode: %s<br>\n", mysql_result($result,0,"postcode"));
printf("Email Registered: %s<br>\n", mysql_result($result,0,"email"));
printf("Username Registered: %s<br>\n", mysql_result($result,0,"username"));
printf("Password: %s<br>\n", mysql_result($result,0,"password"));


echo nl2br ("\n");


printf("membership id: %s<br>\n", mysql_result($result,1,"member_id"));
printf("First Name: %s<br>\n", mysql_result($result,1,"firstname"));
printf("Last Name: %s<br>\n", mysql_result($result,1,"surname"));
printf("Contact No.: %s<br>\n", mysql_result($result,1,"contact_no"));
printf("House Name/No.: %s<br>\n", mysql_result($result,1,"housename_no"));
printf("Address Line 1: %s<br>\n", mysql_result($result,1,"address_line1"));
printf("Address Line 2: %s<br>\n", mysql_result($result,1,"address_line2"));
printf("Address Line 3: %s<br>\n", mysql_result($result,1,"address_line3"));
printf("City or County: %s<br>\n", mysql_result($result,1,"city_county"));
printf("Postcode: %s<br>\n", mysql_result($result,1,"postcode"));
printf("Email Registered: %s<br>\n", mysql_result($result,1,"email"));
printf("Username Registered: %s<br>\n", mysql_result($result,1,"username"));
printf("Password: %s<br>\n", mysql_result($result,1,"password"));
echo nl2br ("\n");
mysql_close($connect);
?>

[chriscloyd]

<?php
/*reading the data we have just entered */
$connect = mysql_connect("*****","****","****");
if (!$connect)
die ("Could Not Connect to the Database");
mysql_select_db("mdb_am663", $connect);
$result = mysql_query("SELECT * FROM contacts",$connect);
while ($view = mysql_query($result)) {
echo 'membership id: '.$view['member_id'].'<br>\n';
echo 'First Name: '.$view['member_id'].'<br>\n'
echo 'Last Name: '.$view['surname'].'<br>\n';
echo 'Contact No.: '.$view['contact_no'].'<br>\n';
echo 'House Name/No.: '.$view['housename_no'].'<br>\n';
echo 'Address Line 1: '.$view['address_line1'].'<br>\n';
echo 'Address Line 2: '.$view['address_line2'].'<br>\n';
echo 'Address Line 3: '.$view['address_line3'].'<br>\n';
echo 'City or County: '.$view['city_county'].'<br>\n';
echo 'Postcode: '.$view['postcode'].'<br>\n';
echo 'Email Registered: '.$view['email'].'<br>\n';
echo 'Username Registered: '.$view['username'].'<br>\n';
echo 'Password: '.$view['password'].'<br>\n';
echo nl2br ("\n");
}
mysql_close($connect);
?>