query excuting problem
Posted
by srini-r85
on Stack Overflow
See other posts from Stack Overflow
or by srini-r85
Published on 2010-05-25T11:11:31Z
Indexed on
2010/05/25
11:41 UTC
Read the original article
Hit count: 240
php
|mysql-query
hi,
i tried to execute following query in php script.
$db_selected = mysql_select_db("lumiinc1_sndemo1", $con);
if ($db_selected) {
echo "database connected";
}
else
{
die ("Can\'t use db : " . mysql_error());
}
$sql = "INSERT INTO `markers` ( `name`, `address`, `lat`, `lng`, `id` ) SELECT `name`, `street`, `latitude`, `longitude`, `lid` FROM `location` WHERE NOT EXISTS ( SELECT * FROM `markers` WHERE `location`.`lid` = `markers`.`id` )";
$result = mysql_query($sql);
if ($result) {
echo "Query executed OK";
} else {
die("Invalid query: " . mysql_error());
}
script does not show any error.also query executed.but i didn't get my expected result.at the same i try this query in phpmyAdmin i got my expected result. i dont know the cause of this problem. plz any one find the problem . thanks
© Stack Overflow or respective owner