Need help! Two Problems

[TheHyipSite]

Hey guys

I have two tables, hl_listings and hl_statistics

They have the following fields:

hl_listings

id.....................bigint(20)................. 3(Primary)
name...............varchar(255)............ Test site

hl_statistics

id....................bigint(20)......................70 (Primary)(70th payment)
listing_id.........bigint(20).....................3 (for. key)
type................tinyint(1)......................0 or 1(0 for incoming payments and 1 for out)
date................datetime......................2006-07-01 00:00:00
amount...........double(10,2).................15.00 ie $15.00

What i want to do is display some of the information in an image, basically a table with a background and the rows contain some fields in php.

However im having trouble with some calculations that need to be displayed.

I would like to show the most recent pay out date for the image id (same as hl_listings.id) something like

$date= $info['date']
print $date when date=largest and type =0???

And display the date as 1/07/06 for example?

Next problem, i'd like to calculate the perectentage profit done something like this

print $info['amounts'] where type=0/$info['amounts'] where type=1 * 100 to show the percentage???
but only show the percent ie 10

but i dont know how to do this as php?

I know this is an awful lot guys but any help is greatly appreciated!!

If this helps the record 9 in the database is shown in what ive got so far: http://www.thehyipsite.com/index.php?a=image&lid=9 only the name, paying image and a link to the page that this record is on have been added to the table/image

another example at http://www.thehyipsite.com/index.php?a=image&lid=2 the other parts is just a image located at http://www.thehyipsite.com/images/Image_bk.gif

Like i said before any help greatly apprectiated!! 🙂 🙂

Many thanks

Mikk

[TheHyipSite]

Here is what i have so far for the image found at the link posted above:

 function draw_image ()
  {
global $frm;
mysql_connect("xxxx", "xxx", "xx") or die(mysql_error());
mysql_select_db("xxx") or die(mysql_error()); 
$frm = $frm['lid'];
$data = mysql_query ("SELECT  hl_listings.name, hl_listings.hyip_status, hl_statistics.type, hl_statistics.amount, hl_statistics.listing_id, hl_statistics.date, hl_statistics.id  FROM hl_listings, hl_statistics WHERE (hl_statistics.listing_id = '$frm') and(hl_listings.id = '$frm') "); 
$info = mysql_fetch_array( $data );		         

$amount = $info['amount'];
$type = $info['type'];
$Id = ($info['listing_id']='$frm')
?>
<font size="8" face="Times"><table frame=border background ="http://www.TheHyipSite.com/images/Image_bk.gif" cellspacing="10">
<tr>
  <td><center><?php print $info[name];?></td>
</tr>
<tr>
 <td><center><br><br><br><br></td>
</tr>
<tr>
  <td><center><?php ;?>
		</td> 
</tr>
<tr>
  <td><center><?php  while ($type = 0 and $Id) print "$amount" ;?></td>
</tr>
<tr>
  <td><center><?php 
	  if ($info['hyip_status'] == 1) print "<a href='http://www.TheHyipSite.com'><img src='http://www.thehyipsite.com/images/m_pay.gif' width=60 height=45 border=0 alt='TheHyipSite.com' title='TheHyipSite.com: The Site For HYIPs'>";

if ($info['hyip_status'] == 2) print "<a href='http://www.TheHyipSite.com'><img src='http://www.thehyipsite.com/images/m_wait.gif' width=60 height=45 border=0 alt='TheHyipSite.com' title='TheHyipSite.com: The Site For HYIPs'>";

if ($info['hyip_status'] == 3) print "<a href='http://www.TheHyipSite.com'><img src='http://www.thehyipsite.com/images/m_prob.gif' width=60 height=45 border=0 alt='TheHyipSite.com' title='TheHyipSite.com: The Site For HYIPs'>";

if ($info['hyip_status'] == 4)print "<a href='http://www.TheHyipSite.com'><img src='http://www.thehyipsite.com/images/m_npay.gif' width=60 height=45 border=0 alt='TheHyipSite.com' title='TheHyipSite.com: The Site For HYIPs'>";
?><br></td>
</tr>
<tr>
   <center><?php  print "<td align='center'><A HREF='http://www.TheHyipSite.com/?a=details&lid=$frm'><Blink>Vote For Program</Blink></A></td>"; ?>
  </tr>
</table>
</html><?

}

[TheHyipSite]

a hard problem isnt it ill check back now and then thanks

mikk