jenningsdove
New Member
My project is working fine on my local machine but not on the web server. I think it is the stored procedures, because the error that I am getting is:\[code\]Fatal error: Call to a member function fetch_array() on a non-object in ...\[/code\]The collation of the database is "utf8_general_ci".Just a simple example:\[quote\] I have a stored procedure called offices: CREATE PROCEDURE offices() BEGIN\[code\]SELECT * FROM offices;\[/code\] END//\[/quote\]And the php code:\[code\]<?php\[/code\]\[quote\] require ("db.php"); $db = dbConnect(); $result = $db->query("CALL offices()"); while(list($id, $city, $address) = $result->fetch_array()) echo "($id) $city: $address
"; ?>\[/quote\]
"; ?>\[/quote\]