db entry based on primary key

Posted on 16th Feb 2014 07:03 pm by admin

My "topics" table contains 10 entires
*--------------*
topicid topic
------
*--------------*
01 Bye
02 Hi
03 Hello
.....
10 Morning
*--------------*


<?php //topics.php
require_once("includes/connection.php");
....
....
ttopics[]= //I have 10 strings here which have changed by now.

foreach ($ttopics as $ttkey)
{

//I am trying to update my "topics" table whenever these strings change, based on the topicid (primary key).

//Please correct my code.

$id = mysql_real_escape_string('topicid');
$topic = mysql_real_escape_string('topic');
$result = mysql_query("SELECT topicid, topic FROM table WHERE topicid='{$id}' and topic='{$topic}' ");
if($result)
{
$num = mysql_num_rows( $result );
if ($num == 0)
{
$querypost = mysql_query ("INSERT INTO trendingtopics (topic) VALUES ('$ttkey')");
}


}


I am getting an error. Lets say the position of Morning is first and Bye is last. It should update the database accordingly. If there is a new entry, say "phpfreaks" in first position. It should update according.

Your Answer:

Login to answer

Other forums

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

problem with array - multilingual page
this is my test page :
Code: <?php
if(isset($_GET['lang'])) {
if($_GET['la

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact