[Northern Star]

OK, I need some help with this one. I hate admitting defeat but I'm getting frustrated!

I've got a table called 'Events' with these fields...

eID
eName
eStartDate
eEndDate

An example entry would be...

1
'Course Open Day'
12-Nov-2006
14-Nov-2006

What I want to be able to do is search the table and select any records where a given date falls between the the startDate and endDate.

So, if I searched with '13-Nov-2006' i'd get 'Course Open Day'.

Hope I've made myself clear!

Thanks, Andy.

[Ben]

<?php

$query = "SELECT eID, eName, eStartDate, eEndDate FROM events";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
echo "Name :{$row['eName']} <p />" .
"Start Date : {$row['eStartDate']} <p />" .
"End Date : {$row['eEndDate']} <p />";
}

?>

[Northern Star]

That will just return all the records in the table?

[Ben]

Ah Gotcha!

Sorry

Ermmmm, gotcha, ok, does this link help at all?

http://www.help.thinkhost.com/web-developm...-forms_359.html

Ben

[Northern Star]

Not really , but thanks for the link - looks like a good reference page!

I might have to give in and do it another way