php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #10861 Array bug w/MySQL
Submitted: 2001-05-14 16:59 UTC Modified: 2001-05-14 17:34 UTC
From: czaries at hotmail dot com Assigned:
Status: Not a bug Package: Arrays related
PHP Version: 4.0.5 OS: Unix
Private report: No CVE-ID: None
View Developer Edit
 [2001-05-14 16:59 UTC] czaries at hotmail dot com 
When trying to put a value from a database into an array for checking, it jsut won't do it...

Like this:
$board_r = mysql_query("SELECT * FROM mb_boards WHERE BoardID='$BoardID'", $link);
$board = mysql_fetch_row ($board_r);
$userarr = array($board[9]);

When I try to call $userarr at a later date, all it prints is: "Array" - and it doesn't put the contents of that veriable into the array, even though the contents of the cell are separated with commas and all the proper stuff needed for an array!

Please help me!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-14 17:06 UTC] derick@php.net 
user error:

change this line:
$userarr = array($board[9]);

to:
$userarr = $board[9];

and mysql_fetch_row gives one row per call

derick
 [2001-05-14 17:34 UTC] cmv@php.net 
You can't "print" an array in PHP.  You either need to loop through the array and print each element, or use something like print_r() or var_dump() to see the contents of the array.

I bet this will work for you:

$board_r = mysql_query("SELECT * FROM mb_boards WHERE BoardID='$BoardID'", $link);
$board = mysql_fetch_row ($board_r);
$userarr = array($board[9]);

print_r($userarr);       // this, or ...
echo $userarr[0];     // this.

- Colin
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Oct 28 20:00:01 2025 UTC