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

Re: Alter Problem

2006-08-03 Thread Miles Thompson
At 11:12 AM 8/3/2006, Nicholas Vettese wrote: 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, userna

RE: Alter Problem

@lists.mysql.com Subject: Alter Problem 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,

RE: Alter Problem

Maybe: $query = "UPDATE profile SET acct_type='%at', ., genre='$g' WHERE id=$userid" /Peter -Original Message- From: Nicholas Vettese [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 9:12 PM To: mysql@lists.mysql.com Subject: Alter Problem

Alter Problem

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