extracting data from db

[raymie7]

Hi,

I'm trying to extract data from a db but without much success. Can anyone lead me in the right direction with the following code?

<?php
$query="select cardbox_id
from PRODUCTS p, PRODUCT_LOOKUP pl
where p.$td[$i]['product_id'] = pl.product_id";

$result=mysql_query($query);
?>
<td <?php echo $style ?>><?php echo $result;?>&nbsp;</td>

When I alter the query I sometimes get resource no. errors but generally the code returns nothing.

Thanks for any help.

[meekos]

Try this.

$result=mysql_query($query);

$rec = mysql_fetch_array($result);
?>
<td <?php echo $style ?>><?php echo $rec[0];?> </td>

[raymie7]

Thanks, I gave it a try but got a warning saying the supplied argument is not a valid MySQL result resource.

I'll keep going!

[meekos]

$query="select cardbox_id
from PRODUCTS as p, PRODUCT_LOOKUP as pl
where p.$td[$i]['product_id'] = pl.product_id";

what is $td[$i]['productid']?
If it is a fieldname try reversing statement, i.e, pl.product_id=p.$td[$i]['product_id']

If it is a value, try removing p. from $td[$i]['product_id'] or rewrite like this:
p.productid=$td[$i]['product_id'] AND pl.productid=p.productid

$result=@($query);
if ($result) {
$rec = mysql_fetch_assoc($result);
?>
<td <?php echo $style ?>><?php echo $rec['cardbox_id'];?> </td>
<?php
} else {
echo 'failed to run query'.;
}