[PHP] displaying database results with forward and back buttons
Hi, I have a query that returns lots of rows so I want to display the results in blocks of 25 or so on my web page and have forward and back buttons to navigate the results. Can someone point me in the right directions please I have tried to look around for something using google but cant think of a suitable search term Thanks Matt
Re: [PHP] displaying database results with forward and back buttons
I have a query that returns lots of rows so I want to display the results in blocks of 25 or so on my web page and have forward and back buttons to navigate the results. Can someone point me in the right directions please I have tried to look around for something using google but cant think of a suitable search term I think pagination might be the term you're looking for. I'm pretty sure there's a PEAR class which will help with this or you can check PHPBuilder.com or Zend.com for articles on the subject. Larry -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Displaying Database Results
I have a php script that queries a MySQL database and I loop through the results displaying them as follows: echo td width='100'input name='description' type='text' size='45' maxlength='20' value=.StripSlashes(mysql_result($badgedetails, $i, 'descr')). tabindex='1'//td; The problem is that as per the example above, the text displayed is Name but it should be Name Badge. With all my fields, the text is displayed OK until it hits a space. Why does this occur? This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Displaying Database Results
Put quotes around your value input name='description' value='Name Badge' ... vs input name='description' value=Name Badge ... HTML will see the Badge or anything after a space as an extra attribute to the tag. ---John Holmes... -Original Message- From: Mark Colvin [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 6:10 AM To: Php (E-mail) Subject: [PHP] Displaying Database Results I have a php script that queries a MySQL database and I loop through the results displaying them as follows: echo td width='100'input name='description' type='text' size='45' maxlength='20' value=.StripSlashes(mysql_result($badgedetails, $i, 'descr')). tabindex='1'//td; The problem is that as per the example above, the text displayed is Name but it should be Name Badge. With all my fields, the text is displayed OK until it hits a space. Why does this occur? This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php