Is there any way to invert a Do-While loop so it continues to loop through the Do statement if the While statement is FALSE. And then end execution once the While statement is true.
Code: [Select]
do{
$length = 2;
$characters = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$string ="";
$string.= microtime(true);
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters))];
}
$string= substr_replace($string, '', 0, 4);
for ($p = 0; $p < $length; $p++) {
$string2 .= $characters[mt_rand(0, strlen($characters))];
}
$string="".$string2."".$string;
$string=explode(".",$string);
$string=$string[0].$string[1];
$rma_number=$string;

$sql12345="SELECT * FROM $tbl_name4 WHERE rma_number=$rma_number";
$result12345=mysql_query($sql12345);
$num_rows12345=mysql_num_rows($result12345);
}
while($num_rows12345 < 1){
$sql2000000="UPDATE $tbl_name4 SET rma_number='$rma_number', rma_name='$rma_name' WHERE rma_id = $rma_id";
mysql_query($sql2000000);
}

While Loop To Pick A Certain Type From Db??

Similar Tutorials

View Content

I am not getting any error messages as I just think the codes are wrong. I am trying to get the $sql(s) to choose and print out the the looking_for in the database. However it is not printing anything. Any ideas of where I am need to fix this. I have tried a few ways with no luck.

$sql = mysql_query("SELECT id,gender,looking_for FROM Members");
$nr = mysql_num_rows($sql);

$sql2 = mysql_query("SELECT * FROM Members WHERE id='".($_POST['$looking_for'])."' LIMIT $pn, $itemsPerPage");
$outputList = '';
while($row = mysql_fetch_array($sql2)) {

Similar Tutorials

View Content

Whlie Loop

Similar Tutorials

View Content

This is probably a simple question, but if you are looping through a while loop using an if - else statement
why would it echo the answer the amount of times there are data fields?
Like if you had three users in a database and you had an if statement to validate a user name and password. If the user name and password passed it would say good - if it failed it would say no good.
But instead it prints - good no good good, or no good good good, ect.???

If File_get_contents Failed...loop?

Similar Tutorials

View Content

Ok, I'm having some trouble with file_get_contents failing & am trying to make a loop that will sleep & then retry a maximum of 3 times before giving up & moving to the next item. I tried using a while loop but I'm getting unexpected T_WHILE, which I assume is because it's already in a while loop?

I found this:

Code: [Select]
$maxTries = "3";
for ($try=1; $try<=$maxTries; $try++) {

but could use some clarification. Will that only trigger if it failes or do I need to include another if statement like

Code: [Select]
$myfile = file_get_contents("http://example.com");
if ($myfile === FALSE) {
$maxTries = "3";
for ($try=1; $try<=$maxTries; $try++) {
sleep(3);
$myfile = file_get_contents("http://example.com");
}
else {
//continue with script

I hope that makes sense...trying to explain it as best I can without having to post my actual source code as I've had it stolen off forums before & now I have a clone to compete with. I'm not great at putting this into words so if I need to clarify, please feel free to ask. I appreciate any & all help given. Thanks!

Creating A Loop Singling Out Multiples Of 3 And 5 And Replacing Them With A Word

Similar Tutorials

View Content

Nested For Loop Problem

Similar Tutorials

View Content

Hi, first of all thanks in advance for the help. I'm a newbie college student and am having a little problem with a project for a class that I can't figure out.

I'm trying to construct a loop that creates an array for a javascript image gallery. First I call for the categories and I want to then pull all the images from that category into the array and then loop through all the categories in the database. The code below just cycles through the first category and then quits after pulling the images from that category.

Code: [Select]
<?php
        // SQL Query for Categories
            $sql="SELECT CategoryID, CategoryName FROM pro2category";
            $result = mysql_query($sql);

            if(empty($result))
            {
                $num_results = 0;
            }
            else
            {
                $num_results = mysql_num_rows($result);
            }

        ?>
<?php
        for($i=0; $i<$num_results; $i++)
        {
            $row = mysql_fetch_array($result);

            $CategoryID = $row["CategoryID"];
            $CategoryName = $row["CategoryName"];

        ?>

var <?php echo $CategoryID ?> = new Array();






<?php
                $sql="SELECT ImageID, ImageName, ImageNumber, URL, CategoryID FROM pro2image WHERE CategoryID='$CategoryID'";
                $result = mysql_query($sql);

                if(empty($result))
                {
                    $num_results = 0;
                }
                else
                {
                    $num_results = mysql_num_rows($result);
                }

            ?>

<?php
                for($i=0; $i<$num_results; $i++)
                {
                    $row = mysql_fetch_array($result);

                    $ImageID = $row["ImageID"];

                ?>

<?php echo $CategoryID ?>Array[<?php echo $i ?>] = "http://cgtweb2.tech.purdue.edu/356/zrodimel/Project2/admin/upload/<?php echo $ImageID ?>.jpg";

<?php
                }
                ?>

<?php
        }
        ?>
thanks for the help

Zach

Php Display Bookings Loop

Similar Tutorials

View Content

Hey guys,

I couldn't really think of a decent topic title for this but I hope by the end of it you'll know what I mean.

Brief background: I work in an IT department in a school. I am in the process of writing a page to show room and resource booking for the current day and for the next day. There are six blocks that bookings can be made (before school, periods one-four, after school). I have written a query to display all the bookings for a given day. I have looped the six available periods to it has a header for them, and have done the same for containers for the bookings.

What I am having problems with is getting it to show under the correct period for the start time and end time for the booking. For example, if a booking starts and ends period three, I want it to show just for period three. If it is a daily booking, it goes on all day.

My query is this and I am happy with it - phpmyadmin display everything I want and the start time and end time are correct.

Code: [Select]
(
SELECT
`bno` AS `bookingid`,
UPPER(`whofor`) AS `name`,
`timestart`,
`timeend`,
`where` AS `room`,
'' AS `comments`,
TRIM(TRAILING '||' FROM `What1`) AS `equipment`,
IF(`date` = '1', '1', '1') AS `type`
FROM
`booked`
WHERE
UNIX_TIMESTAMP(CONCAT_WS('-', `year`, `month`, `day`)) = '{$time}'
AND `active` = 'yes'
AND `timestart` != 'all'
)
UNION (
SELECT `bno` AS `bookingid`,
UPPER(`whofor`) AS `name`,
'1' AS `timestart`,
'6' AS `timeend`,
`where` AS `room`,
'' AS `comments`,
TRIM(TRAILING '||' FROM `What1`) AS `equipment`,
IF(`date` = '1', '1', '1') AS `type`
FROM
`booked`
WHERE
UNIX_TIMESTAMP(CONCAT_WS('-', `year`, `month`, `day`)) = '{$time}'
AND `active` = 'yes'
AND `timestart` = 'all'
)
UNION (
SELECT `bid` AS `bookingid`,
UPPER(`name`),
`period`,
`period`,
IF(`room` = '8', 'Lower Laptops', 'Middle Laptops') AS `room`,
`comments` AS `comments`,
'',
IF(`timebooked` = '2', '2', '2') AS `type`
FROM
`bookedrooms`
WHERE
UNIX_TIMESTAMP(CONCAT_WS('-', `year`, `month`, `day`)) = '{$time}'
AND `room` IN(8,9)
AND `name` != 'not available'
AND `active` = 'yes'
)
ORDER BY `timestart`, `type` ASC
$time = (isset($_GET['tomorrow'])) ? strtotime('tomorrow 00:00') : strtotime('today 00:00');

Just wondering if anybody here has ever done anything similar to this to give me a hand.

Thanks in advance!