Hi I have the following code which is a photo gallery, I have set it up so
users
can add comments to the photos, what I want to happen is in the gallery if a
user
has posted a comment on the photo, I want it to say comments under the photo
in the gallery, I have tried doing this using IN_ARRAY but I am getting an
error msg,
Warning: in_array(): Wrong datatype for second argument
on line 203
line 203 is this: if(in_array($images[$i],$result))echo "<br><font
class=blue>Comments</font>";
will have a play around with a few things and left yuo know if I suceed b4
you get back.
Can someone see what I am doing wrong with the in_array..
Thanx In advance
Adam
==================================================
<?PHP
//start of comments selection...
$mysql_access = mysql_connect("localhost", "username", "password") or
DIE(mysql_error());
mysql_select_db("database", $mysql_access) or DIE(mysql_error());
$query = "SELECT * FROM comphotolink WHERE comphotolink.PhotoPath =
$PathVar";
$result = mysql_query($query, $mysql_access) or DIE(mysql_error());
if ($result) {
while ($r = mysql_fetch_array($result))
{ // Begin While
extract($r);
$PhotoName = $PhotoName;
//echo "$PhotoName <br>";
} //End While
} else {
echo "no comments<br><br>";
}
//end of comments selection
//page vars
$total = count($images);
$limit = 15;
$page = $_GET['page'];
$num_prow=3;
//$offset = ($page - 1) * $limit;
//$jpgs=0;
$handle=opendir($PathVar);
$index=0;
$images;
$last_updated;
while($file=readdir($handle)){
if($file!='.' && $file!='..'){
$myfile=explode(".",$file);
if($myfile[1]=='jpg' || $myfile[1]=='JPG'){
$images[$index]=$file;
//$size[$index]=filesize($file);
//$date[$index]=filemtime($file);
$thumb[$index]=$file;
$index++;
$jpgs++;
}
}
}
if(!$images){
print "::<B>Warning</b>::<br>This folder contains no allowed image files.";
exit;
}
$total=count($images);
$numPages = ceil($total / $limit);
$j=0;
// Set first set of pictures
if(!isset($pics)){$pics=$page * $limit;}
//$pics = $page * $limit;
$from = $pics-$limit;
$pp = $pics+$limit;
// =====OUTPUT=====
$query2 = "SELECT * FROM eventlistings WHERE PhotoPath = $PathVar";
$result2 = mysql_query($query2, $mysql_access) or DIE(mysql_error());
if ($result2) {
while ($r = mysql_fetch_array($result2))
{ // Begin While
extract($r);
echo "";
}} //End While
echo "<div align=center><strong>$EventName - $EventDate</strong> <br>
Directory contains a total of ".count($images)." image files </div><BR>";
echo "<div align=center><table cellspacing=10 cellpadding=10
bordercolor=#CC33CC border=1 class=txt><tr bordercolor=#000000
bgcolor=White>";
for($i = $from; $i < $pics && $i < $total; $i++){
if($j == $num_prow){
echo "
<tr bordercolor=#000000 bgcolor=White><td align=center valign=top><a
href=\"MainPhoto.php?Image=$thumb[$i]&PhotoPath=$PathVar\">
<!-- $images[$i]<BR><BR> -->
<img border=0 src=\"$PathVar/thumb/$thumb[$i]\"></a>";
if(in_array($images[$i],$result))echo "<br><font
class=blue>Comments</font>";
echo "</td>";
//
$j = 1;
}else{
echo "<td align=center valign=top><a
href=\"MainPhoto.php?Image=$images[$i]&PhotoPath=$PathVar\"><!--$images[$i]<
BR><BR> --><img border=0 src=\"$PathVar/thumb/$thumb[$i]\"></a>";
//
if(in_array($images[$i],$result))echo "<br><font
class=blue>Comments</font>";//
$j++;
}
}
echo "</tr></table><BR><BR><BR>";
if ($page == 1) // this is the first page - there is no previous page
echo "Previous";
else // not the first page, link to the previous page
echo "<a href=\"Gallery.php?PathVar=$PathVar&page=" . ($page - 1) .
"\" class=cssbtn>Previous</a>";
for ($i = 1; $i <= $numPages; $i++) {
echo " | ";
if ($i == $page)
echo "$i";
else
echo "<a href=\"Gallery.php?PathVar=$PathVar&page=$i\">$i</a>";
}
if ($page == $numPages) // this is the last page - there is no next page
echo " | Next";
else // not the last page, link to the next page
echo " | <a href=\"Gallery.php?PathVar=$PathVar&page=" . ($page + 1)
. "\" class=cssbtn>Next</a>";
/*
if($i < $total){echo "<a
href=\"".$PHP_SELF."?PathVar=$PathVar&page=$pp\">Next</a>";}
if($page != $total){echo " <a
href=\"".$PHP_SELF."?PathVar=$PathVar&page=$total\">Last</a></div>";}
*/
echo "<br><br></body></html>";
closedir($handle);
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
