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:
h
$result=0;
$query="select * from users where user_id='$user_id'";
$result=mysql_query($query,$link);
if(mysql_fetch_row($result)) $result=1;
else $result=0;
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 My
On Fri, Apr 13, 2001 at 04:46:54PM -0400, Cary Collett wrote:
>
> I'm 2/3 of the way to getting my daisy chained replication
> working.
>
> Here's my set up
>
>
> Machine 1:
> Compaq Proliant 6000, RedHat Linux 7, mysql 3.23.36, 1 NIC, 2 IPs
>
> server id 1 bound to IP 65.64.51.104
> server
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
su
>Hello,
>
>I am a translator with quite a good knowledge of programming and of
>HTML/CGI/Perl/Apache and many other web related topics.
>
>I am translating part of a book on PHP and, for the reasons
>above, I have had no problems so far.
>I am having problems however, in translating a short sectio
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 kno
On Thu, 12 Apr 2001, Dennis Gearon wrote:
> Date: Thu, 12 Apr 2001 15:16:42 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: relationship/field design
>
> I have a table design question, looking for tips, not the exact sql to
> create the tables.
>
> I have tri
Hi,
thanks, but "-V" shows 3.23.36 and there are no underscores in dbnames!
Martin
-Ursprüngliche Nachricht-
Von: Tomasz Szymczak [mailto:[EMAIL PROTECTED]]
Gesendet: Samstag, 14. April 2001 00:13
An: Martin Bringe
Betreff: Re: unusable mysqlshow and mysqldum under 3.23.36
12 kwiecień
since the outfile is being written as the user that owns the mysqld
process you'll need to make sure that, that user has write access to the
location specified.
Brian Cassidy wrote:
>
> Redirecting file output (for user bpc) with a command such as
> select * into outfile 'home/bpc/test.txt' from
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
Hello,
I am a translator with quite a good knowledge of programming and of
HTML/CGI/Perl/Apache and many other web related topics.
I am translating part of a book on PHP and, for the reasons
above, I have had no problems so far.
I am having problems however, in translating a short section where,
Open your datasource (via control panel/ ODBC datasource administrator) and
make sure the option "Change BIGINTcolumns to INT" is checked. This will
correct your problem with "show table status" and "show processlist"
Regards,
Gary "SuperID" Huntress
You can use MS SQL's Scripting tool to produce the table structure, but MS
SQL's scripts need to be massaged a bit before you can use them with MySQL
to create the database.
The data is another story. MS discontinued the 'DUMP' command after SQL
Server 6.5 (it is in 7.0 for backward compatability
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
Can't MS SQL export to an "SQL Script?" I imagine it would be a simple
matter of cat'ing said script and piping it into the MySQL CLI client.
(Are you on a UNIX box?)
On Fri, 13 Apr 2001, AJ wrote:
>
> Does anyone know any good source of info for the conversion of MS Sql
> databases to MySql
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 inclu
Actually, we are looking to do just the same thing for a pretty large
database. We've come across a project at sourceforge that claims to do
this (upsize bcp) and will be investigating how well it works next week.
Sourceforge page is http://sourceforge.net/projects/upsize-bcp/.
On Fri, 13 Apr 2
HELP!
I want to get the result of "show table status" into a ADO2.6 Recordset.
But the result of my query is EMPTY. But only in VB6. When I use the
"admndemo.exe" program it works.
Note:
"show status" works perfektly, only "show table status" and "show
processlist" makes trobble...
I need the i
I've having a HORRIBLE time compiling this new version of MySql. Can
someone please tell me what could be wrong?
I have upgraded glibc to 2.96 per recommendations on the website, with
no
change in results.
Here is the error I get
6 -DDBUG_OFF -c my_error.c
my_error.c: In function `my_error':
Troy
[EMAIL PROTECTED]
"I do not understand what I do, for what I want to do I do not do but what I
hate I do"
Rom 7:15 NIV
- Original Message -
From: "WHSSB/ERNE/POSTMASTER" <[EMAIL PROTECTED]>
To: "N6REJ" <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 17:26
Subject: Mail failure
>
Fist of all thank you for your help!!!
Sorry, but I disagree with you.Record is inserted correctly in database.
The only problem is that Resultset remains empty after RS.Update.
Any solution how to get Id of that inserted record without using MySQL
specific solution?
Thanks all!
Simon
--
UTF-8 is just another encoding scheme.
You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even
CHAR), however you cannot do much more with it beyond storing.
Comparisons aren't likely to work, character-length calculations will
not work, etc. So if all you wanna do is store and retri
Sofiane Sakhri writes:
> Hello,select ... in (select ) dosn't work, can I
> return the second query in array and use it in the
> first?
> Thanx
Yes, you could.
SELECT ... WHERE column IN (1,2,3,4,5);
You have to fix it in your application.
Most of the nested selects, like yours above can
xuan li writes:
> Hello all, When I use mysql_create to create the struce to access table,
> I have a question about the BOLB type.
> My table defined as follow:
>
> drop table ClipBoard; #4-13
> create table ClipBoard( # added 4-12 xuan li
> id INTEGER NOT NULL,
> data blob,
> primary key
N6REJ writes:
> I've having a HORRIBLE time compiling this new version of MySql. Can
> someone please tell me what could be wrong?
> I have upgraded glibc to 2.96 per recommendations on the website, with no
> change in results.
> Here is the error I get
> 6 -DDBUG_OFF -c my_error.c
> my_error.c
Just a quick note about RecordCount. RecordCount only returns the number of
records or rows from the recordset that have been 'seen'. Therefore it is
only reliable if you have traversed the entire recordset before calling it.
I agree, however, that direct SQL calls will generally produce a more
Hi!
New version of mysqlgui, version 1.7.5 has been released at it's usual
place.
An excerpt from readme for this version :
Regarding bug fixes, foremost of all, some of FLTK widgets have been
updated, which has caused some changes in mysqlgui source code. Some users
have reported problems w
Unfortunately, it doesn't seem like all ADO methods and properties and
supported when working with MySQL. Update, as you know, is one of them,
along with others like RecordCount.
I would recommend using a connection object and then passing an SQL
statement to run. If need be, you can add the resu
MyOdbc Silent Install is available for download at:
http://www.avukatpro.com/mysql.html
Regards
Avukatpro Limited Sirketi
Stupid Robot :) database mysql vb asp
the 'integers' you insert as key are too big to fit in the size of a
integer.
mysql replaces such a big or small integer by the biggest or smallest value
possible.
if you look closely at your query, you see that the key returned by mysql
are not the same values as you inserted.
you have to: or cha
Hi,
On Sat, Apr 14, 2001 at 11:53:52AM +0200, Filip Trojan wrote:
> In the following example I created simple table with two-column primary key ID,IDT.
>After some inserts there came insert with ID, IDT values, that are not equal to none
>of the previous couples, but MySQL still reported error
Dear MySQL experts
In the following example I created simple table with two-column primary key ID,IDT.
After some inserts there came insert with ID, IDT values, that are not equal to none
of the previous couples, but MySQL still reported error "Duplicate entry". In the
lines below there is sou
Hello!
I am using mysql with VB ADO under Windows 2000 Proffesional.
I add data with:
RS.Open "Query WHERE 0=1", Cn, , , adCmdText
RS.AddNew
RS.Fields(Cols).Value = xx
.
RS.Update
After RS.Update RS.Fields(Cols).Value is NULL.
If I use Access database, RS.Fields(Cols).Value has value of las
Well I have managed to rewrite alot of my coding from MS SQL in a downward
and more portable style using MySQL and ASP. I too have now hit apon where
I need to have Sub queries on some basic searching of products. Rather than
just telling people "the manual says..." that Sub Selects are missing,
On 13 Apr 2001 07:30:23 -0500, Das Lekha wrote:
> Could you please let me know whether MySQL database can be used with QNX
> Neutrino Realtime Platform ? If so, what version?
I believe we do not have such version of MySQL. But if this platform
have decent threads and compiler we can try to make
On 13 Apr 2001 18:02:19 -0400, bryan wheelock wrote:
> Is a more complex single query going to run faster on a server than
> several smaller queries where the results are set to variables and then
> used as criteria in tertiary queries.
Usually yes as you do not have network and parsing overhead
Hello,select ... in (select ) dosn't work, can I
return the second query in array and use it in the
first?
Thanx
___
Do You Yahoo!? -- Pour dialoguer en direct avec vos amis,
Yahoo! Messenger : http://fr.messenger.yahoo.com
---
On 14 Apr 2001 09:56:41 +0200, Andreas Iwanowski wrote:
> Hi
> My PHP Websites all terminate with that error:
>
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255
>
> I already set User rights,
Hi
My PHP Websites all terminate with that error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255
I already set User rights, but what can i do against that.
On my CGI modules that error occurs:
I
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
> How d
41 matches
Mail list logo
