troubleshooting Question

PHP Loop Error

Avatar of brendan-amex
brendan-amex asked on
PHPMySQL Server
3 Comments1 Solution304 ViewsLast Modified:
I'm not sure what the problem is... I thought my code is correct but I've been looking at it for hours now and no resolution. I think I need a fresh set of eyes on it.

It keeps crashing in all the browsers I run it in (IE, Chrome, Firefox) and I'm not sure why.

Thanks guys!

<?

$dbc = mysql_connect("localhost", "user", "pass") or die ('Error: 108');
mysql_select_db("database", $dbc) or die ('Error: 109');

$query29 = "SELECT * FROM tbl_Lists";
$result29 = mysql_query($query29) or die('Error: 110');
$num = mysql_num_rows($result29);
	
mysql_close($dbc);

$i=0;
while ($i < $num) {

$varCompany=mysql_result($result29,$i,CompanyName);
$varFirstName=mysql_result($result29,$i,FirstName);
$varLastName=mysql_result($result29,$i,LastName);
$varTitle=mysql_result($result29,$i,Title);
$varEmail=mysql_result($result29,$i,Email);
$varAddress1=mysql_result($result29,$i,Address1);
$varAddress2=mysql_result($result29,$i,Address2);
$varCity=mysql_result($result29,$i,City);
$varState=mysql_result($result29,$i,State);
$varZip=mysql_result($result29,$i,Zip);
$varCellPhone=mysql_result($result29,$i,CellPhone);
$varWorkPhone=mysql_result($result29,$i,WorkPhone);
$varHomePhone=mysql_result($result29,$i,HomePhone);
$varFax=mysql_result($result29,$i,Fax);
$varWebsite=mysql_result($result29,$i,Website);
$varNotes=mysql_result($result29,$i,Notes);

echo $varCompany . '<br />' . $varFirstName . '<br />' . $varLastName . '<br />' . $varTitle . '<br />' . $varEmail . '<br />' . $varAddress1 . '<br />' . $varAddress2 . '<br />' . $varCity;
}

?>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros