How to ignore an empty value/field

zebraplayer

Hi all,

I am so new to this it's not funny. I have tried searching for the solution to this problem, but I am not sure what to search for, so I did not get very far.

Here's my problem. I have created the following querry:

?php echo $row_rs_films['datename']; ?>, <?php echo $row_rs_films['time']; ?><br>
<?php echo $row_rs_films['venuename']; ?><br><br>
<?php echo $row_rs_films['datename2']; ?>}, <?php echo $row_rs_films['time2']; ?><br>
<?php echo $row_rs_films['venuename2']; ?>

Now datename2, time2, and venuename2 are sometimes blank. As a result, my querry is only showing those entries that have a value for datename2, time2, and venuename2.

I want to know how to tell the code to ignore venuename2, time2, and datename 2 if the field is empty in the database.

Can someone help me out?

Thanks in advance for your help!!!

-LouieG

mykg4orce

Ok simply...

this has nothing to do with PHP from what little code I can see...

You can do this in mysql and save some server load by getting PHP to do the same thing.

Modify your query like this:

SELECT * FROM myinfo WHERE name!=""

!="" tells mysql to ignore all empty rows, now just adapt it your needs.

zebraplayer

mykg4orce,

Thanks for your help.

I tried what you suggested, and it's still not working. Now it is repeating each column 15 times.

Here's the page in question: http://www.charlottefilmfestival.org/eventguide/eventcatalog2.php

I've adjusted the code as follows:

<?php
mysql_select_db($database_CFF1, $CFF1);
$query_rs_films = "SELECT * FROM films, categories, country, dates, prices, venues, genre, dates2, venues2 WHERE films.country=country.countryID AND films.category=categories.categoryID AND films.date=dates.dateID AND films.venue=venues.venueID AND films.venue2!=venues2.venueID2 AND films.date2!=dates2.dateID2 AND films.price=prices.priceID AND films.genre=genre.ID ORDER BY title ASC";
$rs_films = mysql_query($query_rs_films, $CFF1) or die(mysql_error());
$row_rs_films = mysql_fetch_assoc($rs_films);
$totalRows_rs_films = mysql_num_rows($rs_films);
?>

I still think that what I need to do is tell it to ignore the second showtime info ( date2, time2, venue2), since it seems to be getting stuck and only showing the infor for those films that have a second screening time.

<?php do { ?>
<table width="640"  border="0" cellpadding="0" cellspacing="4">
  <tr class="text1">
    <td width="13%"><p><img src="<?php echo $row_rs_films['film_image']; ?>" alt="<?php echo $row_rs_films['title']; ?>" name="filmimages" border="0"></p></td>
    <td width="48%" valign="top"><p><strong><?php echo $row_rs_films['title']; ?><br>
                <em><?php echo $row_rs_films['categoryname']; ?></em><br>
        (<?php echo $row_rs_films['coutryname']; ?>, <?php echo $row_rs_films['year']; ?>, <?php echo $row_rs_films['trt']; ?> min.)</strong></p></td>
    <td width="39%" valign="top" class="homecontent"><div align="right">
        <p><?php echo $row_rs_films['datename']; ?>, <?php echo $row_rs_films['time']; ?><br>
            <a href="javascript:;" onClick="MM_openBrWindow('VenuesFrame.php','VenueDetail','width=368,height=418')"><?php echo $row_rs_films['venuename']; ?></a><br>
            <br><?php echo $row_rs_films['datename2']; ?>, <?php echo $row_rs_films['time2']; ?><br>
			<a href="javascript:;" onClick="MM_openBrWindow('VenuesFrame.php','VenueDetail','width=368,height=418')"><?php echo $row_rs_films['venuename2']; ?></a><br><br>
            <?php echo $row_rs_films['price']; ?><br>
        <a href="http://www.carolinatix.org" target="_blank" class="TextBold" alt="Purchase Tickets">BUY TIX </a></p>
    </div></td>
  </tr>
  <tr class="text1">
    <td valign="top"><p>&nbsp;</p></td>
    <td colspan="2"><p class="homecontent"><?php echo $row_rs_films['description1']; ?>&nbsp;&nbsp;<span class="TextBold">Genre</span>:&nbsp;<?php echo $row_rs_films['genre']; ?></p></td>
  </tr>
  <tr class="text1">
    <td height="23" colspan="3"><hr></td>
  </tr>
</table>
<?php } while ($row_rs_films = mysql_fetch_assoc($rs_films)); ?>

zebraplayer

I could really use someone's help with this. Thanks!

mykg4orce

I assume you have access to phpMyAdmin?

If you do, copy and paste your Query into the SQL window. Remember to replace all the variable names with actual data and see if you are getting the proper results then. If your problem is not at the query...we can look further.