[PHP-DB] Mysql MaxDB Support?

2004-03-11 Thread Carolyn Longfoot
Does PHP natively support MaxDB? I have not seen any mention of it in the manual anywhere. If not and anybody uses ODBC could you kindly post the configuration? Cheers! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mysql MaxDB Support?

2004-03-11 Thread Ricardo Lopes
MaxDB is based on sapdb, try searching for that you probably get better results because sapdb is older that maxdb. In the near future maxdb will support the mysql protocol, so i guess you could then use the mysql functions with maxdb. - Original Message - From: Carolyn Longfoot [EMAIL

[PHP-DB] Re: MySQL Backups

2004-03-11 Thread Justin Patrin
Jai Jones wrote: Hi Everyone. I have MySQL databases on various servers, I'd like to know how people automate backups. I imagine there would be lots of scripts and products that do this, I've tried a few, but I guess I'll have to write something myself to do it. I'd be very interested in

[PHP-DB] Pulldown value not passed to next page

2004-03-11 Thread Karen Resplendo
What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page is new, it gives the default (selected) of 15. For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or

[PHP-DB] Impact of MySQL Queries

2004-03-11 Thread Marcjon Louwersheimer
I have IIS 4.x and MySQL running on the same machine. So do queries use up bandwidth? Does it matter if I have 20 queries per page? Will that slow it down if many people started using my site? Currently only I, and some friends for testing, use it. -- Marcjon -- PHP Database Mailing List

Re: [PHP-DB] Pulldown value not passed to next page

2004-03-11 Thread Doug Thompson
Hi Karen, Depending upon the method used for your form, you should be able to find the value in either $_GET['pagesize'] or $_POST['pagesize']. hth, Doug Karen Resplendo wrote: What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page is

RE: [PHP-DB] Pulldown value not passed to next page

2004-03-11 Thread Hutchins, Richard
Karen, I'm assuming that when you say: For some reason, when Previous/Next are clicked, the value passed is still 15 even though the pulldown says something else (5 or 15 or whatever) you're drawing that conclusion because 15 images (or whatever) are displayed on the resulting page

Re: [PHP-DB] Impact of MySQL Queries

2004-03-11 Thread Miles Thompson
Think of bandwidth as the volume of data returned by the web server to the browser, not machine cycles. MySQL will use machine cycles, but there's more to it than that. For fastest response the fields you are running the query against should be indexed. What pushes you to 20 queries per page?

Re: [PHP-DB] Impact of MySQL Queries

2004-03-11 Thread Cal Evans
If both services are running on the same machine then no, the number of queries per page will not affect bandwidth. It will however, affect you processor usage. Without having seen your code, I can only make generalizations. 20 queries is a bit excessive but it's still manageable if the server

[PHP-DB] Sort Order Description

2004-03-11 Thread kc68
How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by (ssa1202.total/vapall.vapall)*100 in Descending Order. I'd prefer simply

[PHP-DB] ODBC support

2004-03-11 Thread Galbreath, Mark A
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any clues? tia, Mark --

Re: [PHP-DB] ODBC support

2004-03-11 Thread Bruno Ferreira
Galbreath, Mark A wrote: Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page.

RE: [PHP-DB] ODBC support

2004-03-11 Thread Brian Mansell
Take a look at ADODB (It's a good database library that supports a variety of systems): http://php.weblogs.com/ADODB Here's a quick intro: http://www.databasejournal.com/features/php/article.php/651 -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent:

[PHP-DB] Re: Sort Order Description

2004-03-11 Thread David Robley
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by

Re: [PHP-DB] Re: Sort Order Description

2004-03-11 Thread kc68
I'm not clear on your question. The code I quoted, set forth below, has the text that ends up above the table. The following introduces the series of column headings with sort statements (of which the initial code is one): # write out title if ($sort_order == asc) {$sort_title = Ascending;}

Re: [PHP-DB] Re: Sort Order Description

2004-03-11 Thread Bruno Ferreira
[EMAIL PROTECTED] wrote: [snip...] The following is at the beginning of the script: # get sort order (if any) passed to script $sort_field = $_REQUEST['sort_field']; if (! $sort_field) {$sort_field = (ssa1202.total/vapall.vapall)*100;} $sort_order = $_REQUEST['sort_order']; if (! $sort_order)

[PHP-DB] BLOB

2004-03-11 Thread Ng Hwee Hwee
Hi all, how do i find out if a BLOB field in my table is NULL? i tried: SELECT * FROM `MEMBER` WHERE `PASSWD` is NULL however, although there is one entry in my table that has nothing in my PASSWD field, the result set is empty.. how come? how do i search for entries that has password =