ght
> -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 this information on the PHP side?
>
> mysql> SELECT SQL_
doc/refman/4.1/en/information-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
>
> I
06 9:53 AM
> To: 'php-db@lists.php.net'
> 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 co
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 2500
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
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] LIMI
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 don
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 c
en though 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] LI
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 i
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 * FR
-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 th
30, 2006 12:51 PM
To: Gavin Amm; php-db@lists.php.net
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 yo
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 SUBSTRING(FIELD1 FROM 1 FOR 30) FROM myTable
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
>
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]>:
> 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
>
ard [mailto:[EMAIL PROTECTED]
> Sent: Friday, 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 cha
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
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 recei
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]> wr
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:
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,
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 sp
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 PROTECTED]">news:
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 q
$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] "LIM
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
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
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 -
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 provid
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 catal
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
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
>
> Basically, i want to return the results for a search,
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 a
g a get_num_rows and then only using the first 20?
-Original Message-
From: Jonatan Bagge [mailto:[EMAIL PROTECTED]]
Sent: 14 January 2002 11:00
To: matt stewart
Subject: Re: [PHP-DB] LIMIT and get_num_rows
First do a SELECT count(*) from tablename;
This will get the number of entries.
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 comp
$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 com
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
Me
Hello.
Fredrik Wahlberg wrote:
>
> Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server?
You need to use server side cursors. You may want to look at how
Metabase, the PHP database abstraction package does it when using
MS-SQL. For Metabase users, it is as simple as calling th
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 <<<<<<<<<<<<<<<<&
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
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
>
>--
>PH
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 (M
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 exactl
45 matches
Mail list logo