|
-
Feb 22nd, 2013, 11:41 AM
#9
Thread Starter
Lively Member
Re: mysqli dataset, 2nd query not working...
Having played around a bit, I've still go absolutely nowhere, so I'd really appreciate any help...
In my efforts to try and get things working, I've tried to re-look at the function that converts the dataset to an array, however I just get the following error:
Select Sub Sector
Fatal error: Call to a member function fetch_assoc() on a non-object in FILE PATH\functions.php on line 33
The SQL is definitely, absolutely, 100% correct, so that is not the issue!
Code:
function get_combobox_dataset($db1, $query_string) {
//---------------------------------------------------------------------
$result1 = $db1->query($query_string);
$num_results = $result1->num_rows;
$res_array = array();
for ($count=0; $row = $result1->fetch_assoc(); $count++) {
$res_array[$count]=$row;
}
return $res_array;
}
//---------------------------------------------------------------------
So there is some sort of problem with the fetch_assoc line...can anyone help?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|