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

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

Help please - How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

How to get all server headers like Live http Headers does
Hey all, like many of you I use the Firefox addon "Live http Headers". I'm trying to write

How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and

Ten Operator Syntax
Hi Guys,

I can't figure out why i am getting a parse error with this basic ten op code:

Cache PHP Objects/Classes?
Does anyone have ideas about caching PHP objects using something like: http://memcached.org/