Loading an Array Problem

Anon

This sounds like a simple question but for some reason I can't figure out what I am doing wrong. I am trying to load a series of values into a set of arrays for constructing tables

Here's the code;
// Connect to the database
$connect = mysql_connect ("$myhost", "$myusername", "$mypassword") or die ("Could not connect");
// Set the query
$query = "select table_id, item_1, item_2 from Some_Table";
// Get the goodies
$result = mysql_db_query($mydatabase, $query);
if ($result) {
// create a counter
$x = 0;
while ($r = mysql_fetch_row($result)) {
$table_id($x) = $r["table_id"];
$item_1($x) = $r["item_1"];
$item2($x) = $r["item_2"];
++$x;
}

In theory this should load the values that I am pulling from the database into three seperate arrays that are keyed with $x. $x gets incremented at the end of the loop for the next row pulled from the database. When I run this script, I get a parse error. The only way that I have found to get rid of the problem is to build my table rows right as I am pulling in the data which abviously means that I can't manipulate the data very easily or even get a quick count of the number of records that I pulled in.

I recall doing something like this in PHP3 but that machine was destroyed so I can't even look at my old source.

Any Ideas?

Patrick
Toronto, ON, Canada

Anon

I should probably mention what the architecture of this machine is. P200, 64MB, 2GB drive. Mandrake 7.2, Apache 1.3.14, PHP4 v4.0.3pl1, MySQL 3.22.32, 3com 509b network.

Everything was compiled from source with no weirdness configured. Straight from the PHP help file.

Anon

There are plenty of errors in your code :

After connecting, you have to select a database with mysql_select_db
Use mysql_fetch_array instead of mysql_fetch_row if you want a fieldname-indexed array
$table_id($x) is incorrect, you have to write $table_id[$x]

You can also omit the counter ($table_id[]=...) to obtain the same result.

Anon

Thank you. Excellent. I was trying to figure out what the hell I had done wrong and changing from ( ) to [ ] is just so simple that I missed it.

After connecting, you have to select a database with mysql_select_db

I do actually select the database to use using this line
$result = mysql_db_query($mydatabase, $query);
The $mydatabase is fed to the script from a required file.

Thanks again.

Patrick