11162004 1514 GMT_6
Ok, based upon my mistake before I created this:
*$sql = "SELECT name, accounts.acct_holderid, fname FROM accounts,
acct_holder WHERE accounts.acct_holderid = acct_holder.acct_holderid
ORDER BY fname ASC";
*
What I want to do is pull ALL the accounts but order them by the account
holder. What I have only pulls one record.
Wade
Mike Hillyer wrote:
You have not specified any relation between the two tables you query,
so you get one row combination for every row in the two tables (a
cartesian product).
$sql = "SELECT accounts.accountsid, name, number, balance, payment
FROM accounts, billing WHERE accounts.accountsid = billing.accountsid
ORDER BY accounts.accountsid";
That should do it.
5 messages in com.mysql.lists.win32Not enough returns
