PHP newbie seeking help

[jeffers]

Hello folks

 

Thought i'll try and learn some php coding to accustomise my site so it's more to my liking, but tragically fallen down at the 2nd hurdle.

 

In mysql the command line for the info i require is

 

select manufacturers_id from products where products_id = 377;

 

this returns the answer required which is 35

 

but how to i get this to work in oscommerce,

i have the lines

$manu_query = tep_db_query(...................);

$account = tep_db_fetch_array($manu_query);

echo $account;

 

now it is the bits marked ........ that i have tried with all to no avail because in theory the part that says

echo $account; should print on the screen 35

 

I know i am connecting to the database as a previous calculation within the page gives me the figure 377.

 

Hope someone can help

 

Jeff

[Chris Dunning]

Jeff -

 

It would help quite a bit to show us your entire code, rather than just "......." - no telling what's going on with that.

 

The function tep_db_fetch_array is a wrapper for the function mysql_fetch_array, which you can read about here:

http://us2.php.net/mysql_fetch_array

 

The function returns an array rather than just a single value. To see what's in the array, use:

print_r($account);

 

The short answer is, try this:

echo $account['manufacturers_id'];

 

I'm moving this thread to a more appropriate forum.

[jeffers]

The short answer is, try this:

echo $account['manufacturers_id'];

 

 

Thanks for a swift reply the above has done the trick and now i can progress.

 

Thanks