php mysql compare values

Question

I have an mysql database named gpstracking. There are a couple tables in this database: positions and devices.

What is the issue. On the table positions we have a row called device_id.

On the table devices we have a row called id.

On the table devices we have a row called name.

The device_id and id rows are the same id's, they are pointed to get the name. My problem is, how to in PHP a loop or something to get the name when compare the 2 id rows.

So example:

device_id row:
1 
2
3
4
5

id row:

1      Jan
2      Klaas
3      Piet

So if i fetch the information from table with the device_id row, i want that the script can get the name from the device_id.

Can someone help me ?

en.wikipedia.org/wiki/Join_%28SQL%29

Marc B
– Marc B

2014-04-28 19:37:54 +00:00
Commented Apr 28, 2014 at 19:37 — Marc B
– Marc B, Commented Apr 28, 2014 at 19:37

Alex · Accepted Answer · 2014-04-28 19:37:04Z

1

You mean this:

Select * from positions
join devices ON positions.device_id = devices.id

answered Apr 28, 2014 at 19:37

Alex

8,0827 gold badges44 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php mysql compare values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related