[RESOLVED] Can't resolve error message

Simplyput

I am trying to pull a url from one table and then have it placed in another to have words extracted from it. My code looks good but I keep getting an error message at line 40.

The error message states

While executing query "INSERT INTO pid_ct_pages (page_url) VALUES (page_url = http://dir.yahoo.com/rss/dir/getrss.php?biz)" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://dir.yahoo.com/rss/dir/getrss.php?biz)' at line 1 In: /home/rtiper/public_html/xxxx/RSS_Key_Words/index.php on line: 40

Here is the code below.


$result = $db->sql_query("SELECT lid, cid, title, url FROM ".$prefix."_rss_rss ORDER BY cid DESC LIMIT 0,30" ,false,__FILE__,__LINE__);
while (list($lid, $cid, $title, $url,) = $db->sql_fetchrow($result)) {
    $title = stripslashes($title);
echo '<a href="'.getlink('RSS&amp;l_op=Showrss&amp;cid='.$cid).'">'.$title.'</a><br>';
echo "$title<br />";
echo "$url<br /><br />";

   $url = $row['url'];


/* Does this URL already have a record in the page-table? */
$result2 = $db->sql_query("SELECT url FROM ".$prefix."_rss_rss");
$row = $db->sql_fetchrow($result2);

if( $row['lid'] )
{
   /* If yes, use the old page_id: */
   $lid = $row['lid'];
}
else
{

   /* If not, create one: */
line 40---->  $db->sql_query("INSERT INTO ".$prefix."_ct_pages (page_url) VALUES (page_url = ".$row['url'].")");
   $page_id = mysql_insert_id();
}

I don't see where I am going wrong.

Derokorian

The proper format for an insert statement is:

INSERT INTO <table> (<column_list>) VALUES (<value_list>)

But instead you are trying to turn value_list into column = value which isn't right. See http://dev.mysql.com/doc/refman/5.5/en/insert.html for more info.

Simplyput

Derokorian;11000804 wrote:
The proper format for an insert statement is:
INSERT INTO <table> (<column_list>) VALUES (<value_list>)
But instead you are trying to turn value_list into column = value which isn't right. See http://dev.mysql.com/doc/refman/5.5/en/insert.html for more info.

rewrote it and still no dice.

While executing query "INSERT INTO pid_ct_pages (page_url) VALUES ( http://dir.yahoo.com/rss/dir/getrss.php?biz)" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://dir.yahoo.com/rss/dir/getrss.php?biz)' at line 1 In: /home/rtiper/public_html/xxxx/RSS_Key_Words/index.php on line: 41


 $url = $row['url'];
   $db->sql_query("INSERT INTO ".$prefix."_ct_pages (page_url) VALUES (".$url.")");
   $page_id = mysql_insert_id();

bradgrafelman

String values in SQL queries must be delimited with single quotes.

Simplyput

bradgrafelman;11000809 wrote:
String values in SQL queries must be delimited with single quotes.

This did the trick.

Thanks

Too many long nights and not enough sleep.