? Either way, it might be worth checking
which is faster for your application.
Regards,
Dwight
-Original Message-
From: Dwight Altman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 9:53 AM
To: 'php-db@lists.php.net'
Subject: RE: [PHP-DB] LIMIT
So how do I get
-functions.html
http://www.mysqlfreaks.com/statements/101.php
Regards,
Dwight
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 9:46 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
If you're using MySQL then:
SELECT SQL_CALC_FOUND_ROWS
'
Subject: RE: [PHP-DB] LIMIT
So how do I get this information on the PHP side?
mysql SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
- WHERE id 100 LIMIT 10;
mysql SELECT FOUND_ROWS();
I count 2 queries above (unless there is some caching magic). Whatever.
I was hoping to add another
Bastien Koert wrote:
Your example predicates that the resultset it passed to an array which
you then take the size of, which would only give you the LIMIT value if
that clause is specified in the query...
I see, I misunderstood the OPs question then they wanted to know that
there are
On 7/1/06, Dwight Altman [EMAIL PROTECTED] wrote:
Thanks, but that's an additional query.
I was wondering if there may be a PHP function that can operate on the
$result or perhaps $link of the single query that uses a LIMIT clause and
have the information [count(*) had there not been a LIMIT
chris smith wrote:
On 7/1/06, Dwight Altman [EMAIL PROTECTED] wrote:
Thanks, but that's an additional query.
I was wondering if there may be a PHP function that can operate on the
$result or perhaps $link of the single query that uses a LIMIT clause and
I'm not sure how this would be done
I am not sure that any dbs will do thati usually run two queries (one
for the limit data and one for the total rows)
Bastien
From: chris smith [EMAIL PROTECTED]
To: Dwight Altman [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
Date: Sat, 1 Jul 2006 18:51:11 +1000
Your example predicates that the resultset it passed to an array which you
then take the size of, which would only give you the LIMIT value if that
clause is specified in the query...
Bastien
From: JupiterHost.Net [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
Date
If you're using MySQL then:
SELECT SQL_CALC_FOUND_ROWS * FROM aTable LIMIT 5
SELECT FOUND_ROWS()
It's in the mysql documentation under SELECT syntax I believe.
Chris
Dwight Altman wrote:
Is there a way to get the number of rows that would have been returned had
there not been a LIMIT clause
there was a LIMIT clause]. Something
like mysql_info.
Regards,
Dwight
x2407
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 5:46 PM
To: Dwight Altman
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
What about 'select count(*) from
What about 'select count(*) from aTable'
- Frank
Is there a way to get the number of rows that would have been returned
had
there not been a LIMIT clause in a SELECT statement?
For example, if
Query #1) SELECT * FROM aTable
would normally return 100 rows. But
Query #2) SELECT * FROM
Subject: Re: [PHP-DB] Limit chars from select
Gavin Amm wrote:
How do I limit the characters a Select statement returns?
In Seudo code:
SELECT * FROM myTable LIMITCHARS 30;
I'm using MySQL.
Thanks.
Do you want to limit the characters from an individual field? If so,
then
SELECT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gavin Amm wrote:
I'd like to avoid having to manually add all of the cols to the select
statement if possible, so if there's a universal command I can put in
that'd be best.
In that case, what I would do is just do your SELECT statement, sans the
If it is a unix timestamp, why not just select rows where the date is = 7776000
(which is 90 days) or if you want to be specific about the months, use mktime()
to generate the timestamp for the date 3 months ago.
--
Adam Alkins
http://www.rasadam.com
Quoting Marie Osypian [EMAIL PROTECTED]:
From: Marie Osypian [EMAIL PROTECTED]
I don't want to use the limit on this query anymore. What I want is to
display all that are dated within the last 3 months. What would be the
easy
way to do that?
SELECT federal_development_id, UNIX_TIMESTAMP(date) AS date, topic, body
Try:
$sql = SELECT LEFT(columnName,255) FROM tableName;
Using that syntax should return the first 255 characters from the selected
column, reading LEFT to right. I tested it in the command line and it worked
just fine.
Hope that helps.
Rich
-Original Message-
From: Marie Osypian
, June 20, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Limit return Size
Try:
$sql = SELECT LEFT(columnName,255) FROM tableName;
Using that syntax should return the first 255 characters from
the selected
column, reading LEFT to right. I tested it in the command
line
I would like to know how I limit my answer from a mysql database query to
display only a limited size? Is this done in the query or the php?
i.e. Our Performance Results area includes First Quarter 2003 investment
returns for virtually every 529 savings programs. See how your 529 plan
Also, since Sybase ASE uses a lot of the same T-SQL constructs, you can
attempt some methods located here:
http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12
--
Matt
Noam Giladi [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
a solution offered i received
$start = 10;
$numbers_to_show = 25;
$sql = SELECT * FROM bla Limit $start, $numbers_to_show;
or just go to mysql.com and use the manual :)
-Original Message-
From: Noam Giladi [mailto:[EMAIL PROTECTED]]
Sent: woensdag 19 februari 2003 16:00
To: [EMAIL PROTECTED]
Subject: [PHP-DB] LIMIT
The title suggests MSSQL, which if I am correct doesn't support Limit
like MySQL.
I'm working on the same thing right now so I don't have a quick and
dirty working example, although it doesn't look to be too difficult to
use server side cursors in MSSQL.
Here is a related a link to a similar
i assume this problem was solved in the past
i didn't found a ready solution.
i try to use FATCH .
and i have another link with ths same problem..
http://forums.devshed.com/showthread.php?threadid=33114
tnx noam
John Krewson [EMAIL PROTECTED] wrote in message
[EMAIL
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id $lastid
And just have lastid posting to the page every time
they hit next, and in lastid, put the last id of the results
on that page.
On Wed, 2003-02-19 at 09:59, Noam Giladi wrote:
I'm trying to
i'm not using a fixed sort
tnx noam
Adam Voigt [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id $lastid
And just have lastid posting to the page every time
they hit next, and
Well if you do, (sort by id) this will work.
On Wed, 2003-02-19 at 11:14, Noam Giladi wrote:
i'm not using a fixed sort
tnx noam
Adam Voigt [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Assuming your sorting by id, just do:
a solution offered i received from raydan
Untested:
Untested:
declare @num int
set @num = 20
EXEC ('select top 10 from myTable
where ID not in (select top ' + @num + ' from myTable order by ID)
order by ID')
But beware the dangers of dynamic SQL.
Mark Snijders [EMAIL PROTECTED] wrote
LIMIT limits only to output.
So if a SELECT creates 1 million rows and you LIMIT 10, you got the first 10 rows but
the full SELECT is done.
To speedup consider adding some id columnt with unique ints in ascending order.
Andrey
P.S.
I've to go. Have a nice evening.
- Original Message
Another suggestion - use explicit joins.
SELECT c.*, p.province, co.country
FROM test.cities AS c LEFT JOIN test.countries AS co USING(country_c)
LEFT JOIN test.provinces AS p ON c.province_no=p.province_id
ORDER BY country , province
limit 0, 10;
This might work. If not read the docs at
thanx, I am gonna play with it
Andy
Andrey Hristov [EMAIL PROTECTED] schrieb im Newsbeitrag
004301c1d8ca$276af940$0b01a8c0@ANDreY">news:004301c1d8ca$276af940$0b01a8c0@ANDreY...
Another suggestion - use explicit joins.
SELECT c.*, p.province, co.country
FROM test.cities AS c LEFT JOIN
Looks like LIMIT can only contain one number, when using UPATE the offset
parameter cannot be added.
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
So . . .
UPDATE
Quoting from the MySQL manual:
In MySQL Version 3.23, you can use LIMIT # to ensure that only a given
number of rows are changed.
So then, it's LIMIT # instead of LIMIT #,#
Obviously, the way around it would be using WHERE instead of LIMIT, but
I don't know your table structure so I can't
On Monday 14 January 2002 19:06, matt stewart wrote:
but presumably if i'm doing a SELECT count(*) FROM Designs WHERE Keywords
LIKE %sport%
followed by a SELECT * FROM Designs WHERE Keywords LIKE %sport% LIMIT
0,20
it's still using nearly as much processing time as just returning all the
On Monday 14 January 2002 19:21, Markus Lervik wrote:
Damnit.
Forgot to cc to the list, again. Here it is.
-- Forwarded Message --
On Monday 14 January 2002 12:55, you wrote:
hi guys, just looking for verification on this, as i don't think there's
any way to do it
$fulldate = date(dmy);
echo $fulldate;
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 23:34
To: PHP-DB
Subject: [PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this
0109011754
but I only want to
left(timestamp,6)
- Original Message -
From: Jeff Oien [EMAIL PROTECTED]
To: PHP-DB [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 11:33 PM
Subject: [PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this
0109011754
but I only want to compare
I think so, but check the SS lang manual. It should be under the syntax for
SELECT, maybe it's called "TOP". Haven't worked with SS for a while.
MIles
At 02:24 PM 3/12/01 +, Fredrik Wahlberg wrote:
Is there any equivalent to MySQL's "LIMIT x,y" in Microsoft SQL-Server?
/Fredrik
--
PHP
Yep there is- its called TOP
Example:
SELECT TOP 2 *
FROM Table
Fredrik Wahlberg wrote:
Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server?
/Fredrik
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
But with TOP I can't start on any row I want? I would like to be able to
select rows 40 through 60 or something similar.
/F
Ursprungligt meddelande
Trey Sheldon [EMAIL PROTECTED] skrev 2001-03-12, kl. 15:35:38 angende
mnet Re: [PHP-DB] LIMIT in MS SQL:
Yep there is- its called TOP
Hello,
Luigi Barone wrote:
I have the same problen of Fredrik
Is there any equivalent to MySQL's ?LIMIT x,y? in Informix Dynamic Server
2000?
As you may have noticed, I have just replied a similar message but about
MS-SQL. The same Metabase base solution can work for Informix because
On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote:
Are you useing persistent connections (I had no real luck with them)?
How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated
Server ?
I am just using phplib for the dirty stuff :) So I don't know exactly
MaxClients inyour httpd.conf is a nice way to limit it. :)
Karsten Dambekalns wrote:
On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote:
Are you useing persistent connections (I had no real luck with them)?
How do you connect to your DB over Multi Threaded Server (MTS) or
41 matches
Mail list logo