Re: [PHP-DB] http_server_vars ???

2001-12-10 Thread Jon Niola
At 09:02 PM 12/10/2001 -0500, John King wrote: >Trying to run a php script that involves a MySQL DB. Script needs to >reference these variables: > >$HTTP_SERVER_VARS['SQL_HOST'] >$HTTP_SERVER_VARS['SQL_USER'] >$HTTP_SERVER_VARS['SQL_PASS'] >$HTTP_SERVER_VARS['SQL_DB'] These are PHP Environmental/

[PHP-DB] http_server_vars ???

2001-12-10 Thread John King
Trying to run a php script that involves a MySQL DB. Script needs to reference these variables: $HTTP_SERVER_VARS['SQL_HOST'] $HTTP_SERVER_VARS['SQL_USER'] $HTTP_SERVER_VARS['SQL_PASS'] $HTTP_SERVER_VARS['SQL_DB'] Are the above PHP variables from the server or just variables from a function? The

[PHP-DB] HELP! ODBC-->SQL Server Authentication

2001-12-10 Thread Daaron Dwyer
Hello All, I am trying to use the windows authentication of the user surfing on the database I am connecting to. I have made myself a user on the database the ODBC DSN is pointing to. Here is the script: $db=odbc_pconnect("EOSTest", "", ""); $result=odbc_exec($db,"select system_user"); odbc_res

RE: [PHP-DB] Re: Retrieving data woes

2001-12-10 Thread Andres Sulleiro
Thanks to Hugh and DL Neil for their answers. I got it working now with your help. Makes me feel dumb now! -- Andrés > > In your SQL request, sort by date. When printing the output, > keep track of the previous date - only print the date if it > changes. Something like > > $conn = my

[PHP-DB] Shopping Cart Category help

2001-12-10 Thread Chris Payne
Hey there everyone, Hope you are all doing good :-) I have a problem, I have a shopping cart system but I need to add sub-categories, how - using PHP with MySQL do I get the system to display sub-categories if they are found? I have category 1 as the main one which displays all products, but

[PHP-DB] RE: WYSIWYG HTML Editor with PHP

2001-12-10 Thread Andrew Chase
It depends on what platform and browser you expect contributors will be using to add content; ActiveX objects are only good for MSIE/Windows, while Java has a somewhat broader reach. WYSIWYG with HTML/DHTML/Javascript is klugey at best, even if it's PHP-based; PHP is great for making admin screen

Re: [PHP-DB] Retrieving data woes

2001-12-10 Thread DL Neil
Hi Andres, > I have what probably is a basic question, but can't figure out by > myself. If > any of you kind souls can point me in the right direction I would > appreciate > it. > > I have a db table that has these columns: > id, date, time, title, body > > some of the rows can have th

[PHP-DB] Re: Retrieving data woes

2001-12-10 Thread Hugh Bothwell
"Andres Sulleiro" <[EMAIL PROTECTED]> wrote in message 002001c18193$eacb4450$[EMAIL PROTECTED]">news:002001c18193$eacb4450$[EMAIL PROTECTED]... > I have a db table that has these columns: > id, date, time, title, body > > some of the rows can have the same "date" and want to output the da

[PHP-DB] Re: calculate size of remote url

2001-12-10 Thread Hugh Bothwell
"Chidambaram" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi > i have to calculate the size of a remote url > ex:http://www.ee.iitm.ernet.in/index.html > i have written a php script but it returns only > the size of html page it doesnot include the images >

Re: [PHP-DB] Problem with file upload...

2001-12-10 Thread koelwebdesign
> I already asked my provider if I have the rights to access the tmp/ file and > he says yes! but does php also have the right to put in your webdirectory? the problem is: php does not use your username and password. what I did (and I don't know if you've got the same problem), is fread all data

[PHP-DB] Retrieving data woes

2001-12-10 Thread Andres Sulleiro
Hi all, I have what probably is a basic question, but can't figure out by myself. If any of you kind souls can point me in the right direction I would appreciate it. I have a db table that has these columns: id, date, time, title, body some of the rows can have the same "date" and want

[PHP-DB] Re: how to make a dropdown list with sql content

2001-12-10 Thread Hugh Bothwell
"Venomous" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I need to make a dropdown menu from my mysql database but i don't no how to > come about > > It's the meaning that i don't get weird things in my database for instants > > PI 300 or pi 300 think about

[PHP-DB] Problem with file upload...

2001-12-10 Thread Michael
Hi to all, I'm developing a cms and need to upload an inage and a pdf-file to the server. Everything is just working fine, but when trying to upload any file I get the following error: Warning: Rename failed (Invalid cross-device link) in/www/971/html/admin/object_add.php on line 115 here's the

Re: [PHP-DB] undefined function: pg_connect()

2001-12-10 Thread Jason Wong
On Monday 10 December 2001 22:33, Michael Hanna wrote: > I'm running apache 1.3.20 with php 4.0.6 and I'm trying to connect to > pgSQL 7.1.3(OS X 10.1.1). > > I'm certain pgsql support is on..this is from my ./configure o/p: > > checking for PostgreSQL support... yes > > but this code: [snip] >

[PHP-DB] calculate size of remote url

2001-12-10 Thread chidambaram
Hi i have to calculate the size of a remote url ex:http://www.ee.iitm.ernet.in/index.html i have written a php script but it returns only the size of html page it doesnot include the images size in that file could anyone help me in this regard I have written PHP code that returns file size and ot

[PHP-DB] undefined function: pg_connect()

2001-12-10 Thread Michael Hanna
I'm running apache 1.3.20 with php 4.0.6 and I'm trying to connect to pgSQL 7.1.3(OS X 10.1.1). I'm certain pgsql support is on..this is from my ./configure o/p: checking for PostgreSQL support... yes but this code: \n", $row[0]); printf ("First Name: %s\n", $row[1]); printf ("Email : %s

RE: [PHP-DB] how to make a dropdown list with sql content

2001-12-10 Thread Leotta, Natalie (NCI/IMS)
I don't understand the second part of your question but for the first part you can use a select distinct in your SQL statement and then loop through the result to put things into a drop down box. I just printed the HTML with the var name in there and it worked well. Good luck! -Natalie > -

[PHP-DB] how to make a dropdown list with sql content

2001-12-10 Thread venomous
I need to make a dropdown menu from my mysql database but i don't no how to come about It's the meaning that i don't get weird things in my database for instants PI 300 or pi 300 thanks in advanced -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTE