Php, mysql help needed..... please assist...
Posted: Thu Mar 05, 2009 10:17 am
I am trying to display records ...where in table 1(member1d=8) and also where (table2.itemid=table1.postid)
I am not quit sure how to get around it the right way.....
I need help. Thanks.
table 1
+--------+--------+----------+
| joinid | postid | memberid |
+--------+--------+----------+
| 1 | 3 | 8 |
| 2 | 4 | 8 |
| 3 | 5 | 8 |
| 4 | 7 | 8 |
| 5 | 10 | 8 |
+--------+--------+----------+
table 2
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
| id | itemid | posterid | postdate | title | mypost |
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
| 1 | 4 | 8 | 2009-02-23 03:06:07 | problem with my work... | am just testing to see if its ok..
|
| 2 | 9 | 7 | 2009-02-23 03:14:17 | this is for | tes ting again to see
|
| 3 | 21 | 8 | 2009-02-26 14:22:05 | it is ok? | I am having a problem
|
| 4 | 1 | 3 | 2009-02-26 22:21:03 | hi | hi
|
| 5 | 10 | 5 | 2009-02-26 22:24:20 | hi | hi
|
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
V
I am not quit sure how to get around it the right way.....
I need help. Thanks.
table 1
+--------+--------+----------+
| joinid | postid | memberid |
+--------+--------+----------+
| 1 | 3 | 8 |
| 2 | 4 | 8 |
| 3 | 5 | 8 |
| 4 | 7 | 8 |
| 5 | 10 | 8 |
+--------+--------+----------+
table 2
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
| id | itemid | posterid | postdate | title | mypost |
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
| 1 | 4 | 8 | 2009-02-23 03:06:07 | problem with my work... | am just testing to see if its ok..
|
| 2 | 9 | 7 | 2009-02-23 03:14:17 | this is for | tes ting again to see
|
| 3 | 21 | 8 | 2009-02-26 14:22:05 | it is ok? | I am having a problem
|
| 4 | 1 | 3 | 2009-02-26 22:21:03 | hi | hi
|
| 5 | 10 | 5 | 2009-02-26 22:24:20 | hi | hi
|
+----+----------+----------+---------------------+-------------------------+----
--------------------------------+
V