Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

PHP + MySQL - Presenting Data

Guest
Jul 07, 2009 Jul 07, 2009

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

TOPICS
Server side applications
533
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Deleted User
Jul 07, 2009 Jul 07, 2009

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

Translate
Guest
Jul 07, 2009 Jul 07, 2009

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jul 10, 2009 Jul 10, 2009
LATEST

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines