Try:
$sql = select * from item where \bib#\ = 300;
- Original Message -
From: Jeremy Peterson [EMAIL PROTECTED]
To: PHP DB [EMAIL PROTECTED]
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 $textbr;
}
?
--
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