<div>
Too late cause of network issues. It dropped just when I want to send my answer.<br />
<br />
Pyxos
</div>


Too late cause of network issues. It dropped just when I want to send my answer.

Pyxos

<div>
Hello,<br />
<br />
Thx xBite!!!<br />
<br />
Kind Regards.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
In ASP when I do a select statement I could specify the number of rows I want, e.g. &quot;Select Top 5 from aTable&quot;. Then I executed the query.<br />
<br />
But in MySql this statement is not valid (TOP 5). The statement below (in PHP):<br />
<br />
$result = mysql_query (&quot;SELECT Top 5 FROM $table&quot;) or die (&quot;Invalid query&quot;);<br />
<br />
generates the error message &quot;invalid query&quot;.<br />
<br />
My Question:<br />
How can I select some rows only (say 5) instead of the whole recordset???<br />
<br />
Thanks,<br />
nad<br />
<br />

</div>
</div>


Hello,

In ASP when I do a select statement I could specify the number of rows I want, e.g. "Select Top 5 from aTable". Then I executed the query.

But in MySql this statement is not valid (TOP 5). The statement below (in PHP):

$result = mysql_query ("SELECT Top 5 FROM $table") or die ("Invalid query");

generates the error message "invalid query".

My Question:
How can I select some rows only (say 5) instead of the whole recordset???

Thanks,
nad



MySql Select Statement in PHP

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.