RE: [PHP-DB] File Optimisation

2001-03-15 Thread Steve Brett
Hi, Thanks for the comments, we do use IE but for the future we have to keep an open mind as there is a fair chance the network may go linux. There are plans for a windows type app in the pipeline already, with the web front end being the test-bed so I guess things ewill improve. Gonna do some l

[PHP-DB] Default port on sybase_connect()

2001-03-15 Thread Trond Straume
What's the port that the php-command "sybase_connect()" uses? As far as I can see it's not possible to define which port the function shall connect to... -- Trond Straume -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-m

Re: [PHP-DB] Help w/ displaying return vals

2001-03-15 Thread Russ Michell
Ryan: The followoing error message: >Warning: Supplied argument is not a valid MySQL result resource means that a php function hasn't been supplied witht the correct number of arguments. Try the following: $link = mysql_connect("host","yourusername","yourpassword") or die("Died at connectio

Re: [PHP-DB] Default port on sybase_connect()

2001-03-15 Thread Trond Straume
In the documentation for sybase_connect() the 'interfaces' file is mentioned. Where is this file on php4 for win32, and what is the syntax for defining a server including a specific port? ""Trond Straume"" <[EMAIL PROTECTED]> wrote in message 98q1ea$g3i$[EMAIL PROTECTED]">news:98q1ea$g3i$[EMAIL

Re: [PHP-DB] Default port on sybase_connect()

2001-03-15 Thread Koos van den Hout
Quoting Trond Straume who wrote on Thu, Mar 15, 2001 at 10:23:36AM +0100: > What's the port that the php-command "sybase_connect()" uses? > As far as I can see it's not possible to define which port the function > shall connect to... That is because you connect to a name from the sybase interfac

[PHP-DB] Interbase: ibase_pconnect() problem

2001-03-15 Thread Wolfgang Hege
Hi ! I have following problem when connecting to Interbase: When trying to establish a persistent connection using 'ibase_pconnect()', a new connection is created each time. The database connection remains open, but it will not be re-used later. So I have loads of database connections and a huge

Re: [PHP-DB] What is the life time of mysql connection if I use pconnect()

2001-03-15 Thread Jason Stechschulte
On Thu, Mar 15, 2001 at 11:55:20AM +0800, Carfield Yim wrote: > From the document, the connection opened by pconnect() will not close > after you use. > And it will store it and reuse at next time. > I would like to ask, it is keep open until I shutdown apache? AFAIK, it is kept open for the li

Re: [PHP-DB] Text Searches on MySQL

2001-03-15 Thread Jon Valvatne
First of all, to answer the inital question, here's a quote from the database: * It's not normally useful to split a table into different tables just because the rows gets 'big'. To access a row, the biggest performance hit is the disk seek to find the first byte of the row. After finding the da

[PHP-DB] If expressions in selects....

2001-03-15 Thread Trond E. Hundal
Is it possible to run sql expressions in an if expression??? Eks: IF(table1.id > 12, table1.id, 'Not') hmm... I haven`t been doodling with if`s in mysql before... Have anyone any code sample i can look at...? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL P

Re: [PHP-DB] PHP and MySQL

2001-03-15 Thread Romeo Manzur
hi, you could do it in a easier way, first put real names for the fields in your form: login : group : password : , second you could do this: INSERT INTO $tabl

Re: [PHP-DB] If expressions in selects....

2001-03-15 Thread CC Zona
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Trond E. Hundal") wrote: > Is it possible to run sql expressions in an if expression??? > Eks: IF(table1.id > 12, table1.id, 'Not') Do you mean something like "select if(table1.id > 12, table1.id, 'Not') from foo where somefield='bar'"? Yes,

[PHP-DB] validating checkboxes

2001-03-15 Thread Adv. Systems Design
Hello all: I have to validate that AT LEAST ONE checkbox is checked in a series of checkboxes...the checkboxes all use the name=preq[] so that when I process it, it will go into a php array...the problem is that I want to validate it using javascript and the [] in the object name (preq[]) causes

Re: [PHP-DB] Default port on sybase_connect()

2001-03-15 Thread Darryl Friesen
> In the documentation for sybase_connect() the 'interfaces' file is > mentioned. Where is this file on php4 for win32, and what is the syntax for > defining a server including a specific port? It's in whatever directory you installed FreeTDS or the Sybase client. It should be fairly obvious by

[PHP-DB] Money to double format?

2001-03-15 Thread Julio Cuz, Jr.
Hi-- I have about 10 fields (in PGSQL) that have the MONEY format, when I edit a form they display as "$0.00" (for example), but when I do some math using those fields, PHP treats them as "$0.00" and NOT as 0.0, I've tried to use SETTYPE ($field, double), but all numbers get reset to 1. Any i

[PHP-DB] Error

2001-03-15 Thread Julio Cuz, Jr.
Hi-- When I run the following code: if($myrow = pg_fetch_array($result,0)) { echo "ok..."; } else { die(include("../sqlerror.inc")); } I get this error message: "Warning: Unable to jump to row 0 on PostgreSQL result index 2 in /html/rccd/remodel/display.php on line 27" Please help

[PHP-DB] problem loading php_oci8.dll - IIS 5-0 - PHP 4.0.4

2001-03-15 Thread "Barraud, Stéphane"
I'm trying to use oci8 to acces an oracle database. I have install PHP4.0.4pl1 as CGI on Windows2000 with IIS 5.0. When I uncomment the line extension for php_oci8.dll I get the following error message : "unable to load dynamic library d:\php\extensions\php_oci8.dll. The specified module could

[PHP-DB] ph and sybase

2001-03-15 Thread Jason LeDuc
Can anyone tell me where to find the commands like sybase connect and other such commands I compiled php with sybase. It didn't complain or give any errors. However the php web page still shows that sybase is not installed. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] DB question

2001-03-15 Thread Jon Page
PHP newbie here. I configured apache with php extensions on a Solaris system but forgot the oracle and sybase configuration options. Do I need to re-do the whole bloody apache install or is there an easier way? Any help would be appreciated. Jon Page [EMAIL PROTECTED] -- PHP Database Maili

[PHP-DB] syntax trouble

2001-03-15 Thread Marc S. Bragg
What does this mean? Parse error: parse error, expecting `','' or `';'' in /http/www/b/bidattorney.com/public_html/user/stest.phtml on line 13 -- Marc S. Bragg [EMAIL PROTECTED] Bialecki & Bragg, PC p: 610-444-7508 f: 610-444-7548 http://www.chescolawyers.com/BB "Chester County Legal Services"

RE: [PHP-DB] syntax trouble

2001-03-15 Thread Ted Rolle
Can I see line 13? Or better yet, the script? If you have the .phps source code option enabled I can view it that way -- I think. -Original Message- From: Marc S. Bragg [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 12:39 To: [EMAIL PROTECTED] Subject: [PHP-DB] syntax trouble

RE: [PHP-DB] validating checkboxes

2001-03-15 Thread Stewart Taylor
The javascript syntax is document.form_name.elements['preq[]'][indx] -Stewart -Original Message- From: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Sent: 15 March 2001 15:39 To: PHP List Subject: [PHP-DB] validating checkboxes Hello all: I have to validate that AT LEAST ONE check

Re: [PHP-DB] Missing mysql_connect()?

2001-03-15 Thread Ken Noel
I'd like to also know the answer to your problem. I get the same error. I have a plain 7.0 RH installation, Apache from the install of RH, PHP4 from the RH and mysql that I compiled. The problem I believe is that php does not know what to do with mysql. I'm trying to get it working with recomp

[PHP-DB] How to compile standalone php extentions ?

2001-03-15 Thread yavo
I've been strugling for some time now to compile php extentions as separate modules, byt I never seem to manage. I do the phpize, configure install steps but I end up with a .so file which cannot be loaded with the dl() function. can any one tell me what I'm doing wrong -- PHP Database Mailing

Re: [PHP-DB] PHP how to compare?

2001-03-15 Thread Joe Brown
No, two is a more accurate comparison. !== Although for most cases != is sufficient. ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > use just one = sign. So, > > if ($PASS != $PASSNOG) {... > > > At 01:41 AM 3/15/01 +0100, Duky wrote: >

[PHP-DB] meta tag inside php / redirect / refresh

2001-03-15 Thread Marc Bragg
Crazy after hours of syntax. How do you insert php code so that on different results, 1 or 0, a different the resulting html page is redirected or refreshed to a dfiferent url . . . . i tried: http://www.chescolawyers.com/BB/index2.shtml"> ?> to no avail. help thanx -- PHP Database Mailin

[PHP-DB] Website, Design, hosting and maintenance for only $999.00 per year

2001-03-15 Thread Netmark Desing
Warning Could not process message with given Content-Type: multipart/mixed;boundary= "Z_MULTI_PART_MAIL_BOUNDAEY_S"