MySQL Query problem, possible bug?

2001-08-10 Thread Leon Mergen
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] President of Operations BlazeBox, Inc. ICQ

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: query to display per page

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

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

2001-06-11 Thread Leon Mergen
| | +---+---+---+--+-+---+--+--- + 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 PROTECTED] BlazeBox, Inc. ICQ

Re: Password encryption

2001-06-10 Thread Leon Mergen
, 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 I used the function password() if that helps

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] To: Leon Mergen [EMAIL

Password encryption

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

Delayed insert

2001-05-26 Thread Leon Mergen
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 list archive