help with creating a mysqli function

[jrough]

I need help with creating the store_sql() function used for storing a query in an associative array so I can retrieve the query by the query name, $queries['city_info']

This is an example of the parameters for the $queries var:

$db->store_sql('SELECT fname, lname from students WHERE lname=?','student_list' );

This is what I have so far:

public function store_sql($query, $query_name){
    $this->queries[$query][$query_name)  {
   return$this->queries[$query_name]
 }

I get a Parse error:syntax error, unexpected T_logical_or after I call this function
here:

$db->store_sql('SELECT fname, lname from students WHERE lname=?','student_list' );

thnkx,

[bradgrafelman]

The parse error I noticed is that you have an extra opening '{' brace here:

$this->queries[$query][$query_name)  { 

as well as a missing semicolon on that line and the next.

[jrough]

Well I must have typed something wrong. I have a different error now.
NOw I'm getting this

Parse error: syntax error, unexpected ';', expecting T_WHILE in /Users/jlrough/Sites/announce_media/studentlist.php on line 53

line 53 is the last line before the ?>
I don't see any extra ;'s
I looked in the class also

$result = $db->query($queries) or die($db->error());

 while ($row = $result->fetch_assoc()) {

 	   foreach($row as $key=>$value) {
 	   	      echo ''.$key.': '.$value.'';
 	   }
 	          echo ' ';
 }

echo $db->prepared_query_result($queries['student_list'], 'Smith');   	
$query  = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5;";
$db->multi_query($query) or die ($db->error());

do {//store the result of the query using the mysqli’s store_result method and put a check around it to make sure it executes properly:

if ($result = $db->store_result()) {//if yes, start another iterator here for each row (note: we’re in the first query)
	while ($row = $result->fetch_row()) {

//now, we print the data out (we know it’s only one piece of info, the username, so just the first element of the row array is needed):

	printf("%s", $row[0]);

} // end while loop
  $result->close();  //existing DB class
} // end if block

  //    check for another queries data here, if yes, print a break tag:

if ($db->more_results()) {

printf("");

} //end if 
}

?>

thanks,

[bradgrafelman]

The unexpected semicolon comes from the closing '?>' of the script (the '?>' can take on the role of a closing semicolon if the statement before it doesn't have one).

This semicolon was unexpected because you have a do {} section with no while(); after it (commonly referred to as a 'do-while loop').