[Fwd: Re: Re: SELECT & html <table>]

[Fwd: Re: Re: SELECT & html <table>]

am 05.12.2005 08:41:34 von Shahmat Dahlan

--------------010101060400030006010400
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


--
Best Regards,

Shahmat Dahlan
Research and Development
SAINS

Mobile: +(60)16 882 6130
Office: +(60)82 426 733 ext 5512


--------------010101060400030006010400
Content-Type: message/rfc822;
name="Re: [PHP-DB] Re: SELECT & html

"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="Re: [PHP-DB] Re: SELECT & html
"

Message-ID: <4393EF15.2060004@sains.com.my>
Date: Mon, 05 Dec 2005 15:41:09 +0800
From: Shahmat Dahlan
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: JeRRy
Subject: Re: [PHP-DB] Re: SELECT & html

References: <20051205050402.12152.qmail@web34811.mail.mud.yahoo.com>
In-Reply-To: <20051205050402.12152.qmail@web34811.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

(1)
i've been using this method for years now, maybe somebody else has a
better way to do this?
sql query
$i = 0;
while (sql result fetches) {
if ($i%2 =! 0) { $bg = 'background="white"'; }
else { $bg = ''; }
echo "";
php codes
$i++;
}
?>

(2) check out the limit syntax in the mysql manuals.
select * from table limit ,
you should work out on how to use the concept of pages, and how many
rows in a page, in which you had mentioned 20.
count the number of page base on the number of records returned then you
get the total number of pages for particular returned result
i'm thinking of the function ceil, at least i think it's the ceiling
function.

e.g.
if pg = 1
maxrows=20
start = ($pg-1)*$maxrows
select * from table $start, $maxrows



pls feel free to correct me


JeRRy wrote:

> From: "Ron Piggott (PHP)" To: "PHP DB" Date: Sun, 04 Dec 2005 13:38:58 -0500 Subject: SELECT & html

>
>
>I have two questions. I would like to display the contents of my table with the first row being grey in background and the next row being white and the third row being grey, fourth being white, etc. I am not sure how to do this. Secondly I only want the first 20 records to be displayed at a time and then I want to create a "NEXT" link for the next 20 records (21-40) ... any idea how you would use the SELECT command to do this? Ron
> [input] [input] [input] [input] [input] [input] [input] [input]
>
>
> Visit http://www.mysql.com/ and read a little bit about LIMIT command. :)
>
> Jerry
>
>
>---------------------------------
>Do you Yahoo!?
> Take your Mail with you - get Yahoo! Mail on your mobile
>
>---------------------------------
>Do you Yahoo!?
> Never miss an Instant Message - Yahoo! Messenger for SMS
>
>


--
Best Regards,

Shahmat Dahlan
Research and Development
SAINS

Mobile: +(60)16 882 6130
Office: +(60)82 426 733 ext 5512




--------------010101060400030006010400
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------010101060400030006010400--