[RESOLVED] Query as a function

mattastic

Hi all,

Can anybody help me with this code?

I need to check to see if the studentevent field is equal to 1

I use this alot, can i put this into a function also?

Thankyou

$query = "SELECT studentevent 
FROM tblgroup 
WHERE groupID = '$groupID'"; 
$result = mysql_query($query) or die ("Query failed: $query - " . mysql_error()); 
if ($myrow = mysql_fetch_array($result) && $myrow[studentevent] == 1) { // see if we got 1 or more rows returned 
echo "this is a student event";} 
else{ 
echo "this is not a student event"; 
}

bogu

Yes u can ...

mattastic

Could you tell me how I can do that please? And how I could call it?

I need to use the groupid as a parameter.

Thankyou

Pinkmischief

For calling in a function from what i can gather is use your code but add the words function to it at the top and then close curlies at the bottom of the function like below

function querystudent(){
$query = "SELECT studentevent 
FROM tblgroup 
WHERE groupID = '$groupID'"; 
$result = mysql_query($query) or die ("Query failed: $query - " . mysql_error()); 
if ($myrow = mysql_fetch_array($result) && $myrow[studentevent] == 1) { // see if we got 1 or more rows returned 
echo "this is a student event";} 
else{ 
echo "this is not a student event"; 
}
//ending curlie for function below 
}

and then in you rpage where you wish to call this function just type

<?php querystudent(); ?>

and that will call the function if you have saved the query in another page you will have to include that page using somethign similar to this

include_once('path to file here');

in the page where you are calling that function.

I hope that this helps.

Regards Pinky

cahva

That function would not work and theres other little things that caught my eye..

Theres $groupID variable inside function and inside the function it would not work unless its a global value.
why use mysql_fetch_assoc when you can search within the query if the event is 1 and just return number of rows.
if using function, it would better to always use return, not echo . Do not print/echo anything inside function unless you absolutely have to.

Heres corrected version:

function querystudent($groupID) {
	$query = "SELECT studentevent
	FROM tblgroup
	WHERE groupID = '$groupID' AND studentevent=1";
	$result = mysql_query($query) or die ("Query failed: $query - " . mysql_error());
	if (mysql_num_rows($result)>0) { // see if we got 1 or more rows returned
		return('this is a student event');
	else
		return('this is not a student event');
}

And how to use that:

echo querystudent($groupID);

mattastic

Thankyou so much

Pinkmischief

you was right cahva 🙂 im relatively new to php so ty for taking it easy on me lol