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): > - > > Class Code: > > > $sql = mysql_query("SELECT DISTINCT cl

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 yo

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

2004-02-27 Thread Pavel Lobovich
Here is the working code: function tes(){ document.write('

JavaScript

'); o=document.getElementById('myselect'); window.location.replace('http://192.168.23.1/coba/coba.php?vtes='+o.value); } "; echo "diforward ke javascript"; echo "

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] 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] 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 MyS

[PHP-DB] Re: Alterations

2004-03-02 Thread Pavel Lobovich
Note! IMHO Creating test table: --- CREATE TABLE `thread` ( `threadid` int(10) unsigned NOT NULL auto_increment, `site_user_id` varchar(32) NOT NULL default '', `boardid` tinyint(3) unsigned NOT NULL default '0', `subject` varchar(200) NOT NULL default '', `mo