Re: Re: max connections

hey, thanks for replying so soon. the max limit of files and inodes have been increased on the system. So that is not a problem. But what i really meant to ask was if mysql scales well over 1000 connections (assuming that i'm not having any external problems like the OS for instance).

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

Re: Query with multiple form fields

aply logic in the app. i. e. build the where clause from the filled in fields only: $where = array() ; foreach( $HTTP_GET_VARS as $v ) { if( '' != $v ) { $where[] = "'%$v%'" ; } } $where = implode( ' OR ' , $where ) ; $query = "select blah $where" ; This is

Re: Re: Re: max connections

thanks a million... i've got another problem that i've been struggling with for a long time now. It needs to be fixed fast.. running out of time... the problem is this - i'm using PHP to connect to mysql using mysql_connect(). The script runs fine till a certain number of users. This

Re: Re: Scaling mysql

hey, replication was ruled out coz the writes are very very frequent. and consistency of data is a very important issue. tx. vinod - Original Message -- "Jason Landry" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jason

Re: Win 2000 Not starting-SOLVED

Hi I had pored for ages over the Manual prior to posting my problem. I've solved it - all the methods given in the Manual dont apply to 2000. Manual states the various start methods etc apply to both NT and 2000. They don't, at least not for Professional. Forget the --standalone, the skip- etc

Perl/mysql.

Hello there, I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some one can send some basic structure of connecting into sql using perl and some useful links. Thanks in

configure can't find LinuxThreads

Description: When running ./configure it can't find LinuxThreads. Environment: Linux 2.0.35 downloaded and expanded LinuxThreads-2.1.3.tar.gz. It seems the tarball do not include pthread.h which "configure" looks for. How-To-Repeat:

Re: Can this query not be done in MySQL.

Hi! Sorry for the late reply, but I was away for a one week work/vacation trip to Rio. "Richard" == Richard Reina [EMAIL PROTECTED] writes: Richard Steve, Richard I never received Mr. Van Engen's response. I appreciate your response. Richard However, my question remains unanswered. If you

MyODBC

I have problem at compilation run MyODBC. ./configure --with-unixODBC=/usr/local/odbc \ --with-mysql-libs=/usr/lib/mysql \ --with-mysql-includes=/usr/include \ --prefix=/usr/local/odbc/lib make cd . autoheader /bin/sh ./libtool --mode=compile gcc

Can't locate DBI.pm in

I just trying to run the below perl script and got the following error. Any suggesstion pls. # more training1.pl #!/usr/bin/perl use DBI; $mysocket="/var/mysql.sock"; $dsn="dbi:mysql:training;mysql_socket=$mysocket"; $user="demo"; $password="demo";

Re: A newbie question

Hi By saying "mysql -u root mysql" you are telling mysql that you are going to use the database mysql which you have to use to add new users. Another way of doing it is type "mysql -u root" to log in and type "use mysql" in mysql command line. "test" is a database created by mysql by default when

MySQL for my application?

Hello all, I am brand new to MySQL. I have very limited experience with SQL type databases. MySQL appears to be a very elaborate product capable of many things. I've glanced at the documentation before writing this. I have 2 very general question to all you 'experienced' MySQL users. Question

Re: Can't locate DBI.pm in - CLOSED

Thank you all. I installed and seems working fine. - Original Message - From: "Paulus" [EMAIL PROTECTED] To: "N Sikkandar Dulkarnai" [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 8:04 PM Subject: Re: Can't locate DBI.pm in You haven't propably installed DBI. Find it at CPAN and

Index / Rank in table

Hi I'm designing a site where people can vote for their favourite albums using PHP3 to query the database. It's the first database I've 'designed', and I'm sure that there are improvements I could make to the way I have organised the data. For example, I'm looking for a way to make the

Re: Win 2000 Not starting-SOLVED

At 13:29 03/03/2001 +, Lucy wrote: Hi, Hi I had pored for ages over the Manual prior to posting my problem. I've solved it - all the methods given in the Manual dont apply to 2000. Manual The above it isn't correct, I use Win2kPro and Win2k Server on my work machine and all applies to NT

RE: Index / Rank in table

Dear Adam, I have faced the same problem a while ago and I didn't receive any kind of answer regarding doing this with MySQL in any discussion list at all. I had to create a function using PHP to do the hard job and the ranking position was created on the fly (using your example, I wouln't need

Keyword search string

Greetings, I have a table that has a column where search keywords are entered. column searchwords word1 word2 word3 ..etc Now when this column is queried for a search, I'm wonder how is the best way to evaluate matching the keywords. In the SELECT query, would I get better results if I use:

Problems building mysql++

I am trying to build mysql++, I am doing something wrong but I don't know what. I have downloaded and untar'd ungzipped mysql++-1.7.8.tar.gz into mysql++-1.7.8, run configure and then make, make install. I set my LD_LIBRARY_PATH to include the new library and then I try to run the resetdb

Re: delete

When you delete somthing... is there any way to recover the data?? mvh: Pl Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo direkte: 22 01 66 34, 906 900 62 tlf: 22 01 66 34, fax: 22 01 66 21 http://never.no - icq:103476059 ~ innhold for internett ~ Yes sir. Retype it. mvh: Bob

Re: GROUP BY problem.

Sir, look up Rand and ORDER BY in the documentation. I believe there's an example of using Rand and ORDER BY to do this. Bob Hall Thanks for the answer. but actually I'm not saying that mysql is doing wrong, I just want to know HOW can I group by codigo and then get 10 random rows of the

Re: Select problem

Hi, I having trouble working out how to get a result set similar to the following where I select from a table with Date Sales column. My specific question is can I have a column that accumulates values, if so could I have some guidance on how to express this in a select statement please.