Whats wrong with my syntax?

PLease help!!! can't figure out whwats wrong:

global $dal;
$rs = $dal->details->[B]Query("city='".$value."'","");[/B]
$datatmp = db_fetch_array($rs);
$value = "<a href=\"details_view.php?editid1=".$datatmp["ID"]."\">".$value."</a>";

Code (markup):

The php error points towards something around the bit in bold!

 

code seems ok , just paste complete error

 

The error is:

PHP error happened

Technical information 
Error type 256 
Error description 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 'id='orlando'' at line 1 
URL [url]www.****.com/project/details//output/details_list.php?[/url]  
Error file /home/content/******/html/project/details/output/include/dbconnection.php 
Error line 34 
SQL query select * from `details` where city='orlando' 
Solution This is a general error. It occurs when there is an error in event code or in SQL.

Code (markup):

 

Check the value of $value before execution.

How came you have id instead of city?

 

this is the query you are using:-

but the error says

that sounds weired....how an argument to value city is grabbed by id ? ..check the sql query properly..
Thanks

 

Just chiming in since it seems like he went offline, I just fixed his code bout an hour ago to do what he wants. I guess worry not so much about the error returned and code structure since it was changed before posting to protect the nature of the script.