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
Creating a db with a query
Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP
need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian
Check premium expire
Hi,
I am making a simple file hosting site and want to check if users premium subscriptions h
Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter
noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),
a u
Multi Level Array Problem
hi all,
For example I have array like below:
$temp = array(array('north america', 'us'
paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon
Keeping data in form
How can I keep whatever I write in the form?
mysql select query problem
how can i select multiple fields from multiple table in one query like
i have table name t1 a
PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f
