|
|
Posted by bill on 10/14/07 17:16
C. (http://symcbean.blogspot.com/) wrote:
> On 14 Oct, 12:07, bill <nob...@spamcop.net> wrote:
>> Rik Wasmus wrote:
>>> On Sun, 14 Oct 2007 12:36:13 +0200, bill <nob...@spamcop.net> wrote:
>>>> (Don't froth at the mouth Jerry, this IS a PHP question - sort of <g>)
>>>> I have a SQL column with date format. In my PHP script I need to do
>>>> simple math on it, eg how many days past the date in the SQL record
>>>> are we now.
>>> Well, it could be solved quite easily in MySQL....
>>> SELECT
>>> something,
>>> datecolumn,
>>> DATEDIFF(datecolumn,CURDATE())
>>> FROM table
>>>> Do I need to convert it to a timestamp in order to do the math, or is
>>>> there an easier way ?
>>> Otherwise it's just a string, because PHP has no 'date' type. So either
>>> split it into components or indeed convert it to a timestamp (which
>>> would be easiest).
>> now back to PHP...
>> If I do the select as you noted above, after I have gotten the
>> row, what is the index..
>> e.g: $row['?????']
>>
>> bill
>> (The SQL docs are of no use on this)
>
> They're numbered from the left, but its much, MUCH more sensible to
> always use associative arrays (use var_dump to see what it currently
> shows).
>
> For a proper solution use aliases in the query:
>
> SELECT
> something,
> datecolumn,
> DATEDIFF(datecolumn,CURDATE()) AS days_diff
> FROM table
>
>
> C.
>
better,
Thanks
bill
Navigation:
[Reply to this message]
|