help with if else Operators

djiles

Hello I am attempting to run an if statement that runs if the lowest number is equal to or less than a number and the highest runs if it is equal to or less than a number.

Here is what I have tried so far.

//Query that is being run

$count = mysql_query("SELECT * FROM Times");

$row = mysql_num_rows($count);

==== I have tried the following======

if ($row >= 1 || $row => 8)
if ($row >= 1) || ($row => 8)
if (($row >= 1) || ($row => 8))

I am really new to this and any help would be appreciated. If you need anymore info let me know.

tripodkid

Hello!

You're using a double pipe || which means OR. This means your if argument will execute if any one of the two numbers match your criteria. However, I gather you want the if argument to execute only if both numbers match. So you should be using && instead. Also for less then you should be using < .

if($row <= 1 && $row <= 8 ){
/*The above will run only if the both numbers match your criteria. 
BTW this statement will run if the number is 8 or less so you don't need <=1. */
} else if( $row >= 8){
/*The above will run only if your number is equal to or greater then 8.
}

If you want to run a different action depending on whether your number hits your high or low criteria try something like this.

if($row <= 1){
   //This will run if the number  equals or is less then 1.
} else if( $row >= 8){
   //This will run if your number is equal to or greater then 8.
} else {
/*You could add this third action to run only if your criteria 
in either if or else if arguments was not matched. */
}

djiles

That still isn't returning the desired effect? It probably needs to be an or.

The if will be a number between and including 1-8

The elseif will be a number between and including 9-16

The elseif will be a number between and including 17-24

etc.

Once again what I am doing is splitting results from a database into 1 or more html tables depending on the row count. If the row count is 8 or less it will be one table, if it is 9-16 it will be two, 17-24 is three. Does this make more since? Like I said I am new so I have trouble explaining what I want in solid php terminology.

tripodkid

Try this

if($row <= 8){
// Do this
} else if ($row > 8 && <= 16) { 
//Do this
}else if($row >16 && <= 24){
//Do this
}

Please post your code if you're still having problems

djiles

1 Room works fine but when I added 2 Rooms it gives me an error.

Parse error: syntax error, unexpected T_IS_SMALLER_OR_EQUAL in /home/onlinemo/public_html/test/test_form1.php on line 95

Sorry if it is not very clean but It is in a first draft stage. this is why I have been afraid to post the code, I am embarrassed at how badly organized it is.

<?php

//Connect and selesct db

$con = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

//Get row count

$count = mysql_query("SELECT * FROM Times");

$row = mysql_num_rows($count);

//Divide Rooms

//1 Room

if ($row <= 8)
{
$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT 0, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}
}

//2 Rooms

elseif ($row > 8 && <= 16)

{

//Set limt

$div = ($row / 2);

$up = ceil($div);
$down = floor($div);

//Room 1

$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT 0, $up");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}

//Room2

$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT $up, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 2</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}
}
}

else

?>

tripodkid

In Room2 try

while ($line = mysql_fetch_row($query)){
echo '<pre><br/>';
print_r($line);
//This wont fix the problem but it will tell you what values are in the array $line.
//Compare this to the same array in Room1 since Room1 is working.

Additionally, you should get rid of

}

else

Since it's not doing anything.

djiles

Ok so I have it working some what, now it is returning a

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/onlinemo/public_html/test/test_form1.php on line 228

This doesn't appear untill It gets to 9 entries.

9 - 16 entries returns line 153

17 -24 entries returns line 228, 250, 271

I really do appreciate the help.

<?php

//Connect and selesct db

$con = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

//Get row count

$count = mysql_query("SELECT * FROM Times");

$row = mysql_num_rows($count);

//Divide Rooms

//1 Room

if ($row <= 8)
{
$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT 0, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}
}

//2 Rooms

elseif ($row > 8 && $row <= 16)

{

//Set limt

$div = ($row / 2);

$up = ceil($div);
$down = floor($div);
$Up1 = ($up + 1);

//Room 1

$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT 0, $up");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}

//Room2

$query1 = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT $up1, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 2</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line1 = mysql_fetch_row($query1))
{
echo '<tr>';
echo '<td align="center">'.$line1[1].'</td>';
echo '<td align="center">'.$line1[2].':'.$line1[3].'.'.$line1[4].'</td>';
echo '</tr>';
}
}

//3 Rooms

elseif ($row > 16 && $row <= 24)

{

//Set limt

$div = ($row / 3);

$up = ceil($div);
$down = floor($div);
$Up1 = ($up + 1);

//Set room division

if ($row = 19 || $row = 22)

{
$room1 = $up;

$Room2low = ($room1 + 1);
$Room2high = ($down + $room1);

$Room3low = ($room2high + 1);

}

elseif ($row = 17 || $row = 20 || $row = 23)

{
$room1 = $up;

$Room2low = ($room1 + 1);
$Room2high = ($up + $room1);

$Room3low = ($room2high + 1);
}

elseif ($row = 18 || $row = 21 || $row = 24)

{
$room1 = $div;

$Room2low = ($room1 + 1);
$Room2high = ($div + $room1);

$Room3low = ($room2high + 1);
}

else

//Room1

$query = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT 0, $room1");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}

//Room2

$query1 = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT $room2low, $room2high");

echo '<tr>';
echo '<td align="center" colspan="2">Room 2</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line1 = mysql_fetch_row($query1))
{
echo '<tr>';
echo '<td align="center">'.$line1[1].'</td>';
echo '<td align="center">'.$line1[2].':'.$line1[3].'.'.$line1[4].'</td>';
echo '</tr>';
}
//Room3

$query2 = mysql_query("SELECT * FROM Times ORDER BY Minutes, Seconds, Hundredths ASC LIMIT $room3low, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 3</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line2 = mysql_fetch_row($query2))
{
echo '<tr>';
echo '<td align="center">'.$line2[1].'</td>';
echo '<td align="center">'.$line2[2].':'.$line2[3].'.'.$line2[4].'</td>';
echo '</tr>';
}

}

?>

tripodkid

I suspect the problem is on line 54. Look carefully at the variable you created then take a look at your mySQL query on line 80.

djiles

Ok I feel like a moron but I don't see anything wrong with this code but it returns the data very strangely. Table one works, but table to returns everything from the correct starting point until the end of the db. Then table 3 shows only the correct starting point but nothing else.

It should work

1
2
3
4
5
6

7
8
9
10
11
12

13
14
15
16
17

But it shows

1
2
3
4
5
6

7
8
9
10
11
12
13
14
15
16
17

Here is the code Thanks again.

//3 Rooms

elseif ($row > 16 && $row <= 24)
{
//Set limit

$div = ($row / 3);

$up = ceil($div);
$down = floor($div);
$up1 = ($up + 1);

//Set room division

//1 room +1
if ($row = 19 || $row = 22)

{
$room1 = $up;

$room2low = $room1;
$room2high = ($room2low + $room1);

$room3low = $room2high;

}

//2 rooms +1

elseif ($row = 17 || $row = 20 || $row = 23)

{
$room1 = $up;

$room2low = $room1;
$room2high = ($room2low + $room1);

$room3low = $room2high;
}

//All rooms +1

elseif ($row = 18 || $row = 21 || $row = 24)

{
$room1 = $up;

$room2low = $room1;
$room2high = ($room2low + $room1);

$room3low = $room2high;
}

//Room1

$query = mysql_query("SELECT * FROM Times ORDER BY GT, Minutes, Seconds, Hundredths ASC LIMIT 0, $room1");

echo '<tr>';
echo '<td align="center" colspan="2">Room 1</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line = mysql_fetch_row($query))
{
echo '<tr>';
echo '<td align="center">'.$line[1].'</td>';
echo '<td align="center">'.$line[2].':'.$line[3].'.'.$line[4].'</td>';
echo '</tr>';
}

//Room2

$query1 = mysql_query("SELECT * FROM Times ORDER BY GT, Minutes, Seconds, Hundredths ASC LIMIT $room2low, $room2high");

echo '<tr>';
echo '<td align="center" colspan="2">Room 2</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line1 = mysql_fetch_row($query1))
{
echo '<tr>';
echo '<td align="center">'.$line1[1].'</td>';
echo '<td align="center">'.$line1[2].':'.$line1[3].'.'.$line1[4].'</td>';
echo '</tr>';
}
//Room3

$query2 = mysql_query("SELECT * FROM Times ORDER BY GT, Minutes, Seconds, Hundredths ASC LIMIT $room3low, $row");

echo '<tr>';
echo '<td align="center" colspan="2">Room 3</td>';
echo '</tr>';

echo '<tr>';
echo '<td align="center">Gamertag</td>';
echo '<td align="center">Time</td>';
echo '</tr>';

while ($line2 = mysql_fetch_row($query2))
{
echo '<tr>';
echo '<td align="center">'.$line2[1].'</td>';
echo '<td align="center">'.$line2[2].':'.$line2[3].'.'.$line2[4].'</td>';
echo '</tr>';
}

}