Closed

form to update and add to a table

must be written in classic asp/vbscript & javascript/jquery

We have a table that people on our web site can enter product questions. the question is entered into a table where

sales reps can answer them. we need a back end for that allows us to administer the table.

the table has the following columns

here is the SQL to create a copy of the table

CREATE TABLE `qa` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`ItemID` int(11) DEFAULT NULL,

`Question` longtext,

`Answer` longtext,

`loginid` int(11) DEFAULT NULL,

`QName` varchar(255) DEFAULT NULL,

`AName` varchar(255) DEFAULT NULL,

`State` varchar(255) DEFAULT NULL,

`DateEntered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`Active` int(11) DEFAULT '0',

`edited` int(1) DEFAULT '0',

`editor_remove` int(1) DEFAULT '0',

`edited_by_loginid` int(11) DEFAULT NULL,

`via_email` int(1) DEFAULT '0',

`via_chat` int(1) DEFAULT '0',

PRIMARY KEY (`ID`),

KEY `itemid` (`ItemID`)

)

when creating the program please allow for the table name to be a prameter that is set only once so we can change the table name in one place.

we need 3 pages.

1) to view a list of all the q&a with pagination

2) to add a q&a

3) to edit a q&a

1) to view a list of all the q&a with pagination

this is a page that has a table. each row is another q&a with the following columns contain the information of each field in the database. We also need on each row an "edit" button. that will bring us to page #3 above that will allow us to edit a specific q&a. (it can be a light box.)

pages 2) should a page (or pop up/light box) that allows the user to enter information for each field

page 3) should allow the user to find a q&a based on exact match to any field. and edit any information

the "Active" & "edited" & "editor_remove" should show up as a check box. checked = 1 unchecked = 0

the "loginid" should be set as a variable in one place and we will fill it when we install the page

also please be aware that in the "Question" & "Answer" fields the user may enter quotes please code accordingly

Skills: ASP, Javascript, jQuery / Prototype, MySQL

See more: web pagination, q find, product sales reps, find reps, copy edited, javascript edit page, web page product enter, update product page, timestamp, table, qa a, find name, fill form, edit 343, creating question, create web page allows, javascript table copy, asp jquery sql, add edit view, jquery web form, administer, javascript vbscript, copy table jquery, jquery copy form, jquery sql form

About the Employer:
( 1 review ) Lakewood, United States

Project ID: #1152033

8 freelancers are bidding on average $161 for this job

lsweb

Hello. Please check your PM. Thanks.

$250 USD in 5 days
(126 Reviews)
7.3
shmai

have a glance at PM. regards,

$200 USD in 5 days
(181 Reviews)
6.9
ntiersolutions

Please check your pm.

$250 USD in 8 days
(76 Reviews)
6.0
Vikaskukki

Hi Very Interesting project for us as we have 10 + years in developing in Classic ASP , ASP.NET with MS SQL 2000,2005,2008,MSACCESS,XML,CSV,XLS Dhtml,Dhtmlx,AJAX/JAVASCRIPT/XML/CSV, ASP.NET C#, Ajax2.0 for Both ASP. More

$210 USD in 5 days
(22 Reviews)
5.6
vesel

I am completly free.

$250 USD in 7 days
(0 Reviews)
0.0
AndyES

I have 15 years experience developing with ASP/HTML/Javascript. This will take me approx two days to complete.

$150 USD in 2 days
(0 Reviews)
0.0
ahesanalimomin

please see you pmb sir

$50 USD in 2 days
(0 Reviews)
0.0
saady89

check your pm! =) thanks

$130 USD in 7 days
(0 Reviews)
1.8
ninomirza

I will do it quick and cheep try me :)

$50 USD in 2 days
(0 Reviews)
0.0