Re: Sybase Query- Problems with Pound Sign

Try: $sql = "select * from item where \"bib#\" = 300"; ----- Original Message ----- From: "Jeremy Peterson" <jeremy.peterson@moody.edu> To: "PHP DB" <php-db@lists.php.net> Sent: Wednesday, August 06, 2003 4:34 AM Subject: [PHP-DB] Sybase Query- Problems with Pound Sign > 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. > > Printing $sql returns the proper sql statement, so what is the sybase_query > function doing to the variable? > > My code is at the bottom of this page. > > Thanks, > > Jeremy > > > > <?php > include "$DOCUMENT_ROOT/include/sybase.inc"; > > $syb_connect = syb_connect($syb_server, $syb_user, $syb_pw); > > $sql = "select * from item where bib# = 300"; > print "sql=$sql"; > $result = sybase_query($sql); > > //print "someting"; > while($row = Sybase_Fetch_Assoc($result)){ > extract($row); > print "$tag $text<br>"; > > } > > > ?> > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php