Re: [PHP-DB] Sybase Query- Problems with Pound Sign

[Tiberiu Ardeleanu]

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

[PHP-DB] Sybase Query- Problems with Pound Sign

[Jeremy Peterson]

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

Re: [PHP-DB] Sybase Query- Problems with Pound Sign

[John W. Holmes]

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.
[snip]
$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: www.amazon.com/o/registry/3BEXC84AB3A5E/

PHP|Architect: A magazine for PHP Professionals  www.phparch.com





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php