Gossamer Forum
Home : Products : Gossamer Links : Discussions :

how to add phone column

Quote Reply
how to add phone column
I need to add a Phone column to the database to it displays the phone numbers entered on the form.

I am not sure how I go about this.. can anyone walk me through it...

Thanks
Quote Reply
Re: [6foot4] how to add phone column In reply to
Database > Links/Properties > Add Column

Add your phone column based on the specs you require - you'll probably want a CHAR column unless the numbers contains digits only in which case use INT.

Then if you only want the phone number field accessible to admin then you're done, otherwise you need to add the new field into include_form.html

Oh you'll also want to add the phone column tag into link.html to display the output.

Last edited by:

Paul: May 1, 2003, 11:31 AM
Quote Reply
Re: [Paul] how to add phone column In reply to
Unable to add column 'Phone'. Reason: Failed to execute query: 'ALTER TABLE lsql_Links ADD Phone CHAR(50)' Reason: Duplicate column name 'Phone'





that is what I get when I try..
Quote Reply
Re: [6foot4] how to add phone column In reply to
Looks like you already have a column called "Phone" in your database ;)
Quote Reply
Re: [Paul] how to add phone column In reply to
hmmm... well this is what happend.

I moved servers.. and had to reinstall linksSQL.. so It might be there..but isnt showing up.

How do I get it to show in the database again..? I amguessing it is saved iwth mysql. (I am not abig tech guy..)
Quote Reply
Re: [6foot4] how to add phone column In reply to
On the Database > Links/Properties page scrool down and click "Resync Database"
Quote Reply
Re: [Paul] how to add phone column In reply to
sweet thanks Paul.. :)

I think that did it