How can i get the date from my database and put it on query

Question

this is my database

the name of the table is sms_in

I would like to get sms_text using send_dt so i tried dis query

$query = mysql_query("SELECT  `sms_text` FROM `sms_in` WHERE 'sms_dt' = 2015-01-13");

but it doesn't show any result can anyone help me I'm new in query.

I'm trying to get the data for my website

sorry for the typo it's 'sent_dt' in my query not 'sms_dt'

`sms_dt` = 2015-01-13 \\ mysql_* is deprecated please use mysqli_* — Arun, Jan 13 '15 at 05:55
i've answered ur question.. check it.. look what @Arun commented about mysqli — habib ul haq, Jan 13 '15 at 06:02

score 0 · Answer 1 · answered Jan 13 '15 at 05:54

0

first of all use mysqli instead mysql version. and if type of sms_dt is text then u should use single quotes''

$query = mysql_query("SELECT  sms_text FROM sms_in WHERE 'sms_dt' = '2015-01-13'");

answered Jan 13 '15 at 05:54

habib ul haq

824
6
13

is it ok if i use that even the date is datestamp?? how can i say this the date comes from sms messages date with the format YYYY-MM-DD, is it a text or object?? – Ram Aquino Jan 13 '15 at 06:01
Remove single quote on `sms_dt` and put backticks for that – Sadikhasan Jan 13 '15 at 06:04

score 0 · Answer 2 · edited May 23 '17 at 12:03

0

Use quote of your column value don't column

$query = mysql_query("SELECT  `sms_text` FROM `sms_in` WHERE `sent_dt` = '2015-01-13'");

This question may help you

edited May 23 '17 at 12:03

Community

1
1

answered Jan 13 '15 at 05:58

Imran

3,031
4
25
41

None i'm just troubleshooting it in mysql query database and it says 0 rows selected – Ram Aquino Jan 13 '15 at 06:10

score 0 · Answer 3 · answered Jan 13 '15 at 06:01

0

Hello brother use single quotes for the date

$query = mysql_query("SELECT  `sms_text` FROM `sms_in` WHERE 'sms_dt' = '2015-01-13'");

answered Jan 13 '15 at 06:01

Vamshi .goli

522
4
13

score 0 · Accepted Answer · answered Jan 13 '15 at 06:04

0

Try this

Add single('') quote to date value not in date field:

$query = mysql_query("SELECT  `sms_text` FROM `sms_in` WHERE sms_dt = '2015-01-13'");

And also while seeing your table structure I found that there is no field with 'sms_dt' name , there is one date filed whose name is 'sent_dt' So please try with that field like:

$query = mysql_query("SELECT  `sms_text` FROM `sms_in` WHERE  sent_dt = '2015-01-13'");

I hope it will works work you !

answered Jan 13 '15 at 06:04

Deepak Goswami

2,030
1
16
22

@Ram I am glad I could help you! thanks for accepting my answer. please vote it up also it will increase my ranking little more thanks again. – Deepak Goswami Jan 15 '15 at 12:33

score -1 · Answer 5 · edited Jan 13 '15 at 06:14

-1

try to enclose your search criteria in single quotation: if your column is date type column sent_dt then your query should like

$query = mysql_query("SELECT sms_text FROM sms_in WHERE sent_dt = '2015-01-13' ");

edited Jan 13 '15 at 06:14

Imran

3,031
4
25
41

answered Jan 13 '15 at 05:54

M Reza Saberi

7,134
9
47
76

How can i get the date from my database and put it on query

5 Answers5