Bug #10861 Updated: Array bug w/MySQL
| From: | cmv@php.net | Date: | Mon, 14 May 2001 21:34:40 +0000 |
| Subject: | Bug #10861 Updated: Array bug w/MySQL | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-55249@lists.php.net to get a copy of this message | ||
ID: 10861
Updated by: cmv
Reported By: czaries@hotmail.com
Status: Bogus
Bug Type: Arrays related
Operating system:
PHP Version: 4.0.5
Assigned To:
Comments:
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
Previous Comments:
---------------------------------------------------------------------------
[2001-05-14 17:06:22] 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 16:59:21] czaries@hotmail.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!
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10861&edit=2