RE: [PHP-DB] LIMIT

2006-07-05 Thread Dwight Altman
? 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

RE: [PHP-DB] LIMIT

2006-07-05 Thread Dwight Altman
-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

RE: [PHP-DB] LIMIT

2006-07-05 Thread tg-php
' 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

Re: [PHP-DB] LIMIT

2006-07-03 Thread JupiterHost.Net
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

Re: [PHP-DB] LIMIT

2006-07-01 Thread chris smith
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

Re: [PHP-DB] LIMIT

2006-07-01 Thread JupiterHost.Net
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

Re: [PHP-DB] LIMIT

2006-07-01 Thread Bastien Koert
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

Re: [PHP-DB] LIMIT

2006-07-01 Thread Bastien Koert
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

Re: [PHP-DB] LIMIT

2006-06-30 Thread Chris
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

RE: [PHP-DB] LIMIT

2006-06-30 Thread Dwight Altman
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

Re: [PHP-DB] LIMIT

2006-06-29 Thread Frank M. Kromann
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

RE: [PHP-DB] Limit chars from select

2006-01-29 Thread Gavin Amm
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

Re: [PHP-DB] Limit chars from select

2006-01-29 Thread John Meyer
-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

Re: [PHP-DB] Limit

2003-08-04 Thread Adam Alkins
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]:

Re: [PHP-DB] Limit

2003-08-04 Thread CPT John W. Holmes
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

RE: [PHP-DB] Limit return Size

2003-06-20 Thread Hutchins, Richard
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

RE: [PHP-DB] Limit return Size

2003-06-20 Thread Gary . Every
, 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

Re: [PHP-DB] Limit return Size

2003-06-20 Thread CPT John W. Holmes
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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-20 Thread Matt Rogish
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

RE: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Snijders, Mark
$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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread John Krewson
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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Noam Giladi
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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Adam Voigt
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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Noam Giladi
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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Adam Voigt
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:

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Noam Giladi
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

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
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

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
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

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andy
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

RE: [PHP-DB] limit sytax error

2002-01-21 Thread Robert V. Zwink
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

Re: [PHP-DB] limit sytax error

2002-01-21 Thread Bogdan Stancescu
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

RE: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread matt stewart
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... The rest should be simple

Re: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread Jason Wong
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

Re: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread Markus Lervik
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, but

Re: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread Jason Wong
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

RE: [PHP-DB] Limit Select Field Characters?

2001-08-01 Thread Dave Watkinson
$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

Re: [PHP-DB] Limit Select Field Characters?

2001-08-01 Thread Tom Carter
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

Re: [PHP-DB] LIMIT in MS SQL

2001-03-12 Thread Miles Thompson
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

Re: [PHP-DB] LIMIT in MS SQL

2001-03-12 Thread Trey Sheldon
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

Re: [PHP-DB] LIMIT in MS SQL

2001-03-12 Thread Fredrik Wahlberg
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

Re: [PHP-DB] limit in informix

2001-03-12 Thread Manuel Lemos
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

Re: [PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread Karsten Dambekalns
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

Re: [PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread George Schlossnagle
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