RE: [PHP-DB] Creating an array of mySQL results with PHP

2002-03-12 Thread Shrock, Court
You don't need to apologize for being new to PHP or for not understanding what I have suggested. We all have to start somewhere. I fully understand what you are trying to do--postnuke, as well as multiple sites of my own use the method that I describe to do multiple row updates simultaneously.

Re: [PHP-DB] An interesting query that needs a different pair of eyes

2002-03-12 Thread DL Neil
Howdy John, Two things: firstly the stated objective and the sample query differ (WHERE division.leagueID???). Secondly I'm sorry that I'm short of time this morning, otherwise I'd try to develop/illustrate this for you... May I suggest that you employ the KISS principle: Start off by coding a

[PHP-DB] help php4.0.6Oracle9i !

2002-03-12 Thread varin valery
I was successful in compiling php with the options --with-oracle and --with-oci8. but when i tried to connect to the database with the instruction Ora_logon(user@tnsname, password), I got the following error message: Warning: Oracle: Connection Failed: Error while trying to

[PHP-DB] MS SQL problem with php

2002-03-12 Thread Daniel Ryhle
I run MS SQL 2000 on a win 2k machine and IIS5. On this i have installed php4.11 with php_mssql.dll support. When i do an insert query it works fine. But my problem is with SELECT querys. If i write a select query and run it on a table that is empty it works fine. BUT if i put an entry into

[PHP-DB] conflicting result problem with MySQL/php

2002-03-12 Thread George Pitcher
Hi all, I'm having a small problem with a biggish query. The query: $Itemlistquery= select [a whole load of fields from 3 tables] ending with ; $Itemlistquery.= transactions.Pdownload ; $Itemlistquery.= from bib_extract,scanrates,transactions where ; $Itemlistquery.= (transactions.CourseID =

[PHP-DB] Re: An interesting query that needs a different pair of eyes

2002-03-12 Thread John Hawkins
Hugh, Thanks so much for the very detalied explanation. You can bet I'll be saving it as reference for future projects. Your solution worked perfectly! As for the divisionID not being needed in both tables. Ultimately, you are correct. I could easily get away with connecting the tables

[PHP-DB] Fatal Error using mysql_connect()

2002-03-12 Thread mailing list
Hello, I am receiving a fatal error on a php page: Fatal error: Call to undefined function: mysql_connect() in /www/meyercousa/pages/view_data.php on line 13 My syntax on line 13 is: $db = mysql_connect('localhost', 'username', 'password'); Anyone have any ideas? Regards, Adrian Mcmanus IT

Re: Re(2): [PHP-DB] Fatal Error using mysql_connect()

2002-03-12 Thread Jason Wong
On Wednesday 13 March 2002 03:56, mailing list wrote: [EMAIL PROTECTED] writes: Looks like MySQL support was not compiled into PHP. If you are using a linux based system you need to run the configure script with the --with-mysql flag in order to utilize the MySQL function set. HTH Sam

Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()

2002-03-12 Thread mailing list
[EMAIL PROTECTED] writes: Try: -with-mysql=/usr -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence diminishes mediocre passions and increases great ones, as the wind blows out candles and fans fires. -- La Rochefoucauld */ -- PHP Database Mailing List

[PHP-DB] PLEASE HELP mysql_connect()!!!

2002-03-12 Thread Inter-Media Webmaster
PLEASE HELP !!! HOW I CAN GET CONNETCTION TO REMOTE HOST IN OTHER SERVER WITH mysql_connect(); e.g. my php file is in www.abc.com/index.php mysql server is in cgi.xyz.com on localhost PLEASE ANSWER to [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] compiling php for mysql on linux

2002-03-12 Thread mailing list
Hello, I am still recieving errors when I try to connect to my MYSQL database using php. Here is the error that is generated on the page: Fatal error: Call to undefined function: mysql_connect() in /www/meyercousa/pages/view_data.php on line 13 As instructed from a previous post I recompiled

[PHP-DB] RE: MS SQL problem with php

2002-03-12 Thread Oliver Cronk
What is the query / code that you are sending to MS-SQL in PHP? -Original Message- From: Daniel Ryhle [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 21:42 To: [EMAIL PROTECTED] Subject: MS SQL problem with php I run MS SQL 2000 on a win 2k machine and IIS5. On this i have installed

Re: Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()

2002-03-12 Thread Jason Wong
On Wednesday 13 March 2002 04:50, mailing list wrote: It compiled without any errors using -with-mysql=/usr However I still receive an error while trying to connect to my mysql database: Fatal error: Call to undefined function: mysql_connect() in /www/meyercousa/pages/view_data.php on

[PHP-DB] Iterate through the resulting rows of a single column select statement.

2002-03-12 Thread Glenn Holden
I'm looking for a reasonably simple and fast way to fill an array with the results of a single column select query. example results from query: +---+ | productid | +---+ | PS| | PSLEB | | MD1 | | CPSS1 | | CPSG1 | | CPSP1 | | CPSSR | | CPSGR

[PHP-DB] how many queries?

2002-03-12 Thread dvigil
Is it possible to find out how many queries a particular persistent mysql link has handled without keeping a separate running counter? Daniel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php