Re: [PHP-DB] extract() expects first argument to be an array

2003-01-17 Thread Paul Burney
on 1/17/03 7:02 PM, Addison Ellis at [EMAIL PROTECTED] appended the following bits to my mbox: > Warning: extract() expects first argument to be an array in > /users/infoserv/web/register/ca/new_account.php on line 82 > $result = mysql_query($sql) > or die("Couldn't execute query 1

[PHP-DB] extract() expects first argument to be an array

2003-01-17 Thread Addison Ellis
hello, i have received the following error message and don't know what to do to correct it. i have tried several things but what i have tried does not work. i will post my code below the error message. thank you for your time. best, addison ellis Warning: extract() expects first argument to be

RE: [PHP-DB] SUM(colname)

2003-01-17 Thread Aaron Wolski
Select SUM(colname) as newColName FROM SomeTable WHERE value='value'; Reference the 'newColName' as your variable. Aaron -Original Message- From: Cesar Aracena [mailto:[EMAIL PROTECTED]] Sent: January 17, 2003 2:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] SUM(colname) Hi all, I'm tr

[PHP-DB] MSSQL + PHP incredibly slow

2003-01-17 Thread Joey Smith
We've been using PHP hosted on a win32 machine to connect to SQL Server 2000. When the PHP host and the MSSQL host are the same machine, everything is fine. But when we try to use seperate hosts for PHP and MSSQL, query times become unbearably slow. The odd thing is that I can run the same scrip

[PHP-DB] SUM(colname)

2003-01-17 Thread Cesar Aracena
Hi all, I'm trying to add all the values from the same column in MySQL with a query like this: SELECT SUM(colname) WHERE value = 'value' But then I can't output it on the screen correctly. I've tried to put all the results into an array and then make an array_sum($arrayname) and it gives me exac

[PHP-DB] Excel ODBC connections

2003-01-17 Thread Micah Stevens
Hi, I have a gig right now that the client wants me to connect to an Excel spreadsheet that contains the data for the website. It's a real low-traffic area, but I do know that these types of connections only can handle a few connections at a time. My question is, does anyone know what the maximu

Re: [PHP-DB] Recursive SQL Expression?

2003-01-17 Thread Paul Burney
on 1/16/03 7:12 PM, Alan McFarlane at [EMAIL PROTECTED] appended the following bits to my mbox: > I've a small problem working out the best method of reading data from a > mySQL database with PHP... > > The table is a simple self-referential table constructed (loosely) as > follows: > > cat_id

[PHP-DB] Problem with declarations

2003-01-17 Thread Jon Miller
I run a script and I get a error message stating I cannot redeclare a function. Another issue I do not understand while DWMX is putting in 'Connections/addrbk.php' when I do not have have this as a path or anything of the sort on the server. I have to constantly go in and change this. If the

Re: [PHP-DB] SELECT problem

2003-01-17 Thread Larry E. Ullman
    Hello PHP world!!! i've just finisched installing Apache 1.3.27 with PHP4 and 1.4 in Windows 2000. I've installed all off the scripts that function all right in Linux Red Hat in Windows 2000, but when it comes to do a simple select to a table that does exist and the select is all right ther