One For Each - Dev Articles

Dev Articles Community Forums Sponsor:

December 10th, 2002, 01:11 AM

DivaX007

Junior Member

Join Date: Nov 2002

Posts: 23

Time spent in forums: < 1 sec
Reputation Power: 0

One For Each

i have included a rating script in a gallery script using include(). the drop down rating box appears only once when i test the script, but i need it to appear beside each image. how do i do this?

<?php

// Connects to sql server and logs in with username and password
// if successful, then the script moves on to displaying the gallery.

$connect=mysql_connect("localhost","xxxx","xxx")
or die("couldnt connect to sql server");

$db= mysql_select_db("dbname") or die ("couldnt select database");

include("./rate.php");

// Ive set the number of photos per page, in this case I only have 7 photos
// so I want to display 1 photo per page.

$per_page = 1;

// Selects all of the data from database

$sql_text = ("SELECT * from photogallery ORDER BY id DESC");

// Sets page number, if no page is specified, it will create page 1

if(!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;

$query = @mysql_query($sql_text);

// Sets up specified page

$page_start = ($per_page * $page) - $per_page;

$num_rows = @mysql_num_rows($query);

if($num_rows <= $per_page) {
$num_pages = 1;
}
else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
}
else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;

if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}

$sql_text = $sql_text . " LIMIT $page_start, $per_page";
$query = mysql_query($sql_text);

?>




<title>My Photo Gallery</title>
<body bgcolor="#ffffff">
<blockquote> There are currently
<?php echo "$num_rows"; ?> photos in My Photo Gallery



<?php
while ($result = mysql_fetch_array($query))
{
$title = $result["title"];
$photo = $result["photo"];

$linkToFullPhoto = $result["link2Full"];

// Using HTML "img" tags for the photos, it selects the photo by it's "id" number

echo $title.' 

<a href="'.$linkToFullPhoto.'">

<img src="'.$photo.'" border="0">

</a>

<hr width="400" align="left">';
}

// This displays the "Previous" link

if ($prev_page) {
echo "<a href=\"$PHP_SELF?page=$prev_page\">< Prev</a>";
}

// This loops the Pages and displays individual links corresponding
// to the photos.

for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo " <a href=$PHP_SELF?page=$i>$i</a>";
} else {
echo " $i ";
}
}

// This displays the "Next" link.

if ($page != $num_pages) {
echo " |<a href=\"$PHP_SELF?page=$next_page\"> Next ></a>" ;
}

?>

</blockquote>
</body>
</html>

_____________

Viewing: Dev Articles Community Forums > Programming > General Programming Help > One For Each

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump