Many Thanks
>
> Sunit
>
Look around http://www.php.net and http://www.phpbuilder.com for info on
PHP (a good language for interfacing with databases)
Look around http://www.mysql.com and http://www.devshed.com , among others,
for tutorials and info on using databases.
Anna
--
.. (although I did not try it!)
>
I have found this doesn't work. If $RESULT_SET is null or
equal to nothing, that means that there was a problem
with the query.
You have to use mysql_num_rows($RESULT_SET)
to find out if 0 rows were returned.
Anna
l.
the /etc/hosts content as below:
127.0.0.1 local localhost.localdomain localhost
192.168.0.99linux
192.168.0.2 anna
the 192.168.0.99is my local linux server and 192.168.0.2 is windows 98 which I
used to connect local linux and internet.
any suggestion?
th
eturn all permutations of the remaining words (a b c, c a b, b c a, etc).
Insert each of those permutations into the word table and relational table.
My question now is, this is going to get very big very fast. Should I worry
about that at all? Or as lo
WHERE categoryID='$categoryID' && packageID='2'
LIMIT $counter+$pageStart, $pageEnd
Hope this makes sense.
Anna
nce for any comments.
>
> Mariusz Brzezinski
No.
As long as you give them different names. :-)
$connectionLocal=mysql_connect(bleah, bleah, bleah);
$connectionOther=mysql_connect(bleah, bleah, bleah);
Then in any mysql_query you must, of course, specif
>- Original Message -
>From: "Linsen Limsico"
>Does anyone know how to find duplicates in a table and >deleting them. I
can't figure out how to structure the query.
>Linsen
Exact duplicates or where only
ith the slash? If you use a command like
addslashes(), the slash doesn't actually make it into the database.
You would have to add Mel\\\'nikova to get Mel\'nikova into the database.
Anna
-
Before posting, please ch
for the ID, which
according to another poster, has a maximum limit of 127.
So it can't auto_increment above the maximum limit.
Use int. It can do into the thousands.
Anna
-
Before posting, please check:
http://www.mysql.
ump: mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE="" */':
Query was empty (1065)
Can anyone help me with this problem?
Thanks!
Regards Anna Henricson
----
Anna Henricson, MSc, PhD student
Center for Genomics and Bioinformatics
ent below:
mysql> SELECT VERSION();
+---+
| VERSION() |
+---+
| 3.23.45 |
+---+
1 row in set (0.00 sec)
Can anyone help me with this problem?
Thanks!
Regards Anna Henricson
---
Anna Henricson, MSc, PhD student
Center for Genomics and Bioinfor
le handler error
code 127. But I have no idea what that means.
Has anyone experienced anything like this!? It's just to weird! I have no
idea what to do and are ready to give up and export it all to linux and
postgreSQL instead.
Anna
___
production and I'd like to put the rest in
production to, but I don't dare do that until I've found out why this db is
misbehaving.
Anna
This message was sent u
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by using joins?
Thanks very much for your help.
Anna
please tell how to get an auth code - i want to unsubscribe but i can't
without an authcode.
emailing the unsubscribe address doesn't work...i've been trying for weeks!
thanks
-
Before posting, please check:
http://www.mysql
nothing at all i'm afraid..
i think this requires a little shouting ...
PLEASE GET ME UNSUBSCRIBED OFF THIS LIST
thanks
anna
- Original Message -
From: "Brian McDonough" <[EMAIL PROTECTED]>
To: "anna soobrattee" <[EMAIL PROTECTED]>; <[EMA
emails to this list...
anna
- Original Message -
From: "Phillip Vamplew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "Arne Claassen" <[EMAIL PROTECTED]>; "Heikki Tuuri"
<[EMAIL PROTECTED]>; <[EMAIL P
get this ID? I guess I cannot use "SELECT MAX(id)
FROM Table" since old, deleted id's are reused for new rows.
Please, help me!
Regards,
Anna
-
Before posting, please check:
http://www.mysql.com/manual.ph
ls to mysql_query?
Thanks in advance for your help,
Anna Winkler
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
aorund this ?
Please write back soon!
Anna
Hi,
The username field is text and number so you I can't autoincrement a
username like "abc003434" ...
- Original Message -
From: "Mohammad Shoja" <[EMAIL PROTECTED]>
To: "anna soobrattee" <[EMAIL PROTECTED]>
Sent: Wednesday, June 1
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by using joins?
Thanks very much for your help.
Anna
but all these result in an error ... i can dump the whol database but not the table
studenttable
thanks
anna
this table will be updated very frequently - will access time degrade
severely even though i use mainly ints in this table?
thanks for your help.
anna
this table will be updated very frequently - will access time degrade
severely even though i use mainly ints in this table?
thanks for your help.
anna
d very
quicky.
has anyone got any ideas on the best way to store this information ??
thanks for your help.
anna
object is created once for the database that I'm working with
in the constructor for MyDatabase, and reused for subsequent queries.
Has anyone else tried this? Any other ways to do this? I'm using the C
API and MySQL 3.23.48 on RedHat Linu
Hi,
I tried taking out the new MYSQL, and my application dumps -- it doesn't
look like mysql_init is actually allocating memory for the MYSQL object
because then mysql_real_connect is called with a NULL pointer.
Is that supposed to happen?
--Anna
Ben Goodwin wrote:
Hi!
mysql_init
length issue).
> I tried changing the column type to text to no avail. I
> searched the documentation and couldn't figure it out. Can someone
> provide some insight for me?
> Thanks-
> Anna
-
Befor
o
escape it?
Thanks very much,
Anna
[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 &l
Well, the function is called like this:
mysql_real_query( mysql_connection, query_string, strlen( query_string ));
Wouldn't that pass the correct length?
--Anna
Paul DuBois wrote:
> At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >Hi,
> >
> >I have an insert
Paul DuBois wrote:
> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >Well, the function is called like this:
> >
> >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
> >
> >Wouldn't that pass the correct length?
>
>
Paul DuBois wrote:
> >Paul DuBois wrote:
> >
> >> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >> >Well, the function is called like this:
> >> >
> >> >mysql_real_query( mysql_connection, query_string, strlen( query_string
Anna Fowles-Winkler wrote:
> Paul DuBois wrote:
>
> > >Paul DuBois wrote:
> > >
> > >> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> > >> >Well, the function is called like this:
> > >> >
> > >
Gerald Clark wrote:
> The semicolon does not belong there.
Where? At the end of the query or in the string?
--Anna
>
>
> Anna Fowles-Winkler wrote:
>
> >Anna Fowles-Winkler wrote:
> >
> >>Paul DuBois wrote:
> >>
> >>>>Paul DuBo
ompt_8, allow_0, allow_1, allow_2,
allow_3, allow_4, allow_5, allow_6)
VALUES ('Eye Movement
Time',1,NULL,'per',0,'.1;',0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,1)
Paul DuBois wrote:
>
Hi,
Does the MySQL C API function mysql_real connect allocate memory or do I
need to do it? This is what my code currently does:
MYSQL *mysql;
mysql = new MYSQL
mysql_init(mysql);
mysql_real_connect(mysql, host, user, password, dbase, 0, 0, 0);
Thanks,
Anna
37 matches
Mail list logo
