Login | Register | FAQ
Anonymous

PHP mySQL result loop in Table

+ Post a reply

2 posts Page 1 of 1


PHP mySQL result loop in Table

by themenaceman » Tue Apr 10, 2012 3:34 pm

I'm having a problem when trying to display results from mysql db into a table. I am able to dynamically create a new row for each result but cannot nest another loop to add cells to each row. I hope this makes sense. What I would basically like to happen is to query the db and display every website a user has in a new row. Then I would like to query a different table and display each page in the website in a new cell next to the website. Here is my code it should help. <?php
include ("connect_to_mysql.php");
mysql_select_db("themenaceman", $con);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<h3>Your Account</h3>
<div><?php
$result = mysql_query("SELECT * FROM Websites WHERE userid= '488'");
$result2 = mysql_query("SELECT * FROM pages2 WHERE webname = 'Test Website' AND userid= '488'");

echo "<table border='1'>
<tr>
<th>Website</th>
<th></th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['webname'] . "</td>";
//echo "<td>" while($row = mysql_fetch_array($result2)){ echo $row['pagename'] } "</td>";
echo "<td>" . '<a href="newpage.php?website=' . $row['webname'] .'">Add Page</a>'. "</td>";
echo "</tr>";
}
echo "</table>";


mysql_close($con);
?></div>
</body>
</html>


Line 28 (commented) is where the problem is (Parse error: syntax error, unexpected T_WHILE, expecting ',' or ';' in /home/content/83/9160783/html/new/account.php on line 28) I hope this is enough information. and thanks in advance for any help.
User avatar

themenaceman

  • Posts: 5
  • Joined: Sat Mar 31, 2012 10:44 pm

Re: PHP mySQL result loop in Table

by XainPro » Tue Apr 10, 2012 8:40 pm

you can not echo a while statement
your code
Code: Select all
//echo "<td>" while($row = mysql_fetch_array($result2)){ echo $row['pagename'] } "</td>";

correct code
Code: Select all
echo "<td>";
while($row = mysql_fetch_array($result2)){ echo $row['pagename']; }
echo "</td>";

You are Welcome :)
User avatar

XainPro

  • Posts: 3706
  • Joined: Fri Feb 17, 2012 8:10 pm


+ Post a reply

Page 1 of 1