Hi all folks, in this query code from chapter 6 (Beginning Php,apache,Mysql web development), what is the meaning of : '".$_GET['id']."' (I know the meaning of the $_GET array,but why I need the symbols '". ."' ?)

chapter code:
$moviesql = "SELECT * FROM `movie` (why I need the backticks?)
    WHERE `movie`.`movie_id`= '".$_GET['id']."' ";

THIA

Well you write query in string variable, hence in quotes. . i.e., dot is used in string concatenation.

In WHERE clause of SQL, you need put argument in single quotes like id='$id'

In your example, $GET[] variables are joined to SQL query using .. However, PHP can keep value of $ variables in string also, so you may remove dots to make your query easy to understand:

$moviesql = "SELECT * FROM movie WHERE movie.movie_id = '$_GET[\'id\']'";

Backticks ` are not compulsory. Backslash \is used to escape a character (when placed before the character) like '

I hope you understood.

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Support Indian students' finances http://scholarship.mediasworks.com/

I'm confused but thanks for the post...!Best regards!