How can i do this?

[calle08]

SELECT name, date, comment

FROM narvaro_all

WHERE datum ='2011-07-14' AND datum='2011-07-20'

 

 

Just getting empty result have data in both dats

[trq]

Read your query. How can datum equal two different values at the same time?

[calle08]

Wrong of me

 

SELECT name, date, comment

FROM narvaro_all

WHERE date='2011-07-14' AND date='2011-07-20'

 

But still get empty results. Don't understand?

 

[trq]

Now, how can date be two different values at the same time?

[calle08]

Ok so how can i fix it? Use JOIN? I want the comments from 2011-07-20 to join after the comments from 2011-07-14 just don,t know what i can use?

 

SELECT name, date, comment

FROM narvaro_all

WHERE date='2011-07-14'

[gristoi]

your query can't be TWO dates at the same time. use between:

<?php
SELECT name, date, comment
FROM narvaro_all
WHERE date BETWEEN '2011-07-14' AND '2011-07-20'
?>

[calle08]

Thats the problem i always get the result as the first example in picture ex1. Thats wrong i want it to look like ex2. It is a script that tell if you can come or not. To print it on a web page i need it to look like ex2 is it possible?

 

[attachment deleted by admin]

[PFMaBiSmAd]

You would use OR in order to get both matching rows -

 

WHERE date ='2011-07-14' OR date='2011-07-20'

 

You want to match rows where date is '2011-07-14' or where date is '2011-07-20'

 

You can also use IN() -

 

WHERE date  IN('2011-07-14','2011-07-20')

[calle08]

That give same result as in ex1 in my picture = wrong. I must get it to look like ex2. I think its harder need somting like join or so?

[PFMaBiSmAd]

Perhaps if you describe exactly what you are trying to accomplish, someone can help? The query you posted to get help with and the image you posted don't suggest at all what you are trying to do, having something or nothing to do with matching dates in the data. Without a clearly defined statement of what you are trying to accomplish, it's difficult for you to accomplish anything and impossible for us to help.

[calle08]

I need the result to list one row/name there is one field for every date in the database for user test1 there is two fields but i want to make it to one field and have both dates and comments in that one field. Get it to look like this

 

test1 test1 2011-07-14 yes 2011-07-20 No

test2 test2 2011-07-14 yes 2011-07-20 No

 

I think i need it to be like thig for using while($kolumn = mysql_fetch_array($result)){ to make tables that works. It is hard for me to explain to

 

 

SELECT name, date, commentFROM narvaro_allWHERE date BETWEEN '2011-07-14' AND '2011-07-20'

 

If i use that question i get two fields/name i need one.

[fenway]

Then self-join.

[calle08]

How to get started? I have been thinking that self-join can work. Looking at the manul but dont get it. How to get the date and comments from 2011-07-20 to join on 2011-17-14? Somone good at join can help?

[calle08]

Ok this olmost did it. Look at pic. How do i remove the Duplicates? The highlighted lins is the ones i want.

 

[attachment deleted by admin]

[fenway]

Well, you're missing an ON clause.

[calle08]

can someone help me with that?

[fenway]

Sure -- just tell me what's unique about each set you want to combine.

[calle08]

In the pic the i want only the two highlighted lins...

[fenway]

How do you know that?