Database Problem PHP Mysql

DevF

Hi All,

Lets say i have a 2 tables
Table1
ID(int)
Name(varchar)

Table2
ID2(int)

---

ID = ID2

So on a page if i have ID2 on table 2, i would like to display Name on table1, how would i go about doing this?
Sorry if it is a bit confusing but let me know if you are confused.

CuAnnan

DevF wrote: »

Hi All,

Lets say i have a 2 tables
Table1
ID(int)
Name(varchar)

Table2
ID2(int)

---

ID = ID2

So on a page if i have ID2 on table 2, i would like to display Name on table1, how would i go about doing this?
Sorry if it is a bit confusing but let me know if you are confused.

What, you mean a join?

Adam

If you have ID2 in a variable all you need is a WHERE sql lookup...

DevF

Yea Id2 is a variable, would you mind writing out the sample code in php?

Adam

http://www.coursesweb.net/php-mysql/php-mysql-where-like

There's a million examples out there, best that you read a bit more about it rather than just get the answer given to you.