fenway

Like so: select substring_index( trim( "www.mysite.com?id=" from "www.mysite.com?id=33&name=Brenda" ), '&', 1 )

Why do you have duplicate usernames?

You need a sortorder column -- nothing more.

First, make sure the inner tables (before the union) execute as you expect. Second, consider summarizing this data, instead of pulling it in real-time.

It makes it incredibly easy to link tables together when there's only a single unique column value required.

Other than the fact that you're not quoting (or santizing, for that matter) your input value, it's hard to say without seeing the actual sql statements and errors.

Sounds like parsing error.

I don't see what's not working -- see the link in my sig.

If you think that's sufficient information, you're mistaken.

And what have you tried thusfar?

Your mysql version has a CSV engine for this purpose.

Define "not working".

I'm all about surrogate keys -- having a UID for each record in a table is priceless, and adds little overhead (at least for non-clustered indexes).

Huh?

What makes you think this is mysql-related?

Use mysql_real_escape_string().

Then check the manual for how LIMIT works with a non-zero offset...

Usual many-to-many relation table applies here.

Yes, that's usually the case.

Well, you can't start with IF... but why bother?

Where's the many-to-many table?

In general, more tables are free, at least until traffic becomes a serious issue.

We'll pretend "artical" is a word for the moment.... are you talking about foreign keys? I don't follow.

I don't follow.

This is covered by many a tutorial.