db entry based on primary key
Posted on
16th Feb 2014 07:03 pm by
admin
My "topics" table contains 10 entires
*--------------*
topicid topic
------
Did you know?Explore Trending and Topic pages for more stories like this.
*--------------*
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.
No comments posted yet
Your Answer:
Login to answer
76 
17 
Other forums
printing links
Hi every1
i am connecting to a table in sql and the looping through with a while ($ var = my
PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see
Problems with strings containing
Hey all,
I have encountered something strange in a script. I am trying to write an XML heade
How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c
Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages
Multiple upload and Resize
I would like some help on my script I have the for my index.php
////
<html&
PHP form authentication
Hi guys,
what am trying to achieve is this: Whenever a user tries to login to my website, an
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer
help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "
re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w
