在PHP中选择2个vars的mysql

How i can make this whitout php notice error:

$id = $_GET['id'];
$name = $_POST['name'];

$sql = mysql_query("SELECT * FROM table WHERE id = '$id' or name = '$name');

And how i can do one search in many tables at once.

Thank you

Your query string is incomplete. You need a closing double quote at the end.

$sql = mysql_query("SELECT * FROM table WHERE id = '$id' or name = '$name'");
                   ^                                                      ^

To search many tables at once, add more tables separated by a comma.

"SELECT table1.field, table2.field FROM table1, table2"

$id = isset($_GET['id']) ? $_GET['id'] : null;
$name = isset($_POST['name']) ? $_POST['name'] : null;

if($id !== null || $name !== null) {
  $sql = mysql_query("SELECT * FROM table WHERE id = '$id' or name = '$name'");
}