Replace variables in resulting query

[Jim]

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

[torpecool]

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