mysql_fetch_array problem

[robert_gsfame]

I have tried to retrieve the record ['id'] which is an autoincrement number from database

using mysql_fetch_array but then instead of getting the same result as what stored in database, i get this : 1

 

database: 25, 3, 7

mysql_fetch_array: 1, 1, 1

 

what is actually cause the problem, can anyone help me?

thx

 

 

 

 

[AdRock]

You need to show some code so we can see what the problem is

[robert_gsfame]

this is just some code

$selectquery=mysql_query("SELECT * FROM detail dg JOIN userlist dp ON dg.username=dp.username WHERE dg.province='Austin'  LIMIT 0, 5");

while($selectarray=mysql_fetch_array($selectquery)){

$selectid=$selectarray['id'];

echo $selectid."<br>";

}

[robert_gsfame]

Just for info, there is no problem in retrieving other records except id

[robert_gsfame]

I got some clue now.......i have to state one by one records that i want to SELECT, so instead of using *, i  have to state dg.id

[jcbones]

Mysql is most likely confused on which tables ID you want.  Try:

SELECT dg.* FROM detail dg JOIN userlist dp ON dg.username=dp.username WHERE dg.province='Austin'  LIMIT 0, 5

[AdRock]

Mysql is most likely confused on which tables ID you want.  Try:

SELECT dg.* FROM detail dg JOIN userlist dp ON dg.username=dp.username WHERE dg.province='Austin'  LIMIT 0, 5

 

I was just about to suggest that

[robert_gsfame]

Yeah dg.* solve everything.....THX A LOT!!!