Function Error

[Lee-Bartlett]

I keep getting

 

 

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\xampp\htdocs\Website\includes\functions.php on line 10

 

but i cant actually see what is wrong with it, can anyone help

That is my function

 

<? php

function confirm_query($result_set) {
if (!$result_set) {
die("database query failed: " . mysql_error());
}
}
function 'get_all_subjects'() {
global $connect
$query = "SELECT * FROM subjects ORDER BY position ASC";
$subject_set = mysql_query($query, $connect);
confirm_query ($subject_set);
return $subject_set;
}

function = get_pages_for_subject(subject_id) {
global $connect
$query = "SELECT * FROM tblpages WHERE subject_id = {$subject_id["id"]}";
$page_set = mysql_query($query, $connect);
confirm_query ($page_set);
return $page_set;
}
?>

 

 

 

 

[jonsjava]

a few errors. I cleaned them up. If you want an explanation, just ask!

 

<?php
function confirm_query($result_set) {
if (!$result_set) {
	die("database query failed: " . mysql_error());
}
}
function get_all_subjects() {
global $connect;
$query = "SELECT * FROM subjects ORDER BY position ASC";
$subject_set = mysql_query($query, $connect);
confirm_query ($subject_set);
return $subject_set;
}

function get_pages_for_subject($subject_id) {
global $connect;
$query = "SELECT * FROM tblpages WHERE subject_id = {$subject_id["id"]}";
$page_set = mysql_query($query, $connect);
confirm_query ($page_set);
return $page_set;
}
?>

[Lee-Bartlett]

Can you please show me what you cleared up, best way for me to know in the future if that is possible.

[.josh]

a) you don't have a closing } for your confirm_query function, you just go right into get_all_subjects function

b) you had single quotes around your 2nd function name

c) you don't have a ; at the end of

 

global $connect

[jonsjava]

you had a space between <? and php

you had single quotes around the function name get_all_subjects

you forgot the semi-colon after global $connect (both spots)

you had an equal sign between function and get_pages_for_subject(subject_id)

you did not have a "$" in front of subject_id

 

[Lee-Bartlett]

Ah little bits a missed, bugging me for a while, ty guys