|
|
Joined: Aug 2000
Posts: 262
Enthusiast
|
Enthusiast
Joined: Aug 2000
Posts: 262 |
how exaclty do you grab information from two tables. for example from table fav, i want to grab the fusername and fbnumber WHERE the fusername = $Username and fbnumber = $number. And i want to grab the information subject, last post, replies, and views from the table w3t_posts WHERE fbnumber = $number. i have no idea how to do that. thanks for helping! [:red]-------------- http://extremeforums.org/index
|
|
|
|
Joined: Aug 2000
Posts: 262
Enthusiast
|
Enthusiast
Joined: Aug 2000
Posts: 262 |
figured it out. $query = "SELECT fav.fusername,fav.fbnumber,w3t_Posts.B_Subject,w3t_Posts.B_Replies,w3t_Posts.B_Username FROM fav,w3t_Posts WHERE fav.fusername = '$Username' AND fav.fbnumber = B_Number"; [:red]-------------- http://extremeforums.org/index
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 21,079
Joined: March 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|