[PHP-DB] Version Upgrade

2004-05-20 Thread Ng Hwee Hwee
Hi all, I'm running on PHP 4.2.2 and MySQL 3.23.54 I would like to do an upgrade... What would be the highest version number that I can upgrade to without causing any possible conflict? I'm thinking of upgrading to PHP 4.2.3 and MySQL 4.0.4 because they have some features that I need. But I

[PHP-DB] Re: Slow php-mysql

2004-05-20 Thread drez
First that was not only the first connection that sucks but all. Second, the holy solution to my problem was to move all to another server, with the exactly the same config (software but new hardware) and all is now fine. It is a very strange issue that I continu to try to understand. If I

[PHP-DB] Request database_queryf() functions.

2004-05-20 Thread William Bailey
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, After having been talking to lots of people in irc lately who are haveing problems with SQL injection etc i think that haveing a *_queryf() function would be really useful to help people esp when it comes to integers and the id=$id

Re: [PHP-DB] Request database_queryf() functions.

2004-05-20 Thread William Bailey
If you need a better source example/layout goto: http://nopaste.php-q.net/59720 William Bailey wrote: Hi All, After having been talking to lots of people in irc lately who are haveing problems with SQL injection etc i think that haveing a *_queryf() function would be really useful to help

[PHP-DB] Display mysql query results divided in dynamic numbered pages

2004-05-20 Thread Kpromos
Dears, I'm new to php, so I'm not able to solve the following problem. I have a function with a while loop that generates the results of a mysql query. I'd need to generate a flow of the results, divided in pages as ... Previous 1 2 3 4 Next ... The function I'm using follows .. and also the

RE: [PHP-DB] Display mysql query results divided in dynamic numbered pages

2004-05-20 Thread Gary Every
Look at: http://www.phpclasses.org/browse/package/92.html It's a pager class that does: Previous 1 2 3 4 5 6 7 8 9 10 Next Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Kpromos [mailto:[EMAIL

[PHP-DB] Re: Am I missing something? Why doesn't php have a 'date' variable

2004-05-20 Thread Justin Patrin
Ross Honniball wrote: Hello. I've been using php for about 5 months now. One of the first things I noticed it was missing was a standard in-built manner of handling dates. I assumed that, being inexperienced, I was probably missing something and in time all would become clear. It's a while

[PHP-DB] Forum Software

2004-05-20 Thread Room 11 Designs
Hi there everyone, I was wondering how hard it is to write your own forum, maybe even as complicated as PhpBB... Any help out there?

[PHP-DB] Re: Forum Software

2004-05-20 Thread Justin Patrin
Room 11 Designs wrote: Hi there everyone, I was wondering how hard it is to write your own forum, maybe even as complicated as PhpBB... Any help out there? To completely write something that complicated and featureful takes a long time. Why not just use PHPBB? -- paperCrane Justin Patrin -- PHP

[PHP-DB] sybase and php

2004-05-20 Thread Julia Simmons
Ever since we have been using PHP to access data in our Sybase database, database permissions have been spontaneously disappearing from the tables that are being looked at! It happens on the time frame of a couple months between times. To fix it, I have to go into Sybase and grant select

[PHP-DB] how to reuse DB results

2004-05-20 Thread Aaron Wolski
Hi All, Got this logic problem I don't know how to solve. Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Right now, I am making two calls to the Db to get

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Hutchins, Richard
Off the top of my head, you could do the db call once, assign the full result set to an array, pull off the parts you want at the top of the page, then use reset($arrayname) to put the pointer back to the beginning of the array then use a loop to print out the whole thing at the bottom of the

Re: [PHP-DB] Forum Software

2004-05-20 Thread Room 11 Designs
I just want to know if there are any good forum tutorials out there... I mean, I am using vBulletin 3 - so I cant say anything is better than it. - Original Message - From: Galbreath, Mark A [EMAIL PROTECTED] To: 'Room 11 Designs' [EMAIL PROTECTED] Sent: Thursday, May 20, 2004 8:54 PM

Re: [PHP-DB] how to reuse DB results

2004-05-20 Thread Cal Evans
adodb has a moveFirst() function. You should be able to use it to display x rows then $rs-moveFirst() and then use a while loop to display all of them. HTH, =C= : : Cal Evans : Evans Internet Construction Company : 615-260-3385 : http://www.eicc.com : Building web sites that build your business

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Hutchins, Richard
Yeah, that's kind of what I was thinking. The logic in your pseudocode seems correct. However, I'm not sure about the bit where you do: $resultset[] = $results Not because it's wrong, just because I always have to refer back to some form of documentation when putting result sets into an array to

Re: [PHP-DB] how to reuse DB results

2004-05-20 Thread John W. Holmes
Aaron Wolski wrote: Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Look for the seek() function of whatever database you're using, i.e. mysql_data_seek() to

[PHP-DB] Passthru Strangeness

2004-05-20 Thread Ryan Jameson (USA)
Hi All, My win32 server is not in safe_mode but I can only use passthru for simple commands like dir and type but when I try to do say a ping it simply returns no output but no error either. Anyone have an idea what's going on? I have used it for ping in the past. Ultimately I plan to use it to

Re: [PHP-DB] Forum Software

2004-05-20 Thread Marcjon
Of course it all depends on how complex you want these forums to be. I've been working on my own forums system, which can be viewed at http://marcjon.no-ip.com/juicylucy It's made with PHP 5.0rc2 and MySQL 4.0. It does that job (though coding PHP is just a hobby for my right now, so anything that

Re: [PHP-DB] Version Upgrade

2004-05-20 Thread Ng Hwee Hwee
hi all, Sorry, I meant to say PHP 4.3. Will it be very different from PHP4.2.2 that my programs may perform strangely if I upgrade to PHP4.3? many thanks, Hwee - Original Message - From: Gary Every [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Sent: Thursday, May 20, 2004 9:23