Revision: 1452
http://mrbs.svn.sourceforge.net/mrbs/?rev=1452&view=rev
Author: cimorrison
Date: 2010-09-15 09:13:17 +0000 (Wed, 15 Sep 2010)
Log Message:
-----------
Simplified SQL query and added a LIMIT 1 to improve performance
Modified Paths:
--------------
mrbs/branches/provisional_bookings_new_style/web/edit_entry_handler.php
Modified:
mrbs/branches/provisional_bookings_new_style/web/edit_entry_handler.php
===================================================================
--- mrbs/branches/provisional_bookings_new_style/web/edit_entry_handler.php
2010-09-15 09:02:05 UTC (rev 1451)
+++ mrbs/branches/provisional_bookings_new_style/web/edit_entry_handler.php
2010-09-15 09:13:17 UTC (rev 1452)
@@ -557,9 +557,10 @@
// details
if ($mail_settings['details'])
{
- $sql = "SELECT r.id AS room_id, r.room_name, r.area_id, a.area_name
";
- $sql .= "FROM $tbl_room r, $tbl_area a ";
- $sql .= "WHERE r.id=$room_id AND r.area_id = a.id";
+ $sql = "SELECT R.room_name, A.area_name
+ FROM $tbl_room R, $tbl_area A
+ WHERE R.id=$room_id AND R.area_id = A.id
+ LIMIT 1";
$res = sql_query($sql);
$row = sql_row_keyed($res, 0);
$room_name = $row['room_name'];
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
