While I am by no strech of the imagination a ColdFusion expert, I
have built a couple of dozen CF sites over the past 5 years. Am
currently working on my first PHP site and am running into a problem
with the simplest little thing.
An index page is returning a list of active category names. Each name
is a link to a thumbnails page. The photos on the thumbnails page are
links to a display page which displays the enlarged photo and
additional text.
My problem is in getting the thumbnails page to only display the
images associated with the category name selected on the index page.
Either the thumbnail page displays ALL images or it displays none.
Below is the query on the thumbnail page, which is currently
returning no records. If I replace '$recordcatID' with the specific
name of a category, the correct records are returned. Likewise, if I
remove the WHERE statement, all records are returned. So obviously
something is wrong with the sql statement.
But I can't help but feel that I'm missing something in the PHP syntax.
<?php require_once('../Connections/connTrail.php'); ?>
<?php
mysql_select_db($database_connTrail, $connTrail);
$query_GetThumbs = "SELECT Photos.Photos_ImagePath,
Photos.Photos_Title, Photos.ID, Photos.Photo_Category,
Photos_Category.Category_Name, Photos_Category.catID FROM Photos,
Photos_Category
WHERE Photos_Category.catID = '$recordcatID' AND
Photos_Category.Category_Name = Photos.Photo_Category";
$GetThumbs = mysql_query($query_GetThumbs, $connTrail) or die
(mysql_error());
$row_GetThumbs = mysql_fetch_assoc($GetThumbs);
$totalRows_GetThumbs = mysql_num_rows($GetThumbs);
?>
The link from the index page to the thumbnails page is carrying the
catID number forward, as seen in the resulting URL (thumbs.php?
ID=17), yet the query isn't accepting it.
table Photos_Category contains the category names.
table Photos contains the photos and other relevant information.
Any ideas where I'm going wrong?
david
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
