Yep, I wish I could name the fields, but alas it is not my database application. For some reason it works... :)

When I use isql it works as expected, thus the problem.

At 10:41 PM 8/5/2003 -0400, John W. Holmes wrote:
Jeremy Peterson wrote:

I am having a problem with a query that has a pound sign in it. The results are quite puzzling, it seems like the page doesn't load if the query is present. I have tested this on other tables without the pound sign and they work beautifully, seems like the pound sign is the troublemaker to me.
$sql = "select * from item where bib# = 300";

The # character is generally used to start comments, so everything after it is ignored in your query. I'm surprised you could even name a column like that...

---John Holmes...

Amazon Wishlist:

PHP|Architect: A magazine for PHP Professionals

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to