在Dreamweaver中创建记录集 - “测试”工作，保存没有

I'm creating a recordset in Dreamweaver with this SQL code:

SELECT elev.fornavn, 
elev.etternavn, 
utplassering.dato_fra, 
utplassering.dato_til, 
fag.fagnavn,  
(SELECT kontaktperson.kp_fornavn FROM kontaktperson WHERE utplassering.kp_skole = kontaktperson.kp_id) AS kp_skole_fornavn,  
(SELECT kontaktperson.kp_etternavn FROM kontaktperson WHERE utplassering.kp_skole = kontaktperson.kp_id) AS kp_skole_etternavn, 
(SELECT kontaktperson.kp_fornavn FROM kontaktperson WHERE utplassering.kp_bedrift = kontaktperson.kp_id) AS kp_bedrift_fornavn, 
(SELECT kontaktperson.kp_etternavn FROM kontaktperson WHERE utplassering.kp_bedrift = kontaktperson.kp_id) AS kp_bedrift_etternavn 
FROM utplassering, elev, fag 
WHERE elev.elevid = utplassering.elev 
AND utplassering.fag = fag.fagid
ORDER BY utplassering.elev ASC

When pressing "Test" in the recordset-setup, it works and shows me the data I'm asking for. When pressing "Ok" and saving the recordset, I get this error:

MySQL Error#: 1064 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 2

I've tried to find solutions, but nothing worked. I also tried to use this directly in the database (MySQLWorkbench), and it worked perfectly. May this be a problem with Dreamweaver?

(Using Dreamweaver CS6 on Mac)

This is the PHP script dreamweaver created: (I'm not too good with code so I can't see what's wrong)

mysql_select_db($database_utplasseringskobling, $utplasseringskobling);
$query_utplassering = "SELECT elev.fornavn,  elev.etternavn,  utplassering.dato_fra,  utplassering.dato_til,  fag.fagnavn,   (SELECT kontaktperson.kp_fornavn FROM kontaktperson WHERE utplassering.kp_skole = kontaktperson.kp_id) AS kp_skole_fornavn,   (SELECT kontaktperson.kp_etternavn FROM kontaktperson WHERE utplassering.kp_skole = kontaktperson.kp_id) AS kp_skole_etternavn,  (SELECT kontaktperson.kp_fornavn FROM kontaktperson WHERE utplassering.kp_bedrift = kontaktperson.kp_id) AS kp_bedrift_fornavn,  (SELECT kontaktperson.kp_etternavn FROM kontaktperson WHERE utplassering.kp_bedrift = kontaktperson.kp_id) AS kp_bedrift_etternavn  FROM utplassering, elev, fag  WHERE elev.elevid = utplassering.elev  AND utplassering.fag = fag.fagid ORDER BY utplassering.elev ASC";
$utplassering = mysql_query($query_utplassering, $utplasseringskobling) or die(mysql_error());
$row_utplassering = mysql_fetch_assoc($utplassering);
$totalRows_utplassering = mysql_num_rows($utplassering);

I checked the PHP script with PHP Code Checker, and it said that I got some deprecated functions. I tried to swap them out with updated functions in Dreamweaver, but then Dreamweaver didn't recognize the PHP code as a recordset any more (didnt't show up in the Bindings tab).

Any clues on how to fix this?