Automatically creating div's using data from a sql table

Question

I'm trying to create duplicate divs with different data in each obtained from a SQL database. I have the code creating the divs and populating the correct fields with the correct data, but my code is nesting the divs within each other.

<?php
$query = mysql_query("SELECT id, name, location, amountRequested FROM     fundable");

while ($temp = mysql_fetch_array($query)) {
echo "<div class='widgetLoan'>";
echo "<div class='title'><h6>".$temp['name']."</h6><span class='widgetLoanCat'>Category</span>";
echo "<div class='num'><a href='#' class='blueNum'>".$temp['amountRequested']."</a></div>";
echo "</div>";
}
?>

You're not closing the "title" div

lc.
– lc.

2012-08-25 18:41:22 +00:00
Commented Aug 25, 2012 at 18:41 — lc.
– lc., Commented Aug 25, 2012 at 18:41

RedhopIT · Accepted Answer · 2012-08-25 18:41:48Z

3

Try this :

<?php
$query = mysql_query("SELECT id, name, location, amountRequested FROM     fundable");

while ($temp = mysql_fetch_array($query)) {
echo "<div class='widgetLoan'>";
echo "<div class='title'><h6>".$temp['name']."</h6><span class='widgetLoanCat'>Category</span></div>";
echo "<div class='num'><a href='#' class='blueNum'>".$temp['amountRequested']."</a></div>";
echo "</div>";
}
?>

answered Aug 25, 2012 at 18:41

RedhopIT

6192 gold badges7 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tayler Hughes Over a year ago

You have no idea how long I have been Staring at this, thanks for your help!

Gabriel Sosa · Accepted Answer · 2012-08-25 18:41:53Z

1

you forgot to close a </div> tag

change

echo "<div class='title'><h6>".$temp['name']."</h6><span class='widgetLoanCat'>Category</span>";

for

echo "<div class='title'><h6>".$temp['name']."</h6><span class='widgetLoanCat'>Category</span></div>";

answered Aug 25, 2012 at 18:41

Gabriel Sosa

7,9644 gold badges42 silver badges48 bronze badges

1 Comment

Tayler Hughes Over a year ago

You have no idea how long I have been Staring at this, thanks for your help!

Mike M · Accepted Answer · 2012-08-25 18:44:07Z

0

Looks like you are missing a </div> tag to me.

answered Aug 25, 2012 at 18:44

Mike M

2123 silver badges11 bronze badges

Collectives™ on Stack Overflow

Automatically creating div's using data from a sql table

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related