how to display all values from two different mysql tables?

wrfan

I want to display all data from two different tables, but if I use the following code:

$jokelist = mysql_query(
"SELECT ipnumber, realtime, useragent " . 
	   "FROM ipsucker, user_agent WHERE AID=user_agent.ID");

while ($joke = mysql_fetch_array($jokelist)) { 
	$ip3 = $joke["ipnumber"];  

	$timmy3 = $joke["realtime"]; 
	$usa3 = $joke["useragent"];

echo "<BR>$ip3, $usa3,$timmy3<BR>";
}

I have to create a new column in every table (AID and ID) and assign increasing numbers (first entry would be AID=1 and ID=1, second AID=2 and ID=2 etc.), and I don't know how to tell mysql to insert a new number (last number+1) every time new entries are added to the database.
Maybe there is another possibility to display all values only once, without adding new columns (AID and ID) to every table at all? or if not, how do I tell mysql to add new values to the ID and AID columns everytime new information is added to both tables?

TTT

get max id

$result = select id from table order by id DESC

$new_id = odbc_result($result,1);
$new_id++;

wrfan

thanx for the tip. I also found out that one can achieve what I want using the mysql auto increment function.

Still, I still don't understand completely how these table relationships work. Let's say I have ten customers, and I want to insert their names and their credit card numbers into the database. then I could simply assign ID 1 to customer 1 and credit card Nr. 1 and so on. But what if one these customers has two credit cards, which have to be saved in the database? then I have to connect customer 1 to 2 different credit card numbers. here auto increment would't work. I could use the credit card numbers as the primary key, putting the values in both tables, but how do I use simple numbers as primary keys in these case?

Customer 1 - AID 1
Customer 2 - AID 2

Creditcard Number 1 - ID 1
Creditcard Number 2 - also ID 1
Creditcard Number 3 - ID 2

WHERE AID=creditcards.ID

how do I tell mysql to assign the same ID number to both credit cards when the customer submits both of his credit card numbers?