Re: [PHP-DB] changing output method

2005-03-01 Thread chintan
as usual my database is in mysql and there are lots of records available i had wrote my script like this $link = mysql_connect(localhost, chintan,hellomysql) or die(Could not connect); mysql_select_db(chintan) or die(Could not select database); $query = SELECT * FROM

RE: [PHP-DB] onClick

2005-03-01 Thread mel list_php
I use a submit button with a name: input type='submit' name='cloningView' value='View' and then I can test on that name: if($_POST[cloningView]) { ...display new web page .. } From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Subject: [PHP-DB] onClick Date: Mon, 28 Feb 2005

[PHP-DB] Updating many records at a time

2005-03-01 Thread Steve McGill
I have a situation where I am doing lots of complex sorting on records that already exist in a MySQL table. The table has a 'sort_order' field which means I can do a simple ORDER BY sort_order to keep it nice and quick on SELECT, it's only UPDATE which is slow. If I change the order that I want

Re: [PHP-DB] changing output method

2005-03-01 Thread graeme
Try putting your print \t$col_value\n immediately after the foreach... foreach ($line as $col_value) print \t$col_value\n; remember to remove teh semi-colon after the foreach line. graeme. chintan wrote: as usual my database is in mysql and there are lots of records available i had wrote my

Re: [PHP-DB] changing output method

2005-03-01 Thread anirudh dutt
u already seem to have a table-like format (after u make the changes graeme mentioned) to get it as CompanyName :Data Address :Data City:Data Zipcode :Data i'm assuming u want to do something like CompanyName Address City Zipcode :Data:Data

Re: [PHP-DB] onClick

2005-03-01 Thread anirudh dutt
On Mon, 28 Feb 2005 21:41:45 -0500, Ron Piggott [EMAIL PROTECTED] wrote: Another question: Is there a way that I may set up an IF command with the onClick function so that my_web_page.php3 will not be displayed unless a web form was used to generate it? Ron if ur page was generated by a

Re: [PHP-DB] onClick

2005-03-01 Thread mel list_php
What I actually do is I retrieve the POST array and then extract the variables at the beginning of my script. That's also why I forgot to add the quotes because I initialize my variable at the beginning, and I'm dealing with $cloningView directly. I just added it manually to make it clear that

Re: [PHP-DB] Updating many records at a time

2005-03-01 Thread Martin Norland
Steve McGill wrote: I have a situation where I am doing lots of complex sorting on records that already exist in a MySQL table. The table has a 'sort_order' field which means I can do a simple ORDER BY sort_order to keep it nice and quick on SELECT, it's only UPDATE which is slow. If I change the

Re: [PHP-DB] Updating many records at a time

2005-03-01 Thread Steve McGill
Steve McGill wrote: I have a situation where I am doing lots of complex sorting on records that already exist in a MySQL table. The table has a 'sort_order' field which means I can do a simple ORDER BY sort_order to keep it nice and quick on SELECT, it's only UPDATE which is slow. If

Re: [PHP-DB] onClick

2005-03-01 Thread anirudh dutt
On Tue, 01 Mar 2005 14:11:22 +, mel list_php [EMAIL PROTECTED] wrote: Why do you think that checking the value ($cloningView==View) is better? no, i didn't say it was better but it does make a lil difference. i also said, test the POST var. ur example makes it appear as though u keep