On Thu, 19 Apr 2001, Doug Schasteen wrote:
>
>
> 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
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.
===
Duke,
Long time no chat. How are you?
Try having a look at this link:
http://www.gslis.utexas.edu/~l384k11w/normover.html
which gets absolutely useless as soon as you hit 3 rd normal form, so
scroll down to the puppies example later in the article, "AnOutline of
Normalization" by Marc Rettig.
> 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
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,
To use ODBC from PHP/Linux to a Win32/MSSQL server you will need to link an
ODBC Driver Manager into your PHP build.
There is a complete HOWTO on this at: www.iodbc.org, where you will also
find the open source iODBC Driver Manager.
Fabrizio is correct, however - you will need to alter your mssql
Jason,
To my knowledge there is no Linux ODBC driver for Filemaker.
One architectural workaround is to 'piggyback' a connection from your Linux
box onto the Filemaker driver.
OpenLink's Multi-Tier driver will do this, but you will need a third tier
box in the middle.
e.g.
Note: I imagine Fil
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 reg
> -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 regi
> 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 rec
> -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 can
I have this error
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(111)
what appening?
AND I CANT connect to mysql for html page why??
I'm comming crazy!
--
---
-= franky =-
[EMAIL PROTECTED]
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
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
becky the code below is spot on (nearly)
stick it on a form that calls itself change the ';
echo 'Choose a Region';
for ($s=0; $s<$numregs; $s++)
{
$reglist = pg_fetch_array($regs,$s);
echo''.$reglist["region
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 PROTECT
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"" <
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 y
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
The MSSQL extension works fine with SQL Server 6.5, 7.0 and 2000.
What type of errors are you getting ?
- Frank
> Why the mssql_connect don't function with mssql server 2000 ?
>
> Bye
> Gian Luca
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL
At 06:45 19-4-01 -0500, johndmiller wrote:
>I just looked at my mysql.sock file and it has a length of zero. Is this
>the right size, I don't think it is. If not, do I have to reinstall MySQL
>to get the file back or can I get it from somewhere else.
Length of zero.. thats perfectly normal.
By
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 f
Hi,
I have a login form that uses the POST method so variables don't get shown.
After I log in, I can go to another page, but if I hit the Back button to go
back to the "successfully logged in" page, I get an error that says that the
page has expired. If I refresh the page, it will load the page f
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 th
-- 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
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
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
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,
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,
>
--
.--
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
th
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, e-
I am having problem with PHP4 session variables. I think I misunderstood how
they work, and I can't see what I'm doing wrong. Any help would be
appreciated. I am using the version from EasyPhp 1.1.1.
Below is a short example to explain my problem. I've got two php scripts.
'test1.php' which start
32 matches
Mail list logo
