Re: [PHP-DB] Optimising LIMITs - alter table order by...

2004-03-02 Thread Pavel Lobovich
Hello Pavel, Tuesday, March 2, 2004, 7:20:03 AM, you wrote: PL 2. ALTER TABLE `board` ORDER BY `threadid` DESC; I never knew you could do this - it's quite fascinating this list sometimes :) I do have a question though - if I use this order by table alteration, does MySQL remember

[PHP-DB] Re: Alterations

2004-03-02 Thread Pavel Lobovich
`status` (`status`) ) TYPE=MyISAM; Insert data: - ?php set_time_limit( 6000 ); error_reporting( E_ALL ); define ( NUM, '20' ); mysql_pconnect( 'localhost', '---', '--' ); mysql_selectdb( 'richardboard' ); $name = Pavel Lobovich, Belarus; $text

Re: [PHP-DB] Optimising LIMITs

2004-03-01 Thread Pavel Lobovich
Hi Richard! Step 1 --- Is it right? 1. `threadid` value is unique. 2. `threadid` value is auto_increment. 3. if `threadid`(2) `threadid`(1) = `created`(2) `created`(1). You can do the following: 1. Create the index on two fields: (boardid, status) 2. ALTER TABLE `board` ORDER

Re: [PHP-DB] Uploading files

2004-02-28 Thread Pavel Lobovich
Try to change the following limits in your php.ini file: max_input_time = 120 ; Maximum amount of time each script may spend parsing request data memory_limit = 10M ; Maximum amount of memory a script may consume (8MB) ; Maximum size of POST data that PHP will accept. post_max_size = 10M

Re: [PHP-DB] INSERT dynamic values problem - Need help urgently!

2004-02-27 Thread Pavel Lobovich
Hi all: I am trying to create a registration form whereby one of the user input is as follows: (a drop down menu with values retrieved from DB): - td class=lighter width=350Class Code:/td td class=lighter

Re: [PHP-DB] Uploading files

2004-02-27 Thread Pavel Lobovich
If your on a slow connection, it might be timing out. Try putting: set_time_limit(0); At the top of the page where the file is being uploaded to (not from), and see if that helps. You dont have to do it. Script execution will not start before all posted files are uploaded. If your

Re: [PHP-DB] Passing the value of a variable from PHP to JavaScript.

2004-02-27 Thread Pavel Lobovich
Here is the working code: ?php echo html script language='JavaScript' function tes(){ document.write('pJavaScript/p'); o=document.getElementById('myselect'); window.location.replace('http://192.168.23.1/coba/coba.php?vtes='+o.value); } /script body ; echo diforward ke javascript; echo select