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

Comment: ALTER is used to change the structure of an table, for example add an extra column or change the default values etc. Or to add an index or similar. -Original Message- From: Nicholas Vettese [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 9:12 PM To: mysql@lists.mysql.co

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 I am working on a script that loo