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:
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
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:
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
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
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:
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
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
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.
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 field A
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
... 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:
code
int current = 0, max = 3;
print_table_row_start();
while (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
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', needed by
Hello,
When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling
the following example:
#include iostream
#include winsock.h
#include windows.h
#include iomanip
#include mysql++
int main()
{
Connection con("stw");
return 0;
}
I always get the
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
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
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
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
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 iostream.h
#include iomanip.h
#include "sqlplus.hh"
cchar *user="sqluser";
cchar
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
-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
28 matches
Mail list logo