How Do I Create A Loop For This....

[Channel5]

Hi,

I'm trying to create a loop that will run through a MySQL database up to a certain date only, then end.

I'm really only familiar with while loops.

Can I use a for or a do...while loop, running through the rows of my database?

Or what's the best way to go about doing this?

[traq]

Instead of executing many queries in a loop, get the data you need first and then loop through the results.

<?php

$result = $db->query( "SELECT whatever,you,want FROM some_table WHERE the_date < '2013-08-04'" );
if( $result ){
    while( $row = $result->fetch_array() ){
        /* do whatever */
    }
}

[haley01]

Well I suggest you for following code for loop creation:

CREATE PROCEDURE doiterate(p1 INT)
BEGIN
label1: LOOP
SET p1 = p1 + 1;
IF p1 < 10 THEN
ITERATE label1;
END IF;
LEAVE label1;
END LOOP label1;
SET @x = p1;
END;