basically i want to return records from a search from 2 seperate tables. is there a way of combing the results so i can loop through them rather than create two seperate looped regions ?

Are the two tables the same strucutre? If not, then you just need to do a more advanced SQL query.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

no the 2 tables are of different structure . can u give me an example of how to do this please

Hello,

You have to use SQL INNER JOIN
JOIN ON the logged user ID.

Example :

FROM Jobs INNER JOIN Users ON Jobs.User = Users.ID

Hope this helps,

Wim

there is no matching reference between the 2 tables

its to search the content from an entire site

Well, then it'll be one long SELECT statement, I'm assuming.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>