User Profile

jaxpylon · Jun 10 '07, 07:44 AM

It might be possible to do it using a column alias:

Code:

CREATE TABLE table2 SELECT *, usern AS username FROM table1;

Else, you can do it in two transactions:

Code:

CREATE TABLE table2 SELECT * FROM table1;

ALTER TABLE table2 RENAME COLUMN usern to username;

jaxpylon · Jun 8 '07, 12:36 PM

Not entirely sure what you mean by a condition when it joins. It gets the other username (the topic creator) prefectly fine.

Essentially, what I need for that second user name is:

Code:

SELECT Usr_Name
FROM user_account
WHERE Usr_ID = (SELECT Poster_ID
                FROM message
                WHERE Post_Date = (SELECT Max(Post_Date)
                                   FROM message)));

...

jaxpylon · Jun 8 '07, 06:46 AM

I assume you already have some users table in the database?

What you need to do is create a new table in your database - let's say DailyRoster.

Code:

CREATE TABLE DailyRoster {
    id_user int(11) NOT NULL, -- Should be the same as the key in your users table
    date datetime NOT NULL,
    PRIMARY KEY (id_user, date)
};

Then, just put this on your page. This will check if a user's...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Multiple Join MySQL Query