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

php sessions,logouts & the bloomin back button!
Hi All,

I've got a cms that members can log into. When they logout, the session is destroyed,

Why is this function returning a false value when it shouldn't be??
This is in an include file. I want it to check a value in an html form and see if it's just white s

Stats of viewers
Hello. I have a website in php and people can login. I want to make an admin control panel where u c

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

links using header()
Hi All

I'm not sure where to ask for help on this but I hope someone can offer some. I'm at

Extract text from string
Hi folks,

I have a string that looks like this:

aaaaaaaaaa:
bbbbbbbbbb (ccccccccc)

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

does anyone know a php script to send mail using gmails/googles free smtp server
cause i heard u can do that but i dont know how

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo