| Multiple <a> Tags, Filled With MySQL DB data with PHP [message #179220] |
Tue, 25 September 2012 17:43  |
tom.rankin51
Messages: 17
Registered: September 2012
Karma:
|
Junior Member |
|
|
Hello
I am trying to create two image galleries using fancybox. There is no issue doing this by manually typing out a bunch of <a> tags with the info inside, but when I attempt to code a piece of PHP to pull this data from my database, it doesn't like it and displays the images strangely.
The "working" code is:
<a class="fancybox" rel="1" href="/image4.jpg" title="Title 1"><img src="thumbnail.jpg"></a>
<a class="fancybox" rel="1" href="/image3.jpg" title="Title 2"></a>
<a class="fancybox" rel="2" href="/image2.jpg" title="Title 3"><img src="thumbnail.jpg"></a>
<a class="fancybox" rel="2" href="/image1.jpg" title="Title 4"></a>
This essentially groups the images by the 'rel' tag automatically, showing two thumbnails which when clicked shows the corresponding images in descending order (ie last added).
In my database I have created a 'rel' field and populated it with either "1" or "2", and tried the following:
<!-- START OF PHP SCRIPT (DB OPEN)-->
<?
include("php/dbinfo.inc.php");
mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$visuals_query=mysql_query("SELECT id, imagelink, comment, picdate, rel FROM PictureMedia ORDER BY picdate DESC");
mysql_close();
?>
<!-- END OF PP SCRIPT (DB OPEN) -->
<?
while($r=mysql_fetch_assoc($visuals_query)) {
echo '<a class="fancybox" rel="'.$r["rel"].'" href="'.$r["imagelink"].'" title="'.$r["comment"].'"><img src="thumbnail.jpg"></a>';
}
?>
Now, I think that this should do exactly the same thing, other than showing four thumbnails obviously. What actually happens is that the first thumbnail loads the last added image in a new page, then the other three as expected but with the focus on the picture displayed by the query. It also did not show a Facebook share button when using PHP.
I understand that this issue isn't all down to PHP, but may be down to the fancybox script. However, I can't post in two groups simultaneously so if my code looks correct then I can go along another route.
Thanks in advance
Tom
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]