help to build a query for simple bulletin board

hi, I'm trying to build a simple bulletin board, just topics and posts. created following tables: CREATE TABLE `topics` ( `topic_id` int(8) NOT NULL auto_increment, `author_id` int(8) unsigned NOT NULL, `topic_title` varchar(255) collate utf8_unicode_ci default NULL, `topic_date_entered` date

Re: Array property of object from Resource

On Jan 26, 2007, at 2:33 PM, Brent Baisley wrote: while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) { $this->result_List[] = $row; } That produces an array like this: [0]=> [WHAM_ID]=>15, [NAME]=>Fred, [AMOUNT]=>99 That is getting me close to what I am looking for, I just wo

Re: Array property of object from Resource

oops, Sorry: I meant to post this to the PHP group. On Jan 26, 2007, at 2:06 PM, phphelp -- kbk wrote: Hello, folks -- lurking for a while, first post -- I'm relatively new to PHP but doing database design work for nearly 20 years. I've RTFM'ed (+ books + other resources) a bunch of times

Array property of object from Resource

Hello, folks -- lurking for a while, first post -- I'm relatively new to PHP but doing database design work for nearly 20 years. I've RTFM'ed (+ books + other resources) a bunch of times but I have a mental block around doing this: I want to have an multidimensional array as a property of

Re: Max number of 64 indices per table?

Horst Jäger ha scritto: Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? recompile with "configure --with-max-indexes=128" I'm using MySQL 5.0.27 . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

RE: Unable to put data on a different computer from mysql - I'm responding to Felix

Can't seem to figure out how to respond to a thread...Do I simply repost again? Anyway, Thanks for the info Felix...I tried it and get the same result. Works locally on a different drive, but not over our network. Is the problem to do with windows file sharing? Not sure what else to try...

Re: Use Samba Share For Data Directory

On 1/26/07, Dominik Klein <[EMAIL PROTECTED]> wrote: Michael Stearne schrieb: > We have 5.0.27 installed on a CentOS machine that doesn't have a ton > of disk space. Is it possible to point the data directory to lie on a > samba connected share? The samba share does not support Unix file > perm

InnoDB Deadlock Prevention

Hi, I am experiencing deadlocks using InnoDB row level locking. I would like to prevent these deadlocks by accessing the rows in the affected table in a fixed order, as suggested in the MySQL manual http://dev.mysql.com/doc/refman/5.1/en/innodb-deadlocks.html. Unfortunately, I could not find how

Max number of 64 indices per table?

Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? I'm using MySQL 5.0.27 . Thanks in advance Horst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to log on the server refused connections?

Hi, I'm experiencing some sporadic "connection refused" from mysql-max server. I'd like to keep track of these events, so is there a way to log on the server these 3 items? - date and time - ip of the client - reason of the refusal Thanks, Nico -- Email.it, the professional e-mail, gratis

Re: Innodb, why not?

Hi, According to the manuel, Falcon is not yet optimized for performances, so benchmarking it would not be fair. And I do not recommand using the binary alpha release in production, you could corrupt badly your database (some bugs has only been fixed a few days ago concerning this corruption).

Re: Use Samba Share For Data Directory

Michael Stearne schrieb: We have 5.0.27 installed on a CentOS machine that doesn't have a ton of disk space. Is it possible to point the data directory to lie on a samba connected share? The samba share does not support Unix file permissions so it is not possible to set mysql as the owner of th