Jump to content
Larry Ullman's Book Forums

Getting An Error Occurred In Script


Recommended Posts

<?php // Dynamically generate the content links:
$q = 'SELECT * FROM categories ORDER BY category';
$r = mysqli_query($dbc, $q);
while (list($id, $category) = mysqli_fetch_array($r, MYSQLI_NUM)) {
 echo '<li><a href="category.php?id=' . $id . '" title="' . $category . '">' . $category . '</a></li>';
}
?>

Line 54 is above in the yellow.

 

'C:\xampp\htdocs\MyEcommerce\html\includes\footer.html' on line 54:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
 

Array(    [0] => Array        (            [function] => my_error_handler            [args] => Array                (                    [0] => 2                    [1] => mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given                    [2] => C:\xampp\htdocs\MyEcommerce\html\includes\footer.html                    [3] => 54                    [4] => Array                        (                            [_GET] => Array                                (                                )                            [_POST] => Array                                (                                )                            [_COOKIE] => Array                                (                                    [PHPSESSID] => tl6m4s5b4toqjd27p1hmuesen3                                )                            [_FILES] => Array                                (                                )                            [_SERVER] => Array                                (                                    [MIBDIRS] => C:/xampp/php/extras/mibs                                    [MYSQL_HOME] => \xampp\mysql\bin                                    [OPENSSL_CONF] => C:/xampp/apache/bin/openssl.cnf                                    [PHP_PEAR_SYSCONF_DIR] => \xampp\php                                    [PHPRC] => \xampp\php                                    [TMP] => \xampp\tmp                                    [HTTP_ACCEPT] => text/html, application/xhtml+xml, */*                                    [HTTP_ACCEPT_LANGUAGE] => en-US                                    [HTTP_USER_AGENT] => Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)                                    [HTTP_ACCEPT_ENCODING] => gzip, deflate                                    [HTTP_HOST] => localhost                                    [HTTP_DNT] => 1                                    [HTTP_CONNECTION] => Keep-Alive                                    [HTTP_COOKIE] => PHPSESSID=tl6m4s5b4toqjd27p1hmuesen3                                    [PATH] => C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Toshiba\Bluetooth Toshiba Stack\sys\;C:\Program Files (x86)\Toshiba\Bluetooth Toshiba Stack\sys\x64\;                                    [SystemRoot] => C:\windows                                    [COMSPEC] => C:\windows\system32\cmd.exe                                    [PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC                                    [WINDIR] => C:\windows                                    [SERVER_SIGNATURE] => Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7 Server at localhost Port 80                                    [SERVER_SOFTWARE] => Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7                                    [SERVER_NAME] => localhost                                    [SERVER_ADDR] => ::1                                    [SERVER_PORT] => 80                                    [REMOTE_ADDR] => ::1                                    [DOCUMENT_ROOT] => C:/xampp/htdocs                                    [REQUEST_SCHEME] => http                                    [CONTEXT_PREFIX] =>                                     [CONTEXT_DOCUMENT_ROOT] => C:/xampp/htdocs                                    [SERVER_ADMIN] => postmaster@localhost                                    [SCRIPT_FILENAME] => C:/xampp/htdocs/MyEcommerce/html/index.php                                    [REMOTE_PORT] => 49599                                    [GATEWAY_INTERFACE] => CGI/1.1                                    [SERVER_PROTOCOL] => HTTP/1.1                                    [REQUEST_METHOD] => GET                                    [QUERY_STRING] =>                                     [REQUEST_URI] => /MyEcommerce/html/index.php                                    [SCRIPT_NAME] => /MyEcommerce/html/index.php                                    [PHP_SELF] => /MyEcommerce/html/index.php                                    [REQUEST_TIME_FLOAT] => 1364055892.085                                    [REQUEST_TIME] => 1364055892                                )                            [live] =>                             [contact_email] => you@example.com                            [_SESSION] => Array                                (                                )                            [dbc] => mysqli Object                                (                                    [affected_rows] => -1                                    [client_info] => mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $                                    [client_version] => 50010                                    [connect_errno] => 0                                    [connect_error] =>                                     [errno] => 1046                                    [error] => No database selected                                    [error_list] => Array                                        (                                            [0] => Array                                                (                                                    [errno] => 1046                                                    [sqlstate] => 3D000                                                    [error] => No database selected                                                )                                        )                                    [field_count] => 0                                    [host_info] => localhost via TCP/IP                                    [info] =>                                     [insert_id] => 0                                    [server_info] => 5.5.27                                    [server_version] => 50527                                    [stat] => Uptime: 9026  Threads: 1  Questions: 8  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 0  Queries per second avg: 0.000                                    [sqlstate] => 00000                                    [protocol_version] => 10                                    [thread_id] => 2                                    [warning_count] => 0                                )                            [pages] => Array                                (                                    [Home] => index.php                                    [About] => #                                    [Contact] => #                                    [Register] => register.php                                )                            [this_page] => index.php                            [v] => register.php                            [k] => Register                            [login_errors] => Array                                (                                )                            [q] => SELECT * FROM categories ORDER BY category                            [r] =>                         )                )        )    [1] => Array        (            [file] => C:\xampp\htdocs\MyEcommerce\html\includes\footer.html            [line] => 54            [function] => mysqli_fetch_array            [args] => Array                (                    [0] =>                     [1] => 2                )        )    [2] => Array        (            [file] => C:\xampp\htdocs\MyEcommerce\html\index.php            [line] => 38            [args] => Array                (                    [0] => C:\xampp\htdocs\MyEcommerce\html\includes\footer.html                )            [function] => require        ))
Link to comment
Share on other sites

 Share

×
×
  • Create New...