shahzad429

I have two tables CREATE TABLE `pricedata` ( `TableID` int(11) NOT NULL AUTO_INCREMENT, `AgentName` int(10) DEFAULT NULL, `VechicleName` int(10) DEFAULT NULL, `DestinationName` int(10) DEFAULT NULL, `FromDA` float DEFAULT '0', `FromAA` float DEFAULT '0', `FromSA` float DEFAULT '0', `FromRA` float DEFAULT '0', `UserID` int(10) DEFAULT NULL, PRIMARY KEY (`TableID`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1; CREATE TABLE `vehicles` ( `TableID` int(11) NOT NULL AUTO_INCREMENT, `VechicleName` varchar(255) DEFAULT NULL, `VehiclesTypeName` int(10) DEFAULT NULL, `MoreInfo` longblob, `Pic1` varchar(255) DEFAULT NULL, `Facilities` varchar(1000) DEFAULT NULL, `MaxPass` varchar(255) DEFAULT NULL, `MaxSuit` varchar(255) DEFAULT NULL, `GolfBag` varchar(255) DEFAULT NULL, `ExtraBag` varchar(255) DEFAULT NULL, `ChildBooster` varchar(255) DEFAULT NULL, `InfantSeat` varchar(255) DEFAULT NULL, `WheelChair` varchar(255) DEFAULT NULL, `Bicycle` varchar(255) DEFAULT NULL, `ExtraStop` varchar(255) DEFAULT NULL, `UserID` int(10) DEFAULT NULL, PRIMARY KEY (`TableID`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; what i am doing right now is using below query "select * from pricedata where DestinationName='1' group by AgentName ,VechicleName" but now i am stuck because now clients wants to show result based on VehiclesTypeName which is in my second table. so how i can display the result where DestinationName=1, VehiclesTypeName=3 and MaxPass<=4? maybe we can do it my mysql join or left or right join i am weak in mysql if anyone can help me please. Thanks, Shahzad

Ok round() is fine. and how can i show days with no data??

Thanks Barand it is working fine. It is showing the days with the data can we make it in a way that it will display all days in that month if no data then it will show 0 and 1 more question sum and average are showing 8-9 digits after decimal. we have to put some thing in query so that it will only display 2 or 3 digit after decimal?? Thanks again for your help. Thanks, Shahzad

I have a table CREATE TABLE `safarioldddata` ( `TableID` int(11) NOT NULL AUTO_INCREMENT, `TourDate` date DEFAULT NULL, `ClientName` varchar(255) DEFAULT NULL, `NOAdults` int(10) DEFAULT '0', `AdultAmount` float DEFAULT '0', `AdultAvg` float DEFAULT '0', `NOChildren` int(10) DEFAULT '0', `ChildrenAmount` float DEFAULT '0', `ChildAvg` float DEFAULT '0', `UserID` int(10) DEFAULT NULL, PRIMARY KEY (`TableID`) ) And now i am working on daily report i have used below query select TourDate,sum(NOAdults) as NOAdult , sum(AdultAmount) as AdultTotal, avg(AdultAvg) as AdultAVG, sum(NOChildren) as NOChildren , sum(ChildrenAmount) as ChilrenTotal, avg(ChildAvg) as ChildrenAVG from safarioldddata where TourDate="2012/1/2" it is working fine but the problem is as i am passing one days it give me on record like TourDate NOAdult AdultTotal AdultAVG NOChildren ChilrenTotal ChildrenAVG 1/2/2012 183.00 34,253.38 206.24 24.00 1,966.60 36.36 there is a way where i will pass month and year and it will display report for whole that month. Thanks, Shahzad

select * from product where TableID not in (select ProductID from agencytoproduct where AgencyID='$object[TableID]') order by ProductName asc i have used this and it worked is it ok??

I have two table 1. TableID, ProductName 2. TableID, AgencyID, ProductID what i want to do is to display all the products from table 1 and exclude when TableID of table 1 match ProductID of table 2. any help regarding this pelase Thanks, Shahzad

Thank you it worked thank you very much for you help.

the goal is what ever user select to store those options in DB for later retrieval. so what ever method is good tell me. right now in front end user can add and remove option but what i want when he submit i should know when he select so that i can save them. Thanks, shahzad

I know but no help from javascript section so i thought maybe some one from PHP area know how to take this value and store them in database. thanks is why i post this here. Sorry

I have use this This to make add/remove select list <form action="home.php?action=test" method="post" id="myform" name="myform" onsubmit="ValidatePageForm()"> <fieldset> <select name="selectfrom" id="select-from" multiple size="5"> <option value="1">Item 1</option> <option value="2">Item 2</option> <option value="3">Item 3</option> <option value="4">Item 4</option> </select> <a href="Javascript:void(0);" id="btn-add">Add &raquo;</a> <a href="Javascript:void(0);" id="btn-remove">&laquo; Remove</a> <select name="selectto" id="select-to" multiple size="5"> <option value="5">Item 5</option> <option value="6">Item 6</option> <option value="7">Item 7</option> </select> </fieldset> <input name="submit" type="submit" value="submit" /> </form> using below script i can see values of selected options <script type="text/javascript"> function ValidatePageForm() { $('#select-to option').each(function(){ alert($(this).val()); }); } </script> But how can i take these values and store them in database?? because when i submit i dont get see data in post dump. any help regarding this please. Thanks, Shahzad

I have Google map using Google map API v3. what i have is a Google map in accordion which user can click and place a marker and value of lat & lon fill two text boxes on top. this part is working fine with below script. but what i want now as text boxes is filled with lat & lon if user change value of lat or lon in text box marker need to change accordingly. var map = null; function initialize() { var myLatlng = new google.maps.LatLng(25.263327,55.329895); var myOptions = { zoom: 10, center: myLatlng, mapTypeId: google.maps.MapTypeId.ROADMAP } var map = new google.maps.Map(document.getElementById("map_canvas"), myOptions); var marker; function placeMarker(location) { if ( marker ) { marker.setPosition(location); } else { marker = new google.maps.Marker({ position: location, map: map }); } } google.maps.event.addListener(map, 'click', function(event) { placeMarker(event.latLng); document.getElementById("latFld").value = event.latLng.lat(); document.getElementById("lngFld").value = event.latLng.lng(); }); } $(document).ready(function() { $("#accordion").bind('accordionchange', function(event, ui) { if (ui.newContent.attr('id') == 'tabThree' && !map) { map = initialize(); } }); });

thanks Pikachu2000 it is working like a charm thank you again every one for all your help and support.

thank you very much guys.

I have a 5 letter string eg: etd00 and AA001 there is any way in PHP to check first 2 letters are capital or not? Thanks, Shahzad

yes i can control so how to format a string?