MySQL Query problem, possible bug?

2001-08-10 Thread Leon Mergen
problem? This query DID work on the previous server, the RedHat one, but just doesn't work on the FreeBSD server. The databases are EXACTLY the same, so there shouldn't be any problems. Or should it? Anyway, thanks in advance for your replies, Leon Mergen [EMAIL PROTECTED] Preside

Memory usage

2001-06-26 Thread Leon Mergen
Hello, I was wondering, how can I lookup how much memory MySQL is currently allowed to use, and how can I change this value? Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353 - Before posting

Re: Again: ORDER BY key_part1,key_part2 does not use index

2001-06-11 Thread Leon Mergen
2 | const |1 | | +---+---+---+--+-+---+--+--- + 1 row in set (0.00 sec) As you can clearly see in the 2nd query, memberid is a key, and is used there. But why isn't it used in the ORDER BY clause? Thanks in advance, Leon Mergen [EMAIL PROTECTE

Re: query to display per page

2001-06-11 Thread Leon Mergen
In PHP, I used something like this: query("select * from table limit $x,25"); while ($row=$db->fetch_array($result)) { echo $row[column]; } $next = ($x+25); echo "Next\n"; ?> So that's the idea... Leon Mergen [EMAIL PROTECTED] President of Operations Blaze

Re: Password encryption

2001-06-10 Thread Leon Mergen
vance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353 - Original Message - From: "Rolf Hopkins" <[EMAIL PROTECTED]> To: "Leon Mergen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, June 10, 2001 3:43 PM Subject: Re: Password encryption

Re: Internals Of MySQL

2001-06-09 Thread Leon Mergen
s.php _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. T: +31 31 735 03 03 F: +31 31 735 03 08 ICQ: 55677353 The information transmitted in this email is intended only for the person(s)or entity to which it is addressed an

Re: Password encryption

2001-06-09 Thread Leon Mergen
Anyone has any idea how much this encryption method sucks up server load? _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. ICQ: 55677353 - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]>

Password encryption

2001-06-08 Thread Leon Mergen
in the value of "secret". Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353

Delayed insert

2001-05-26 Thread Leon Mergen
this and how to fix it? Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li