[nycphp-talk] sql query with php
Daniel Convissor
danielc at analysisandsolutions.com
Mon Mar 13 10:29:38 EST 2006
On Mon, Mar 13, 2006 at 07:06:15AM -0800, jlesidt wrote:
... snip ...
> from [tablename]
... snip ...
While this isn't your problem, a heads up. Do not use delimited
identifiers or identifiers that requirie delimiting. Doing so WILL cause
you grief in the long run.
> This works perfectly fine in mssql query analyzer. But when this is
> executed through php no rows are returned. Should I not use "in" and
> subquery in php. Any help will be greatly appreciated.
All PHP does is pass the the query to the database server. Two possible
reasons for your problem are your PHP script is not connecting to the
server/database you think you are or there is a bug in you PHP code.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
More information about the talk
mailing list