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

unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_
Can anyone view my code and tell me why im getting the error:
Parse error: syntax error, unexpect

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

get the country of visitor and display content based on that
Hello all,

I have seen that Google analytics can tell you where a visitor is coming from and

php/mysql problem
Hey all,

Problem: im trying to setup a shop where people can use a drop-down list to select t

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

passthru() help
Hi everyone,
I'm new to the forum and to PHP. I have some pretty good experience writing shell sc