Jump to content

litebearer

Members
  • Posts

    2,356
  • Joined

  • Last visited

Posts posted by litebearer

  1. Presuming each image is in a separate row...

    $q = "SELECT image_name FROM images WHERE image_type = 'ad' AND user = '$id'";
    $r = mysqli_query( $dbc, $q );
    
    while ( $row = mysqli_fetch_array( $r, MYSQLI_ASSOC)) {
      $imageName[] = $row['image_name']; 
    }
    $count = count($imageName);
    if($count>0) {
      ?>
      <div class="add1"><?php echo $imageName[0]; ?></div>
      <?php
    }
    if($count>1) {
      ?>
      <div class="add2"><?php echo $imageName[1]; ?></div>
      <?php
    }
    
    

  2. rough way to list them all...

     

    $query = "SELECT `Schedule`, `EMMA`,  `Aircraft`  FROM `Aircraft_Daily_Status` ";
    $result = mysql_query($query);
    echo "<table>";
    while($row = mysql_fetch_array($result)) {
    ?>
    <tr><td><?php echo $row['Aircraft']; ?></td><td id="cell2display"><?php echo $row['Schedule']; ?></td><td id="cell3display"><?php echo $row['EMMA']; ?></td></tr>
    <?php
    }
    echo "</table>";
    

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.