first time to use MySQL on MS Platform with PHP.

Dear my friends... I am trying to develop a database application with PHP Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and Apache 2. I tried to insert a record onto my MySQL but I got this error messages. What do I have to defined to overcome this problem? " Notice: Undefined variable: product

Re: Personal Servers

Many... but try Xitami and Apache. They're great. BTW, XP? Try SuSE, far better then Windoof. --- Nicola Hartland <[EMAIL PROTECTED]> wrote: > I am not sure this is the right place for this > question but I am trying to find a personal server > that I can install on my PC, I run XP that I

Sub query on mySQL 4.0.18

Dear my friends... I don#t understand why subquery on my MySQL 4.0.18-Mas does not valid. Here what I have done. " [EMAIL PROTECTED]:~> mysql -h 192.168.23.1 -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 354744 to server version:

Re: Sub query on mySQL 4.0.18

Oooo...Oo. thank you very much for you information. I better migrate my database to postgres. I'll use MySQL back after MySQL 4.1 stable version released on SuSE Distro. --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > I don#t understand why subquery on my MySQL > 4.0.18-Mas > > does not v

Writing a database program in GNU C++ using MySQL.

Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mai

MySQL

--- [EMAIL PROTECTED] wrote: > 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,queries,smallint > > If you just reply to this message, and

MySQL

MySQL __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: MySQL

Thank you my friend.. --- Jerry <[EMAIL PROTECTED]> wrote: > http://www.mysql.com/doc/en/ALTER_TABLE.html > > - Original Message - > From: "Prabu Subroto" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 19, 2003 11:5

Displaying column name of a table from MySQL client (not PHPMyAdmin)

Dear my friend I don't want to be spoiled by PHPMyAdmin anymore. I want to get be more expert in SQL Command of MySQL. So far, everything is fine but today I realized a problem. If I want to diplay the columns of an empty table, the MySQL Client will diplay nothing such as : " mysql> select *

RE: Displaying column name of a table from MySQL client (not PHPM yAdmin)

> T: +27 021 406 3681 > F: +27 021 406 3143 > E: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > -Original Message- > From: Prabu Subroto [mailto:[EMAIL PROTECTED] > Sent: Saturday, February 22, 2003 2:00 PM > To: [EMAIL PROTECTED] > Su

Re: MySQL

Thank you very much, my friend. It is solved. Thanks.. --- Stefan Hinz <[EMAIL PROTECTED]> wrote: > Prabu, > > >> Is it possible to define Foreign Key and Primary > Key > >> of my database after the tables have been created > ? > >> If yes, how? > > Yes. Use the ALTER TABLE command for this.

re: MySQL

Thank you my friend. --- Egor Egorov <[EMAIL PROTECTED]> wrote: > On Wednesday 19 February 2003 13:58, Prabu Subroto > wrote: > > > > I did something very stupid in my development. I > > > created a database with a couple of tables...but > I > > &g

Re: What command to restore MySQL DataBase ?

Very easy... just copy paste the content of your file (from mysqldump) into your mysql-client command line. That's all. --- Somsak RAKTHAI <[EMAIL PROTECTED]> wrote: > Dear sir, >I used mysql-4.0.10-gamma on RedHat-8.0. > I used "my.cnf" from "support-files/my-large.cnf". > >When I backu

Re: problem connecting to mysqld

Of course because your MySQL engine is off. Start up your MySQL. Why not with Linux. Linux is far better than the Stupid Windows Plat form. Windows is only for a computer idiot. (but I am not meaning that you are idiot. I mean the windows). --- Ahmed Shams <[EMAIL PROTECTED]> wrote: > > I am ha

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

What does, "rcmysql status" say? --- Mark <[EMAIL PROTECTED]> wrote: > Hi, I just installed 3.23.55 and I started getting > this message when > I run mysql from the shell. > > /tmp/mysql.sock exists and the permissions are right > and mysqld is > running, also the weird thing is that php is > conn

Re: Allowing a user to change their password

I suggest you to make a special application for this operation. With three-tier architecture for example and your application ask the current passord to make sure that they are the legal user before your sql query change their password through your application. --- "Shawn P. Garbett" <[EMAIL PROTEC

Re: hi

See www.mysql.org. There you can find a complete documentation for mysql. You have a good decision to use mysql on linux. I don't believe mysql on MS. MySQL on MS is not optimal in my opinion. Sorry if I am wrong. --- Hridyesh Pant <[EMAIL PROTECTED]> wrote: > Hi all, > i am just new for MySql,ca

"mysql_fetch_row" wrong on mysql 3.23.52

Dear my friends I am trying to read the content per line of a query result with "mysql_fetch_row". But I got this error message : " Musingin homepage koneksi sukses. Sukses memilih database. Sukses melakukan query. Besar hasil query 1. Warning: mysql_fetch_row(): supplied argument is

Re: "mysql_fetch_row" wrong on mysql 3.23.52

Dear Fred... It is solved. Thank you very much, my friend. --- Fred van Engen <[EMAIL PROTECTED]> wrote: > Hi, > > On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu > Subroto wrote: > > Dear my friends > > > > I am trying to read the content pe

RE: "mysql_fetch_row" wrong on mysql 3.23.52

It is solved. Thanks Don. --- Don Read <[EMAIL PROTECTED]> wrote: > > On 30-Mar-2003 Prabu Subroto wrote: > > Dear my friends > > > > I am trying to read the content per line of a > query > > result with "mysql_fetch_row". But I got

Re: "mysql_fetch_row" wrong on mysql 3.23.52

Dear Fred. Your explanation is very complete. Thank you very much for your generousity. My problem has been solved, Thank you. --- Fred van Engen <[EMAIL PROTECTED]> wrote: > Hi, > > On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu > Subroto wrote: > > Dear my friends..

defining allowed host for mysql

I tried to connect to my mysql server but there was always an error message saying "this host is not allowed". Anybody so kind to tell me, "how can I define the hostname/computer name in my mysql server to be allowed connect to my database server and use my kmysqladmin and kmysql software". Thank

MyVbQL

Dear pals, Could anybody help me to tell me where I can download MyVbQL. I am an absolute new bie of MySQL. Please help me. I am also so glad and thank you if somebody send me the software to my mailbox directly. Thanks so much in advance. __ Do

what' about my current database if I reinstall mysql and my linux

Dear my beloved e-pals, Would you like to be so kind to answer my question ? Please.. Where is located the database of my mysql database engine...? Under which directory is my database located ? And which harddisk ? I want to reinstall my linux. I have more than one harddisk... I have to make

Kylix frustrated me...!!!

Dear Friends, I am trying to develop an application with Kylix ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux (i686). I am using MySQLConnection object to connect my MySQL database server (and with so : libmysqlclient.so.10.0.0). But I found some ridiculous problem : 1. Have setup/determ

DBGRID displays only "(MEMO)"

Hallo, I am developing a database application using Kylix ver.1 and MySQL 4.23.41-log . I can connect and execute the query but the problem is my DBGRID only displays " (MEMO) ". Some of my friends said that perhaps it is caused by the datatype of the field but I tried to change the datatype o

SQL Error : Error Mapping Failed

Hi Buddy, Anybody knows the solution of my problem ? I've written a program with Kylix 1 and MySQL 3.23 . I am using DBGRID, DBNavigator, DataSource, ClientDataSet, DataSetProvider, SQLDataSet, SQLConnection objects for my program. It queries a table an put it into DBGRID table. I am using "CHAR"

Seeking the minimum value of a DateTime column type in MySQL

Dear friends, I am developing a database application for our saleses with PHP and MySQL. Our sales must call the customers on time. They may not be late to call the customers. The may not miss the appointment to meet the customer on the telephone line. But I have a problem to implement the SQL que

Seeking minimal value of a DateTime column type in MySQL

Dear friends, I am developing a database application for our saleses with PHP and MySQL. Our sales must call the customers on time. They may not be late to call the customers. The may not miss the appointment to meet the customer on the telephone line. But I have a problem to implement the SQL que

Seeking the minimum value of DateTime column type in MySQL

> Dear friends, > > I am developing a database application for our saleses > with PHP and MySQL. > Our sales must call the customers on time. They may > not be late to call the customers. The may not miss > the appointment to meet the customer on the telephone > line. > But I have a problem to impl

selecting appontment time whose 3 minute later then now()

Dear my friend, I am using MySQL as database server. I still have problem now to select appointment time whose 3 minute difference (later) than now(). I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ? I tried this command but it didn't work : " select * from appointmen

Selecting appointment time whose 3 minutes later then now()

Dear my friend, I am using MySQL as database server. I still have problem now to select appointment time whose 3 minute difference (later) than now(). I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ? I tried this command but it didn't work : " select * from appointmen

Selecting appointment whose 3 minutes later then now()

Dear my friend, I am using MySQL as database server. I still have problem now to select appointment time whose 3 minute difference (later) than now(). I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ? I tried this command but it didn't work : " select * from appointment

SELECT....UNION SELECT.....

Hallo my friends I am writing a database application program with PHP and MySQL. I have two tables that I want to query in the same time with "SELECT...UNION SELECT ..." syntax. Too many errors encountered; the rest of the message is ignored: The 2 tables are APPOINTMENT table (APP) and SALES