Displaying Multiple Records Per Row in a MySQL Query Result Set - Digging Deeper

(Page 3 of 5 )

What we are really interested in is the link that displays the images in the gallery in a horizontal format.

The URL in the code above looks like this:

 http://localhost/gallery/show_pictures_h.php?CAT=3&AID=2&LOC=2

We start once again with the code needed to connect to the mysql server and request info from the query string attached to the URL. It is important to clean up query strings before you submit a request to the database. One of the simpliest and most effective means to do so is to use the built in PHP 'htmlspecialchars' function which prevents html markup from adding dangerous code to your query. The function has more capabilities then presented here, but in general it does the following.

•  · & (ampersand) becomes '&' 
  
•  " " (double quote) becomes '"' when ENT_NOQUOTES is not set. 
  
•  ' ' (single quote) becomes ''' only when ENT_QUOTES is set. 
  
•  < (less than) becomes '&lt;' 
  
•  > (greater than) becomes '&gt;' 
  

<?php
require("../../includes/db_config.php");  // connect to mysql server from protected directory
if(isset($_GET['CAT']) && ($_GET['AID'])) {
 $CAT = htmlspecialchars($_GET['CAT']); // clean up query string variable
 $AID = htmlspecialchars($_GET['AID']); // clean up query string variable
 $LOC = htmlspecialchars($_GET['LOC']); // clean up query string variable
 
 // get album name first to populate title bar
 $sql_T = "SELECT albums.albumNAME FROM albums WHERE catID = '$CAT' AND albumID = '$AID' ";
 $sql_T_result = @mysql_query($sql_T, $connection)
  or die ("Could not execute your select albumNAME request");
 $row_T = @mysql_fetch_array($sql_T_result);
 $NAME = stripslashes($row_T['albumNAME']);
 
 // get images from album
$sql = "
 SELECT
  albums.albumNAME,
  images.imgID,
  images.catID,
  images.albumID,
  images.locID,
  images.imgTITLE,
  images.thumbPATH,
  images.thumbNAME,
  images.copyright
 FROM images, albums
 WHERE images.catID = '$CAT' AND images.albumID = '$AID' AND images.albumID = albums.albumID
 ORDER BY copyright, thumbNAME";

 $result = @mysql_query($sql, $connection);
 if(!$result) {
  print "Could not execute your select images request";
  exit;
  }
  
 $num = @mysql_num_rows($result); 
 // you choose how many columns you want to display in each table row
 $thumbcols = 5;
 // quick and dirty formula to figure out how many rows you will need
 $thumbrows = 1+ round($num / $thumbcols); 
 }
? >
   

Next: Getting the Query Results to Display Horizontally >>
 

More MySQL Articles
More By Peter Cole

Comments On: Displaying Multiple Records Per Row in a MySQL Query Result Set

>>> Be the FIRST to comment on this article!