[go: up one dir, main page]
Menu ▾ ▴

[r112]: / trunk / standings.php  Maximize  Restore  History

Download this file

67 lines (61 with data), 2.3 kB 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php

# $Id$

#

# Includes

####################################################################

include("includes/session.inc.php");

include("includes/layout.inc.php");

include("includes/functions.inc.php");

include("includes/db.inc.php");

include("includes/variables.inc.php");





# Main

#####################################################################?>

<html>

<head>

<?php echo "$headtitle $head";?>

</head>

<body>

<div id=menu>

<?php include("includes/menu.inc.php");?>

</div>

<div id=mainframe>

<b><?php echo $standings;?></b><p>



<table width=850 border=0 cellpadding=4 cellspacing=0>

<a href="insert.php?db=dauerauftraege "rel="gb_page_center[300, 510]"><img src=images/new.gif border=0 title="<?php echo "$new_m $standing";?>"></a>



<tr align=right bgcolor="#DDDDDD">

<td><b><?php echo $day?></td>

<td><b><?php echo $month?></td>

<td><b><?php echo $year?></td>

<td align=left><b><?php echo $entrytext?></td>

<td><b><?php echo $amount?></td>

<td align=left><b><?php echo $category?></td>

<td><b><?php echo $sh?></td>

<td><b><?php echo $number?></td></tr>



<?php $query = mysql_query("SELECT id,tag,monat,jahr,betrag,quelle.q_name,hauptkategorien.hk_name,subkategorien.sk_name,username,shared,text FROM dauerauftraege LEFT JOIN quelle ON dauerauftraege.q_id = quelle.q_id LEFT JOIN hauptkategorien ON dauerauftraege.hk_id = hauptkategorien.hk_id LEFT JOIN subkategorien ON dauerauftraege.sk_id = subkategorien.sk_id WHERE username='$activeuser' $strippedformreturn ORDER BY tag,monat,id ASC") or die (mysql_error());

while ($output=mysql_fetch_array($query)) {

	echo "<tr class=hover align=right>";

	echo "<td> ";

	if ($output[1] == 0) { echo "<img src=images/loop.png>"; } else { echo "$output[1]"; }

	echo "</td><td> ";

	if ($output[2] == 0) { echo "<img src=images/loop.png>"; } else { echo "$output[2]"; }

	print ("</td><td> $output[3]</td>

	<td align=left> $output[10]</td>

	<td> $currency " . zahlFormat($output[4]) . "</td>

	<td align=left> $output[6] $output[7] ($output[5])</td>");

	if ($output[9] == "0") {

		echo "<td> </td>";

	} else {

		echo "<td> $yes</td>";

	}

	echo "<td bgcolor=#FFFFCC> $output[0]</td>";

	echo "</tr>";

}?>

</table>

<table width=850 

<tr><td align=right>

<?php eintragEditieren(dauerauftraege);?>

</td></tr>

</table>

</div>

</body>

</html>