Sql ?

pankaj · 03-13-2007, 06:48 AM

Whats wrong in the following query -->

Code:

SELECT SUM(bookings),SUM(invoices),SUM(segments),SUM(totalgross),SUM(totalsale),SUM(commission),SUM(tax),SUM(SELECT grossfare FROM salesqww where type="cash adjustments" and aircode="UA") FROM summary WHERE aircode='UA'

jumpenjuhosaphat · 03-13-2007, 03:50 PM

It's really hard to tell without knowing some details. Are all of the table fields numeric? How are you trying to acess the data that is returned?

pankaj · 03-14-2007, 04:30 AM

Quote:

Originally Posted by jumpenjuhosaphat

It's really hard to tell without knowing some details. Are all of the table fields numeric? How are you trying to acess the data that is returned?

Yes all the fields are numeric.

kenni · 03-14-2007, 04:19 PM

What error are you getting? Add this code after the section where you submit the query.

Code:

mysql_query("<query-here>") or die(mysql_error());

That should return the MySQL error if there is one.

jumpenjuhosaphat · 03-15-2007, 04:19 AM

The reason that I'm asking how you are trying to access the data is because you can't access it like you normally would. It would be stored in your array as numbers, ie. $row[0], $row[1], etc. If you are trying to access the information by using $row[bookings] etc, then it won't return the information in the function.

mani · 03-15-2007, 08:14 PM

Please pm me with what you are stuck on and i will try to help as much as possible.

03-13-2007, 03:50 PM	#2
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Sql ? It's really hard to tell without knowing some details. Are all of the table fields numeric? How are you trying to acess the data that is returned? __________________ Storage Sheds Lost Forum

03-14-2007, 04:19 PM	#4
kenni Registered Member Join Date: Dec 2005 Posts: 1,543	Re: Sql ? What error are you getting? Add this code after the section where you submit the query. Code: mysql_query("<query-here>") or die(mysql_error()); That should return the MySQL error if there is one. __________________ Wanna thank someone? Give 'em a rep. More info.

03-15-2007, 04:19 AM	#5
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Sql ? The reason that I'm asking how you are trying to access the data is because you can't access it like you normally would. It would be stored in your array as numbers, ie. $row[0], $row[1], etc. If you are trying to access the information by using $row[bookings] etc, then it won't return the information in the function. __________________ Storage Sheds Lost Forum

03-15-2007, 08:14 PM	#6
mani Junior Guru Contributor Join Date: Aug 2006 Posts: 578	Re: Sql ? Please pm me with what you are stuck on and i will try to help as much as possible. __________________ Free Online Addictive Games - Fun flash arcade Car Specifications - Ultimate Car Guide

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)