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: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
