Hi, New here and would like to see if anyone can help with a query I am trying to make.
The field is persona.persona_submitted, the value is a UNIX date. I would like to only select 'dates' from the last 7 days from the 'current' date (depending on 'when' the query is run on/page loaded. But have no clue as to how to phrase that. I have the first part up to the date thing but need help from there.... any help would be greatly appreciated.
SELECT * FROM member, persona WHERE member.member_id = persona.persona_user_id AND persona.persona_submitted
I know I need to do a function thing too and have been staring at the php online manual for the last few days to try to figure it out.. it's greek to this newb.