Dear all:
I have been exploring about this issue quite a lot, and find no solution:
Platform: Debian, MySql 4.1.11, PHP 4.3.10-2, Apache.
Is there any way I can retrieve a set of values depending in a where clause:
For example:
from a set of values in one field: 1,2,5,8,9,11,13
I'd like to re
Hi all,
I need some help with navigation in an array.
The plan is to display a row and by using a 'Next" or 'Previous' button to
display, on the same form, the next or previous row from that array.
The array is populated correctly and when the script runs it displays all
twelve elements, followed b
Hynek Semecký
www.semecky.com
www.perlickovekoupele.cz
Profi Web Hosting: http://www.web4u.cz/index.php?page=Programy&rid=2837
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: 20. prosince 2002 16:16
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Next/
check out php.weblogs.com
ADODB does this for you.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Next/Prev 10 lines
Has
On Friday 20 December 2002 23:16, Steve Dodkins wrote:
> Has anyone got some code that will correctly display the next 10 line of a
> table with prev and next working?
> Or point me in the right direction for help?
Search the archives. This kind of question gets asked (and sometimes answered)
eve
Has anyone got some code that will correctly display the next 10 line of a
table with prev and next working?
Or point me in the right direction for help?
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and should
only be read by those persons to whom it is a
> That would actually work for just getting a certain number of records
from
> a
> query, but you would have to execute another query to figure out the
> navigational
> links he said he wants on the bottom...like google has, << 1 2 3 4 5
>>.
> So,
> when I attacked it I figured one query is better
That would actually work for just getting a certain number of records from a
query, but you would have to execute another query to figure out the navigational
links he said he wants on the bottom...like google has, << 1 2 3 4 5 >>. So,
when I attacked it I figured one query is better then two eve
How about appending " LIMIT _GET[startrow],5" to the end of your query.
The first parameter to LIMIT is the start position and the second is
the number of rows to return.
Does this help, or am I misunderstanding your question?
Mark
Lucas Novæ Matrix wrote:
>Hello,
>
>I am trying to creat
I did something like this with a photo gallery I made. The approach I took is
the execute a query, get the number of rows, and divide that number by how ever
many records I wanted on that page. Then that would give me the number of total
pages I would have for my navigational links at the bottom
Hello,
I am trying to create a "next n" interface through php4, using results from
a mysql query. I did this in the past easily with ColdFusion, but this time
it's a bit more complicated.
What I need to do basicaly is to have only 5 results per page. The first
page displays the 5 results and "Ne
> -Original Message-
> From: Smita Manohar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 26, 2002 8:26 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] next prev links for search result
>
>
> hiii..
>
> i want page no. and next prev links while di
hiii..
i want page no. and next prev links while displaying search result. the
script which im using presently, needs to run the search query 2 times for
each search operation.
first time it finds all the records matching the query string,
ie, select * from table where field like '%$search_st
#x27;s birthday next month (or something like that).
>
> Robert Zwink
> http://www.zwink.net/daid.php
>
> -Original Message-
> From: Kristjan Kanarik [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 08, 2002 5:30 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Next
be much simpler if you
just showed everyone's birthday next month (or something like that).
Robert Zwink
http://www.zwink.net/daid.php
-Original Message-
From: Kristjan Kanarik [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 5:30 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Next bir
I have a table called 'members' with a field (among many others)
'member_dob' - the birthday of a particular member. The data type of this
field is date (-mm-dd).
What I'd like to do now is to fetch one particular row from the database
(I am using MySQL 3.23.37) - namely the row of the member
TED]]
Sent: Wednesday, November 14, 2001 3:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Next
I am writing a questionaire, am gonna include java timer etc... and it is
written in PHP 4 and Mysql running on Apache.
I have my questionaire database full of questions I randomly select say 40
questions.
Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Peter Allum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 14, 2001 11:37 AM
Subject: [PHP-DB] Next
> I am writing a questionaire, am gonna include ja
I am writing a questionaire, am gonna include java timer etc... and it is
written in PHP 4 and Mysql running on Apache.
I have my questionaire database full of questions I randomly select say 40
questions. But rather than display the whole array on the screen I would
like to have 1 question per p
;
$pagesize) )
{
// print rows of data etc etc
}
if( ($page > 1) )
{
print "Next";
}
if( ($page < $pages) && ( $pages > 1 ) )
{
print "Next";
}
-Original Message-
From: Pranot Kokate [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 09
hi.. friends
i have a database (mysql) in which their r many records. Through PHP i want them to
display on the page.
Main requirement is that there should be a NEXT - PREVIOUS facility. So if there r 20
records and suppose only 10 should show up on scren at a time, then a NEXT link should
b
tispam.html
-Mensagem Original-
De: Andrew Hill <[EMAIL PROTECTED]>
Para: Dreamvale <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Enviada em: quinta-feira, 22 de fevereiro de 2001 14:10
Assunto: RE: [PHP-DB] next & previous record
> You want to use Cursor
Keep a counter of the rows you have fetched. so when you want to go back
call mysql_data_seek ($Result, Counter-1);
then mysql_fetch
and you've got the previous row.
Lennin Arriola
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [E
w.com
> -Original Message-
> From: Dreamvale [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 11:42 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] next & previous record
>
>
> I was not refering pagination.
>
> suppossing there are these 3 reco
thanks.
- Original Message -
From: "Brunner, Daniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 12:12 AM
Subject: FW: [PHP-DB] next & previous record
> > Check this link out...
> > http://www.oreillynet.com/pub/a/php/200
From: Dreamvale
> Sent: Thursday, February 22, 2001 9:55 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] next & previous record
>
> hi all,
>
> need to implement record scrolling, one at a time -either forward or
> backward, on MySQL. The key is
hi all,
need to implement record scrolling, one at a time -either forward or
backward, on MySQL. The key is a char (32) containing part numbers.
anyone has done this before?
thanks in advance.
dreamvale
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTEC
27 matches
Mail list logo