get variable in url to use in sql statement

[Lazarus]

how do i get the www.domain.com/index.php?show=2

how do i use that "show=2" in the sql statement?...

[jeremuck]

the sure-fire way is like this:

$sql = "SELECT * FROM table WHERE field = '" . $_GET['show'] . "'";