Query to get the all column names of a given table in ms sql server

I just found a grate tutorial for the MySql.
What it does we’ll create a query to get the all column names of a given table in ms sql server. It’s quite easy. Let’s have a look over the query.

/* Query to get the all field names of a given
table in ms sql server  */
select column_name from information_schema.COLUMNS   
where table_name='yourtbl_name'   
order by column_name asc
ajax contact form

Contact Form using JQuery, PHP and MySql – updated

New Updates:

1. In order to make the contact form a little bit more secure, I have implemented an Secureimage PHP Captcha, more here: http://www.phpcaptcha.org
2. Again for security purposes in PHP logic there are extra checks to validate the email address.
3. Small bug fixing when returning the ajax response (if it failed or not).

Found an issue? Leave it in the comment and I will pick it up see how can I help you with. Have a question again you can leave a comment :)

I’ve decide to make this tutorial because when I was working for a project I couldn’t find a good contact form using css3, html, php, jquery and finaly mysql (this it will be optional). There are a lot of tutorials many are grate but something is missing. Hope that mine has what were you looking for.

At the end of this tutorial we will have a ajax form. Let’s stop talking and do the work.