Get value between to hours from mysql using php

Question

I'm trying to get a specific show description from my DB but I really don't know how, I know i'm new into this, the table (guide) have 2 DATETIME values "start" and "end"

If I use this:

$sql = mysql_query("SELECT * FROM guide WHERE start  >= CURDATE()");

Only return the first value from the table, and inclusive its the wrong value, please I need some help to get this, because I don't find a solution from other on this web

You should be able to use between. select * from guide where now() between start and end. — chris85
– chris85, Commented Jan 13, 2016 at 2:49
I didn't understand what you want. It should be "value between two hours" — Vinícius Fagundes
– Vinícius Fagundes, Commented Jan 13, 2016 at 2:50
I'm trying to create some kind of TV Guide and I want to show the current show on air, but the shows have an "start hour" and a "end hour", and the only value that I have to get this is the current time like this: 2016-01-12 20:45:14 so my problem is how can I get the current show using that — ozonostudio
– ozonostudio, Commented Jan 13, 2016 at 2:57
@chris85 your solution works fine, now how I use a 3rd value for get the specific show? I mean the "channel" row, something like: where channel = $channel_ID — ozonostudio
– ozonostudio, Commented Jan 13, 2016 at 3:03

chris85 · Accepted Answer · 2016-01-13 03:08:48Z

1

You should be able to use mysql's between function to pull the records in the current time range.

select * from guide where now() between start and end

To limit the returns you can add in additional parameters, this may give you back no results though so have a default value.

select * from guide where channel = $channel_ID and now() between start and end

You also should look into parameterized queries and updating your driver. Having variables in your query isn't the best practice.

answered Jan 13, 2016 at 3:08

chris85

23.9k7 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ozonostudio Over a year ago

Thanks to your first solution I ended using: $sql = mysql_query("SELECT * FROM guide WHERE (NOW() BETWEEN start AND end) AND channel = 13"); And works, this is OK or may cause any issue?

chris85 Over a year ago

That query should be fine, depending on how your application runs it may display things strangely when no results are found/available though (or maybe that won't happen).

ozonostudio Over a year ago

Thanks for you quick and really nice solution

Collectives™ on Stack Overflow

Get value between to hours from mysql using php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related