DaniWeb Forum Index > Web Development > PHP

MySQL Query Problem

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Dec 2007

Posts: 112

Reputation: !Unreal is an unknown quantity at this point

Solved Threads: 2

!Unreal

Offline

Junior Poster

MySQL Query Problem

Feb 21st, 2009

This query doesn't work. What have I dont wrong?

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
mysql_query("INSERT INTO list (title, url, description) 
VALUES ('$title', '$addtolist', '$description') 
DELETE FROM spider WHERE url='$addtolist'");
mysql_query("INSERT INTO list (title, url, description) 
VALUES ('$title', '$addtolist', '$description') 
DELETE FROM spider WHERE url='$addtolist'");

Heres the whole page if it makes things clearer.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
include('includes/config.php');
 
$addtolist = $_GET['add'];
 
$open = file_get_contents($addtolist);
 
$title = get_inner_string($open, '<title>', '</title>');
 
$description = get_inner_string($open, '<meta name="description" content="', '" />');
 
mysql_query("INSERT INTO list (title, url, description) 
VALUES ('$title', '$addtolist', '$description') 
DELETE FROM spider WHERE url='$addtolist'");
 
header('Location: moderation.php');
?>
<?php
include('includes/config.php');

$addtolist = $_GET['add'];

$open = file_get_contents($addtolist);

$title = get_inner_string($open, '<title>', '</title>');

$description = get_inner_string($open, '<meta name="description" content="', '" />');

mysql_query("INSERT INTO list (title, url, description) 
VALUES ('$title', '$addtolist', '$description') 
DELETE FROM spider WHERE url='$addtolist'");

header('Location: moderation.php');
?>

•

Join Date: May 2008

Posts: 525

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

Re: MySQL Query Problem

Feb 21st, 2009

Try

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
mysql_query("INSERT INTO `list` (`title`, `url`, `description`) VALUES ('$title', '$addtolist', '$description')");
mysql_query("DELETE FROM `spider` WHERE url='$addtolist'");
mysql_query("INSERT INTO `list` (`title`, `url`, `description`) VALUES ('$title', '$addtolist', '$description')");
mysql_query("DELETE FROM `spider` WHERE url='$addtolist'");

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.