KingPin's Forum
 
K.P.s.N. Register vbBux / KPs Mall Bugs Blogs FAQ Search Today's Posts Mark Forums Read Donate
Go Back   KingPin's Forum > KP's Network Forum > RSS News
Reload this Page PHP & MySQL: echo something every X number of rows?
 


RSS News This is a discussion on PHP & MySQL: echo something every X number of rows? in the RSS News;
Description: How do I retrieve results from a MySQL db and have something printed with every X rows returned? Thanks. i'm ...

Reply
 
LinkBack Thread Tools
PHP & MySQL: echo something every X number of rows?
(#1 (permalink))
Old
mbch is Offline
Private
Points: 164, Level: 2 Points: 164, Level: 2 Points: 164, Level: 2
Activity: 0% Activity: 0% Activity: 0%
mbch is an unknown quantity at this point
 
 
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Dec 2007
PHP & MySQL: echo something every X number of rows? - December 26th, 2007

How do I retrieve results from a MySQL db and have something printed with every X rows returned? Thanks.
i'm still looking for a solution. thanks.
byteofk, i can't get that to work.

 
Reply With Quote
Revenue Shared Ads
(#2 (permalink))
Old
quantumkev is Offline
Private
Points: 197, Level: 2 Points: 197, Level: 2 Points: 197, Level: 2
Activity: 0% Activity: 0% Activity: 0%
quantumkev is an unknown quantity at this point
 
 
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Dec 2007
December 26th, 2007

I'm not sure about how one would do this in PHP, but I know that in other languages such as VB and C#, I would accomplish this by using ADO and returning a recordset object from the MySQL db. Then, I would read through the recordset in a loop, keeping track of the number of records read so far, and print whatever I wished to print at the desired counts - preferrably, they would be multiples, so the condition would be easy to check for.

 
Reply With Quote
(#3 (permalink))
Old
byteofk is Offline
Private
Points: 213, Level: 2 Points: 213, Level: 2 Points: 213, Level: 2
Activity: 0% Activity: 0% Activity: 0%
byteofk is an unknown quantity at this point
 
 
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Dec 2007
December 26th, 2007

pseudocode (no attention to syntax):

$sizeofblock = 10; // if you want it repeated every 10 rows
$x=0;
while($results()){
$x++;
echo $results($x);
if((floor($x/10))==($x/10)){
echo $dividertext after $x rows;
}
}

 
Reply With Quote
Revenue Shared Ads
Reply

Bookmarks

Tags
echo, mysql, number, php, rows

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Rupees Per Thread View: 1.00
Rupees Per Thread: 15.00
Rupees Per Post: 5.00
Forum Jump



These are the 100 most searched terms
Search Cloud
_backup.rc antrix wow antrix wow server autocad 2007 keygen best google gadgets best wow character bt map devil may cry 4 crack enchanting leveling erika bella fuckteam fuckteam 5 georgina lempin gigistar gigistar topless kpsden kpsforum leatherworking guide leveling enchanting mangos custom vendors mangos item id mangos linux mangos server mangos spell id mangos wotlk mature creampie milena velba no rest for the ass object id wow phoenix marie this is sparta vipersdenforums voyage century bot windows activation workaround windows xp lite wotlk alpha private server wotlk private server wotlk server wotlk wiki wow leatherworking guide wow mount locations wow object id wow object id list wow object id's wow object ids wow objects id www.adobeflashplayer www.adobeflashplayer.com www.kpsforum.com xbox 360 mmorpg ... powered by Simple Search Cloud
Powered by vBulletin® Version 3.8.0 Beta 3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
Copyright 2004-2009 KPsN


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82