English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

To retrieve the First Name and Last name in SQL server, and able to edit, or update the First Name and Last name

2007-02-01 05:49:55 · 1 answers · asked by trangphi2003 1 in Computers & Internet Programming & Design

Big D, more details please, i got XP window and SQL server install. Email me trangphi2006@yahoo.com. Thanks

2007-02-01 07:00:51 · update #1

1 answers

To do this you need a server side scripting language, easiest is probably php. Then you will also need a sql database, cheapest/easiest is MySQL. Now if you want to run this you need a host that provides this. I do not have enough room to tell you how to do this all but a sample of what you could do for the queries are:

(Your query would be something like
$view_query = "SELECT first_name, last_name FROM user_names WHERE user_id=$id";
$update_query = "UPDATE user_names SET first_name='$first_name', last_name='$last_name' WHERE user_id=$user_id";

//with user id being the id of the user you selected - primary key)

Really to get a good grasp on it get Larry Ullman's book PHP & MySQL quickstart guide. It is well written and will really get you up and running quick. It is by far one fo the best php books I've seen and one of the best programming books I've seen.

2007-02-01 06:18:40 · answer #1 · answered by Big D 4 · 0 0

fedest.com, questions and answers