Hello
I have products with category number (as a field in the same table).
A user can access any category, and he gets a list of products under that
cat.
What I want is, when the user enters a product, to have a "next" link that
would allow him to pass to the next record in that selection.
is t
Hello,
How do I get the number of the next month (Ex: 4). And when the current
month reaches 12, the next month would be 1 and the next year would be 2002.
Anybody know how I can accomplish this?
Thanks,
Tyler Longren
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
Finished with Beginning PHP from Wrox. Am eyeing Advanced PHP from Wrox.
Other good books I should think about? Recommendations? Reviews? I know the
PHP FAQ has pointers to books, but I am looking for recommendations on what
I SHOULD get as I transition from a Cold Fusion person to a PHP devotee :
I'm seeing references to functions that 'are' in 4.0.6, but I wasn't
even
aware that 4.0.5 was released yet. I've seen references to RCs for
4.0.5,
but nothing's on the php.net page. Did I miss something?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTE
Hi Tyler - did you check the date functions in the manual?
date() with the 'n' format let's you grab the month's ordinal from a unix
timestamp, and mktime() let's you easily create unix timestamps
$next_mon = date("n", mktime(0,0,0,date("m")+1));
jason
> Hello,
>
> How do I get the number of
-mail)" <[EMAIL PROTECTED]>
Sent: Saturday, July 07, 2001 11:23 PM
Subject: [PHP] Next Book
> Finished with Beginning PHP from Wrox. Am eyeing Advanced PHP from Wrox.
> Other good books I should think about? Recommendations? Reviews? I know
the
> PHP FAQ has pointers to books, but
Rick wrote:
[...]
> I'd be interested in some good PHP books as well, I feel like I'm in a
rut.
> At first, PHP was all new, and I was learning s much... but now if I
> think up a task I can visualize how to do it in PHP pretty easily. I know
I
> have a LOT to learn, but I think my problem is
On Sat, Jul 07, 2001 at 10:23:58PM -0800, Chris Lott wrote:
> Also looking for a good book on MySQL. The MySQL/MSQL book from O'Reilly is
> pretty dated.
Please read "MySQL" from Paul DuBois. Some Reviewers are on the last day
on the LinuxDays in Stuttgart, Germany.
-Egon
--
LinuxTag, Stuttga
TED]>
To: Php-General (E-mail) <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 2:23 AM
Subject: [PHP] Next Book
| Finished with Beginning PHP from Wrox. Am eyeing Advanced PHP from Wrox.
| Other good books I should think about? Recommendations? Reviews? I know
the
| PHP FAQ has pointers
http://www.newbienetwork.net/ciao.php
PHP, MySQL, PostgreSQL Tutorials, Code Snippets, and so much more
> -Original Message-
> From: Chris Lott [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 08, 2001 2:24 AM
> To: Php-General (E-mail)
> Subject: [PHP] Next Book
>
>
"Chris Lambert - WhiteCrown Networks" <[EMAIL PROTECTED]> wrote in
message 007901c10788$6ba051a0$6401a8c0@server">news:007901c10788$6ba051a0$6401a8c0@server...
[SNIP]
> Web Application Development for PHP 4.0 (Ratschiller, Gerken)
I can recommend this book for people who are already somewhat fam
AIL PROTECTED]>
Sent: Sunday, July 08, 2001 4:31 AM
Subject: Re: [PHP] Next Book
> Good books for advanced topics are:
> PHP4 Developer's Guide (Schwendiman)
> PHP Developer's Cookbook (Hughes)
> Web Application Development for PHP 4.0 (Ratschiller, Gerken)
>
> And
PHP 4.0.6 has been out for 3 months now. Any word on the next update?
--
Eugene Lee
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EM
Nope, it 4.0.5 hasn' been released yet.
However at one point I believe there was a 4.0.6dev source code on CVS,
before the Midgaard extension required another round of release candidates.
So I think that's where the mentions came from.
And I'm sure some people are planning their features to be i
On a page i have all the records from a table. they are linkable. if you
click on them, the will show the specific record id with all info on the
row.
how to make a link for the following record and one other for the previous?
suppose, the page you're seeing is http://www.x.com/news.php?ID=50
I need some help with the NEXT() and PREV() functions. I want to use them
with a webpage to direct which page is viewed by the user. If NEXT is
selected then I would like the next information pulled from the database. If
the PREV is selected I would like the previous information pulled from the
da
Dear All,
I am using PHP + MYSQL. I have a question that I need some expert
to help. That is:
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063
Hello,
I've been trying write a .php page that displays 10 results per page
with links to the next 10 avail. I've found a couple examples on how to
do this with MySQL, and I tried to convert it to work with Postgres with
no luck. Has anyone ever done this using PHP4.0.6 and Postgres 7.1?
Also,
Hello
After several days of reading various articles on the web I've 'finally' got
a basic database working. The database is for a massive collection of my
vinyl records. Therefore I would like to limit the results to about 20 per
page and move forward/backward with 'next' and 'previous' links.
--- Miguel Brás <[EMAIL PROTECTED]> wrote:
> suppose, the page you're seeing is
> http://www.x.com/news.php?ID=501 how to add
> a link for the page to show the ID=502 and the
> ID=500
Next
Previous
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.ph
Hi,
it's giving me an error. it assumes the next page as news.php?ID=1 and the
previous as news.php?ID=-1
Any hint for that?
Miguel
"Chris Shiflett" <[EMAIL PROTECTED]> escreveu na mensagem
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> --- Miguel Brás <[EMAIL PROTECTED]> wrote:
> > suppose, the
esday, 15 January 2003 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Next and Previous
>
>
> Hi,
>
> it's giving me an error. it assumes the next page as
> news.php?ID=1 and the previous as news.php?ID=-1 Any hint for that?
>
> Miguel
>
> "C
y 2003 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Next and Previous
>
>
> Hi,
>
> it's giving me an error. it assumes the next page as
> news.php?ID=1 and the previous as news.php?ID=-1 Any hint for that?
>
> Miguel
>
> "Chris Shi
>"Miguel Brás" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> That's not the case, I tested it on ID549 and the previous one should be
548 and he still assume -1
Works for me. Are you adding the ?ID=500 to the url? If you don't have
that, then the ID is 0, so
Let's see
i solved thhe problem...
I did since I was making the select with WHERE ID = '$ID'
so I get the var $ID.,
Thx for the help of all
Miguel
"Matt" <[EMAIL PROTECTED]> escreveu na mensagem
034901c2bc37$41429160$[EMAIL PROTECTED]">news:034901c2bc37$41429160$[EMAIL PROTECTED]...
> >"Miguel
I am having trouble with creating a list box.
I am attaching the code.
I am not sure the code in the for loop close to the end of the program
is correct.
If someone could take a look at it I would appreciate it.
Thanks,
Sara
My Class Schedule
http://www.areawebdirectory.net/sealmark2.gif";>
Ladies and gentlemen of PHP,
I'm quite new to PHP (coming from Perl) so please don't laugh too hard if
I'm missing something obvious.
My scenario is as follows:
Connect to the MySQL server->grab the data from the table->display the data
of the first row on the web page->sleep 1 second->display th
Hello all.
Our next PHP user group meeting will be held this coming Thursday, May
3rd
(the first Thursday of the month) at our office in downtown Ypsilanti,
MI.
(125 North Huron, #400, to be exact).
We normally meet around 7ish for drinks/eats beforehand, and get started
at 8.
Keith Elder will b
On Tuesday 08 October 2002 06:03, Jef wrote:
> I need some help with the NEXT() and PREV() functions. I want to use them
> with a webpage to direct which page is viewed by the user. If NEXT is
> selected then I would like the next information pulled from the database.
> If the PREV is selected I w
What archives?
Jef
++
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Tuesday 08 October 2002 06:03, Jef wrote:
> > I need some help with the NEXT() and PREV() functions. I want to use
them
> > wit
On Tuesday 08 October 2002 22:23, Jef wrote:
> What archives?
List archives. Searching for "archives" in www.php.net would have shown you
where they are.
Also google for "php database next previous" would've turned up some good
links.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.
some where id>'ID0015' order by id limit 0,1;
Best regards,
Andrey Hristov
- Original Message -
From: "Mark Lo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 5:15 P
EMAIL PROTECTED]
Subject: Re: [PHP] Next and Preview Row
Yes, but how to get ONLY the 3 records you need ?
Because often in an application, you don't care about the other records.
In this case AFAIK, there is no other solution than issuing at least two
queries :
SELECT * FROM table WHERE field<=&
> How do I find out a next and preview row values by using PHP and MYSQL. For
> examples,
Take a look at the function
mysql_result();
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
;[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: [PHP] Next and Preview Row
>
> Dear All,
>
> I am using PHP + MYSQL. I have a question that I need some expert
> to help. That is:
>
> How do I find out a next and preview row val
> The solution I have been using is to do three queries similar to the below
> SELECT * FROM table WHERE field='ID00025'
> SELECT * FROM table WHERE field<'ID00025' ORDER BY field DESC LIMIT 0,1
> SELECT * FROM table WHERE field>'ID00025' ORDER BY field ASC LIMIT 0,1
> If you whish more row return
> It seems worst to me because in your case mysql has to retrieve all the
> rows. If it's a table with 1 million records or more, this should hurt ;)
As I said, it was pseudo code. Now, imagine that you were just
getting the records for a particular user? a particular application?
Where there w
ot;Raymond Gubala" <[EMAIL PROTECTED]>; "Mark Lo"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 4:45 PM
Subject: Re: [PHP] Next and Preview Row
> > The solution I have been using is to do three queries simila
;Mark Lo" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 9:17 PM
Subject: Re: [PHP] Next and Preview Row
> > It seems worst to me because in your case mysql has to retrieve all the
> > rows. If it's a table with
Could you send me the URL's for the MySQL examples? Thanks!!
> -Original Message-
> From: webmaster [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Next and Previous links
>
>
> Hello,
>
>
I found an answer for anyone who may be interested on phpbuilder.com
http://phpbuilder.com/annotate/message.php3?id=1010986
-Elkan
webmaster wrote:
> Hello,
>
> I've been trying write a .php page that displays 10 results per page
> with links to the next 10 avail. I've found a couple example
On Friday 09 August 2002 22:35, webmaster wrote:
> Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
> requires at least 2 parameters where all the examples I find only use
> 1. Is this a DB configuration problem?
Did you try the obvious step of consulting the manual?
--
Dear list,
I would like to query only the last 50 records/rows (order by ID desc) in the
following script file which uses MySQL, and I want to have NEXT page for the 50 rows
earlier than last 50 queried and go on. I think I can use JavaScript for BACK page to
go back. Could you pl add for me th
Dear list,
I would like to query only the last 50 records/rows (order by ID desc) in
the following script file which uses MySQL, and I want to have NEXT page for
the 50 rows earlier than last 50 queried and go on. I think I can use
JavaScript for BACK page to go back. Could you pl add for me the s
ursday, November 13, 2003 3:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP] next,key,current question
I am having trouble with creating a list box.
I am attaching the code.
I am not sure the code in the for loop close to the end of the program
is correct.
If someone could take a look at it I would appr
Sara Daugherty wrote:
I am having trouble with creating a list box.
I am attaching the code.
I am not sure the code in the for loop close to the end of the program
is correct.
If someone could take a look at it I would appreciate it.
Thanks,
Sara
I like to use foreach:
foreach($Classes as $Clas
On Friday 24 December 2004 13:09, Greg Wardawy wrote:
> I'm quite new to PHP (coming from Perl) so please don't laugh too hard if
> I'm missing something obvious.
> My scenario is as follows:
> Connect to the MySQL server->grab the data from the table->display the data
> of the first row on the we
day, December 24, 2004 10:39 AM
Subject: [PHP] Next page every second
> Ladies and gentlemen of PHP,
>
> I'm quite new to PHP (coming from Perl) so please don't laugh too hard if
> I'm missing something obvious.
> My scenario is as follows:
> Connect to the MySQL
TED]>
To: "Greg Wardawy" <[EMAIL PROTECTED]>;
Sent: Thursday, December 23, 2004 1:25 PM
Subject: Re: [PHP] Next page every second
If all you want to display each record one by one at a particular interval
of time
you could do this at one page itself...here is the procedure
1. c
Use a LIMIT clause. See
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
-Rasmus
On Tue, 23 Oct 2001, Tshering Norbu wrote:
> Dear list,
> I would like to query only the last 50 records/rows (order by ID desc) in
> the following script file which uses MySQL, and
I am trying to access a website that has tab delimited data and use PHP to
open the file, read from the
file for output.
I'd like to then place this data into an array, loop through the array and
output only the next to last record.
It is:
http://waterdata.usgs.gov/ny/nwis/uv?format=rdb&period=
> Use a LIMIT clause. See
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
>
> -Rasmus
And for a db that not have limit (like ibm db2)
Josep.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additio
Hi all,
I have this mySQL query giving me my result back.
The info about the current db-record is showing.
Now I want to display ' view next ' and ' view previous ' buttons on my website. which
takes you to the same page but with the next record in the query result.
Is there a clever way to d
> > Use a LIMIT clause. See
> >
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
> ECT
> >
> > -Rasmus
>
> And for a db that not have limit (like ibm db2)
Use a cursor or rowcount, if you have that.
-Rasmus
--
PHP General Mailing List (http://www.php.ne
Wilbert,
Use the LIMIT tag in your select statement. You can also choose which
matching record to start from.
Another pure database question...
HTH
Chris
Wilbert Enserink wrote:
>Hi all,
>
>
>I have this mySQL query giving me my result back.
>
>The info about the current db-record is showing
you need to keep track of the last record and number to display to work out the values
for limit.
> -Original Message-
> From: Chris Hewitt [mailto:[EMAIL PROTECTED]]
> Sent: 13 June 2002 3:32 PM
> To: Wilbert Enserink
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP]
56 matches
Mail list logo