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

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t

Set Categories
I am creating a submission form for somebody to come in and submit products. These products are sep

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,