PHP Query::whereAndLeftJoinImageQuery Examples

Example #1

File: footer3.php Project: rocafuerte/opus_static

    <div class="rightCenterDivFlow"><a href="tv.php"><img src="graphics/closeupTV.gif" border="0" alt="Close-Up TV"/></a><br />
    <?php 
    echo $tvQ->getResultRow("code");
    ?>
    
    <br />
    <span class="smallGrey"><a href="tv.php">Kolla in Close-Up TV! Massvis med videos fr&aring;n festivaler och spelningar!</a></span><br />
    <span class="smallOrange"><a href="tv.php">Close-Up TV</a></span> <br />
    <br />
    <hr class="hr2" noshade="noshade" />
  </div>
	
	<?php 
}
$compQ = new Query("competitions");
$compQ->whereAndLeftJoinImageQuery("*", "active", 1, "date", "DESC", 5);
if ($compQ->getNumRows() > 0) {
    while ($row = mysql_fetch_object($compQ->getResult())) {
        ?>
		<div class="rightCenterDivFlow"><span class="boldWhite"><a href="tavlingar.php?id=<?php 
        echo $row->rowid;
        ?>
"><?php 
        echo $row->title;
        ?>
</a></span> <!--<img src="graphics/tavling_right.gif" alt="" />--><br />
		 <?php 
        if (Helper::hasValue($row->image_id)) {
            ?>
			<a href="tavlingar.php?id=<?php 
            echo $row->rowid;

Example #2

File: header_inc2.php Project: rocafuerte/opus_static

      <br />
      <hr class="hr2" noshade="noshade" />
    
      </div>
      
      <div class="leftCenterDivFlow">
       <span class="boldWhite">Kulturtips! </span><br /><br />
     <span class="smallGrey">
      Ta g&auml;rna en titt p&aring; några andra tidskrifter som vi p&aring;  gillar. Exempelvis <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-denimzine.asp target=_blank>Denimzine</a></span>, <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-ordfront.asp target=_blank>Ordfront</a></span>, <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-vagabond.asp target=_blank>Vagabond</a></span> och <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-zero-music-magazine.asp target=_blank>Zero Magazine</a></span>.<br/><i>i samarbete med <span class="smallOrange"><a href=http://www.tidningsbutiken.se target=_blank>tidningsbutiken.se</a></span></i></span>
      </div>
      </div>
</div>
<div id="centerContainer">
<?php 
$newest = new Query("new");
$newest->whereAndLeftJoinImageQuery("*", "active", 1, "date", "DESC");
if ($newest->getNumRows() > 0) {
    ?>
<div class="newestHeaderBig"></div>
<div class="newestBig">
  <table border="0" cellpadding="0" cellspacing="0" class="noBorder">
    <tr>
      <td width="80" class="noPadding" rowspan="3"><a href="index.php?id=<?php 
    echo $newest->getResultRow("rowid");
    ?>
"><img src="image_crop.php?source=<?php 
    echo Settings::getUploadedImages() . '/' . $newest->getResultRow("file");
    ?>
&dest=&thumb_size=100" class="imgWhiteBorder" /></a></td>
      <td width="450" class="tdPadding" colspan="2"><span class="boldWhite"><a href="index.php?id=<?php 
    echo $newest->getResultRow("rowid");