fenway

I have no idea what you mean... but you can use a multi-valued insert statement.

Forget about the output for a minute... get back the two rows first.

information_schema tables.

Are you searching one of the fields? How?

You should always know that... I suppose you could use the I_S tables to figure it out in real-time, but you should know that your design has some serious flaws. Why did you decide to use dynamic FIELDS?

Oh good,it's not just me.

Thanks for the insight... no worries.

Well, I'm done. Confirm that the data is fine in the database, make sure you're db connection and your php script are set properly. Otherwise, maybe someone else can decipher it.

Post some sample data from the .sql file.

Well, echo them for our benefit, too. You might want to avoid using the same variable, though.

I don't understand.. you show a third table.

what do you have so far? you seem to be missing some tables...

See here -- did you move it in the conf file?

oh, i get it... could you also post the query you're talking about?

that doesn't answer the question.

Wait a minute, dynamic "fields"?

Is this a UTF8 field?

Well, if they all have a space, you can find it, and select out the left and right halves...

Assuming you made the column NULLable.

I suppose you could use format and a replace to get rid of the comma... or just handle it in php for now.

Sure, but you'll need to establish how all of them are formatted first.

Please don't mark anything "solved" without posting the solution for everyone's benefit.

Maybe... are you talking about the actual DB values or PHP output?

That, and DISTINCT is not a function!

That's true... as long as all of the column in the group by appear in distinct, they're the same.. .but that's really what distinct is meant for. Also, performance can be very different -- DISTINCT is very dumb.