creating 2 column results mysql php

Some of the code above you dont need

if (file_exists('../library/opendb.php')) {
include("../library/opendb.php");
} else {
include("library/opendb.php");
}
$ASC = 'ASC';
$query="SELECT * FROM gallery_category ORDER BY category_name ASC";
$result=mysql_query($query);

if (!$result==1) {
echo "DB Error, could not query the database\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}

while ($gal = mysql_fetch_assoc($result)) {
myarray=array();
$j=1;
while (next-record-loop)
{
myarray+=array($j=>array('category_id'=>category_id, 'category_name'=>category_name, 'cat_description'=>cat_description));
$j++;
}

I have made the extra bits bold. you don't need the inner while loop. if you want to limit the results, say you have 100 items in your database but only want 10, you'd use limit and even offset

LIMIT 10 // gets first ten results
LIMIT 5,10 // gets 5 results starting at 10 (really 9 as mysql starts at 0)

the highlighted line below is causing a pharse error now...

Parse error: parse error, unexpected '=' in /**/**/**/**/**/**/**/index.php on line 31

been sat here looking at other scripts and example sites and still cant figure this one out..

---------------------------------------------------------------------
if (!$result==1) {
echo "DB Error, could not query the database\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}

while ($gal = mysql_fetch_assoc($result)) {
[****line 31***]myarray=array();[***line 31***]]
myarray+=array($j=>array('category_id'=>category_id, 'category_name'=>category_name, 'cat_description'=>cat_description));

echo "";
echo $gal['category_name'];
echo "";
echo nl2br($gal['cat_description']);
echo "";
------------------------------------------------------------------

myarray=array();

should be

$myarray=array();

(needs the dollar sign) but really that bit and the following bit

myarray+=array($j=>array('category_id'=>category_id, 'category_name'=>category_name, 'cat_description'=>cat_description));

can/should be removed as they aren't doing anything, the results are coming from the database query loop.

If you leave it, the myarray+= needs a dollar sign too.
just comment it out for now even

// single line comment
/* multi
line
comment */
# to end of line comment (not recommend if you edit in different editors)