Re: give me a sample to print out to printer

2002-02-12 Thread Teddy A Jasin
Maybe you can try find the application at hotscripts.com. regards, Teddy -- experience the online learning commmunity at http://www.mycyberclassroom.com At 08:32 AM 2/7/2002 +0700, Franky Aniversarius wrote: >when i click the icon client1(in end client, it's show up from php >applicat

Re: select stmt problem

2001-10-24 Thread Teddy A Jasin
lue for count(*), the >number of record. >So of course you can't order by counts, it's a single value. > >On Wednesday 24 October 2001 02:43 am, Carl Troein wrote: > > Teddy A Jasin writes: > > > Hi, > > > I have this mysql statement: > > > select h

select stmt problem

2001-10-23 Thread Teddy A Jasin
Hi, I have this mysql statement: select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs where counts > 10 and datesent between '2001-09-24' and '2001-10-24' and (returncode > 0 and returncode < 10) group by hpnumber order by counts DESC and i Get this following error: Unknown column '

HELP: mysql driver error

2001-10-17 Thread Teddy A Jasin
Hi, i never found this kind of problem before. I posted on the microsoft and asp forum about the problem, but no help. Some people ask me to check with the mysql provider. anyone can help me on this?? Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation ge

Re: lost connection to mysql!

2001-10-17 Thread Teddy A Jasin
.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Teddy A

Re: mysql is really a slow rdbms

2001-02-25 Thread Teddy A Jasin
Just simple question.. why u designed it such a way that differentiate the 'thn','bln' and 'hari' field when you can do it just using one field and using DATE type field instead of integer. and when you query u can use your SQL sorting to speed up searching. Regards Teddy - Original Message

Re: mysql extremely slow

2001-02-17 Thread Teddy A Jasin
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 18, 2001 2:09 AM Subject: Re: mysql extremely slow > On Sun, Feb 18, 2001 at 01:18:04AM +0800, Teddy A Jasin wrote: > > Hi All, > > Below is the status that I got from my server's mysql server, can

mysql extremely slow

2001-02-17 Thread Teddy A Jasin
Hi All, Below is the status that I got from my server's mysql server, can anyone explain to me more on this?? and as u see here... currently mysql server is running extremely slow: mysql>show variables; ++--+ | Variable_name

Re: cannot connect to database

2001-02-17 Thread Teddy A Jasin
just do it using grant statement so that you can connect from another host. use grant to username@'%' instead of localhost - Original Message - From: "Emre Yildirim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 18, 2001 12:40 AM Subject: cannot connect to database >

returning PID

2001-02-16 Thread Teddy A Jasin
Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy

mysql takes so much resources

2001-02-15 Thread Teddy A Jasin
Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME COMMAND 24339 51.6 0.7 6876 3704 p2- R10:56AM

MySQL set up plan

2001-02-14 Thread Teddy A Jasin
Hi All, Currently I have four websites using one MySQL server. The MySQL and the four websites each is placed on different server. However this MySQL server, I dont know why after running for a few days can stop responding that I have to restart the MySQL server. This caused my four websites also

Re: external access to mysql

2001-02-12 Thread Teddy A Jasin
Hi, again phpmyadmin can do this :) Teddy - Original Message - From: "Mike Yuen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 1:45 PM Subject: external access to mysql > I and 2 others are working on a web site an occasionally. Each of us are > in d

Re: MySQL GUI for Windows

2001-02-12 Thread Teddy A Jasin
Use PhpMyadmin - Original Message - From: "indrek siitan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 11:00 PM Subject: MySQL GUI for Windows > Hi, > > can anyone suggest a good GUI client to suggest to MySQL hosting > customers? > > it should: > > * be

Re: Technical Clarification

2001-02-12 Thread Teddy A Jasin
You can save the excel file in csv format (delimited text) and upload it to mysql using load data. Or the easiest use phpmyadmin Teddy - Original Message - From: "gopinath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 7:27 PM Subject: Technical Clarificati

ISAM and MYISAM

2001-02-09 Thread Teddy A Jasin
Hi, I've read some people talking about ISAM and MYISAM table. I dont understand what are those tables and can anyone explain to me and the difference of each table. and also which one has better performance? thanks Teddy - Be

Re: Insert into blob

2001-02-07 Thread Teddy A Jasin
Hi okie heres a snippet of my php code: the code below takes a file uploaded from the web with $file as declared filename on the form. if ($file_size>0) { //check whether the file is not empty $data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and add neccessary quote

Re: cant connect to local mysql server

2001-02-07 Thread Teddy A Jasin
Are you sure u try ur mysql server already? if not start the "mysqld" Teddy soon chee keong wrote: > hi..could someone pls help me > > i had created mysql server before in my pc but this morning i discovered > that i cant access my mysql server.this is what i typed: > > shell> mysql > >

MYSQL BENCHMARKING & PROBLEMS

2001-02-06 Thread Teddy A Jasin
Hi, My website is running on MySql 3.21 and it has so much records that it sometimes stopped running and I had to restart the mysqld. My question is how do I go about benchmarking my site and the mysql server? TIA Teddy

Re: binary data

2001-02-03 Thread Teddy A Jasin
R Uploading File:".mysql_errno().": ".mysql_error()."$SQL"); } okie hope that helps! Teddy "Robert C. Paulsen Jr." wrote: > On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote: > > I have the scripts in php to do this if u want. > >

Re: binary data

2001-02-03 Thread Teddy A Jasin
I have the scripts in php to do this if u want. "Robert C. Paulsen Jr." wrote: > How can I put binary data into a MySQL database? > > I assume the data type is blob, but I don't see how I can > use SQL syntax to insert anything but text data. I would > like to include various binary files (tar f