RE: PHP Question

2002-04-11 Thread Andreas Frøsting
Hi, Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Why? As you say, it's not in any way related to MySQL. reload the page and postthe message again! doh! Anyways, has anyone come up against a similar problem and found a way around

RE: phpMyAdmin issue + looking for php/mysql websites

2002-03-26 Thread Andreas Frøsting
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the

FW: RE: phpMyAdmin issue + looking for php/mysql websites

2002-03-26 Thread Andreas Frøsting
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query Gaah.. Hi, I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header

RE: server startup error on linux

2002-03-21 Thread Andreas Frøsting
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and

RE: server startup error on linux

2002-03-21 Thread Andreas Frøsting
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and

Sub-select look-alike?

2002-03-13 Thread Andreas Frøsting
Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with

RE: Sub-select look-alike?

2002-03-13 Thread Andreas Frøsting
Hi Greg, SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; I really need to get some sleep I think. So simple, and yet my buggy mind didn't come up with that solution. Thanks, //andreas (sql, query - just to

RE: databases under users dir

2002-03-09 Thread Andreas Frøsting
Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and

RE: order by date error!!!

2002-02-27 Thread Andreas Frøsting
But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to order the new format incorrectly, because I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!! I normally do this: SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as

RE: Warning: mysql is deprecated???

2002-02-17 Thread Andreas Frøsting
Hi, Warning: mysql is deprecated; use mysql_select_db() and mysql_query() instead in (rootPath here)\cart\admin\addcategoryresponse.php on line 7 [snip] What does depricated mean? I have searched the manual and the resources online but cannot find anything about it. Does it mean that

RE: Warning: mysql is deprecated???

2002-02-17 Thread Andreas Frøsting
It means something is out of date...looks like you need an update of something... This is the line 7 that it is talking about How do I know what is out of date and how to fix it? Are there any utilities out there for updating scripts or do I need to manually go into each .php file

RE: Warning: mysql is deprecated???

2002-02-17 Thread Andreas Frøsting
mysql_select_db($DBName); mysql_query(SELECT Date,BuyerID,OrderNumber FROM Buyers) How do I assign the variable to both of those lines that make up the DB call??? Unless you're planning to use several databases, you only have to use mysql_select_db($DBName); once, normally where you

RE: Error untarring MySQL on a RAQ3

2002-02-16 Thread Andreas Frøsting
tar -xvfz mysql-3.23.32.tar.gz tar: Cannot open z: No such file or directory tar: Error is not recoverable: exiting now Any Help? Should there be a z: directory? And where? Try: tar zxvf mysql-3.23.32.tar.gz z = gzipped x = eXtract v = verbose f = file You had a 'z'

Unique index/primary key case-insensitive?

2002-02-15 Thread Andreas Frøsting
Hi there, I'm having som difficulties trying to figure out MySQL's unique indexes and primary keys. Case: mysql create table flaf (lala varchar(20) not null, unique(lala)); Query OK, 0 rows affected (0.00 sec) mysql insert into flaf VALUES ('hest'); Query OK, 1 row affected (0.00 sec)