Can you use a php variable to filter a recordset?

Question

I've got a table of 'events', which have a description and
more importantly for this a month ID number. (1-12 for the months
of the year, when the event takes place) .

I've used php's date function on a page to fund out
numerically what month it is now $thismonth = date("n");

i want to filter my recordset by only bringing up events that
take place during the current month so where event_month =
$thismonth

IS this possible? It seems like it should be easy to do but I
can't get it to work.

Thanks in advance

Dave

Newsgroup_User · Accepted Answer

jnkjnkjnkjnkjn wrote:> i want to filter my recordset by only bringing up eventsthat take place > during the current month so where event_month =$thismonth> > IS this possible? It seems like it should be easy to dobut I can't get it to > work. Yes, it's very easy, but you need to do a little hand-coding.In the Advanced recordset dialog box set the end of the SQL query toWHERE event_month = 1. When you have saved the recordset, changethe SQL to WHERE event_month = $thismonth.-- David Powers, Adobe Community ExpertAuthor, "Foundation PHP for Dreamweaver 8" (friends of ED)Author, "PHP Solutions" (friends of ED)http://foundationphp.com/

jnkjnkjnkjnkjn · Answer

brilliant, thanks

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded