MySQL noob question

Posted on 16th Feb 2014 07:03 pm by admin

hi guys

I have a simple mysql table set up, along the lines of

Col 1 - Col 2 - Date_last_updated
--------------------------------
Som - Some - 06/11/2009 23:23:23
Bob - Bob - 06/11/2009 23:30:30


and so on...

I am trying to put an mysql statement together that reads along the lines of

SELECT * FROM table WHERE (date_last_updated > 01/01/01 23:23:23) AND (date_last_updated < 02/01/01 00:00:00)


how do I go about doing this?

thanks

(hope I was clear and concise)

Your Answer:

Login to answer

Other forums

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

Change Sort Order to Display Newest File First
Hi Guys,

I have a page that sorts the contents (PDFs) of a directory and displays them on the

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l