Home arrow MySQL arrow Page 3 - Displaying Multiple Records Per Row in a MySQL Query Result Set

Digging Deeper - MySQL

Ever wonder how you can query a database and display the result set in something other than a one record per row layout? Keeping in mind that the simple answer is always the best one, I found a solution that keeps to that premise and solves an issue that seemed impossible not long ago. In a word, the answer, lies in the loop. An additional one, that is. But first, lets define and explain the general look and functionality of our project.

TABLE OF CONTENTS:
  1. Displaying Multiple Records Per Row in a MySQL Query Result Set
  2. Getting Connected
  3. Digging Deeper
  4. Getting the Query Results to Display Horizontally
  5. The Look we want and the Secret that gets you there
By: Peter Cole
Rating: starstarstarstarstar / 47
May 19, 2004

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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); 
 }
? >
   



 
 
>>> More MySQL Articles          >>> More By Peter Cole
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: