Book Recommendation

2006-11-27 Thread Nicholas Vettese
I am looking for a book that will help me understand PHP/MySQL, and the way that they work together. My biggest problem is multi-valued selections, and INSERTING them into the database. A book with great examples like that would be a huge help. Also, any websites that could do the same would be

RE: Problems Updating Database

2006-09-06 Thread Nicholas Vettese
, 2006 9:15 AM To: mysql@lists.mysql.com Subject: Re: Problems Updating Database At 08:22 AM 9/6/2006, Nicholas Vettese wrote: >I have a registration script that inserts data into the database, and >then emails you an activation code to activate your account. The >problem is that when I

Problems Updating Database

2006-09-06 Thread Nicholas Vettese
I have a registration script that inserts data into the database, and then emails you an activation code to activate your account. The problem is that when I click on the link in the email, the account does not get updated. The portion of the script that has a problem is this: $query = "UPDATE

RE: Testing Email

2006-08-25 Thread Nicholas Vettese
: Testing Email INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: "Renato Golin" <[EMAIL PROTECTED]> To: "Nicholas Vettese" <[EMAIL PROTECTED]> Cc: Sent: Friday, August 25, 2006 4:31 PM Subject: Re: Testing Email > Nicholas V

Testing Email

2006-08-25 Thread Nicholas Vettese
I have been having problems with my email, and I wanted to test to this list. Thanks, nick

Re: cell colors PHP/MySQL

2006-08-09 Thread Nicholas Vettese
Wouldn't using a 'switch' statement work better? Just please do not ask me to show an example. :) - Original Message - From: "Chris White" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 09, 2006 3:30 PM Subject: Re: cell colors PHP/MySQL On Wednesday 09 August 2006 12:24 pm, Bri

Re: Alter Problem

2006-08-03 Thread Nicholas Vettese
ould be the best way to use `userid`? Thanks, nick - Original Message - From: "Miles Thompson" <[EMAIL PROTECTED]> To: Sent: Thursday, August 03, 2006 10:42 AM Subject: Re: Alter Problem At 11:12 AM 8/3/2006, Nicholas Vettese wrote: I am working on a script that looks

Alter Problem

2006-08-03 Thread Nicholas Vettese
I am working on a script that looks at the MySQL Table, checks to see if there are any matches, and if there are, alter the table to add the requested information. Here is the code I am using: $query = "ALTER profile (acct_type, username, firstname, lastname, email, addr1, city, state, zip, n

Checkboxes

2006-07-26 Thread Nicholas Vettese
I am trying to allow a user to use checkboxes for multiple selections, and I am trying to get the database to record the choices made by the user. I am using a VARCHAR(250), but I am guessing that may be wrong. Also, other than adding a "[]" to the end of the 'name' (e.g. Alternative), what do

Images Table

2006-07-20 Thread Nicholas Vettese
I am looking to create a database that holds the location of images on my server. I was wondering if anyone could help me understand if I am doing it correctly, and if I either need to add, change or remove something from the current table code. img_idINTNOT NULL auto_increment PRIMARY

File (xls, csv, txt) to MySQL

2006-07-10 Thread Nicholas Vettese
If I have a file that is in a spreadsheet format, how can I dump that into a MySQL database, using PHP MyAdmin? Thanks, Nick

Re: Rekall

2006-07-07 Thread Nicholas Vettese
If you are using an apt-based system, type 'apt-cache search mysql' That should bring up some programs you can install from. nick - Original Message - From: "Daniel da Veiga" <[EMAIL PROTECTED]> To: Sent: Friday, July 07, 2006 1:12 PM Subject: Re: Rekall On 7/7/06, Timothy Murp

Insertion Problem

2006-06-28 Thread Nicholas Vettese
Hello all, I am trying to get this script to INSERT a couple of records into my DB, but I am getting these errors. I know the second warning has nothing to do with MySQL, so I will work on figuring out that portion later today. Warning: mysql_fetch_array(): supplied argument is not a valid M

Multiple Entries

2006-06-26 Thread Nicholas Vettese
If I have a multiple choice on a form and want to store that in my DB, then how should I set up my table? I have been reading up on these, but everyone seems to have a different opinion on how to accomplish this task. What I am looking to do give the user a few options to check when submitting

New to the group

2006-06-22 Thread Nicholas Vettese
Hello, My name is Nick, and I am a new MySQL user. My hope is not to become a PITA, so I will make sure that any question is straight and to the point with the information needed to answer the question. My skill in MySQL is pretty low, and I am looking to build a website for myself that