fenway

Huh?

What are you trying to do?

You need a LEFT JOIN.

Echo the interpolated query.

It will "submit" as many fields as you POST to it... and yes, you'll need to insert multiple records.

You can just shuffle a list of UIDs in php and store the result back.

This: Product number 1 -needs- Component A and B Product number 2 -needs- Component A and C Product number 3 -needs- Component A, B, and C requires this: Product number 1: Component A Product number 1: Component B Product number 1: Component C .... in the relating table. Doesn't matter if it's one to many or many-to-many.

JavaScript and PHP have nothing to do with one another.

This is now a php error only -- if the sql part has been resolved, I'll move this thread accordingly.

That's not a function.

You need to overload onselectstart...

Sure... "countdown js setInterval"

Have you read through the sticky?

Doesn't matter how it's set up -- always use a many-to-many table for stuff like this.

Are the actual values in the DB correct? I don't know how phpmyadmin supports these.

Actually, the second argument can't have spaces... it's the window name, not the title.

.data? That's an unusual attribute to set.

You want the number to change every second... that's an interval.

What doesn't work about it?

And that comes back as a string?

This doesn't sound like it has anything to do with mysql, but rather with php's str_replace() function... if so, I'll move it to the appropriate forum.

Strange... post the table structure.

Delimited number of strings? that's your problem -- you need to normalize this table.

Yes... use IF( paid >0, 0, 1 )

Why would you have any trouble?