Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 10 of 10
Search took 0.50 seconds. Search: Posts Made By: gbarrett
Forum: MySQL 09-20-2012, 11:23 AM
Replies: 6
Views: 857
Posted By gbarrett
That was it it works perfectly thank you.

That was it it works perfectly thank you.
Forum: MySQL 09-19-2012, 10:51 AM
Replies: 6
Views: 857
Posted By gbarrett
Wow, thank you - I can see all the logic but I am...

Wow, thank you - I can see all the logic but I am getting this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...
Forum: PHP 04-27-2011, 11:11 AM
Replies: 4
Views: 552
Posted By gbarrett
Yes this works thankyou SELECT...

Yes this works thankyou

SELECT customer.ClientID, customer.Title, customer.FirstName, customer.Surname, customer.Postcode, customer.Tel, customer.LeadGen, customer.Closer, customer.2ndCallDate,...
Forum: PHP 04-26-2011, 02:55 PM
Replies: 4
Views: 552
Posted By gbarrett
Thank you - Yes I only want to show the highest...

Thank you - Yes I only want to show the highest number. So a customer may have a ststus of 1 and 2 and 3 and 4 and 5 but I only want it to show the highest number - if the highest status number a...
Forum: PHP 04-25-2011, 03:03 PM
Replies: 4
Views: 552
Posted By gbarrett
Select Query Problem

I have 3 tables customer, claiminfo and claimstatus
One customer can have multiple claims (claiminfo) and each claim can have many status(claimstatus).
In the claimstatus table there is a column...
Forum: MySQL 03-22-2011, 12:32 PM
Replies: 3
Views: 547
Posted By gbarrett
Thank you - that works perfectly. Just a quick...

Thank you - that works perfectly. Just a quick one how can you select 1 in the sub query - don't you need to select a column - what does the 1 stand for?
Forum: MySQL 03-18-2011, 02:58 PM
Replies: 3
Views: 547
Posted By gbarrett
Select Query problem

I have 2 tables one for customer and one for product information. A customer can have more than one product. Each product has a stage. I need to pull in all records that have the stage 13. So;...
Forum: MySQL 03-15-2011, 12:03 PM
Replies: 5
Views: 1,102
Posted By gbarrett
Brilliant thanks - that works perfectly!

Brilliant thanks - that works perfectly!
Forum: MySQL 03-14-2011, 03:54 PM
Replies: 5
Views: 1,102
Posted By gbarrett
Thank you. At first glance I thought this was...

Thank you. At first glance I thought this was perfect however I can't get it to work.
SELECT conversation.cClientID, MAX(conversation.stage), COUNT(*)
FROM conversation
GROUP BY...
Forum: MySQL 03-14-2011, 12:53 PM
Replies: 5
Views: 1,102
Posted By gbarrett
Max Count problem

I have 2 tables; customer and conversation. The conversation table records stages that a client is at, for example client 1 may have 3 conversations, one at stage '1', one at stage '2', and one stage...
Showing results 1 to 10 of 10

 
Forum Jump

All times are GMT +1. The time now is 09:27 AM.