<div>
Try like this:<br />

<pre><code id="code-183767">$itemsbydate = mysql_query(&quot;SELECT id,group_number,group_name,date_received,disposition,DATE_FORMAT(date_received,'%Y%m%d') as recdate from inquiries where userid='$userid' and date(recdate) = $searchval&quot;);</code></pre>
</div>


Try like this:


$itemsbydate = mysql_query("SELECT id,group_number,group_name,date_received,disposition,DATE_FORMAT(date_received,'%Y%m%d') as recdate from inquiries where userid='$userid' and date(recdate) = $searchval");

<div>
Thanks! &nbsp;Both of your solutions combined helped me.
</div>


Thanks!  Both of your solutions combined helped me.

<div>
<div class="content wysiwyg-content">
I'm trying to use the following code to select data by a date range and display it. &nbsp;I can display it fine, but I can't seem to get the mySQL query right...<br />
<br />
$url[3]; is an exploded query_string. &nbsp;The value is 11/01/08<br />
<br />
$searchval = $url[3];<br />
&nbsp; &nbsp; &nbsp; &nbsp; $itemsbydate = mysql_query(&quot;SELECT id,group_number,group_name<wbr />,date_rece<wbr />ived,dispo<wbr />sition,DAT<wbr />E_FORMAT(d<wbr />ate_receiv<wbr />ed,'%Y%m%d<wbr />') as recdate from inquiries where userid='$userid' and recdate=$searchval&quot;);<br />
&nbsp; &nbsp; &nbsp; &nbsp; while($disprow = mysql_fetch_array($itemsby<wbr />date, MYSQL_ASSOC))<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<br />

</div>
</div>


I'm trying to use the following code to select data by a date range and display it.  I can display it fine, but I can't seem to get the mySQL query right...

$url[3]; is an exploded query_string.  The value is 11/01/08

$searchval = $url[3];
        $itemsbydate = mysql_query("SELECT id,group_number,group_name,date_received,disposition,DATE_FORMAT(date_received,'%Y%m%d') as recdate from inquiries where userid='$userid' and recdate=$searchval");
        while($disprow = mysql_fetch_array($itemsbydate, MYSQL_ASSOC))
	{


PHP mySQL Select query by date

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.