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
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;
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:
s
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
O
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 t
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 so
>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
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 -rdyna
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 East
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.
Subsequ
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.
-
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 fie
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 wit
> ... 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_row
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 passw
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
>
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', neede
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 he
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 belie
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 sett
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
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
cr
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: <[EMAI
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
>MHotMailBCA3
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 P
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 <
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,
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=
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
-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
30 matches
Mail list logo
