[snip] $string = "select * FROM `table` where id='$value' order by name"; [/snip]
I know it ain't pretty, but the coding style we have accepted is this.... $string = "select * FROM `table` where id = '" . $value . "' order by name "; or (we requite caps on reserved words)... $string = "SELECT * "; $string .= "FROM `table` "; $string .= "WHERE id = '" . $value . "' "; $string .= "ORDER BY name "; No ambiguity and cleaner on longer queries. It's all in preference I suppose. Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
