PROS! IF ELSE statement help

brianb

Hello Pros,

Here's what I'm looking to do.

Basically some checking in 2 different DB tables.

I want the PHP to go and check for a record in the first table.
If something exists, build the HTML table and stick the data inside.
Then check if data exists for the record in the second table. If data exists in this 2nd table, stick that info inside the HTML table we've already built as well.
If data doesn't exist in the first table, but IT DOES exist in the second table, build the HTML table and stick the info into it.

Make sense?

Here's what I have right now:

//query the 1st table
$sql = "SECECT TABLE1";
$res = mysql_query($sql);

//if the record exists in the 1st table
if( mysql_num_rows($res) > 0 )
{
   //fetch & echo review
   $record = mysql_fetch_array($res);
   echo $record['review'];
}
//else the record doesn't exist in the first table
//so, now check the 2nd table
else
{
   //query the 2nd table
   $sql = "SECECT TABLE2";
   $res = mysql_query($sql);

   //if the record exists in the 2nd table
   if( mysql_num_rows($res) > 0 )
   {
      //fetch & echo review
      $record = mysql_fetch_array($res);
      echo $record['review'];
   }
}

Now, this code obviously isn't what I want because if data exists in the first table, it builds the HTML table, then stops checking the second table.

Please help!

thanks in advance.

sjpatrick

Move the else clause code out of and under the if block altogether?

Or perhaps:

function table2code() {
//do stuff;
}

if (mysql_num_rows($res) > 0) {
//do table1 stuff;
table2code;
} else {
table2code;
}

That's the best I could interpret your intent.
Keep us posted.

<geek>Steve</geek>

SpasePeepole

As you can see I changed the else to elseif and added a statement

 //query the 1st table
$sql = "SECECT TABLE1";
$res = mysql_query($sql);

//if the record exists in the 1st table
if( mysql_num_rows($res) > 0)
{
   //fetch & echo review
   $record = mysql_fetch_array($res);
   echo $record['review'];
}
//else the record doesn't exist in the first table
//so, now check the 2nd table
elseif (mysql_num_rows($res) <= 0)
{
   //query the 2nd table
   $sql = "SECECT TABLE2";
   $res = mysql_query($sql);

   //if the record exists in the 2nd table
   if( mysql_num_rows($res) > 0 )
   {
      //fetch & echo review
      $record = mysql_fetch_array($res);
      echo $record['review'];
   }
}

give it a try 😃

brianb

Hey guys...

OK...getting there. I think there might have been some confusion as to what I was looking for.

Let's reference my actual site, on a test page:

http://www.lightsoutentertainment.com/movies/film.OK.php?filmID=6

Ok, scroll down to where it says REVIEWS on the right side. That's what we're working with here.

So, see how the PHP is building 2 table for both reviews? When there are 2 reviews like this I'd like the PHP to put both review in the same table...(the REVIEWS HTML TABLE in black)

Basically, what this all comes down to is putting all the reviews in ONE html table, BUT building the nice black "Reviews" table if ANY kind of review exists. make sense?

Here' s the actual code for the page right now...I know it's wrong:

<?PHP

$sql = "SELECT reviewtable1"
//if movie reviews exists
if( mysql_num_rows($res) > 0 )
{
   echo "<table width='300' border='1' bordercolor='#000000' cellspacing='0' cellpadding='3' align='center' class='table_thin'>
  <tr><td bgcolor='#000000'><font color='#FFFFFF'><b><u>Reviews</u></b></font></td></tr>
  <tr><td><table width='100%' border='0' cellspacing='0' cellpadding='3'>";
   while ( $review = mysql_fetch_array( $res ) )
   {
      if( $review[filmID] == '0' )
      {
         echo "&nbsp;";
      }
      else
      {
         echo "<tr><td width='18%' class='small' bgcolor='#F0F0F0'>$review[person]</td>";
         echo "<td width='17%' class='small2' bgcolor='#CCCCCC' align='center'>$review[rating] Stars</td>";
         echo "<td width='65%' class='small' bgcolor='#F0F0F0'>&quot;$review[blurb]&quot;...<a href='/movies/reviews.php?filmID=$review[filmID]&reviewID=$review[reviewID]' class='links5'>more</a></td></tr>";
      }
   }
   echo "</table></td></tr></table>";
}

//now check for Mushy Reviews

$sql = "SELECT reviewtable2"

if( mysql_num_rows($res) > 0 )
{
   echo "<table width='300' border='1' bordercolor='#000000' cellspacing='0' cellpadding='3' align='center' class='table_thin'><tr><td>";
   while ( $mmm = mysql_fetch_array( $res ) )
   {
      if( $mmm[filmID] == '0' )
      {
         echo "&nbsp;";
      }
      else
      {
         echo "<table width='100%' border='0' cellspacing='0' cellpadding='2'><tr>
          <td width='0%' valign='top'><img src='/media/random/mmm_grades/$mmm[grade].gif' width='56' height='30'></td>
          <td width='100%' class='small'>\"$mmm[blurb]\"<br>~Mushy's Movie Minute</td></tr></table>
";
      }
   }
   echo "</td></tr></table>";
}
?>

brianb

P.S.

Pay no attention to:

if($review[filmID]=='0')

______{

________echo" ";

______}

______else

That was just a test and needs to be removed.