db entry based on primary key

Posted on 16th Feb 2014 01:33 pm by admin

My "topics" table contains 10 entires
topicid topic
01 Bye
02 Hi
03 Hello
10 Morning

<?php //topics.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}' ");
$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 Like 17 Dislike
Previous forums Next forums
Other forums

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Longines All
[b][url=http://www.copylongines.me/]fake longines[/url][/b] [b][url=http://www.copylongines.me/]cop

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

simplexml_load_file and rss problem

I have a problem parsing an rss feed using simplexml_load_file - this is strange as i hav

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Google+ Indyaspeak @ Pinterest RSS