Update

[chinni_77]

Hello everybody,

I have a form where i can insert article heading and article text into a table.To be more precisely,
I first list all the topic names into a list box and then select one, click a button so that corresponding sub-topics are shown in the another listbox.Now, i can enter the article name and the article text.Its working fine:-)

I also want the user to update this article name or text in case if he has wrongly typed them.

How best can I do???

My table structure is something like
topic(topic_id, topic_name)
subtopic(subtopic_id,topic_id,subtopic_name)
articles(article_id,topic_id,subtopic_id,article_name,article_text)

I just want to put this update section as friendly as possible.Is that possible to put in the same form?

Could somebody explain me how can i do this one??I can show you my code also, so that you can help me out where all i can insert the update stuff.

Thanks everybody

[chinni_77]

Hello,

Does any PHP gurus have some ideas on this post??

thanks

[mahers]

After selecting the topic and the sub-topic from the listboxes have another listbox which lists all articles in the sub-topic. Then the user selects the article he/she wants to edit from the listbox and the article heading and article content is placed in a textfield and textarea field as required. I think you know where to go from there if you have come this far 🙂. This is just a basic idea for it.

[chinni_77]

Hello mahers,

Thanks for your post.I'm upto here so far.

I'm listing all the topics in the list box and user selects a topic, clicks a button, the sub-topics are shown in the 2nd listbox.
Now, select the sub-topic, hit a button, the articles related to the sub-topic are shown.

Now, what i want to do is, when i select an article name in the 3rd list box, i want to transfer this article name into a text box and one more field(article content) into another text box.Then, the user can make changes and hit the update button.

How should i do with the 3rd part??i.e, how should i transfer the article details into text boxes.

Lemme know if you wanna see my code.

Thanks for your time

[mahers]

// Get the article
$sql = mysql_query("SELECT article_name,article_text FROM articles WHERE topic_id=$var1 AND subtopic_id=$var2")

$myrow = mysql_fetch_array($sql);

Then in the form have for example.
<form name="update" action="update.php" method="post">
<input type="text" name="article_name" value="<?=$myrow['article_name']?>">
<textarea name="article_text" rows="10" cols="10"><?=$myrow['article_text']?></textarea>