Query error need help please

2004-09-14 Thread Soheil Shaghaghi
Hello. I have a subroutine which checks for multiple entries and if a user has voted once in the same day, it will not calculate the vote. However, I found out that it does not really do this. What it does is only look at the last entry. If the user IP address is the last entry it does not

Re: Query error need help please

2004-09-14 Thread Greg Donald
On Tue, 14 Sep 2004 19:55:42 -0700, Soheil Shaghaghi [EMAIL PROTECTED] wrote: I have a subroutine which checks for multiple entries and if a user has voted once in the same day, it will not calculate the vote. However, I found out that it does not really do this. What it does is only look at

Need help please!

2002-02-14 Thread Richard C Rossy
Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What I have in the script is: Configure.pl sub configure {

Re: Need help please!

2002-02-14 Thread Brian Reichert
On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote: Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What

Re: [QUERY] Problem with Syntax/Query. Need Help Please.

2001-11-17 Thread Tore Van Grembergen
with Syntax/Query. Need Help Please. G'Day All. I'm trying to do the following in a query, in mySQL. All my previous years of SQL has been on MS-SQL, and i'm having some little problems with tricky sql statements. * i'm trying to insert a new record if the name doesn't exist in the table

[QUERY] Problem with Syntax/Query. Need Help Please.

2001-11-16 Thread Pure Krome
G'Day All. I'm trying to do the following in a query, in mySQL. All my previous years of SQL has been on MS-SQL, and i'm having some little problems with tricky sql statements. * i'm trying to insert a new record if the name doesn't exist in the table. If i insert, return ID, else return 0