php +newlines+mysql

I have a problem in php page: i want to insert into mysql database value $string with newlines: $string="-line1\n -line2 \n-line3"; $result2 = db_query("update table1 set column1= '$string' where ID = '$IDcurent'") or db_die(); When i try to view in a textarea control the new value from colum

ANNOUNCE: moodss-16.4

### CHANGES ### --- version 16.4 --- - added support for MySQL database server version 3.23.51 to mystatus module - added Windows support to snmp module (read snmp module documentation for required software) - in snmp module: - improved end of table detection - formatted data of time tick

Re: export table?

simplist way i know and use, is through mysqlfront www.mysqlfront.de - Original Message - From: "Chip Wiegand" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 1:11 PM Subject: export table? Where is info on exporting a table? I checked the mysql docs and

export table?

Where is info on exporting a table? I checked the mysql docs and the only reference to export has nothing to do with exporting a table. I want to copy a table from one server to another, should be simple enough, right? -- Chip [EMAIL PROTECTED] www.wiegand.org ---

Re: find record using MYSQL command in ASP

Beste Defrin... thank u very much my friend. it is work! :D Cheers... - Original Message - From: Defryn, Guy <[EMAIL PROTECTED]> To: 'Ivan Paul' <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 10:38 Subject: RE: find record using MYSQL command in ASP > Hi the

Relationship between Questions and Com_*

If I want to break down what types of queries my server is handling (INSERT/DELETE/UPDATE/etc) I can look at the Com_* values provided by SHOW STATUS. If I sum up the Com_* values I get a number much larger than the value of Questions. My guess is that this is because REPLACE executes both an INSE

RE: find record using MYSQL command in ASP

Hi there, Try this <% dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject("adodb.connection") set objrs = server.createobject("adodb.recordset") objconn.connectionstring="server=192.168.0.1;driver=

find record using MYSQL command in ASP

dear all, when i want to find some records in mysql table using ASP script language, i found an error on it. this is error message in my script: Microsoft OLE DB Provider for ODBC Drivers error '80040e29' The rowset cannot scroll backwards /find_record.asp, line 16 and this is my ASP scrip

UDF, Can anyone please help?

Hi, I've being trying for the last couple of months to convert a MS Access to Mysql. I pull out data extract from around 100 + queries. These took about 5 months of solid work to develop and are extremely complex. I can convert these to mysql, but have one big problem. There is no last functi

Re: Cannot set privileges

Thanks to Paul, I solved the problem by replacing the "*" with "*.*". In my "PHP and MySQL" book, the "*" is used in the examples. Any explanation why this does not work? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] ---

Join problem in MYSQL

sql,query Can anyone have a look at my join. It returns errors Select O.name, O.amount , P.Productname, P.price >From Orders AS O JOIN Products AS P ON O.product=P.Productid Where O.cluster= 'ANP'; It works fine when I use Select O.Name, O.amount, P.productname , P.price >From Orders as O,

MERGE & FULLTEXT, two years later.

I searched the archives and in December 2000 it did 'not yet' work. ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html ) Will MERGE tables and FULLTEXT indexes work together in 4.x? Two-and-a-half years later? Regards, -Sander

Cannot set privileges

When I log into mysql with [root mysql]# mysql -u root -p and enter the password, I have access to mysql. Then I type in grant all on * to todd identified by 'mypassword' with grant option; Now when I do a select * from users; All of the privileges for todd have N's. Have I missed somethin

Re: Deep Nesting (sql)

Beautiful. Thanks! BenO At 05:00 PM 7/7/02 -0500, you wrote: > >The tables will be used to enable users to enter comments concerning what > >they believe happens at individual conjunctions. For example, in astrology, > >let's say one enters a comment of what happens when the Moon enters > >Scorpi

Re: Installing mysqladmin

At 13:42 -0700 7/7/02, Todd Cary wrote: >Paul - > >My mistake was worse than what I thought: somehow I had renamed the Server and >Client so they both had the same RPM code. This is why my Client install was >*NOT* working. Sone days :-) !! > >I have a beginners question: how can I have mysql cr

Re: Deep Nesting (sql)

>The tables will be used to enable users to enter comments concerning what >they believe happens at individual conjunctions. For example, in astrology, >let's say one enters a comment of what happens when the Moon enters >Scorpio. These comments can then be called by other users and rated with

Deep Nesting (sql)

Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users

Re: Installing mysqladmin

Paul - My mistake was worse than what I thought: somehow I had renamed the Server and Client so they both had the same RPM code. This is why my Client install was *NOT* working. Sone days :-) !! I have a beginners question: how can I have mysql create a database in a different directory than t

Licensing--web site is schizophrenic

At one place on the MySQL site I see: http://www.mysql.com/support/arrangements.html which says the client library is under the LGPL. At another place I see: http://www.mysql.com/doc/C/o/Copyright.html which says the entire codebase, including the client, is released under the GPL. Does

Re: Installing mysqladmin

At 11:03 -0700 7/7/02, Todd Cary wrote: >My platform is RH Linux and I did a rpm with > >rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm > >I got back the acknowledgement and the suggestion that I change the root user >password with > >/usr/bin/mysqladmin > >However, mysqladmin is not on the system!! What

privileges

I'm using a MySQL and PHP4 setup that was done for me by the websites owner. I am able to run MySQL through telneting in through SSH, but I can't seem to run any MySQL through the website. Mysql_connect() seems to just hang up the browser till it times out. It doesn't give me password or user inco

Installing mysqladmin

My platform is RH Linux and I did a rpm with rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm I got back the acknowledgement and the suggestion that I change the root user password with /usr/bin/mysqladmin However, mysqladmin is not on the system!! What did I miss?? Todd -- Todd Cary Ariste Software 2

Deep Nesting

Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users

Re: MySql User Lookup

Pada Sun, 7 Jul 2002 13:04:02 -0400 "sajiddalvi" <[EMAIL PROTECTED]> menulis : > Is there a way to check which my sql user (who has logged into the database) > has inserted a row in a table? > I could add a "logged_in_user" column but that seems redundant. you can set your mysqld to log all acti

MySql User Lookup

Is there a way to check which my sql user (who has logged into the database) has inserted a row in a table? I could add a "logged_in_user" column but that seems redundant. --- Introducing NetZero Long Distance Unlimited Long Distance only $29.95/ month! Si

Re: Setting up hostname

Pada Fri, 05 Jul 2002 14:19:21 -0700 "Desmond Lee" <[EMAIL PROTECTED]> menulis : > Hi guys > > I just managed to install mysql... yippy > > But, i had to use the '--force option' when executing the > /usr/local/mysql/scripts/mysql_install_db . > > I got a message saying that i needed to confi

Re: Access denied error

Pada Sat, 06 Jul 2002 09:36:27 +0500 (IST) VINOD <[EMAIL PROTECTED]> menulis : > I own a domain with MySQL support. I have created a database > "lnet_cal" on the web and also table "yarntype", using PHP Myad- > min on the webspace and also granted all access privileges to > user "lnet_r

Re: mysqldump

Pada Sat, 6 Jul 2002 12:22:44 +0400 Papa Carlo <[EMAIL PROTECTED]> menulis : > > mysqldump incorrectly export char/varchar binary and *BLOB fields. > it export binary fields like text strings > > INSERT INTO users VALUES (7,'zk',1,'¦î¯¯Çbv','ó+:ºÐ','Ó]¦Ç\ZW¦{','T~âxÎË-','T >üc¦SüG\"R-¦Íê

Re: Need help on Matching MySQL, Apache & PHP

Pada Sat, 06 Jul 2002 15:10:43 + "duo fu" <[EMAIL PROTECTED]> menulis : > Dear Friends: > I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I > failed to install tarball versions of PHP4.21 with Apache1.3.26 under my > REDHAT 6.2. I always got the error message when I tri

Re: backup of mysql

Pada Sun, 7 Jul 2002 17:53:08 +0500 "Impex Holidays Maldives / Hasan" <[EMAIL PROTECTED]> menulis : > Hi, > > This may be out of topic,but still I'm working on a mysql back up file. > Does any one have a shell script to ftp a file to another location, so that I can >schedule to run this file wi

Re: Typing Short Cuts

I'm using MySQL 3.23.47-nt on Windows NT 4.0 Workstation ... up-arrow doesn't work and F3 only repeats from the command prompt. When I'm in the MySQL console, I'm on my own. - Original Message - From: "Patrick Sherrill" <[EMAIL PROTECTED]> To: "Paul Flint" <[EMAIL PROTECTED]>; <[EMAIL PRO

Re: Typing Short Cuts

In the command line mode of Windows(DOS sic), F3 will repeat the last command line. In current versions of mysql CLI arrow up will replay the command series. What version are you using and with what version of Windows? Pat... - Original Message - From: "Paul Flint" <[EMAIL PROTECTED]>

DBase to MySQL

I am attempting to create a link from a dbase (.dbf) database to a mysql database. Here's the description: dbase file is a file that gets updated on a daily basis. Changes to this file can be a change in a record or the addition of a record. no record is 'deleted'. Updated/new records include

Re: Typing Short Cuts

Paul: To access the previously-typed command, switch to Linux. All kidding aside, the Windows MySQL console can't do it. We work around this little issue by either commiting queries to scripts that can be piped into MySQL, or by using a GUI-based query tool. There are several (MySQLGUI, MySQL-F

Typing Short Cuts

I'm working on a win32 version of MySQL. I don't work much in DOS and do not know how to access the previously typed command so that I can edit it before executing it. I usually botch it atleast once on the LOAD DATA INFILE command and have to type the whole darn command again. I'm looking for

backup of mysql

Hi, This may be out of topic,but still I'm working on a mysql back up file. Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan - Before p

Re: How to search for backlash in a field?

* xu tom > I created a MYISAM table named 'TBLTest', > there is a field named 'value', varchar(32) binary, > I insert value in it with a backlash as 'test\ABC', > I can search the record by : value='test\\ABC', > but I cannot search it by : value like '%test\\ABC%'. select * from TBLTest where v

Re: An existing table

Give the command: alter table tablename add column column_name create_definition (section 7.7 in the mysql manual) Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] >>> Yair Zohar <[EMAIL PROTECTED]> 07/07/02 01:46PM >>> Hello, Is there

How to search for backlash in a field?

Hello, I created a MYISAM table named 'TBLTest', there is a field named 'value', varchar(32) binary, I insert value in it with a backlash as 'test\ABC', I can search the record by : value='test\\ABC', but I cannot search it by : value like '%test\\ABC%'. The SQL: 1,create the table: create tab

Re: An existing table

Yes: ALTER TABLE `tablename` ADD `columnname` datatype George - Original Message - From: "Yair Zohar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 07, 2002 11:46 AM Subject: An existing table > Hello, > Is there a way to add a column to an existing table in a mysql d

An existing table

Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: encrypting password fields

Thanks guys, Cristian also suggested that I could encrypt the password via the porgramming language I use with mysql(php,perl,etc). How could this be done? I am using the struts framework. JSPs and Java. Does this mean that I can only use md5()? cheers, Ki Mien -Original Message- Fro

backup

Hi, Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan - Original Message - From: +ACI-Gerald R. Jensen+ACI- +ADw-gjensen+AEA-autodatasys.com+AD4- To: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-h