Re: Problem with mysql++, Aborted (core dumped)

[Mr.Y.SHIVAKANT]

-Original Message-
From: Luis E. Cruz Campos <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Monday, April 16, 2001 9:37 AM
Subject: Problem with mysql++, Aborted (core dumped)


>I am trying to prove a small program of test, but when trying to execute it
>this always it throws "Aborted (core dumped)", this happens at the time of
>making the connection:
>
>It is the program:
>
>#include 
>#include 
>#include "sqlplus.hh"
>
>cchar *user="sqluser";
>cchar *pass="sqluser";
>cchar *host="Localhost";
>cchar *db="test";
>
>main () {
> cout << "Conectando...\n";
> Connection MySQL(db, host, user, pass);
> cout << "Ok.";
> return 0;
>}
>
>also i have proven with "Connection MySQL(db)" and "Connection MySQL();
>MySQL.connect();", this like "root" and "common user"
>
>i am using:
>
>redhat 7.0
>gcc 2.96
>mysql 3.23.36
>mysql++ 1.7.8
>
>Thanks for your help !!! and sorry by my english !!!
>
>--
>Luis E. Cruz Campos
>[EMAIL PROTECTED]
Where do you get this lib sqlplus.hh i dont know and what is cchar.


YOUR SINCERELY
Shivakanth


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with mysql++, Aborted (core dumped)

[Andrei Cojocaru]

I suggest you try the mySQL C API and see if that works first.

-Andrei Cojocaru

>From: Luis E. Cruz Campos <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Problem with mysql++, Aborted (core dumped)
>Date: Mon, 16 Apr 2001 12:17:40 -0400
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id 
>MHotMailBCA3BCD600CA40043191C03AC5A20E370; Sun Apr 15 21:15:19 2001
>Received: (qmail 19544 invoked by uid 7797); 16 Apr 2001 04:11:13 -
>Received: (qmail 19519 invoked from network); 16 Apr 2001 04:11:12 -
>From mysql-return-71581-acojocaru Sun Apr 15 21:16:36 2001
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm 
>(http://www.ezmlm.org)
>List-ID: 
>Precedence: bulk
>List-Help: 
>List-Unsubscribe: 
>
>List-Post: 
>List-Subscribe: 
>Delivered-To: mailing list [EMAIL PROTECTED]
>X-Mailer: KMail [version 1.2]
>Message-Id: <[EMAIL PROTECTED]>
>
>I am trying to prove a small program of test, but when trying to execute it
>this always it throws "Aborted (core dumped)", this happens at the time of
>making the connection:
>
>It is the program:
>
>#include 
>#include 
>#include "sqlplus.hh"
>
>cchar *user="sqluser";
>cchar *pass="sqluser";
>cchar *host="Localhost";
>cchar *db="test";
>
>main () {
>   cout << "Conectando...\n";
>   Connection MySQL(db, host, user, pass);
>   cout << "Ok.";
>   return 0;
>}
>
>also i have proven with "Connection MySQL(db)" and "Connection MySQL();
>MySQL.connect();", this like "root" and "common user"
>
>i am using:
>
>redhat 7.0
>gcc 2.96
>mysql 3.23.36
>mysql++ 1.7.8
>
>Thanks for your help !!! and sorry by my english !!!
>
>--
>Luis E. Cruz Campos
>[EMAIL PROTECTED]
>
>-
>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 unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with mysql++, Aborted (core dumped)

[Luis E . Cruz Campos]

I am trying to prove a small program of test, but when trying to execute it 
this always it throws "Aborted (core dumped)", this happens at the time of 
making the connection:

It is the program:

#include 
#include 
#include "sqlplus.hh"

cchar *user="sqluser";
cchar *pass="sqluser";
cchar *host="Localhost";
cchar *db="test";

main () {
cout << "Conectando...\n";
Connection MySQL(db, host, user, pass);
cout << "Ok.";
return 0;
}

also i have proven with "Connection MySQL(db)" and "Connection MySQL(); 
MySQL.connect();", this like "root" and "common user"

i am using:

redhat 7.0
gcc 2.96
mysql 3.23.36
mysql++ 1.7.8

Thanks for your help !!! and sorry by my english !!!
 
-- 
Luis E. Cruz Campos
[EMAIL PROTECTED]

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Does MySQL support sub queries ?

[Yen]

Thank you Jeremy, these really help!! I can't find the manual :D

-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 4:00 PM
To: Yen
Cc: [EMAIL PROTECTED]
Subject: Re: Does MySQL support sub queries ?


On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote:
> 
> Does anyone know whether this MySQL support sub queries?

Anyone who has checked the MySQL Manual does.

(Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html)

Jeremy


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Query failing

[List Box]

MySQL is not giving expected results in queries:

The table has a decimal field, 'tolong', with a 13 char size and 8 
decimal places.

I know from browsing that the table contains many records with 
'tolong' values less than -120, as low as -124.

The query
select * from Tiger_main
where tolong < -120;

results in no records being retrieved.   
The same query, with reference value -119.8 yeilds no
records returned.
The same query, with reference value -119.7 returns a large number
of records, including several which should have been returned by
the prior queries, with tolong values less than -120.

The table is fairly large, with over 5 million records and 500 MBytes, 
and the tolong field is individually indexed.  

The server is MySQL 3.23.22-beta-log.

Can anybody provide any insight into what the problem might be?

David Keeney


Can anybody shed any light on why MySQL

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: default password?

[Rolf Hopkins]

As mentioned, if this is a new installation, drop the -p

./mysqladmin -u root password 'new-password'

If this doesn't work, look up the manual about skip grants and then try
changing the password.

- Original Message -
From: "David Loszewski" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 23:37
Subject: RE: default password?


> as I said, doesn't work, it's all most as if I typed just ./mysqladmin
when
> I take off the -p
>
> Dave
>
> -Original Message-
> From: Cal Evans [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 14, 2001 11:27 AM
> To: David Loszewski; Guray Sunamak
> Cc: [EMAIL PROTECTED]
> Subject: RE: default password?
>
>
> take away the -p AND the password
>
> Cal
> http://www.calevans.com
>
>
> -Original Message-
> From: David Loszewski [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 14, 2001 10:25 AM
> To: Guray Sunamak
> Cc: [EMAIL PROTECTED]
> Subject: RE: default password?
>
>
> it tells me that I'm missing a command if I take away the -p
>
> Dave
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Guray Sunamak
> Sent: Saturday, April 14, 2001 3:27 AM
> To: David Loszewski
> Cc: [EMAIL PROTECTED]
> Subject: Re: default password?
>
>
> Do not include "-p". Then it won't ask you a password
>
> David Loszewski wrote:
>
> > After intsalling mysql is there a default password assigned to root?
> > I type "./mysqladmin -u root -p password 'new-password'"
> > Well, I don't know what the old/default password is deermind for the
> > american

What on earth do you mean by this?  What has f#$@& America got to do with
MySQL?


> > How do I fix it?
> >
> > thx,
> > DAVE
> >
> > -
> > 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 unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> Guray Sunamak   \\\|///
> [EMAIL PROTECTED]   \\  - -  //
> computer turtle @Samtek-Itc Ankara/Turkey  (  0 0  )
> ICQ# 73827870   -oOOo-(_)-oOOo-
>
>
>
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> 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 unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: www.kwwda.org

[Andrei Cojocaru]

I suggest PHP it's the easiest to learn.

>From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: www.kwwda.org
>Date: Mon, 16 Apr 2001 09:57:15 +0800
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id 
>MHotMailBCA39C14002A4004375CC03AC5A20AF90; Sun Apr 15 18:55:33 2001
>Received: (qmail 16753 invoked by uid 7797); 16 Apr 2001 01:48:39 -
>Received: (qmail 16739 invoked from network); 16 Apr 2001 01:48:38 -
>From mysql-return-71576-acojocaru Sun Apr 15 18:57:27 2001
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm 
>(http://www.ezmlm.org)
>List-ID: 
>Precedence: bulk
>List-Help: 
>List-Unsubscribe: 
>
>List-Post: 
>List-Subscribe: 
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-ID: <021e01c0c618$a165ec20$[EMAIL PROTECTED]>
>References: <[EMAIL PROTECTED]>
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Mailer: Microsoft Outlook Express 5.50.4133.2400
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
>
>Your first step is that you are going to have to decide what language you
>want to use: PHP, Perl, C, Java, ASP, etc..
>
>The next step is to read the appropriate manual/s for that language 
>together
>with the webserver's documentation.
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, April 15, 2001 15:01
>Subject: www.kwwda.org
>
>
> > DEAR sir,
> > I WANT TO connect mysql database to my web site www.kwwda.org.i read the
>tutorials as well still i find it difficult to understand how to get 
>started
>kindly help.
> > asif
> > www.kwwda.org
> >
> > -
> > 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 unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>-
>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 unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: www.kwwda.org

[Rolf Hopkins]

Your first step is that you are going to have to decide what language you
want to use: PHP, Perl, C, Java, ASP, etc..

The next step is to read the appropriate manual/s for that language together
with the webserver's documentation.

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 15:01
Subject: www.kwwda.org


> DEAR sir,
> I WANT TO connect mysql database to my web site www.kwwda.org.i read the
tutorials as well still i find it difficult to understand how to get started
kindly help.
> asif
> www.kwwda.org
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem - Possible Bug?

[Andrei Cojocaru]

Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am 
running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the 
same problem, I upgraded to 3.23.36 today and it had the same problem. I 
have recompiled mysql in full debug and done a stack trace and it keeps on 
crashing in mysql_select(), here they are:

trace #1:

www# cd /usr/local/mysql/libexec
www# gdb mysqld

(gdb) run --user=mysql
Starting program: /usr/local/mysql/libexec/mysqld --user=mysql
010415 19:08:47  Warning: setrlimit returned ok, but didn't change limits. 
Max open files is 1064
010415 19:08:47  Warning: Changed limits: max_connections: 300  table_cache: 
377
/usr/local/mysql/libexec/mysqld: ready for connections

Program received signal SIGSEGV, Segmentation fault.
0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, 
fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=42505217, 
result=0x92da518) at sql_select.cc:799
799   DBUG_RETURN(error);

...

(gdb) back
#0  0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, 
fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=42505217, 
result=0x92da518) at sql_select.cc:799
#1  0x808e919 in mysql_execute_command () at sql_parse.cc:1136
#2  0x809219f in mysql_parse (thd=0x824a818,
inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from 
planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and 
pfs.planetid=3647", length=137) at sql_parse.cc:2298
#3  0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828
#4  0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551
#5  0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4
#6  0xbfadcffc in ?? ()
#7  0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4
#8  0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78
#9  0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274
#10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890
#11 0x804b29d in _start ()

...

(gdb) info locals
tmp_table = (TABLE *) 0x92cc018
error = 0
tmp = 0
need_tmp = true
hidden_group_fields = false
simple_order = false
simple_group = false
no_order = false
cond_value = COND_OK
select = (SQL_SELECT *) 0x92dab20
keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, 
size_of_element = 20}
join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, 
table = 0x0, all_tables = 0x92da7e0,
  sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, 
sort_and_group = false, first_record = false,
  full_join = true, group = false, no_field_update = 76, const_table_map = 
0, outer_join = 0, send_records = 1, found_records = 2,
  positions = {{records_read = 14, table = 0x92da648, key = 0x0}, 
{records_read = 14, table = 0x92da648, key = 0x0}, {
  records_read = 3.497926695968519e-115, table = 0x92e0180, key = 
0x92d9274}, {records_read = 8.8208146916688224e-314,
  table = 0xbfaba66c, key = 0x92d9274}, {records_read = 
6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, {
  records_read = 1.9019183611868367e-269, table = 0x92d9000, key = 
0xbfaba6ac}, {records_read = 3.497926695968519e-115,
  table = 0x820d6ac, key = 0x92d9274}, {records_read = 
1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, {
  records_read = 1.9019183611868367e-269, table = 0x1, key = 
0xbfaba7e0}, {records_read = 3.497926695968519e-115,
  table = 0x820d6ac, key = 0x0}, {records_read = 
1.8993304345295969e-269, table = 0xbfaba6dc, key = 0xbfaba71c}, {
  records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 
0x92d9274}, {records_read = 3.4979266959743929e-115,
  table = 0xbfaba6fc, key = 0x92d9274}, {records_read = 
1.8993304345295969e-269, table = 0x822c4d8, key = 0xbfaba74c}, {
  records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 
0x92d9274}, {records_read = 1.8992611150717832e-269,
  table = 0xbfaba72c, key = 0xbfaba74c}, {records_read = 
1.8993304345295969e-269, table = 0x92e0198, key = 0x92d9274}, {
  records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x0}, 
{records_read = 3.4978027730273331e-115,
  table = 0xbfaba75c, key = 0x0}, {records_read = 
3.497926695968519e-115, table = 0xbfaab000, key = 0x3c}, {
  records_read = 1.8611437758736926e-264, table = 0xbfaba77c, key = 
0x43f}, {records_read = 1.8520806496858815e-264,
  table = 0x12e0198, key = 0xbfaba7cc}, {records_read = 
1.8520805311109313e-264, table = 0xbfaba7f8, key = 0x1}, {
  records_read = 3.4979266959805738e-115, table = 0x820d6ac, key = 
0xbfaba7dc}, {records_read = 1.901849041729023e-269,
  table = 0x282b11c0, key = 0xbfaba7dc}, {records_read = 
3.7004632531246594e-115, table = 0x1, key = 0x92d9274}, {
  records_read = 3.4979266959743929e-115, table = 0x822c4d8, key = 
0x92d9274}, {records

Re: Need feedback

[mysql]

Hi all,

Thanks for the feedback and based on what I read, I will be keeping the sites up for 
at least a few more months.  I would like to see decent use of the site so tell people 
about them.  That will be my determinining factor when I rethink the sites in June or 
July.  They are free and do not require one to be a list member to read or respond to 
the author.  You must be a list member to post to the list, though.

Thanks again to those that wrote me and enjoy.

David Fordham

-- Original Message --
From: "mysql" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
Date: Tue, 10 Apr 2001 23:35:41 -0400

>Hi all, 
>
>I have had this website that captures the list email messages and placed it into a 
>searchable db.  I did this as a learning exercise and think it is pretty cool but am 
>wondering if I should just shut em down.
>
>Take a look and if I get enough feedback, I will keep them running for at least a few 
>more months.  I have a PHP and a MYSQL list db, here are the URLs:
>
>http://www.summittech.com/mysqlmail.php3
>http://www.summittech.com/phpgenmail.php3
>
>They are free and I am not doing anything with the data.
>
>Let me know,
>
>David Fordham
>

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Redirecting Outfile

[Tonu Samuel]

On 14 Apr 2001 16:55:51 -0300, Brian Cassidy wrote:
> Redirecting file output (for user bpc) with a command such as
> select * into outfile 'home/bpc/test.txt' from table
> gives the error ERROR 1: Can't create/write to file
> "/home/bpc/test.txt" (Errcode: 13). The documentation
> recommends setting parameter tmpdir. I have RedHat 7
> with MySQL 3.23 and so I added file /home/bpc/.my.cnf
> with the parameter tmpdir=/home/bpc but that did not
> fix the problem.


[tonu@x3 tonu]$ perror 13
Error code  13:  Permission denied
[tonu@x3 tonu]$ 

Something is wrong with permissions, not directory names.

   Tõnu


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Too many sleepers?

[Tonu Samuel]

On 14 Apr 2001 23:30:51 -0400, Gary Huntress wrote:
> I've noticed, by doing "show processlist", that a few users end up with
> dozens (sometimes 50) sleeping processessome are 4 hours old.   What is
> this typically caused by?   I believe that most of my users connect using
> php, and I believe that if they omit mysql_close() that the connection is
> supposed to be closed automatically when their script ends.
> 
> Are there other situations that would lead to this many ancient sleeping
> processes?


Don't worry about them These are prorably PHP or something other
persistent connections and MySQL drops them in case of inactivity in 8
hours.
 
   Tõnu


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

compiler problem with C++ API

[mysqlweenie]

Hello,

When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling 
the following example:

#include 
#include 
#include 
#include 
#include 

int main()
{
Connection con("stw");
return 0;
}



I always get the following errors related to the mysql_com.h header file:

Configuration: connect - Win32 Debug
Compiling...
connect.cpp
c:\mysql\include\mysql_com.h(117) : error C2208: 'unsigned int' : no members defined 
using this type
c:\mysql\include\mysql_com.h(117) : error C2501: 'fd' : missing storage-class or type 
specifiers
c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(159) : warning C4800: 
'unsigned int' : forcing value to bool 'true' or 'false' (performance warning)
c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(172) : warning C4800: 'int' : 
forcing value to bool 'true' or 'false' (performance warning)
c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(176) : warning C4800: 'int' : 
forcing value to bool 'true' or 'false' (performance warning)
c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(180) : warning C4800: 'int' : 
forcing value to bool 'true' or 'false' (performance warning)
c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(184) : warning C4800: 'int' : 
forcing value to bool 'true' or 'false' (performance warning)
Error executing cl.exe.

connect.obj - 2 error(s), 5 warning(s)

Any ideas for a solution?

Thanks,
John


-

20 email addresses from 15,000 domain names - free at http://www.another.com

Wear a designer label -- your own!  Your email or web address on a t-shirt for only 
9.99:
http://www.clickandbuild.com/cnb/shop/another



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't build mysqlgui-1.7.5

[David Relson]

At 11:42 AM 4/15/01, Sinisa Milivojevic wrote:
>David Relson writes:
> > Greetings,
> >
> > mysqlgui-1.7.5.tar.gz appears to be missing source files.  Here's the
> > output when I try to make it.
> >
> > [relson@osage mysqlgui-src-1.7.5]$ make
> > make: *** No rule to make target `edfile.o', needed by `mysqlgui'.
> > Stop.
> >
> > I've checked and there are source files corresponding to each of the
> > OBJS targets, except for edfile.o
> >
> >
> > David
>
>
>Hi!
>
>edfile.o is from fl_editor source distro. When you build fl_editor,
>just coy that object file to mysqlgui directory.
>
>
>Regards,
>
>Sinisa


Sinisa,

I have fl_editor-0.4.1, which I downloaded, configured, and built 
today.  There is no edfile.o.  I have run command 'find . -name "edfile.*"' 
to locate it and found nothing.

David

David Relson   Osage Software Systems, Inc.
[EMAIL PROTECTED]   Ann Arbor, MI 48103
www.osagesoftware.com  tel:  734.821.8800


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Auto_Increment

[Roel Vanhout]

On Sun, Apr 15, 2001 at 08:20:10PM +0100, Jamie S Buchanan wrote:
> And what exactly are myISAM and ISAM tables?

http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Table_types

> (a quick web search gave me: -the Information centre for South African Music
>-the Institute for the Study of American Music
>-International Swimwear and Active Market)

LOL yeah that's a great help :-)

cheers,

roel

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqlgui: help.

[mario . lat]

I tried mysqlgui:
mysqlgui-linux-static-1.7.5]$ ./mysqlgui

but it didn't works well:
It can't connect to mysql.
Why?
How can I do to connect  for example to a database called "visia" with pw 
"pw_visia" from an user called "rino" in "localhost"?

mysqlgui ask me a password: what password it want?


Tank you in advance, Mario.

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Propagating a Table

[Aigars Grins]

> ... my problem is I want 3 images to appear in any one row in the table.
> Subsequent images I want to start in the next row down, subject to a limit
> of 3 and so forth.

Some naive and simplistic 'pseudo' code:



int current = 0, max = 3;

print_table_row_start();
while (sql_row = get_sql_rows())
{
if (++current > max)
{
print_table_row_end();
print_table_row_start();
current = 0;
}
print_table_entry(sql_row, current);
}
print_table_row_end();



Another approach could be:



create table images (
id int not null primary key auto_increment,
image 
);

select a.image as first, b.image as second, c.image as third
from images as a
left join images as b on (a.id = b.id+1)
left join images as c on (a.id = c.id+2);



In this case you should skip all rows but every third when outputting. That
could be mitigated with a group_id column of sorts in the images table
together with a group by expression.
(A sql guru can propably tell you how to do this without a group_id column)

--
Aigars

Bait: MySQL, SQL



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Auto_Increment

[Jamie S Buchanan]

Hello, I wonder if you can help me.

For a university project I've got a database with several tables using columns 
set up with 'auto_increment'. I've discovered that the value that the system 
creates for a new record is one greater than the largest one which has existed 
even if the records with the largest values have been deleted.  I've read the 
docs and read the part which says that this is the way myISAM tables handles 
auto_increment and that ISAM tables create a value which is one greater than the 
largest value currently existing.

>From this I've presumed that I'm using myISAM tables but is there any way I can 
make the auto_increment feature work the way it does with the ISAM tables?

And what exactly are myISAM and ISAM tables?
(a quick web search gave me: -the Information centre for South African Music
 -the Institute for the Study of American Music
 -International Swimwear and Active Market)
 
Thanks for any help you can give me,
Jamie.   


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to get average value for top n records?

[René Tegel]

select sum(a)/3 from atable order by record_id desc limit 3;

- Original Message -
From: "Kevin Xin Lin" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 9:04 PM
Subject: how to get average value for top n records?


> Hi, if I have a table with only one field A like this:
>
> record#1: 2
> record#2: 3
> record#3: 2
> record#4: 4
> record#5: 6
> record#6: 8
>
> How to write a sql statement to retrieve the average value of field A
> for the last 3 records?
>
> Did I make sense here? Thanks for help.
>
>
>
>
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to get average value for top n records?

[Kevin Xin Lin]

Hi, if I have a table with only one field A like this:

record#1: 2
record#2: 3
record#3: 2
record#4: 4
record#5: 6
record#6: 8

How to write a sql statement to retrieve the average value of field A
for the last 3 records?

Did I make sense here? Thanks for help.





-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Propagating a Table

[Steve Lowe]

Hi,

I have MySQL 3.23.xx and PHP4

I am using a code to return images that puts them in a table.

The search works fine. It selects an image and returns it fine.

However, when more that one image is returned:.

... my problem is I want 3 images to appear in any one row in the table. 
Subsequent images I want to start in the next row down, subject to a limit 
of 3 and so forth.

All I can manage to return is 1 row of x images or 1 column of x images.

Can any one advise me on the correct approach?

Thanks,
Kindest Regards,

Steve Lowe


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Bug fix for FreeBSD and other non-Linux users of InnoDB (= Innobase)

[Heikki Tuuri]

Hi!

The performance problems some users reported on FreeBSD for InnoDB
may have been caused the signal 14 bug already known for the Solaris
port.

The fix and a patch file for 3.23.36 can be found at www.innobase.fi.

This is fixed also in upcoming 3.23.37 which may be out on Tuesday.

Happy Easter,

Heikki Tuuri
Innobase Oy

(Bait for the mailing list spam filter: SQL, MySQL)


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problems with configure

[André Estel]

Hello,

i mail you from germany, so please excuse my "special" english! I just want
to compile mysql 3.23.36 under Debian Potato for use with PHP(classic LAMP).
But get the following error:

configure:8016: checking for tgetent in -lncurses
configure:8035: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c
-lncurses  -ldl -lz -lcrypt -lnsl -lm  -lpthread 1>&5
/usr/bin/ld: cannot find -lncurses
collect2: ld returned 1 exit status
configure: failed program was:
#line 8024 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char tgetent();

int main() {
tgetent()
; return 0; }
configure:8054: checking for tgetent in -lcurses
configure:8073: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c
-lcurses  -ldl -lz -lcrypt -lnsl -lm  -lpthread 1>&5
/usr/bin/ld: cannot find -lcurses
collect2: ld returned 1 exit status
configure: failed program was:
#line 8062 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char tgetent();

int main() {
tgetent()
; return 0; }
configure:8092: checking for tgetent in -ltermcap
configure:8111: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c
-ltermcap  -ldl -lz -lcrypt -lnsl -lm  -lpthread 1>&5
/usr/bin/ld: cannot find -ltermcap
collect2: ld returned 1 exit status
configure: failed program was:
#line 8100 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char tgetent();

int main() {
tgetent()
; return 0; }
configure:8139: checking for termcap functions library

But ncurses is installed, but i dont know where to get termcap!

Please help and thanks a lot

André Estel

-- 
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Outer and left join definition

[Bob Hall]

>bob...
>
>your example does not appear to work for me.  maybe i'm missing
>something?  i created two tables simply as:
>
> create table test1 values (id int);
>
> create table test2 values (id int);
>
>and populated them with some matching and non-matching data.  however,
>when i run the query:
>
> select test1.id, test2.id from test1 left join test2 using id;
>
>i get the following error:
>
> You have an error in your SQL syntax near 'id' at line 1

Sir, it's not a good idea to trust the syntax of anything I've posted 
unless I specifically say that I've run it on my machine. I'm very 
absent-minded.

In this case I was only trying to provide a more or less generic 
example of a LEFT JOIN, not a syntactically correct example of a 
MySQL SELECT statement. By pure luck, the only thing missing is a 
pair of parentheses. I've just run the following on my machine, and 
it works.
select test1.id, test2.id from test1 left join test2 using (id);

On the other hand, the following does not work:
create table test1 values (id int);
I checked the on-line manual. (Ah ha! The fine manual! We can look in 
the manual get answers to syntax questions! Why didn't we think of 
that sooner!?) I can't find anything that suggests that you can use 
VALUES in a CREATE TABLE statement, so I think you probably used
create table test1 (id int);
which is what I used.

Gee, we solved both problems by using the manual. Dr. Pangloss was 
right; this really is the best of all possible worlds!

(Sorry. It's Sunday morning and I'm feeling really silly.)

>any ideas?

Never. I'm not allowed, according to my last date. She said "Don't 
get any ideas." It's not working, though. I've been idea-free for 
weeks, and she still isn't returning my phone calls.

Bob Hall

>
>
>Bob Hall wrote:
>  > SELECT table_a.id, table_b.id
>  > FROM table_a LEFT JOIN table_b USING id;
>  > would return something like
>  >
>  > table_a.id table_b.id
>  > __ __
>  > a  NULL
>  > b  b
>  > c  c
>  > d  NULL

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't build mysqlgui-1.7.5

[Sinisa Milivojevic]

David Relson writes:
> Greetings,
> 
> mysqlgui-1.7.5.tar.gz appears to be missing source files.  Here's the
> output when I try to make it.
> 
> [relson@osage mysqlgui-src-1.7.5]$ make
> make: *** No rule to make target `edfile.o', needed by `mysqlgui'. 
> Stop.
> 
> I've checked and there are source files corresponding to each of the
> OBJS targets, except for edfile.o
> 
> 
> David


Hi!

edfile.o is from fl_editor source distro. When you build fl_editor,
just coy that object file to mysqlgui directory.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How to install mysql-3_23_36-win OR mysql-3_23_36-win-src?

[Gerald R. Jensen]

Rosy:

The source code (src) is for those who wish to compile and install their
own. Unless you know what you are doing (and have the compiler/development
tools), forget the source.

You want the binary version, which is mysql-3_23_36-win (about 9.6mb). Just
unzip it, run the SETUP.EXE, and read the manual. The program will install a
current manual, or you can read online ... but read the manual.

Gerald Jensen

- Original Message -
From: "rosy jariwala" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 8:03 PM
Subject: How to install mysql-3_23_36-win OR mysql-3_23_36-win-src?


> Hi !
>
> I want install mysql server on my laptop which runs windows98 OS.
> On the mysql.com site, I found two different zip files of the version
> 3.23.36 to download:
>
> mysql-3_23_36-win
> mysql-3_23_36-win-src
>
> It seems the first one is a compiled version and second one is source
> version.
> I do not know the difference between this two and I would really
appreciate
> it if you can help me install a mysql server on my notebook.
>
> Thanking you in anticipation,
> Rosy Jariwala.
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't build mysqlgui-1.7.5

[David Relson]

Greetings,

mysqlgui-1.7.5.tar.gz appears to be missing source files.  Here's the
output when I try to make it.

[relson@osage mysqlgui-src-1.7.5]$ make
make: *** No rule to make target `edfile.o', needed by `mysqlgui'. 
Stop.

I've checked and there are source files corresponding to each of the
OBJS targets, except for edfile.o


David

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Outer and left join definition

[Kris Gonzalez]

bob...

your example does not appear to work for me.  maybe i'm missing
something?  i created two tables simply as:

create table test1 values (id int);

create table test2 values (id int);

and populated them with some matching and non-matching data.  however,
when i run the query:

select test1.id, test2.id from test1 left join test2 using id;

i get the following error:

You have an error in your SQL syntax near 'id' at line 1

any ideas?


Bob Hall wrote:
> SELECT table_a.id, table_b.id
> FROM table_a LEFT JOIN table_b USING id;
> would return something like
> 
> table_a.id table_b.id
> __ __
> a  NULL
> b  b
> c  c
> d  NULL

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Help!!

[Don Read]

On 15-Apr-01 ªüÂ× wrote:
> $result=0;
> $query="select * from users where user_id='$user_id'";
   // why fetch all the fields to test an "exists" ?

> $result=mysql_query($query,$link);
// where's the test, in case it failed ?

> if(mysql_fetch_row($result)) $result=1;
 // ^^^ you just trashed your result set
> else $result=0;
 //  ditto

> 
> I use the function of "mysql_fetch_row()" in register2.php
> and it's output is the follow list:
> 
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/shin/public_html/register2.php on line 27 
> 

---

// assumes the $link is valid !?!

function user_exists($user_id) {
global $link;

$query="select * from users where user_id='$user_id'";
$result=mysql_query($query,$link);
if (! $result)
die ('' .mysql_errno() .''.mysql_error() ."\n");

$cnt = mysql_numrows($result);
return($cnt);
}

function user_exists2($user_id) {
global $link;

$query="select count(*) as cnt from users where user_id='$user_id'";
$result=mysql_query($query,$link);
if (! $result)
die ('' .mysql_errno() .''.mysql_error() ."\n");

$row=mysql_fetch_object($result);
return($row->cnt);
}

 
Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: www.kwwda.org

[Yusuf Incekara]

try
http://www.avukatpro.com/mysql.html

mysql & asp section. if you use asp


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 10:01 AM
Subject: www.kwwda.org


> DEAR sir,
> I WANT TO connect mysql database to my web site www.kwwda.org.i read the
tutorials as well still i find it difficult to understand how to get started
kindly help.
> asif
> www.kwwda.org
>
> -
> 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 unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php