you can use PEAR DB::Pager
http://pear.php.net/package/DB_Pager
Fedde Van Feggelen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
str_replace(' ','%',$searchwords);
$query=select * from table where colom like '%$searchwords%' order by
id
desc ;
$result=mysql_query($query);
John Dillon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
...WHERE TO_DAYS(NOW())+1TO_DAYS(MyTable.MyField) ORDER BY
MyTable.MyField DESC LIMIT 30;
however, the LIMIT seems to apply before the ORDER BY clause. How can I
get the LIMIT to apply after
the ORDER BY?
On further
Hello John,
Tuesday, January 6, 2004, 5:20:22 PM, you wrote:
J On further reading, it appears LIMIT stops the query running once x number
J of records are retrieved without sorting the whole table first.
Where did you read this?
If you profile your query you'll notice that in say a 10,000
Richard Davey [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello John,
Tuesday, January 6, 2004, 5:20:22 PM, you wrote:
J On further reading, it appears LIMIT stops the query running once x
number
J of records are retrieved without sorting the whole table first.
Where did you
I can't run mysqli.
Please help me how can I install mysqli.
According to the Manual I copy C:\mysql\bin\libmySQL.dll (916Kb) to
c:\windows and to c:\windows\system32.
(I've also tried to copy dll from C:\php\dlls\libmySQL.dll (228Kb))
when I run a simple script (WinXP, IIS):
?
$link=
Hi folks!
I use a registry in my webapp which holds an instance of my sql-class.
within my application i _only_ use this instance to do queries.
first of all i lock all my tables with
LOCK TABLES tableName WRITE;
Later in the progrmm i try to do a SELECT `menue` as `first` ... but i
get:
Table
Hi,
Iam new in this , can you tell me how to make the pager.php works? I can't
use it...
Best Regards,
Hadi Tjen
Bossek [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
you can use PEAR DB::Pager
http://pear.php.net/package/DB_Pager
Fedde Van Feggelen [EMAIL PROTECTED] wrote in
Hi all,
Right now i would like to INSERT the values from a dynamic drop down
menu into mysql database but encountered some problem here. Values in the drop
down menu are retrieved from DB as follows:
SNIP
SELECT NAME=tutor_name CLASS=textarea
?
$sql = mysql_query(SELECT DISTINCT