Solved

PHP Query, OUTPUT

Posted on 2011-03-17
5
284 Views
Last Modified: 2012-05-11
Hi Experts,

Ive got a query that returns results from a database but does not return all entries under the "last_spoken_to" field.. which is in the notes table..

the current query i have is as follows:

$sql = "select * from customer left join notes on customer.customer_name = notes.customer_name WHERE customer.customer_name = '" . $val . "'";

I have tried the following:

$sql = "select * from customer left join notes on customer.customer_name = notes.customer_name AND customer.customer_name = last_spoke_to.customer_name WHERE customer.customer_name = '" . $val . "'";

but that does not work, it returns an error, What i have got is attached in the picture, And i need it to produce the same output as the notes category.

Many thanks

AS you can see from the picture Notes repeats but last spoke to does not how would i get it to repeat like the notes? as i stated ive tried the above query but that did not work.


 
picture5.jpg
0
Comment
Question by:NeoAshura
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 6

Assisted Solution

by:brb6708
brb6708 earned 250 total points
ID: 35155553
so far i can see is "last_spoke_to" a field in one of the tables "customer" or "notes".

The way you use it is wrong because "last_spoke_to.customer_name" combines two field names which is not correct.

So to answer your question it is necessary to get information abot the tables and fiellds in the database description.
0
 
LVL 17

Accepted Solution

by:
Chris Harte earned 250 total points
ID: 35155563
You say last_spoke_to is a field rather than a table, so should the second query not be

$sql = "
SELECT *
FROM customer
    LEFT JOIN notes
        ON customer.customer_name = notes.customer_name
        AND customer.customer_name = notes.last_spoke_to
WHERE customer.customer_name = '" . $val . "'";
0
 
LVL 6

Author Comment

by:NeoAshura
ID: 35155582
thanks for the feedback now my tables returns nothing they are blank...

Both notes is a table and contains "notes" and "last_spoke_to"

where customer is another table and customer_name is a field in that table which also exsits in the notes table as a referance for the notes and last spoke to. does that make sense?
0
 
LVL 6

Expert Comment

by:brb6708
ID: 35155587
@MunterMan:

that was my idea as well; but does it make sense selecting all customers who have talked to themselves?????

That's why I said that knowledge about the tables and the fields within those tables is necessary to answer NeoAshura's question.
0
 
LVL 6

Author Comment

by:NeoAshura
ID: 35155711
ok guys ive solved it but i appricate your input so points will be awrded equally. Ive outputed what i needed using the following:

$sql = "
SELECT *
FROM customer
    LEFT JOIN notes
        ON customer.customer_name = notes.customer_name
WHERE customer.customer_name = '" . $val . "'";

It is a notes page based on each customer, These notes needed to be logged.. it now looks as follows which is what i needed.
picture6.jpg
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question