default-character-set problem

2002-11-06 Thread nick gatsis
Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49

Re: How to use comma instead dot in numeric values?

2002-10-12 Thread nick gatsis
I had the same problem. No, in MySQL you can't. But you can use number_format() function of PHP. Check PHP Manual for How-to Nikos --- Putte Koivisto [EMAIL PROTECTED] : Is there a simple solution to define MySQL to use comma instead of dot in numeric fields?

float digit

2002-09-12 Thread nick gatsis
How can i change the floating point '.' to ',' as a decimal separator in MySQL 3.23... in Linux RH 7.2? Nikos - sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr

my.ini in RH Linux 7,2

2002-09-11 Thread nick gatsis
In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? Thanx Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting,

MySQL LOGS

2002-09-10 Thread nick gatsis
Does anybody know how to make log files for each of my databases? Thanx sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please

Flash MySQL

2002-09-09 Thread nick gatsis
For the one who need help about using Flush and Mysql, there is a tutorial in the phpbuilder.com, which is enough good. Nikos --- Do You Yahoo!? @yahoo.grhttp://www.otenet.gr

Re: Unknown MySQL Server Host 'localhost' (11001)

2002-09-06 Thread nick gatsis
I've got apache in Win32 system and MySQL 3,32... intall also. As far as i know mysql admin needs a server (loclhost) to work. The ODBC@localhost apears to me when i havn't give permisions to a user to select a database. You should check mysql database where you choose permisions. Nikos ---

Re: Unknown MySQL Server Host 'localhost' (11001)

2002-09-05 Thread nick gatsis
Kevin, have you got install Apache HTTP server? --- Kevin Walker [EMAIL PROTECTED] : Hi all I've recently downloaded and installed MySQL 3.23.52 for Windows. I'm running Win95 OSR2, and Winsock2 is installed. This is a standalone PC with no web server or PHP installed on it. As per

Re: Euro sign mysql

2002-09-05 Thread nick gatsis
The html symbol for euro sign is: euro; (without quots) if that helps. Is it neccecery to insert it in the database? --- Derk van der Harst [EMAIL PROTECTED] : Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get

Re: script for complete Database dump?

2002-09-05 Thread nick gatsis
I suggest you to copy the database files. If you are the administrator in a Linux system make a cron once (for example) a week to copy this files to somwere else. --- Kai Vermehr [EMAIL PROTECTED] : is there any single MySQL script that would backup my complete database? thanks! Kai

Re: Character set

2002-09-05 Thread nick gatsis
I had the same problem with greek characters. I set field as binary and the problem corrected. --- National Theater of Greece [EMAIL PROTECTED] : Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized

Re: can't use the table. What happen, please!!!!!!!!!!

2002-08-12 Thread nick gatsis
Did you flush-privileges? --- Sandra [EMAIL PROTECTED] : Hi all, I am getting the error when trying to connect server from my client: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in . I had my tables in test database, but created a new

Re: How to separate different domains on an e-mail database

2002-08-12 Thread nick gatsis
Its a PHP function my friend. I'm using 3,23... --- DL Neil [EMAIL PROTECTED] : Nick, Explode: which version of the MySQL manual are you using? =dn - Original Message - From: nick gatsis [EMAIL PROTECTED] To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] Cc: [EMAIL

Re: PHP form to mySQL

2002-08-12 Thread nick gatsis
Check some articles in http://www.devshed.com/Server_Side/MySQL, http://www.devshed.com/Server_Side/PHP --- JeRRy [EMAIL PROTECTED] : Hi, I am trying to setup a PHP form to send to mySQL database. I know how to connect to mySQL but need help getting the information in the form to

Re: How to separate different domains on an e-mail database

2002-08-12 Thread nick gatsis
for it. If you know an other solution, i'll be happy to learn it. Cheeres --- DL Neil [EMAIL PROTECTED] : Nick, Understood - but did Carlos say that he is using PHP, and why use PHP when a more efficient/quicker MySQL solution is available? =dn - Original Message - From: nick gatsis [EMAIL

Fwd: Re: Importing into MySQL from Access

2002-08-12 Thread nick gatsis
Did you try to make an .csv file and then import it with Mysql-Front? I believe that both tables have the same structure. --- Ian Zabel [EMAIL PROTECTED] : I already have my table structure in place in MySQL, and I just want to import the data from my Access 2000 database. (the

Re: How to separate different domains on an e-mail database

2002-08-09 Thread nick gatsis
You must create an extra field in your database to store the domain. Use the explode() to seperate the domain from ...@ (array explode (string separator, string string [, int limit]) Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed

Re: Adding super user

2002-08-09 Thread nick gatsis
Try this: Use mysql tables, change or add record in user table. If you add password (and you must) use password('password'). Then flush-previleges from mysqladmin. Also, you must change host and db tables. Go to www.devshed.com and read access granted article. Cheers --- Marius Pana [EMAIL