01-25-2007, 10:28 AM
|
|
|
Confirmed User
Join Date: Jul 2003
Location: Mobtown
Posts: 2,613
|
Quote:
Originally Posted by darksoul
Code:
SELECT a.thumb as thumb,id,name,username,title,hitCount,timestamp FROM tracks,users as a WHERE username=a.username ORDER BY id DESC LIMIT $offset, $rowsPerPage;
|
Query failed, BUT I think it's because I didn't give you enough info.
table1 - tracks
id
name
TYPE
size
path
username *
title
hitCount
timestamp
table2 - users
username *
password
userid
userlevel
email
timestamp
website
about
hometown
postal
thumb
Thanks for helping. 
__________________
no sig
|
|
|