Chapter 4 pg 114 (Improving your Table)

hozdaman · August 25th, 2010, 02:44 PM

Hi,

I keep getting this error when working Chapter 4 example. Any help would be appreciated.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

PHP Code:


			
<?php



//take in the id of a director and return his/her full name

function get_director($director_id) {

  global $db;



    $query = 'SELECT

            people_fullname

       FROM

           people

       WHERE

           people_id = ' . $director_id;

    $results = mysql_query($query) or die(mysql_error());



    $row = mysql_fetch_assoc($results);

    extract($row);



    return $people_fullname;

}

vocabulary2001 · September 5th, 2010, 03:25 PM

I think you may have forgotten the $db in the brackets for:

Code:

$results = mysql_query($query) or die(mysql_error());

should be:

Code:

$results = mysql_query($query,$db) or die(mysql_error($db));

...hope it works