getting weird error..

Posted on 16th Feb 2014 07:03 pm by admin

okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMIT statement, but as far as I can see I have it right, currently using easymysql3.0 as test server, which was latest version as of a couple weeks ago.

Code: function get_subject_by_id($subject_id) {
global $connection;
$query = "SELECT * ";
$query .="FROM subjects ";
$query .="WHERE id=" . $subject_id . " ";
$query .="LIMIT 1"; //this is the line I'm having problems with comes up as syntax error ***this is where problem is at least the one I know about***
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
//if no rows are returned fetch array will return false
if ($subject = mysql_fetch_array($result_set)) {
return $subject;
} else {
return NULL;
}
}
I'd really appreciate the help, thanks for looking at it.

Your Answer:

Login to answer

Other forums

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

Help, Base64 encoding url and decoding server side.
Hello everyone, i have a website with videos and games and also provide an embed code which people c

Question about GD library
I am trying to make an image that shows a random quote from my database.


However I want t

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

BackButton Behaviour in AJAX
I have an ASPX Page AJAX Enabled!The page has a gridView and a DDL for filtering on it. The Gridview

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi