retreaving values

Hi all,

in my php script I need to retreave a value from a table and add it to another table. In my script I have.



then I try to add the value of $curRate to another table using this code




but this doesn't quite work for me. I get "Resource i" inseted in the curRate culumn. I don't know where this Resource i came from.

can anyone please help me = )
Qutaibah

mysql_query returns a resource result that has to be processed using for example mysql_fetch_row or mysql_result..

Try using this code instead



and then



That should work!

Read about mysq_result:
http://www.php.net/manual/en/function.mysql-result.php

Read about the different mysql-functions:
http://www.php.net/manual/en/ref.mysql.php

Thanks for the fast respond,

I see the logic of mysql_result() but it's not really working. I think it's something minor. I'll go and try to move things around maybe I'll find what's wrong with the code.

Qutaibah

Hi Lindset,

like I said it was silly mistake that was messing up everything. but now it's workin just fine. and I understand what a resource is. so I am all happy =)

thanks for your help
Qutaibah