Member Avatar for rukshilag

ok so i have to tables and i want to have a query that selects all from "table a" and "table be" where "a certain variable"="$x".. how do i select all from 2 tables at once?

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by liamfriel
Member Avatar for liamfriel 
$query = "SELECT * FROM `tablea`, `tableb` WHERE `tablea`.`id` = `tableb`.`aid` AND `tablea`.`id`='".$x."'" ;
Edited by liamfriel because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.