...

View Full Version : edit and delete the table



saranya
04-04-2007, 12:31 PM
can anybody help me am new to php/mysql

i have two tables in my database(name knownerror)

table1
username userid
php 1
c 2
c++ 3

table2
userid problemid error solution
1 1 no clear
2 2 yes notclear
3 1 yes notclear

like this.i have webpage displays like this
php
c
c++

if i click php, the database display in the (next) result page is


problemid error solution
1 no clear
1 yes notclear

upto this i will clear now how can i edit and delete this table . the edit and delete icon is in result page itself like below

problemid error solution action
1 no clear edit delete
1 yes notclear edit delete

can anybody help me plz

guelphdad
04-04-2007, 12:55 PM
what application language are you going to use to do this? PHP, PERL? This thread belongs in one of those forums. I can move it for you but want to choose the right forum.

saranya
04-04-2007, 01:13 PM
i have two tables in my database(name knownerror)

table1
username userid
php 1
c 2
c++ 3

table2
userid problemid error solution
1 1 no clear
2 2 yes notclear
3 1 yes notclear

like this.i have webpage displays like this
php
c
c++

if i click php, the database display in the (next) result page is


problemid error solution (action)
1 no clear (edit and delete icons)
1 yes notclear (edit and delete icons)


here i want the new column (action) was also been display with edit and delete icons.if click those icons i want to get the (edit/delete) results.
i think now u can understand my problem

guelphdad
04-04-2007, 01:53 PM
You can't do this in mysql, you would have to add buttons in perl or php or coldfusion or whatever application you use as the front end to mysql.

so what are you using? your question is not mysql related. your question is about the code that you would need to do this in php or perl or whatever.

If you tell me what language/application you are using then I will move the thread.

saranya
04-06-2007, 12:43 PM
thank you i got the answer.

guelphdad
04-06-2007, 10:13 PM
then please post the answer you got. It is not good etiquette to come to a discussion forum looking for help and then not post the answer, whether you got it here or elsewhere.

your input would help other users who are looking for a solution to a similar problem as yours.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum