PHP While Loop and DIV's

Question

I have an issue with my while loop that I'm using. I'm trying to display several modules on my webpage, each of them are stored within my database.

I run the following mysql query.

$modules = mysql_query("SELECT * FROM category WHERE active = '1' ORDER BY ordering ASC"); and then while($allmodules = mysql_fetch_array($modules)) {

This then returns the relevant data that I'm looking for, all that works fine.

I am able to display these 'modules' on the webpage easily, but I'm trying to store them in other DIVs which will then create rows. So I can have 3 rows of modules on the webpage to help positioning and so on.

I'm using <div id="module-row"> 3 times over. When I'm not using PHP I can get it to work. I want to insert the first module I fetch from the while statement in to the first 'module-row' DIV and the second one in the second 'module-row' DIV and the third module, in the third DIV.

That way I'll have one module in each row. I then want to continue it, so the fourth module will then be placed in the first 'module-row' DIV and so on.

Remember: two HTML elements on the same page should never have identical id's — Don
– Don, Commented Jun 22, 2012 at 18:03
When I tested without the PHP I used different ID's but I weren't sure where I stand with the PHP loop. — Craig Jones
– Craig Jones, Commented Jun 22, 2012 at 18:04

jackwanders · Accepted Answer · 2012-06-22 18:07:11Z

2

Your question is a little fuzzy, but it sounds like you're having trouble inserting the fetched data into the appropriate DIV tags.

ID attributes are assumed to be unique, i.e. once an ID is used, it is not used again on that page. Try replacing the ID attribute with a class attribute, like so <div class="module-row">, then access the divs by class name instead of ID.

answered Jun 22, 2012 at 18:07

jackwanders

16.1k3 gold badges42 silver badges40 bronze badges

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

1 Comment

Craig Jones Over a year ago

I understand. Say I had <div id="module-row1">,<div id="module-row2"> and <div id="module-row3"> with the same CSS properties. How would I take the first result from the loop and place it within the module-row1 DIV? and then how would I place the second within the `module-row2' DIV. Hopefully that's cleared it up a little.

user1454661 · Accepted Answer · 2012-06-22 18:40:02Z

1

If your table has an id and data column, it'd look something like this:

while($allmodules = mysql_fetch_assoc($modules)) {
    echo '<div class="module-row'.$allmodules['id'].'">'.$allmodules['data'].'</div>';
}

answered Jun 22, 2012 at 18:40

user1454661

Comments

gadinkid · Accepted Answer · 2013-09-08 07:39:59Z

0

If your table has an id and data column, it'd look something like this:

while($allmodules = mysql_fetch_assoc($modules)) {
    echo '<div class="module-row'.$allmodules['id'].'">'.$allmodules['data'].'</div>';
}

the answer on above is true but i suggest use php query, use require_once function before you have to include insert_db.php belong to [head] so become just use

echo [div class="require_one $database_name"] *please change symbol [div] be <...> ... is div tag

note : remeber if you use sql query to your page it can risk for security system.

answered Sep 8, 2013 at 7:39

gadinkid

11 bronze badge

Collectives™ on Stack Overflow

PHP While Loop and DIV's

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related