Replace variables in resulting query

Hi,

I have the results of a query that as follows. I want to replace $prod
with the value of the variable - how can I get php to do that?

Select total_errors as num from ftr_summary_data where
ftr_product_platform= $Product and Project=$Project'

Select total_errors as denom from ftr_summary_data where
ftr_product_platform= '$Product' and Project='$Project'


Jim

Re: Replace variables in resulting query

I'm not sure, but this is something you may want to try.

If your query is in quotes, here is what it should look like:

"SELECT tota_errors AS num FROM ftr_summary_data WHERE
ftr_product_platform = ".$Product." AND Project = ".$Project."

I hope this helps.
Andy


Jim wrote:
> Hi,
>
> I have the results of a query that as follows. I want to replace $prod
> with the value of the variable - how can I get php to do that?
>
> Select total_errors as num from ftr_summary_data where
> ftr_product_platform= $Product and Project=$Project'
>
> Select total_errors as denom from ftr_summary_data where
> ftr_product_platform= '$Product' and Project='$Project'
>
>
> Jim