Having trouble selecting rows with specific date information
Posted: Tue Feb 22, 2005 5:46 pm
I'm sort of new at this, so please bear with me here.
I'm trying to construct a mySQL query that selects a few bits of information from some specific rows in a table (heh, is that generic enough for ya?). The query looks like this right now:
Also in those rows is a column with date information in the yyyy-mm-dd format. I want to add to my where part of the query to get it to only select rows where the date falls within the current month of the year. How on Earth do I do this?
I'm trying to construct a mySQL query that selects a few bits of information from some specific rows in a table (heh, is that generic enough for ya?). The query looks like this right now:
Code: Select all
$query_certs_per_rep = "select sum(price) from certs where rep_id=$current_rep_id";
$result_certs_per_rep = mysql_query($query_certs_per_rep)
or exit(mysql_error());