Re: MySQL question

On 7/21/06, Karjala <[EMAIL PROTECTED]> wrote: Maybe I should ask this question on a database list, but it's related to DBI, so I'm asking here also: I have a field in a record in the MySQL database that contains a number. I increase it by one with $dbh->do("update table set myfield = myfield +

RE: MySQL question

: Friday, July 21, 2006 7:54 PM To: beginners@perl.org Subject: MySQL question Maybe I should ask this question on a database list, but it's related to DBI, so I'm asking here also: I have a field in a record in the MySQL database that contains a number. I increase it by one with $dbh-&

MySQL question

Maybe I should ask this question on a database list, but it's related to DBI, so I'm asking here also: I have a field in a record in the MySQL database that contains a number. I increase it by one with $dbh->do("update table set myfield = myfield + 1 where mykey = 10"); I was wondering wheth

Re: A MySQL Question

--As of Monday, May 24, 2004 8:43 AM +0600, LRMK is alleged to have said: By the way is PostgreSQL free and if yes where can I get a copy to practise myself. --As for the rest, it is mine. Yes: Daniel T. Staal ---

Re: A MySQL Question

- Original Message - From: "Randal L. Schwartz" <[EMAIL PROTECTED]> To: "LRMK" <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 9:24 PM Subject: Re: A MySQL Question > If you have an actual database (not MySQL, but

Re: A MySQL Question

> > > > the problem is if there are 1500 qualified records in the table there going > to 1501 queries (there going to be lots mor records than 1500 in the real > system) > > Question 1 ) Is there a more efficiant way of doing this, atleast to reduce > the number of querie

Re: A MySQL Question

On Fri, 21 May 2004, LRMK wrote: > I dont like to remove the RANK field onless there is no other solution > becouse this Rating system going to be used by a community of people to > messure the performance of their web sites compaired to others the RANK must > be there. > > I am thinking about cal

Re: A MySQL Question

Unlimited Banner Rotators - Original Message - From: "Dani Pardo" <[EMAIL PROTECTED]> To: "LRMK" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 1:06 PM Subject: Re: A MySQL Question > O

Re: A MySQL Question

On Fri, 21 May 2004, LRMK wrote: > Probably this is not relavent to this mailing list... But any way I ll ask.. > > I am developing a web site traffic rating system. using a combination og > perl and java (PERL in serverside, Java Applets in cliend side - My attempt > to create dynamic images was

A MySQL Question

? I know if I use Oracle db i can make a PL/SQL procedure but my web host only give MySql Question 2 ) Can I make functions with mySQL if yes where can I find a tutorial? Rakhitha Karunarathne Web Master www.Ad-Man.tk - Free Unlimited Banner Rotators ___

RE: perl mysql question

Thanks, That did it! > -Original Message- > From: Daniel Staal [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 11:36 AM > To: Perl Beginners > Subject: RE: perl mysql question > > --As of Tuesday, April 27, 2004 8:30 AM -0700, Christopher Lyon is a

RE: perl mysql question

--As of Tuesday, April 27, 2004 8:30 AM -0700, Christopher Lyon is alleged to have said: while ( @array = $sth->fetchrow_array() ) { print "$array[1] -> $array[3]\n"; $table{ "$array[1]" } = "$array[3]"; } my @keys = keys( %table ) ; while ( $key = pop( @keys ) ) { print "

RE: perl mysql question

> -Original Message- > From: Daniel Staal [mailto:[EMAIL PROTECTED] > Sent: Monday, April 26, 2004 8:54 PM > To: Perl Beginners > Subject: Re: perl mysql question > > --As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is alleged > to have said: >

RE: perl mysql question

Christopher Lyon wrote: > Not sure if I should post this to beginners or not but there it goes. > > I have 10+ tables with some of the same information in each in table > of a mysql database. Here is an example: > [snip] > > I need to take the names and add the counts up for between each table >

Re: perl mysql question

On 4/26/2004 11:53 PM, Daniel Staal wrote: --As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is alleged to have said: So, how to I get the values to look like in variable so that I can push them back into a new table: New Table namecount -+--- Widgets-A|25 Wi

Re: perl mysql question

--As of Monday, April 26, 2004 5:30 PM -0700, Christopher Lyon is alleged to have said: So, how to I get the values to look like in variable so that I can push them back into a new table: New Table namecount -+--- Widgets-A| 25 Widgets-B| 10 Widgets-C| 20 Wi

perl mysql question

Not sure if I should post this to beginners or not but there it goes. I have 10+ tables with some of the same information in each in table of a mysql database. Here is an example: Table 1 namecount -+--- Widgets-A| 10  Widgets-B| 5 Widgets-C| 10 Widgets-D

RE: Mysql Question. Can Someone Help

; If So, Then how do I call it to random place the PayPal, > StormPay addresses into the buttons. > There was my original idea: Select all address into a list and choose a random one. Or Get one address from a query that returns a random one out of all of them. #2 would be better on memory

OT: RE: Mysql Question. Can Someone Help

On Wed, 27 Aug 2003 09:25:03 -0500, "Dan Muey" <[EMAIL PROTECTED]> wrote: > > > > Hello Fellow Members, > > Howdy > > > > > I am new to perl and Mysql. I want to set up a mysql table to > > take Email addresses, and randomly place them into a

RE: Mysql Question. Can Someone Help

> Hello Fellow Members, Howdy > > I am new to perl and Mysql. I want to set up a mysql table to > take Email addresses, and randomly place them into a payment > button from PayPal, and StormPay. > > Can anyone tell me how to write the script to setup the MySql > Table to do this. > Sure,

Mysql Question. Can Someone Help

Hello Fellow Members, I am new to perl and Mysql. I want to set up a mysql table to take Email addresses, and randomly place them into a payment button from PayPal, and StormPay. Can anyone tell me how to write the script to setup the MySql Table to do this. Thanks and God Bless Dan

RE: php mySQL question

> Hi, Howdy > > I have a php form that takes in data for a mysql query. The > script that > processes the form takes the variables from the form and > submits them to > the db. > > What if the field after LIKE needs to be imprecise? The variable > somehow needs to be converted to a regul

Re: php mySQL question

Why are you posting this to a perl list? Try [EMAIL PROTECTED] On Thursday, April 3, 2003, at 06:06 PM, Robbie Staufer wrote: Hi, I have a php form that takes in data for a mysql query. The script that processes the form takes the variables from the form and submits them to the db. What if

php mySQL question

Hi, I have a php form that takes in data for a mysql query. The script that processes the form takes the variables from the form and submits them to the db. What if the field after LIKE needs to be imprecise? The variable somehow needs to be converted to a regular expression like /'%expr%'/

RE: dbi mysql question

Answer my own question. Yes it is possible, no problem. My problem was an obscure infinite loop. So nevermind! Thanks Dan -Original Message- From: Dan Muey Sent: Tuesday, December 31, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: dbi mysql question Does any one happen to know if it&#

dbi mysql question

Does any one happen to know if it's possible to do a query within a query : For instance : This is for demonstartion purposes and is not executable code : prepare $sth ->$dbh... execute $sth ->$dbh $sth ->$dbh fetchrowarray { $sth2 ->$dbh prepare $sth 2->$dbh execute $sth 2->$dbh fe

RE: Perl / MySQL Question

>From the MySQL docs: If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value will be reused with an ISAM, or BDB table but not with a MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM table_name (without a WHERE) in AUTOCOMMIT mode,

Perl / MySQL Question

In my script, I do the following: I insert x amount of records into a MySQL table, process the information and then delete those records. One of the columns is an autonumber type so it starts at 1 for instance. In my query string I use placeholders. Now sometimes the field which is an autonumber st

Re: xml and mysql question...

Below is a mysql approach using DBD::Mysql which can be generalized to DBI pretty easily. #!/usr/bin/perl use Mysql; # connect if (!($dbh=Mysql->connect('localhost',''))) {print "Connect error. Please try back later.";exit;} #sample query $statement="SELECT id,name,location,setting FROM users

xml and mysql question...

Hey im thinking of doing some perl stuff with xml.. but I have no experiance in it.. a friends site offers their news links in xml format.. what I need to do is to open a connection to there site.. read that file then display it on my own site. any ideas one working with xml? Also can someon