MySQL Forums
Forum List  »  PHP

problem in selest asterisk mysql table's fields
Posted by: Mohammad Nemati Habili
Date: May 12, 2013 08:37AM

hi to all
dear friends
i wana have a show from some fields of asterisk mysql database (asteriskcdrdb(cdr table)) in a certain date for example from 2013-4-1 till 2013-5-1
as you know asterisk records all calls information in this table like : calldate,src,dst,duration and ...
i wana show all calls of one extension like 3004 in a certain date
i want all records that 3004 is in src field and 3004 is in dst field(all dialed and recieved calls)
i use below query:

select calldate, src, dst from cdr where calldate between 2013-4-1 and 2013-5-1 and src = '3004' or dst='3004';

the problem is in the result
results do not belong to that date, acctually it shows all calls that 3004 dialed and recieved from the first day that extension creats till today,
its imporatant for me to show results in a specific date
please help me
and if my query has any problem please correct it
plzzzzzzzzzzz

Options: ReplyQuote


Subject
Written By
Posted
problem in selest asterisk mysql table's fields
May 12, 2013 08:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.