Author: vip
Date: Wed May 16 02:24:23 2007
New Revision: 8557
Modified:
toys/stbr/index.php
Log:
- specify LEFT JOIN
Modified: toys/stbr/index.php
==============================================================================
--- toys/stbr/index.php (original)
+++ toys/stbr/index.php Wed May 16 02:24:23 2007
@@ -48,14 +48,16 @@
<h2>Send To Builder Requests Log</h2>
-<table>
+<table width="400px">
<thead>
-<tr><b>Importand Info:</b></tr>
-<tr><td><font color='red'>th-ready:</font></td>
-<td>means you requested an upgrade</td></tr>
-<tr><td><font color='red'>th-test:</font></td>
-<td>means you reqested an test-build</td></tr>
+<tr><td width="150px"><b>Importand Info:</b></td></tr>
</thead>
+<tbody>
+<tr><td width="150px"><font color='red'>th-ready:</font></td>
+<td width="250px">means you requested an upgrade</td></tr>
+<tr><td width="150px"><font color='red'>th-test:</font></td>
+<td width="250px">means you reqested an test-build</td></tr>
+</tbody>
</table>
<br/>
<div id="phonebookTable">
@@ -102,6 +104,7 @@
$inner .= " builder, queue_requester, queue_date ";
$inner .= "FROM application ";
$inner .= "LEFT JOIN status ";
+$inner .= "ON (application.spec=status.spec AND application.date=status.date)
";
$inner .= "WHERE application.date='{$p['date']}' ";
$inner .= "ORDER BY application.date DESC";
_______________________________________________
pld-cvs-commit mailing list
[email protected]
http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit
