Is this possible?

[klops12]

I want to make two text inputs and one text output, and text would be colored according to which text input was used? And I want to make three different movieclips for this.

[Jorge Solis]

You should use TextFormat to change the color in the output, or you can reuse the same TextFormat and change the color property ... is not neccesary to use three MovieClips. Check TextFormat entry in AS dictionaty to grab some example

Jorge

[klops12]

Jorge, is it possible that one text area takes data from two sql databases?

[Jorge Solis]

This is not the concern of Flash, but your back-end language. Flash just call a script that pass data in any format (name/valu pairs, XML, Remoting) and display. Your back-end make the DB access. If you want to check about how Flash loads data, check http://www.flash-db.com/Tutorials/loadingAS3/

Jorge

[klops12]

Ok Jorge, I made few changes and right now my guestbook looks like that www.avsb1.byethost2.com. There are two text input modules, two databases, one output and one PHP file to control everything .

The problem:
I don't know how to make PHP file to return entries from both databases according to their input time.
Btw both inputs work perfect, cause entries are saved in databases.

P.S. This is my first experience with PHP, before this worked only with Flash.

[Jorge Solis]

Why two databases?

Jorge

[klops12]

I have two counters, so they both have to work correctly, is it possible with one database?

[Jorge Solis]

Can you elaborate? Why two counters?

Jorge

[klops12]

Cause I have two inputs and I need counter for each one.

[Jorge Solis]

Use two different tables in the same database, using two databases sounds like a waste of resources (and more code on the server side)

Jorge

[klops12]

OK, will try.

[klops12]

I made two tables, but now A input doesn't work and output either Need to improve PHP code.

[Jorge Solis]

Sure, you need to change select. If you're not familiar with PHP, probably can just copy/paste the original code and change the table. The point is that you need to call different scripts from Flash based on the input text. And in the middle you should load also messages from one or another table.
Another approach is just to add a new column in the table (say type), append this property to the message and filter messages that you show based on this property, in this case you don't need extra tables, just modify the tables you have

Jorge

[klops12]

Yeah, tried just copy/paste, but as you can see it doesn't work... will try to edit PHP script as far as I can

[Ronald Wernecke]

The secret lies in the php code only.
Flash itself does not care

It realy depends what you realy want to do.

If it is only counters, you can do this with differnet fields in an single table.
If you want to count records, it can be deiiferent tables in the databes.

But if you are controlling different webshops or alike, you might have differnt databases.

You can manage everything with a single flash frontend.

But you have to manage somehow, that the php script knows whicht data is to be delivered.