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

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

Using cURL to PUT
Can somebody help with the correct php code to make a cURL PUT request. Here is a sample of code bel

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

Need PHP help... have all the elements... just need help putting them together :
Hey Guys,

I was wondering if someone could help me. I am doing a website for a client which

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

how to load php class from another domain?
how to load php class from another domain?

Help with PHP Email Script
Hi guys,

I'm a newbie to php and need help with the script below:

At the moment when I

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built