Query with multiple form fields

The following query SELECT * from $database WHERE title LIKE '%$title%' OR quotation LIKE '%$quotation%' does not work as desired, if one of the two query fields in the HTML form stays empty. How do I do this query properly, leaving the user the opportunity to narrow the search by filling in a

Installing and starting with Linux

ql/server.pid I try to find something in the Reference manual but couldn't find how to solve the problem. What can I do that I can start mysql? Where can I search form problems? Best Regards, Georg Salvenmoser. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

updateString from OOo

ble (13, 856) Resultset.updateRow() msgbox Resultset.getString (6) Resultset.close() Statement.close() Verbindung.close() End Sub What I can try to solve the problem? When I try it with an dBase Database it works. Thanks Georg Salvenmoser PS.: Please see http://qa.openoffice.org/issues/show_bu

Replication problem

e have a better idea how to set up such a scenario? Bye, Georg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication problem

Hi, On Wed, Apr 21, 2004 at 06:35:53PM +0200, Mechain Marc wrote: > Add this in your my.cnf slave file: > > slave-skip-errors = 1062 Ahh, that's what i was looking for. Seems as if i had not read chapter 6 of the documentation thoroughly enough... Thanks, Georg -- MySQL Genera

Re: LIMIT clause

two numeric arguments. The arguments must be integer constants. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is

Re: Where is 4.1 source

On Thursday 21 November 2002 12:58, Daniel Kiss wrote: > Hi all, > > Where can I download MySQL version 4.1 source code? http://www.mysql.com/doc/en/Installing_source_tree.html Regards Georg - Before posting, ple

Re: question about mysql_real_escape_string()

length is < 2 * strlen(from) + 1 you can change the size via realloc. Regards Georg Filter:mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: question about mysql_real_escape_string()

variable in the my.cnf/my.ini file. I > prefer the latter: mysql_real_escape_string ist a client_side function, so in this case there is no communication between client and server (the charset information is stored on the client side too (in mysql->charset)

Re: Tuning MySQL Server Parameter

take > forever to finish even on the indexed attribute. Before you change some server parameters, you should analyze your join query with EXPLAIN SELECT yourquery. Regards Georg - Before posting, please check: http://www

Re: weird auto increment behaviour (bug???)

is calculated as MAX(auto_increment_column)+1) WHERE prefix=given-prefix. This is useful when you want to put data into ordered groups. Regards Georg > Hi all, I have recently encountered some strange (to me) behaviour with an > auto > increment column. It resulted because of an ove

Re: 4.1 Download

On Friday 20 December 2002 14:14, Anthony W. Marino wrote: > Where/how can I get a copy of 4.1? > Thanks, > Anthony > > http://www.mysql.com/doc/en/Installing_source_tree.html Regards Georg filter: mysql, query -

Re: multiple database connection

diffrent output > all the database and table are exsists > Any good reason why do want to have multiple connections in a script to the same host with same user/pw? Also read the php documentation which describes the syntax for multiple connections to the s

Re: Sorting order in latin1 broken

For the correct sorting you need another charset (latin1_de or german1). Regards Georg filter:mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: Why "unsigned" doesn't work?

On Sunday 29 December 2002 15:06, Octavian Rasnita wrote: > > mysql> create table aaa(id int not null unsigned, name text); > > Can you tell me why doesn't it work? > null can't be signed or unsigned. try int unsigned not null Regards

Re: Initiating secure connection to MySQL4 from PHP

On Monday 13 January 2003 17:49, Tonu Samuel wrote: Hi, Currently PHP's mysql extension doesn't support SSL. This will be available in PHP 5. Regards Georg - Before posting, please check: http://www.mysql.com/

Re: [PHP] MySQL 4.0 + PHP 4

ot to remove a constant. SSL support will be available in PHP 5 (new mysql extension). Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the lis

[Announcement] for PHP and MySQL 4.1 Users/Testers

ation within the next days. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Re: install MySQL

OS X. Thanks a > lot. > Installing MySQL on MacOS is describted in manual section 2.6.5 http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Mac_OS_X Georg - Before posting, please check: http://www

Re: mysql_fetch_array

On Tuesday, 12. February 2002 03:22, [AFQ]T1T4N wrote: G'Morning! Put an echo mysql_error(); behind your mysql_query statement and check error ouput. > > >include("config.inc"); > $db = mysql_connect($servidor, $usuariodb, $password); > mysql_select_db($base,$db); > ?> >$result =

Re: Error codes

y out the error > code corresponding to that message. maybe you're looking for http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_errno ?! Regards Georg - Before posting, please check: h

Re: error messages

ile. To explain your errorcode numbers, use perror errornr to display errormessage. Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: install MySQL

OS X. Thanks a > lot. > Installing MySQL on MacOS is describted in manual section 2.6.5 http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Mac_OS_X Georg - Before posting, please check: http://www

Re: errno: 138

> <---snip---> > mysql> select * from customers; > ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) > <---snip---> http://www.mysql.com/doc/p/e/perror.html Regards Georg -

Re: mysql not using indexes if select * where a <> 5

On Thursday, 21. February 2002 12:46, Natalino Picone wrote: > Hi, > I found that mysql doesn't used indexes if there is a <> in the where > statement... > for example > mysql> explain select * from testtable where id <> 5; It would only make sense to use an index, when you want to select the id

Re: Help Restoring a MySQLdumped database...????

;yourdb" 2) mysql -uuser -ppassword yourdb < yourdump.sql Thats all Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: MySQL php - assigning date variables

to include all dates between > 1995-01-01 and 1998-12-31? don't use LIKE for your statements. With LIKE '%$query%' you can't use an index too. USE >, < and = instead! e.g. SELECT fields from tab

Re: Beginner needs help

sert 2 or more records with one insert statement, that isnt allowed, and therefore the syntax error. Regards Georg mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

Re: Quotation Marks in Mysql fields

you have to do is to escape your quotation marks: " => \" or ' => \' Regards Georg sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Re: Number of working hours in a month.

rticular > month? Has anyone do it before? Thats really not the way to calculate the working hours in mysql. You can do it in PHP, or if you really need it within a query, write an UDF/NF for. Regards Georg - Before postin

Re: mysql task scheduler

ot; (windows) commands to start tasks/programs which do some database operations. Regards Georg sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Query structure puzzle

table or other values in status. Try SELECT status, count(*) from yourtable group by status to see if there are any other values in status. Regards Georg sq, query - Before posting, please check: http://www.mysql.com/manual

Re: is this a mysql Bug ?

this number you substract. When dealing with dates use the Date/Timefunctions described in the Manual. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Importing .sql files into database.

On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote: Would the command by mysql -u > username -p password < dbname filename.sql(mysql) > No, just use mysql dbname -uusername -ppaswwod < filename.sql Re

Re: site search

howstuffworks.com/search-engine.htm Maybe its easier to use an existing engine/code like mnogosearch. Regards Georg (mysql, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: Why queries only the first SELECT statement

lem. Go to php.net and read the documentation -> comparison operators. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: automating mysql command

On Thursday, 14. March 2002 15:13, Andrew Hazen wrote: > Can I just write the mysql commands as a .sql file and tell Unix to > execute it? Or is there another way? When you already use PHP, why don't use php-cli and execute it via cron?! Reg

Re: GETTING STARTED !!

On Friday, 15. March 2002 09:32, Sammy Lau wrote: > > 2. How to check if mysql server is up ? > > [Sammy] trying to connect the mysqlserver is the best way to do the job. Try: ps -ax | grep mysqld or mysqladmin ping Re

Re: remote connect

r run mysqladmin flush-privileges to tell the server to reload the grant tables?! Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: Insert from select

On Saturday, 16. March 2002 09:26, David McInnis wrote: > I think that I saw a similar query last week some time but I cannot > remember the sql syntax. Is it possible to insert from a select. See http://www.mysql.com/doc/I/N/INSERT_SELECT.html Regards

Re: white background

ore take a look here : http://www.php.net/flush Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

Re: Difference between Max

Am Montag, 18. März 2002 13:58 schrieb Alexander Burbello: > I would like to know, what difference between the version mysql and > mysql-max. > > I don't found anything about. > take a look on http://www.mysql.com/downloads/mysql-max-3.23.

Re: environment variable code fails

orrect place for PHP specific questions. For php questions post to the PHP Mailinglist ([EMAIL PROTECTED]). Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Date and SQL statement

for equal to or less? > SELECT columns FROM table WHERE date > DATESUB(CURDATE(), INTERVAL 30 DAY); For a detailed description see: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Regards Georg (mysql, query) -

Re: keeping given order in resulset

name from table where id in (5,3,7) > > AND that mysql orders the results the way I gave into the 'IN(...)' clause > ? Hi Mickael, you can use the find_in_set function e.g. select id,name from table where find_in_set (id, "5,3,7"); But you can't order them

Re: Tables stops at row 126

inyint has a range from -128 to 127. If you have more rows than 127 use unsigned tinyint (0..255) or int. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: MySQL Myths Debunked Revision 5

d implement this?! Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To u

Re: copying field x to field y for each record in table

Am Mittwoch, 3. April 2002 18:10 schrieb Chuck Barnett: > Hi, how do I do the following: > > I have a table I have added a new field to, I want to take field X and copy > it to the new field for each record. What should this query look like? > UPDATE yourtable set newfield=x

Re: access sql statement

On Thursday, 4. April 2002 20:16, Rw wrote: > > http://www.abc.com?select * from test > > Thanks. MySQL is not a web server. But you can use a scripting language like PHP or Perl in combination with a web server and MySQL to do this. Re

Re: Table statistics

ther languages like C, Perl, Python, ... which all supports MySQL. Finally a little note about your PHP Code: Did you ever heard about mysql_free_result ?! Regards Georg - Before posting, please check: http://www.mysql.c

Re: Table statistics

thout any webbrowser. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PR

Re: SQL Question...

work. > http://www.mysql.com/doc/D/a/Date_and_time_functions.html There is a sample how to use TO_DAYS function. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: MySQL UDF questions

say, a multi > dimensional array? Or do I need to write some stringify function for the > UDF to return? UDF functions can return STRING (char *), INTEGER (long) OR REAL (double). Please read the Manual: http://www.mysql.com/doc/A/d/Adding_UDF.ht

Re: MySQL UDF questions

On Thursday, 11. April 2002 10:26, Fei Chen wrote: > Dear Georg, > > > * notation. Just as normally I can say > select * from myTable; > can I write a UDF to handle > select my_udf(*) from myTable; ? > There is the builtin function > select count(*) from myTable; > B

Re: Cannot set auto-increment value to a specific number

a > solution.. > > Is there some way to manually set the auto_increment or not??!!!? Its not recommended to change the auto_increment field, this could be a reason for inconsistent databases. If you need some logic order, inser

Re: Poor Manual [Was: Why using filesort here?]

quot;This was added in version " string some > place. Thats right, but often you can't find this information with the first view. A little note under the function name, like in the PHP-Manual, would be easier to use. Just my 2

Re: Fatal Error: Call to undefined function: mysql_connect()

supports MYSQL ? Go to www.php.net or some of the mirrors. The rpm-package has integrated mysql-support. Or download the source-tarball and compile it. The libmysql is integrated in the tarball to. Regards Georg (query,mysql) ---

Re: >>> MYSQL ERROR-NO.0 <<

As a "webmaster" you also should know, which chars you shouldn't use in Mailaddr Names. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Best book on MySQL

quot;the bible" Newriders ISBN 0.7357.0921.1 Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

Re: How do i add an attachment

ight mailing list for your question. Depends on which language do you use (C, Perl, PHP, Python,...) you should send your question to one of the lang-ml's. Georg - Before posting, please check: http://www.mysql.com/

Re: VERY Urgent!

> faster and produce less load? Hello, first take a look of the SHOW STATUS Output and analyze them. Maybe you have to change your values, or if you have slow queries, optimize your queries. Regards Georg - Before postin

Re: Error code 28

or description use perror perror 28 Error code 28: No space left on device So maybe you should delete some stuff on your disks or buy a new one. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php

Re: Password=password('mypassword')

but that only checks if user exists and doesn't check for the correct password... Same here, quote the username and set the Password field in the where clause. Regards Georg mysql,query - Before posting, please check: h

Re: Adding new users

On Monday, 13. May 2002 07:06, Todd Cary wrote: Hi, > However this does not work in a script: > > mysql_connect("209.204.172.122", "root", "mypassword"); > > What am I missing? W

Re: Password=password('mypassword')

sword('mypassword'); > returns correct result... of course this works, password('mypasswd') returns a value, so its always true. > > mysql> select * from access where UserID='myusername' and > password('

Re: Dateformat

Monday January 3d is week 1) Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PRO

Re: Comparing UNSIGNED and INDEXED columns with negative numbers

IRC, the behaviour without indexes has been fixed in the 4.x version > (to be also an unsigned comparison). No, its still the same in 4.x Regards Georg mysql,query - Before posting, please check: http://www.my

Re: MySQL statement problem

s giving me an > empty set - but there definitely matches. I even did a LIKE instead of =, > takes longer, but comes out the same. I triple checked the data, and it is > *exactly* the same! You should check your data again! Georg -

Re: building tree view in mysql?

On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, > > How can I get MySQL to sort it like that? I tried to use group/order by, > but I cannot get it to sort it this way.. > > Any ideas? For trees you need self joins. Regards Georg

Re: Location of header files - RPM

he configure option --with-mysql. Just use the php built in client library, the include files should be located somewhere under /usr. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: How do I uninstall a MySQL source installation on Linux ?

n like in any other makefiles. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL

Re: MySQL 4

ve. > Thank's in advance. if you need features like cache queries and some other things, you should switch. We run MySQL 4.0.1 in a production environment, with 200q/sec without any problems. All the few bugs we detected are reproducable in 3.23.x or caused by bad design/codin

Re: what is wrong with php?

gt; Linux configuration problem? > It looks like a configuration or network problem. PHP uses the mysql-client library too. Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://list

Re: Undo query in mysql

or BDB you can use "ROLLBACK" Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAI

Re: MySQL dump/recovery probable bug

g should be ok. See also: http://www.mysql.com/doc/R/e/Reserved_words.html Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

Re: SELECT COUNT

according > to mysql ? where as "SELECT COUNT(*) FROM " is ? > > What's with this blank between COUNT and ( ? If you want to use blanks between function names and left parenthesis you have to start the mysql damoen with option --ansi. In this case all your function

Re: Hardware Planning

EXPLAIN SELECT ... statement. Regards Georg mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

Re: Does Yahoo Use MySQL?

ql.com/articles/us/yahoo_finance.html Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTE

Re: lost connectioin error!!

ect... > Connection id:1 > Current database: xoops > Looks like your query is too slow and you will get a timeout. Add an index to type and mid (or if possible a multi-column index) and try it again. Regards Georg -

Re: Mysql C API problems

atoi, atol, atof depends on the type, to convert it: if ((row = mysql_fetch_row(results)) != NULL) { tempo = atoi(row[0]); } Regards Georg mysql, query - Before posting, please check: http://www.mysql.com/manual.php (t

Re: saving modified image to blob

On Saturday, 29. June 2002 15:10, andy wrote: Hi Andy, What shows mysql_errno after mysql_query?! Why you don't use mysql_real_escape_string (or mysql_escape_string for PHP Version < 4.1.1) instead of addslashes?! Regard

Re: Root pass

1046: No Database Selected > mysql> 1) select the database with "use mysql" before, or specify mysql.user as table 2) Quote testpassword: ... =password('testpassword') Regards Georg ---

Re: Query Optimization

On Monday, 8. July 2002 12:37, Arul wrote: > Hi All > > The Query below took around 175 Secs to return 22 Rows..Any way this query > can be optimized > For analyzing your problem, you should send your table definition and an output of the EXPLAIN statement. Regards Geor

Re: replace query

On Wednesday, 10. July 2002 18:13, Anil Garg wrote: Hi! > I tried to do it with the replace query but being a newbie to mysql i > couldnt find the right syntax. > Can someone help. > http://www.mysql.com/doc/U/P/UPDATE.html Re

Re: UDF: Funcion definida por el usuario

On Monday, 15. July 2002 15:28, Daniel BI wrote: > Hola listeros :) Hola! please write in english, or use the spanish mailing list ([EMAIL PROTECTED]) Thx Georg - Before posting, please check: http://www.mysql.

Re: Default created date field

On Monday, 15. July 2002 16:51, Shawn Poulson wrote: Hi, > I'm having trouble doing this in MySQL, but it keeps complaining. All I > have to work on is: > create table mytable ( >createddate datetime not null default now() > ) > Just use timestamp instead datetime.

Re: Calculating weeks

On Monday, 15. July 2002 20:28, Paul W. Reilly wrote: Hello Paul, maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer your question (Function week() ) Regards Georg > Trying to count weeks! I am doing a personal accounting system in > php/mysql. I have a

Re: MyISAM v. InnoDB

On Monday, 15. July 2002 22:46, Chris Boget wrote: > > Of the data? Or of the queries? > Not the data. Just your query, the output from explain and a create table statement. Regards Georg - Before posting, ple

Re: LOAD DATA in LOCAL

On Tuesday, 16. July 2002 08:55, [EMAIL PROTECTED] wrote: Hi, > Before posting, please check: >http://www.mysql.com/manual.php (the manual) http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html Regards Georg -

Re: Mysql wil lnot load

13: Permission denied So you have to change the file privileges, or you should run mysqld under another user. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://list

Re: copy question

On Wednesday, 17. July 2002 18:07, Vivian Wang wrote: > Can mysql copy from table1 to table2? > Yes, if table t2 doesn't exist you have to create table2 first. Then you can use INSERT .. SELECT STAMENT. http://www.mysql.com/doc/I/N/INSERT_SELECT.html Regards Georg

Re: using a php page to reboot linux

Pls help, > Yes, its possible. But this the mysql-list, send you php-questions to [EMAIL PROTECTED] Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: proces to blockade

hard to say, when we don't know anything about your query and your table structure. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

Re: Installation Problem

On Friday, 19. July 2002 07:03, Dexter S. Tan wrote: Hello Dexter, would be interesting to know the content from your config.log file. Regards Georg mysql,query - Before posting, please check: http://www.mysql.com

Re: Very basic bug: Respecting NOT NULL?

+--+ > > | 1 | | X | -00-00 00:00:00 | 0.00 | > > ++--++-+--+ > 1 row in set (0.00 sec) I don't understand your question. None of the columns has a NULL Value. NULL ist not "" (empty string

Re: Installation Problem

m was: > #line 1932 "configure" > #include "confdefs.h" Hi Dexter, Hmm.. looks like that you have specified CC=gcc -03 ?! Should be gcc -O3 (Letter O, not zero). Regards Georg mysql,query - Before p

Re: MySQL Errors -

fter that). > > 020722 8:55:45 read_key: Got error 127 when reading table > './wahse/keywords' perror 127: 127 = Record-file is crashed see http://www.mysql.com/doc/R/e/Repair.html how to fix that. Regards Georg

Re: How to use LAST_INSERT_ID() or mysql_insert_id() ?

phpinfo(), MySQL 3.23.32 and PHP 4.0.5 on Win2K > with IIS 5.0. I recommend to upgrate your MySQL and PHP-Version. Regards Georg mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Crashing under high load

is why is the load so high? I hope you already analyzed your system, your mysql-server and your queries and can could give us some more additional information. Regards Georg - Before posting, please check: http://www.mys

Re: Speed !

d help to give you an answer. Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To

  1   2   >