Edit: Thanks everyone for helping and giving suggestions on what camera to get.
It is been solved now.
A local shop had quite a big boxing day discount , so got myself an entry level DSLR

-------------------------------------------------
Sorry if I post on the wrong forum...
Any suitable cameras for taking close up/macro photos?
does not need to be ultra compact.
From... mid range price to upper range (US$250 and up)
and.... comparation between Canon G9 and G10?
Many thanks in advance