PHP + MySQL - Presenting Data

[Guest]

Hi Guys,

In the beginning:

I'm developing a web application, using PHP and MySQL. The MySQL database contains several tables, some of which link together.

I have a table called 'freelancers', this contains general information about the 'freenlancer'.

Linked to this is a table called 'services' (linked through a Foreign Key), this table holds service information that the 'freelancer' provides.

The services table uses another table called 'languages', which holds titles (EN, DE, FR, etc.), twices, once for a 'source language' and again for 'target language'.

I'm using insertion records to populate the service table with no problem, if I view the services table data, I can see the correct language table values.....I hope this makes sense!

The problem:

On the freelance details page, I'm using a repeat region on the services provided in a table format, but the source and target languages appear in numeric format, rather than the label stored in the languages table.

Does anyone know how I can populate the language values with the labels rather than the numeric values, I've tried to add an extra repeat region within the table, but cannot do so as there is already a repeat region in place for the services.

If anyone can help on this, it would be amaxing, I can provide the sql statements and php data, if needed.

Thanks,

Kool_Samule

[Guest · Accepted solution]

I can understand how your situation is but I can be more understand if u could provide us the sql and php data.

[Guest]

I've got the content to display correctly now, however on another page, it tells me that my MySQL engine has run out of memory, can anyone help me with this one?

http://forums.adobe.com/thread/460621?tstart=0