Calculate price from two different table + using php and mysql -

-

i have 2 tables in database, 1 table has trip/user related information: such trip_id, username, leave_date, return_date, flight_estimate, registration_fee etc, , second table expense table trip_id fk, , expenses such hotelcost, bf,lunch each date... each trip_ip has more 1 record in table.

now, i'm trying create summary table total price using php user , when used following code, gives records of trip 1 date right, if has multiple dates, if creates 2 different records.. want 1 record (since i'm calculating grand total of particular trip)

if(isset($user)) {     $sql =            " select trip.trip_id new_tripid"         . "      , destination"         . "      , leave_date"         . "      , return_date"         . "      , date(last_updatedate) updateddate"         . "      , flight_estimate"         . "      , registration_fee"         . "      , hotel_cost"         . "      , breakfast_cost"         . "      , lunch_cost"         . "      , dinner_cost"         . "      , parking_cost"         . "      , taxi_cost"         . "      , rental_car_cost"         . "      , mileage"         . "      , fuel_cost"         . "      , other_cost"         . "   trip"         . "      , expense"         . "  trip.username='" . $user ."'"         . "    , trip.trip_id = expense.trip_id"     ;     $result = mysql_query($sql);      $num_rows = mysql_num_rows($result);      $o = '<table id="mytable1" border="1" style="border:1px solid orange; background-color: #f3f3f3;"><thead><tr><th>trip id</th><th>destination</th><th>leave date</th><th>return date</th><th>total</th><th>submit date</th><th>status</th></tr></thead><tbody>';  } else {     echo('not valid user'); }  if (!$result) {    die(mysql_error()); }  if ($num_rows<=0){     echo('not valid user'); } elseif ($num_rows>0) {      while($row = mysql_fetch_array($result)) {         $grandtotoal = $row['flight_estimate'] + $row['registration_fee'] +                         $row['hotel_cost']+$row['breakfast_cost']+$row['lunch_cost']+                        $row['dinner_cost']+$row['parking_cost']+$row['taxi_cost']+                        $row['rental_car_cost'] +$row['mileage']+$row['fuel_cost']+$row['other_cost'];           $o .= '<tr><td align = "center" style="width:absolute; height:30px;">'.                $row['new_tripid'].'</td><td align = "center" style="width:absolute;height:30px;">'.                $row['destination'].                '</td><td align = "center" style="width:absolute height:30px;">'.                 $row['leave_date'].                 '</td><td align = "center" style="width:absolute; height:30px;">'.$row['return_date'].                 '</td><td align = "center" style="width:absolute; height:30px;">'.                 $grandtotoal.'</td><td align = "center" style="width:absolute; height:30px;">'.                 $row['updateddate'].'</td></tr>';     }     $o .= '</tbody></table>';      echo $o; } 

select trip.trip_id new_tripid,destination, leave_date, return_date,     date(last_updatedate) updateddate, flight_estimate , registration_fee,     sum(hotel_cost, breakfast_cost, lunch_cost, dinner_cost, parking_cost, taxi_cost,      rental_car_cost, mileage, fuel_cost, other_cost) total_cost trip, expense trip.username='$user' , trip.trip_id = expense.trip_id group trip.username

Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more