Member Avatar for oree

I am trying to use a search script i found online and i am having a problem with the query.
I am trying do a query from multi tables.
I have 12 tables, all have the same fields: name, phone etc.
each table is a different category of items: appliances, art etc..

how do i go through each table and look for the field name?

$value = "oven";
i tried "select * from table1, table2 where name = {$oven}"

It did not work.

Please help with some suggestions.

Thank you!

  • 2 Contributors
  • 1 Reply
  • 127 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by codewall
Member Avatar for codewall

maybe you can try:

select * from table1 AS a inner join table2 as b on a.name = b.name
where a.name = 'oven'

you can search about sql relationships and joining tables

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.