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 reg

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.

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 o

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 it

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

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 :Data

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

[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 10

RE: [PHP-DB] onClick

2005-03-01 Thread mel list_php
I use a submit button with a name: and then I can test on that name: if($_POST[cloningView]) { ...display new web page .. } From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Subject: [PHP-DB] onClick Date: Mon, 28 Feb 2005 21:41:45 -0500 Another question: Is there a way that I may set up a

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 *