[PHP-DB] Redhat TUX

I have heard about a new server developed by Redhat called TUX. Is php supported in this? -Thanks -- Donot rely on the Operating System which don't have any sources for. -Seen somewhere on the Net ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| ||

[PHP-DB] Distributed Tables vs. fewer Monster Tables

I am putting the finishing touches on a forum program which has a direct lineage (look and feel at least) to Matt Wright's WWWBoard perl script. Remember that? Today I have one table per forum. The forums on my live test site are huge. http://www.astronomy.net/forums/ I have long dreamed of c

[PHP-DB] Re: Interbase: how can I insert null values with placeholders?

I found this bug and fixed it but my patch has not been included in the cvs source yet. (Note, someone should give me cvs access to the interbase source.) The problem is that the interbase extension has been pretty much untouched since php3 and I don't think that the null value was added until

[PHP-DB] Stress tesing a DB

I'm gathering data on open-source databases... is there a program that can provide comparisons between databases, such as MySQL and PostgreSQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To cont

Re: [PHP-DB] PHP MSSQL, IIS Question -- Size Question

What version of php are you using ? Handling of binary data from MSSQL Server was changed from php4.0.5 to php4.0.6. As far as I can tell You should not have any problems with php4.0.6 - Frank > I am preparing a report for a database at my company that will be shown on > the web. It has sev

Re: [PHP-DB] Interbase: how can I insert null values with placeholders?

Hi KM-- The general format for the INSERT goes something like this: INSERT INTO anytable (columnname) VALUES (NULL); You technically do not need the newlines ("\n") in your $stmt. So I guess I'm saying that in the code if you change the $asinteger assignment to: $asinteger = "NULL"; /* notice

[PHP-DB] Interbase: how can I insert null values with placeholders?

Hi! I like to insert null values with placeholders in ibase_query. But it doesn't work. $stmt = "insert into category_prop \n". "(id, category_id, category_prop_type_id, asinteger, asfloat, ascurrency, asstring) \n". "values (gen_id(gen_category_prop_id,1),1097,109,?,?,?,?)"; $asinteger

Re: [PHP-DB] front end for mysql for use on my website

On Fri, 6 Jul 2001, Ed Peddycoart wrote: > I am looking for a front end for mysql for use on my website. What I want > is something that I can run, from the server (my webhost will not allow > remote connections to the mysql server), that allows me to insert, delete, > and modify records into a

Re: [PHP-DB] front end for mysql for use on my website

Try phpMyAdmin. On Fri, 6 Jul 2001, Ed Peddycoart wrote: >-I am looking for a front end for mysql for use on my website. What I want >-is something that I can run, from the server (my webhost will not allow >-remote connections to the mysql server), that allows me to insert, delete, >-and modi

[PHP-DB] front end for mysql for use on my website

I am looking for a front end for mysql for use on my website. What I want is something that I can run, from the server (my webhost will not allow remote connections to the mysql server), that allows me to insert, delete, and modify records into a mySql database. Requirements are that it be free

RE: [PHP-DB] TEXT fields without line breaks

Ive encountered this at my last job and we were using perl as our backend. Before inserting into the database, check for \n or \r and replace with a combo of chars that are mostly likely not to be typed into the text field. Examples: ][, or |43; or whatever... Then when you reread back from the

Re: [PHP-DB] TEXT fields without line breaks

The line breaks may be there, but HTML will not render them. Try this: $outputstring = nl2br($stringfromDB); print("$outputstring"); or something like this to see if the newlines will convert to and render correctly. John On Fri, 6 Jul 2001, Mat Marlow wrote: >-Hi all, >-(I'm not sure

[PHP-DB] TEXT fields without line breaks

Hi all, (I'm not sure if this is the right place to submit this but I'm having problems with the php.general group) I am in desperate need for a solution to HTML text fields not storing new lines. I'm storing news articles in a database but all the text just ends up in a big block because it igno

[PHP-DB] Re: Cookie is set?

Here's the way I check: -Set a cookie on the user's machine. I name mine sessionid. -Redirect to a new page using header("location: acceptcookies.php"); -On the new page, check to see if the variable has a value. For example, I would check to see if $sessionid=="" and if it's true then their mac

RE: [PHP-DB] Newbie:Backend scripts

windows 2000 has a command called 'at' .. which is somewhat like crontab. and there is no reason to run lynx and whatever. php for windows has an exe for a reason 'php.exe c:\path\to\phpfile.php' schedule that every two hours. Mats Remman PHP Developer/Mysql DBA Coretrek, Norway +47 51978597 /

Re: [PHP-DB] SQL error:

Which user are you connected as? Who owns the table? unless you connected as the user who owns the table or table is owned by dbo you have to specify username.TBL_DEPT (where username is the name of the user who owns the table) At 16:47 06.07.2001 +0800, you wrote: >[EMAIL PROTECTED] -- PHP

[PHP-DB] UPLOAD

My problem is to browse a local pc (win) and upload a file in a remote database. There is a simple solution (js ie)? Thanks, Enrico

[PHP-DB] SQL error:

hello!!! i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in NT4 server Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web