sprintf and date_format escape asking for advice ......

whisher06

Hi.
I've got this snippet:

public function selectByDate($flatdate){ 
        $query= sprintf("SELECT c.category_title, p.category_ID,p.post_ID, p.post_title, p.post_preamble, p.post_content, p.post_date,u.user_name 
        FROM posts AS p INNER JOIN categories AS c INNER JOIN users AS u 
        ON p.category_ID = c.category_ID 
        ON p.user_ID = u.user_ID WHERE  date_format(p.post_date, '%%Y%%m')='%d';",$this->db->escape($flatdate)); 
echo $query; 
        $this->result=$this->db->query($query); 
    }
$obj->selectByDate("200705");

Is it the right way ?

Is there a different way ?

Thanks in advance. :o

laserlight

What are you trying to do? I have an idea from your code snippet, yes, but you need to state it clearly before one can say if it is "the right way" and if there is "a different way".

whisher06

Sorry 😉

I've got a form like this:

<form action="/admin/edit.php" method="post" name="frm_show_by_date" id="frm_show_by_date">
<fieldset id="fld_show_by_date">
<legend class="generic-legend">Browse Month&hellip;</legend>
<select name="show-by-date" size="1" id="show-by-date">

<option value="200706">June2007</option>
<option value="200705">May2007</option>
<option value="200704">April2007</option>
<option value="200703">March2007</option>
</select>
<input name="show-date" type="submit" value="Show Month" id="show-date"  />
</fieldset>
</form>

With the query I want to retrieve all the posts
posted in that month .

The thing that I'd like to know if about this line:

date_format(p.post_date, '%%Y%%m')='%d'

for the character escape '%%Y%%m'

I hope to have got my idea across clearly 😉