[PHP-DB] Re: mysql -- Commercial DBs, When will I need to upgrade?

2001-04-23 Thread Jon Valvatne
On Thu, 19 Apr 2001, Doug Schasteen wrote: snip 1. At what point will mysql blow up (how many tests could be taken at once? How many rows of results could be stored in a table before it bogs down?) MySQL will not blow up because of large amounts of data. Provided your database design and

[PHP-DB] MS-SQL Server on PHP4/Apache/Linux

2001-04-23 Thread Manuel Prieur
Hello, I currently use PHP4/IIS to access a MS-SQLServer 7.0 with mssql_* functions (php_mssql70.dll extension). I plan to move my website on PHP4/Apache/Linux, and I am wondering if thoses functions will work and how, as I didn't find any explanations on it in documentation. Thanks.

Re: [PHP-DB] MS-SQL Server on PHP4/Apache/Linux

2001-04-23 Thread fabrizio . ermini
I currently use PHP4/IIS to access a MS-SQLServer 7.0 with mssql_* functions (php_mssql70.dll extension). I plan to move my website on PHP4/Apache/Linux, and I am wondering if thoses functions will work and how, as I didn't find any explanations on it in documentation. I think the

Re: [PHP-DB] Designing a database

2001-04-23 Thread Duke Normandin
I want to thank *everyone* that sent me a reply on this matter. Trouble is you guys' messages were so good that I have to study the suckers first before I know if I need to ask for further clarification. So I might be back in a couple of days ;) Thanks a bunch, guys! Later -- -duke Calgary,

[PHP-DB] How I can use multiple results in MySQL

2001-04-23 Thread Yevgeny Dyatlov
Hello, I'm cann't using query to MySQL like this: SELECT name FROM cia WHERE region = (SELECT region FROM table WHERE name = 'Brazil'); And SELECT name FROM table WHERE count = (SELECT max(count) FROM table); I want to select COLUMN_NAME in TABLE where ID is max, how I can do it? -- Best

RE: [PHP-DB] How I can use multiple results in MySQL

2001-04-23 Thread Mark Roedel
-Original Message- From: Yevgeny Dyatlov [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 8:05 AM To: PHP-DB Subject: [PHP-DB] How I can use multiple results in MySQL I'm cann't using query to MySQL like this: SELECT name FROM cia WHERE region = (SELECT region FROM

Re: [PHP-DB] How I can use multiple results in MySQL

2001-04-23 Thread Sigitas Paulavicius
SELECT name FROM cia WHERE region = (SELECT region FROM table WHERE name = 'Brazil'); would be: SELECT cia.name FROM cia, table WHERE cia.region=table.region AND table.name='Brazil' SELECT name FROM table WHERE count = (SELECT max(count) FROM table); if there may be more than one record

RE: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-23 Thread Mark Roedel
-Original Message- From: Klaus Haberkorn [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 6:18 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Supplied argument is not a valid MySQL result resource... Looks like many reasons cause this error-message, but I cannot find

Re: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2001-04-23 Thread B. van Ouwerkerk
At 09:35 24-4-01 -0400, franky wrote: I have this error Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) take a look in this lists archive. THis question has been answered over and over and over.. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] calling a column into a popup

2001-04-23 Thread Beckie Pack
That's almost it. I want to populate the menu automatically from the database without having to manually modify the HTML. I believe the below will pull the data but it doesn't modify the menu in HTML. I tried a few things like using the variable name as the same as the co_name but the menu always

RE: [PHP-DB] calling a column into a popup

2001-04-23 Thread Steve Brett
becky the code below is spot on (nearly) stick it on a form that calls itself change the option name= to option value= and when you refresh the form $company will contain the comany name. you can also use selected in the folowing manner $regs = pg_Exec($conn, select region_id,

Re: [PHP-DB] calling a column into a popup

2001-04-23 Thread Johannes Janson
So a certain company is previously selected? And then you want to populate the form with the info of the company? to do this link the menu with a onChange action to a display page. But I'm not sure if I get the layout. Could you describe it again? Cheers Johannes Beckie Pack [EMAIL

Re: [PHP-DB] Problem with session vars !

2001-04-23 Thread Yasuo Ohgaki
It not related to database. Anyway, If you use $HTTP_SESSION_VARS, forget about session_(un)register(). (Do not use them) Just use $HTTP_SESSION_VARS. It's known issue. (If you use global vars, only use global vars and use session_(un)register()) Regards, -- Yasuo Ohgaki Nicolas Guilhot

Re: [PHP-DB] calling a column into a popup

2001-04-23 Thread Beckie Pack
yup, now i realize it is a form calling itself with a php doc. i feel like a dufus(sp?). i didn't recognize the echo as opposed to print so I didn't see the html coming. learning php, mysql, and database design all together. it's kinda fun, given time for a project you know. thanks to both of

[PHP-DB] PostgreSQL7.1: It's worth to upgrade.

2001-04-23 Thread Yasuo Ohgaki
Hello PostgreSQL users, I'm testing PostgreSQL 7.1 and PHP4.0.4pl1 on Linux. It's really worth to upgrade. Besides PostgreSQL 7.1 supports any size of text, WAL, many bug fixes, better pg_dump/restore, etc. PostgreSQL 7.1 can provide more backends on the same box. A box, which could set to max

[PHP-DB] Insert Variables Into A Passed String

2001-04-23 Thread SOHH.com Webmaster
Hey, I'm trying to figure out how to make a custom message. What I have is a form with a TEXTAREA named MAILFROM. I want to be able to write an e-mail in that section like so: Dear $username. When I press submit, I want the query to cycle through a list of names (got this part) and where it

[PHP-DB] trouble reading a database (fwd)

2001-04-23 Thread johndmiller
Below is the output and code for my problem. When the database gets read, it returns 0 rows. When it writes, it says it can't because of duplicate entry. FLD_FileName and FDL_Path are the Primary key. Two questions, what I am doing wrong and is there a better way to create a string of text

[PHP-DB] RE: [PHP] trouble reading a database (fwd)

2001-04-23 Thread johndmiller
-- Forwarded message -- Date: Mon, 23 Apr 2001 20:19:57 -0500 (CDT) From: johndmiller [EMAIL PROTECTED] To: Jason Murray [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP] trouble reading a database (fwd) Thanks for the pointer about ' vs . I have changed my code to

[PHP-DB] db read

2001-04-23 Thread johndmiller
I am new a database stuff. I am using mysql 4.0.1 with php on RH7.0. I am setting up a db with three fields with no-one field being unique. Do I have to have a unique field? The purpose of this db is to store a word, name of a file, and path to the file. My plan is to use a where clause, but I

Re: [PHP-DB] db read

2001-04-23 Thread php3
Addressed to: johndmiller [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from johndmiller [EMAIL PROTECTED] Mon, 23 Apr 2001 20:37:49 -0500 (CDT) I am new a database stuff. I am using mysql 4.0.1 with php on RH7.0. I am setting up a db with three fields with no-one field

[PHP-DB] Need php page to upload files

2001-04-23 Thread Hector M Banda
Hi all, I need a basic php page to upload files containing information to later import them into my server. Can somebody point me to a simple site where I can get one? Thanks,

Re: [PHP-DB] Need php page to upload files

2001-04-23 Thread Jason Morehouse
http://www.php.net/manual/en/features.file-upload.php On Mon, 23 Apr 2001, Hector M Banda wrote: Hi all, I need a basic php page to upload files containing information to later import them into my server. Can somebody point me to a simple site where I can get one? Thanks, -- .--- .-

[PHP-DB] Weird error connecting to Sybase

2001-04-23 Thread Billy
Hi all, I recently compiled Apache with PHP4 and have configured PHP4 to enable Sybase. I used FreeTDS for that. Everything compiled fine and the Apache server runs fine. I added the right info in the interfaces file and a program like sqsh runs fine. When I try to connect to a Sybase database

Re: [PHP-DB] Weird error connecting to Sybase

2001-04-23 Thread Billy
Sorry. My configuration was a bit messed up. I'm not Billy ;-). Thanks. Paul -- Paul van GoolOpenwave Systems, Inc. [EMAIL PROTECTED] (805) 957-1790 x572 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,