dambuster
-
Posts
3 -
Joined
-
Last visited
Never
dambuster's Achievements
Newbie (1/5)
0
Reputation
-
New to PHP and MySQL so hopefully someone can help with what's probably a simple fault due to my lack of knowledge. When I run the following script I get a message that Apache HTTP Server has encountered a problem and needs to close We are sorry for the inconvenience. Please tel Microsoft about this problem Send error report or Don't send blah blah etc. (I'm sure we've all seen this report. If I remove the line msql_close() the script runs as expected!! Thanks in advance Here's the script <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html lang="en" xml:lang="en"> <head> <?php include("dbinfo.inc.php"); mysql_connect("localhost",$username,$password); mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM contacts"; $result=mysql_query($query); $num=mysql_numrows($result); echo "<b><center>Database Output</center></b><br><br>"; ?> <table border="0" cellspacing="2" cellpadding="2"> <tr> <th><font face="Arial, Helvetica, sans-serif">Name</font></th> <th><font face="Arial, Helvetica, sans-serif">Phone</font></th> <th><font face="Arial, Helvetica, sans-serif">Mobile</font></th> <th><font face="Arial, Helvetica, sans-serif">Fax</font></th> <th><font face="Arial, Helvetica, sans-serif">E-mail</font></th> <th><font face="Arial, Helvetica, sans-serif">Website</font></th> </tr> <?php $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"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><?php echo "$first $last"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo "$phone"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo "$mobile"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo "$fax"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><a href="mailto:<?php echo "$email"; ?>">E-mail</a></font></td> <td><font face="Arial, Helvetica, sans-serif"><a href="<?php echo "$web"; ?>">Website</a></font></td> </tr> <?php ++$i; } mysql_close(); ?>