SQLite Join Problem

[Tikitiki]

Ok so in MySQL a print_r on my users table would look like this...

Array
(
    [uid] => 1
    [username] => somename
    [email] => someemail
    [postnum] => 
    [avatar] => 
    [avatardimensions] => 
    [avatartype] => 
    [usergroup] => 4
    [additionalgroups] => 
    [displaygroup] => 
    [usertitle] => 
    [regdate] => 1166233704
    [lastactive] => 1166233704
    [lastvisit] => 1166233704
    [lastpost] => 
    [website] => 
    [icq] => 
    [aim] => 
    [yahoo] => 
    [msn] => 
    [birthday] => 
    [signature] => 
    [allownotices] => yes
    [hideemail] => no
    [emailnotify] => no
    [invisible] => no
    [receivepms] => yes
    [pmpopup] => yes
    [pmnotify] => yes
    [remember] => yes
    [threadmode] => 
    [showsigs] => yes
    [showavatars] => yes
    [showquickreply] => yes
    [showredirect] => 
    [ppp] => 0
    [tpp] => 0
    [daysprune] => 0
    [dateformat] => 
    [timeformat] => 
    [timezone] => 0
    [dst] => no
    [buddylist] => 
    [ignorelist] => 
    [style] => 0
    [away] => 
    [awaydate] => 
    [returndate] => 
    [awayreason] => 
    [pmfolders] => 
    [notepad] => 
    [referrer] => 0
    [reputation] => 
    [regip] => 127.0.0.1
    [language] => 
    [timeonline] => 
    [showcodebuttons] => 1
    [totalpms] => 
    [unreadpms] => 
)

In SQLite...

Array
(
    [u.uid] => 1
    [u.username] => somename
    [u.email] => someemail
    [u.postnum] => 
    [u.avatar] => 
    [u.avatardimensions] => 
    [u.avatartype] => 
    [u.usergroup] => 4
    [u.additionalgroups] => 
    [u.displaygroup] => 
    [u.usertitle] => 
    [u.regdate] => 1166233704
    [u.lastactive] => 1166233704
    [u.lastvisit] => 1166233704
    [u.lastpost] => 
    [u.website] => 
    [u.icq] => 
    [u.aim] => 
    [u.yahoo] => 
    [u.msn] => 
    [u.birthday] => 
    [u.signature] => 
    [u.allownotices] => yes
    [u.hideemail] => no
    [u.emailnotify] => no
    [u.invisible] => no
    [u.receivepms] => yes
    [u.pmpopup] => yes
    [u.pmnotify] => yes
    [u.remember] => yes
    [u.threadmode] => 
    [u.showsigs] => yes
    [u.showavatars] => yes
    [u.showquickreply] => yes
    [u.showredirect] => 
    [u.ppp] => 0
    [u.tpp] => 0
    [u.daysprune] => 0
    [u.dateformat] => 
    [u.timeformat] => 
    [u.timezone] => 0
    [u.dst] => no
    [u.buddylist] => 
    [u.ignorelist] => 
    [u.style] => 0
    [u.away] => 
    [u.awaydate] => 
    [u.returndate] => 
    [u.awayreason] => 
    [u.pmfolders] => 
    [u.notepad] => 
    [u.referrer] => 0
    [u.reputation] => 
    [u.regip] => 127.0.0.1
    [u.language] => 
    [u.timeonline] => 
    [u.showcodebuttons] => 1
    [u.totalpms] => 
    [u.unreadpms] => 
)

Is there any way to remove the u. from the query statement by setting an option or something like that? I'm open to suggestions 🙂

Thanks in advanced

Cheers,
Tikitiki 🙂

[bretticus]

Just to get this straight...

So you are using table aliases in your query like:

SELECT n.somefield FROM table n

...? And when you call...

$row = sqlite_fetch_array($query, SQLITE_ASSOC));

...you get the table alias ("n") in your array keys?

[Tikitiki]

Exactly.

[Tikitiki]

Nevermind, I figured it out on my own! Thanks allot anyway 🙂 I used

@sqlite_query('PRAGMA short_column_names = 1', $this->link);