Web site developed with perl, html using mySQl as the backend

Hi all just wanted some professional opinions on my web site located at http://www.IWantYourStuff.com I developed the site using HTML (of course) with Perl scripts accessing a mySQL database. If anyone would like to comment on it or make any suggestions please drop me a line. Thanks.

Help with Dates

I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36, 2001

HELP with SQL statement

ubtract all the number 3's (negatives) to give me a true rating. Any ideas? - Original Message - From: "Tomi Junnila" <[EMAIL PROTECTED]> To: "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 10:32 AM Subject: Re: HELP with SQL sta

HELP with SQL statement

I have a table called RATING and two fields one called POSITIVE and the other called NEGATIVE. I need to write an SQL statement for my mySQL database that will return the value of the total of POSITIVEs minues the total of the NEGATIVEs. Any ideas? -

Fw: SQL HELP

- Original Message - From: "Mike Podlesny" <[EMAIL PROTECTED]> To: "Scott Gerhardt" <[EMAIL PROTECTED]> Sent: Tuesday, January 16, 2001 3:20 PM Subject: Re: SQL HELP > Thanks for your help but that unfortunately doesn't answer the question, &g

SQL HELP

I want to select all the fields in from the mySQL database except I want my date field to be returned in the format of: January 16, 2001 How can this be done without having to do the select in this manner: SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield), YEAR(datefield)

SQL HELP

I want to select all the fields in from the mySQL database except I want my date field to be returned in the format of: January 16, 2001 How can this be done without having to do the select in this manner: SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield), YEAR(datefield),field3,f

Help with an SQL statement

Thanks for everyone's help with the dat question now I would like to know if someone could help me with another question. I have a table called COUNTER and a field in the table called HITS in an SQL statement I would like to update this field by adding 1 to it's current value any ideas? Thanks,

Help with a date select

I was wondering if anyone could help me. I have a table with a a bunch of fields and one of those fields is the DATE data type. I would like to write a SQL statement on the mySQL database that will return all if the items from the database that were stored there from today's date to six months a

BLOB Type?

I was looking to see the length or size of the BLOB data type in the manual and it is not listed. Does anyone know the size of BLOB? Also what is the largest number that can be stored in BIGINT? Thanks, Mike - Before posting