Hi Jillian,
Here is one way to implement slide shows in PHP. Please note that this code is
rather crude-- I haven't even put the required <html> and <body> tags.
Anyway, here it is:
<?php
// how many seconds do you want your image to display?
$interval = 5;
if(!isset($_GET['ptr'])) {
$ptr = 1;
}
$link = mysql_connect("localhost", "user", "pass"); // your connection
string;
mysql_select_db("foo");
$query = "select name, description from images where id = 'x' limit $ptr,
1";
$result = mysql_query($query, $link);
if(!($row = mysql_fetch_object($result))) {
$ptr = 1;
$query = "select name, description from images where id = 'x' limit
$ptr, 1";
$result = mysql_query($query, $link);
}
echo "<InvalidTag http-equiv=\"refresh\" content=\"$interval;
slideshow.php?ptr=" . ($ptr + 1) . "\" />";
echo "<img src=\"{$row->name}\" alt=\"{$row->description}\" />";
?>
I can't test this because I don't have your database. I hope this won't
contain too much errors. BTW, a better solution is to implement your slideshow
in Dynamic X/HTML. :)
Regards,
[ simon.cpu ]
>Sorry for the OT message. I'm creating (what I hope) is a super easy
>little script and I wanted to see if anybody could help me as it has to
>be in php.
>
>I need something that:
>
>A) pulls a list of images from the database
> (ie: select * from images where id=x)
>B) cycle through them in a 'slideshow'
>
>Does anybody have something like this they could share? Anything that
>gets me started?
>
>--
>Jillian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207730
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
