Is this possible? If one file assigned to an ID...

Posted on 16th Feb 2014 07:03 pm by admin

I have a page that lists property listings assigned to a specific user (a manage page), with brief text details and a picture.

Each of these listings has several images with it, that aren't seen unless they click on the listing itself to edit/view it.

I'd like to put a warning next to the listing on this manage page if one or more of the images assigned to that listing id are over a certain size. I'm not quite sure how to do this. When I put in the code, I get an error at the top giving an filesize stat warning, listing all of the files run together:

Code: Warning: filesize() [function.filesize]: stat failed for re_images/1263001649_offer_christmasstory.jpg|1263001038_offer_TEST.jpg in
Here is the code I've got that has the problem:

Code: if($rows > '0')
{
$ListingTable .= "<table align=center width=510 border=1 bordercolor=black frame=hsides rules=rows cellspacing=0>n";

while($a1 = mysql_fetch_array($r1))
{
$size = filesize('re_images/'.$a1[image]);
if( $size > 153600 )
{
echo '<p align=center><img src="images/warning.gif" border="0"></p>';
$warning="<font color=#FF0000 size=5>!!</font></b>";
}

$ListingTable .= "<tr onMouseOver="this.style.background='#E2E2E2'; this.style.cursor='hand'" onMouseOut="this.style.background='white'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";

if($a1[PriorityLevel] > '1')
{
//get the priority level name
$qp = "select PriorityName from re2_priority where PriorityLevel = '$a1[PriorityLevel]' ";
$rp = mysql_query($qp) or die(mysql_error());
$ap = mysql_fetch_array($rp);

$sub = "<span class=RedLink>^$ap[0]</span>";
}
else
{
$sub = "";
}

$ListingTable .= "nt<td width=15>";

if(!empty($a1[image]))
{
$ListingTable .= "<img src="myimages/camera.jpg" width=15 height=15>$warning";
}

$ListingTable .= "</td>nt";
$ListingTable .= "<td width=305>$a1[city], $a1[state], $a1[address] $sub</td>nt";
$ListingTable .= "<td width=80>$a1[rooms] br, $a1[bathrooms] ba";
$MyPrice = number_format($a1[Price], 2, ".", ",");
$ListingTable .= "</td>nt<td align=center width=100><b>$$MyPrice</td>n";
$ListingTable .= "</tr>n";

}

$ListingTable .= "</table>";
}
I've coded this on the next page that shows all of the image, and it worked good. This one, I just couldn't figure out how to tell the server to look in the folder to see if any of the image associated with an id are a certain size

Your Answer:

Login to answer

Other forums

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

creating a 1 to 100 in a table
hi guys I am a newb in php need some help.

I have a table with 1 column and 100 rows and in

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

Problem with php's rename function
So, i'm having a problem with the php rename function. Basically my script 'delete_user.php' attempt

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire