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
php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum
Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si
Need help urgant
why down my code ony return one item instead of all the items selected.
$arr = array($date,$
Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');
/* Set login to false initially */
help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "
Problem with Sending Mail by PHP
hello all,
I m new to php, can u plz provide me the code to send mail by php having CAPTC
ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al
Need help with cin setw
I made a program here is my code:
#include
#include
#i
array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h
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
