<div>
When I do it that way, I get this error:<br />
Fatal error: Call to undefined method CI_DB_mysql_driver::orderb<wbr />y()<br />

<pre><code id="code-20-40705800-1">&lt;?php
		$order_query = $this-&gt;EE-&gt;db-&gt;select('*')
					-&gt;where('member_id', $member)
					-&gt;where('status', 'open')
					-&gt;orderby('order_id', 'desc')
					-&gt;get('exp_cartthrob_subscriptions');</code></pre>
</div>


When I do it that way, I get this error:
Fatal error: Call to undefined method CI_DB_mysql_driver::orderby()


<?php
		$order_query = $this->EE->db->select('*')
					->where('member_id', $member)
					->where('status', 'open')
					->orderby('order_id', 'desc')
					->get('exp_cartthrob_subscriptions');

<div>
'ORDER BY' is standard SQL. &nbsp;I have no idea what 'CI_DB_mysql_driver' is. &nbsp;But if it doesn't support 'ORDER BY' then it is wrong. &nbsp;Simply wrong. &nbsp;Do some research, that can't be right. &nbsp;Maybe there is a different way of doing it.
</div>


'ORDER BY' is standard SQL.  I have no idea what 'CI_DB_mysql_driver' is.  But if it doesn't support 'ORDER BY' then it is wrong.  Simply wrong.  Do some research, that can't be right.  Maybe there is a different way of doing it.

<div>
Once you mention order by, I needed to look it up and it is -&gt;order_by
</div>


Once you mention order by, I needed to look it up and it is ->order_by

<div>
<div class="content wysiwyg-content">
How would you write a query if you were trying to find the last entry / the latest entry?<br />
<br />

<pre><code id="code-10-28649797-1">$order_query = $this-&gt;EE-&gt;db-&gt;select('*')
					-&gt;where('member_id', $member)
					-&gt;where('status', 'open')
                                     [b]   -&gt;where('id', 'WHERE ID IS THE HIGHEST NUMBER')[/b]
					-&gt;get('exp_cartthrob_subscriptions');</code></pre>
</div>
</div>


How would you write a query if you were trying to find the last entry / the latest entry?

(CODE)

PHP latest 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.