Solved

PHP Query, OUTPUT

Posted on 2011-03-17
5
248 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
  • 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 16

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
This article discusses four methods for overlaying images in a container on a web page
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now