RE: selecting a constant or label in php

["Jon Davis" <jonwdavis@xxxxxxxxxxx>]

COMM_REGIONID and COMM_TRKGRP are not columns in the tables.  They are the 
actual table names.  I want the count of the PHYSICAL_ID where it is NULL.  
I need to do this for multiple table so I want to hardcode the tablename and 
then have the count:

------------ -----------
COMM_TKGRP                0
COMM_REGIONID             0

using "COMM_REGIONID", 'COMM_REGIONID' and \"COMM_REGIONID\" all fail with:

Warning: sybase_query() [http://www.php.net/function.sybase-query]: Sybase:  
Server message:  COMM_REGIONID not found. Specify owner.objectname or use 
sp_help to check whether the object exists (sp_help may produce lots of 
output).

It's not found because it's not a column.  I just want it in there so when I 
insert it into another table I will know which count applies to which table. 
 Everything I try, gets an error.

Sorry, I should have mentioned what COMM_REGIONID was first.


> From: "Jon Davis" <jonwdavis@xxxxxxxxxxx>
> To: php-db@xxxxxxxxxxxxx
> Subject:  selecting a constant or label in php
> Date: Wed, 03 Dec 2003 09:39:33 -0600
>
> Sorry for another newbie question, I'm learning.
>
> In Sybase I can do:
>
> select "COMM_REGIONID" , count(1) from COMM_REGIONID where PHYSICAL_ID is 
> null
> select "COMM_TKGRP" , count(1) from COMM_TKGRP where PHYSICAL_ID is null
>
> I get parsing errors when putting it in this:
>
>
> $result = sybase_query("select "COMM_REGIONID" , count(1) from 
> COMM_REGIONID where PHYSICAL_ID is null
>                                select "COMM_TKGRP" , count(1) from 
> COMM_TKGRP where PHYSICAL_ID is null" , $server_sybase);
>
>
> How can I hardcode "COMM_REGIONID" and "COMM_TRKGRP"?
>
> _________________________________________________________________
> Wonder if the latest virus has gotten to your computer? Find out. Run the 
> FREE McAfee online computer scan! 
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________
Get holiday tips for festive fun. 
http://special.msn.com/network/happyholidays.armx

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