<div>
It is not clear from your post what you are looking for.<br />
<br />
What does your data look like and your table definition.
</div>


It is not clear from your post what you are looking for.

What does your data look like and your table definition.

<div>
you want 1 column per date, right?<br />
while &quot;easy&quot; in php, not simple in mysql at all.<br />
please clarify
</div>


you want 1 column per date, right?
while "easy" in php, not simple in mysql at all.
please clarify

<div>
Have you tried pivot sql query .Your answer lies in sql query.<br />
<a href="http://stackoverflow.com/questions/4546433/pivot-sql-query-show-date-in-column" rel="ugc">http://stackoverflow.com/questions/4546433/pivot-sql-query-show-date-in-column</a>
</div>


Have you tried pivot sql query .Your answer lies in sql query.
http://stackoverflow.com/questions/4546433/pivot-sql-query-show-date-in-column [http://stackoverflow.com/questions/4546433/pivot-sql-query-show-date-in-column]

<div>
Thanks for the points and thanks for using EE, ~Ray
</div>


Thanks for the points and thanks for using EE, ~Ray

<div>
<div class="content wysiwyg-content">
I have select statement <br />
<br />
<br />

<pre><code id="code-10-28020455-1">select * from cdr where src ='103' and date BETWEEN $date1 and $date2  </code></pre>
<br />
I need to get for each day between $date1 and $date2 show the amounts<br />
<br />
&nbsp;$date1 is 03/02/2013 &nbsp;and $date2 = 05/02/2013 &nbsp; it would show results by each day <br />
<br />
03/02/2013 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04/02/2013 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/02/2013<br />
id 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;id 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;id 30<br />
client 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Client 21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Client 60
</div>
</div>


I have select statement 


(CODE)

I need to get for each day between $date1 and $date2 show the amounts

 $date1 is 03/02/2013  and $date2 = 05/02/2013   it would show results by each day 

03/02/2013          04/02/2013          05/02/2013
id 10                      id 20                    id 30
client 20                Client 21              Client 60

php for each

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.