Arranging a PHP While loop

Question

I'm having an issue arranging the data returned from a while loop in php.

basically I'm trying to return a time slot schedule of work from a database, problem is i seem to be getting either the same result in all time slots or all clients in one time slot.

What i want:

This 4 times in a row to represent 4 weeks in a month.

Each client name is already editable using jeditable and the grey square using Ajax to tick when the job is done (h=just a visual reminder)

my code

        <div class="calendar">
        <div class="header">
            <div class="ts">TIMESLOT</div>
            <div class="day">MON</div>
            <div class="day">TUE</div>
            <div class="day">WED</div>
            <div class="day">THUR</div>
            <div class="day">FRI</div>
        </div>
        <div class="slots">

        <div class="time">09:45 - 10:45</div>
        <?php
        while($ssrow = $scedule->fetch_object()) {
            $scid = $ssrow->scid;
            $scclient = $ssrow->client;
            $sccomplete = $ssrow->completed;    
        ?>
            <div class="client"><span id="<?php echo $scid; ?>"><?php echo $scclient; ?></span><div></div></div>
        <?php
        }
        ?>
        </div>
    </div>

This throws all the client names out in one huge mess and makes my head hurt trying to fix it... any help is highly appreciated here...

My Call to PHP Function

$scedule = seoschedule();

seo schedule function

function seoschedule() {
$mysqli = DB::connection();
return $mysqli->query('SELECT * FROM seoschedule');

}

what's your query for actually getting the schedule? I wonder if that would help us find you a solution. Also, I'm thinking if some of the cells should appear as empty because no client has signed up for that slot yet, then maybe you need to unset the client variables, otherwise, the empty cell will display the variables from the previous row in the database. — bowlerae
– bowlerae, Commented Jan 26, 2012 at 13:17

ethrbunny · Accepted Answer · 2012-01-26 14:12:37Z

1

From your bit of code it looks like everything will be output into the one div:

<div class="time">09:45 - 10:45</div>
<?php
    while($ssrow = $scedule->fetch_object()) {
--> output data
}
?>
</div>

You never increment the 'time' in your loop.

It would appear that you need an outer loop to create the 'time' div and then an inner loop with the corresponding values for that time.

answered Jan 26, 2012 at 14:12

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

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

Collectives™ on Stack Overflow

Arranging a PHP While loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related