Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 04-04-2007, 12:31 PM   PM User | #1
saranya
New Coder

 
Join Date: Apr 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
saranya is an unknown quantity at this point
edit and delete the table

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
saranya is offline   Reply With Quote
Old 04-04-2007, 12:55 PM   PM User | #2
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
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.
guelphdad is offline   Reply With Quote
Old 04-04-2007, 01:13 PM   PM User | #3
saranya
New Coder

 
Join Date: Apr 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
saranya is an unknown quantity at this point
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
saranya is offline   Reply With Quote
Old 04-04-2007, 01:53 PM   PM User | #4
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
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.
guelphdad is offline   Reply With Quote
Old 04-06-2007, 12:43 PM   PM User | #5
saranya
New Coder

 
Join Date: Apr 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
saranya is an unknown quantity at this point
thank you i got the answer.
saranya is offline   Reply With Quote
Old 04-06-2007, 10:13 PM   PM User | #6
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
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.
guelphdad is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:51 PM.


Advertisement
Log in to turn off these ads.