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

Did you know?Explore Trending and Topic pages for more stories like this.
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)
No comments posted yet

Your Answer:

Login to answer
223 Like 46 Dislike
Previous forums Next forums
Other forums

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Problem with Subscreen
Dear Experts ,
I am facing a problem with the subscreens. My senario is as follows :

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

want to add a break after a certain amount of characters
i was wondering how to add a break in a blog post after a certain amount of characters... any idea o

Curl & sessions PLS HELP
Hello,

I have a problem with curl and sessions and i will try to explain the best i could.

Date Format
Hi there,

I have a date format like this right now:
Sat, 17 Oct 2009 17:04:00

I ne

mysql VARCHAR acting like INT
Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Baffled by Undefined Index in Simple Array: Please Help!
Hello. I have a form which posts an array to this script. However, I can't seem to access the values

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash