Re: [PHP-DB] element in the SELECT query

2001-04-11 Thread phobo
you should look at php.net. Having never used postgres, my imagination thinks that perhaps http://www.php.net/manual/en/function.pg-numfields.php is what you're after. and btw, if you're fetching a whole row, don't retreive a field at a time - its very slow. use a fetch_array or something.

[PHP-DB] MySQL maximums?

2001-04-02 Thread phobo
What is ... 1) The maximum number of tables in a database? 2) The maximum number of rows and 3) (most importantly) the maximum size of a MySQL MyISAM table ? (3.23.35) 1. I can find no documentation on this; assuming its atleast 2 bytes; or 65536 tables; this value is if no real concern. 2.

[PHP-DB] Tree structures...

2001-03-24 Thread phobo
What's the best way to deal with tree structures? Use the following setup in a database as an example: ID | Parent | Description 1 || Colours 2 |1 | Red 3 || Hello 4 |1 | Green 5 | 4 | Light 6 | 4 | Dark This should be

[PHP-DB] How do i find MySQL inserted primary key?

2001-02-18 Thread phobo
if i do an insert statement where i let MySQL assign the (autoincrementing) primarykey, how do i find out the primary key of the record i just inserted? siggy - Original Message - From: "Thies C. Arntzen" [EMAIL PROTECTED] To: "Brian Lalor" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent:

Re: [PHP-DB] double posts

2001-02-16 Thread phobo
No you cant. What are you trying to do? Siggy - Original Message - From: "Marc Bragg" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 9:53 AM Subject: [PHP-DB] double "posts" Is it possible to post to two forms with one click, one post command? What

Re: [PHP-DB] double posts

2001-02-16 Thread phobo
ho "PUsername: INPUT TYPE=TEXT NAME=Username VALUE=$Username"; } else { echo "you chose to do something else." } Siggy - Original Message - From: "Marc Bragg" [EMAIL PROTECTED] To: "phobo" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:42 A

[PHP-DB] odbc_error and odbc_errormsg

2001-02-01 Thread phobo
Are odbc_error and odbc_errormsg new functions to PHP v404? I'm running PHP v403sp1 and it says these functions do not exist ? (On Windows, so i DO have ODBC functions otherwise). The online manual says version of odbc_error() added is (unknown) Siggy -- PHP Database Mailing List

Re: [PHP-DB] Install PHP with custom ODBC

2001-01-30 Thread phobo
1. Instead of customodbc, you should use --with-openlink=/usr/local/openlink/ 2 .Are you sure it asks that odbc.h can't be found ? Or is it that you recieve this error: php_odbc.c: In function `odbc_column_lengths': php_odbc.c:606: `SQLINTEGER' undeclared (first use in this function)

Re: [PHP-DB] Error in accessing the database through MySQL

2001-01-30 Thread phobo
Why are you using php3.0.17? That is atleast 6 months old! You have downloaded a version of PHP which doesn't have MySQL functions built in. Beacuse you are using the Win32 version, you should just use PHP4 (the latest version), which WILL have MySQL functions built in. Go to

Re: [PHP-DB] moving

2001-01-23 Thread phobo
You could have a session variable which" When you order/pay/whatever an image, is set to "canorder=1"; When you download an image, canorder can only==1, and is set back to "canrdoer=0" Something like that can be improved upon vastly, but this is my immediate thought plan. Renaming files and

Re: [PHP-DB] Freetds/ODBC/Openlinks?

2001-01-23 Thread phobo
PHP has "built in" functions to talk to MYSQL - see www.php.net/mysql I'd say these are the fastest, more reliable and easiest way to access a MSSQL db. Siggy - Original Message - From: "Julio Cuz, Jr." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 11:08 AM