I'm having trouble with mysql and arrays.. HELP!!

Anon

I'm using the mysql_fetch_array() function ..

then I am assigning the array to a variable... ex: while $data=mysql_fetch_arrey($query) ....etc.

after doing so ... I am printing it like so ...

$data[name] (for the name filed)
$data[price] (for the price filed) ...etc.

here is where my problem lays ..

when I am querying multiple tables .. or joining tables, I need to specify field names with the abriviation of the table it self... ex: p.name (product table, name field) or c.id (category ID) or p.id (product id ..) ... you get the picture...

this seems to not work with the array in php3 ...

please give me a segestion .. I'm stuck!!

Anon

here is the errors that I am getting ...

Warning: 0 is not a MySQL result index in /virtualhosts/dvdchief.com/www/search_cat.php3 on line 150

Parse error: parse error, expecting `']'' in /virtualhosts/dvdchief.com/www/search_cat.php3 on line 157

"0 is not a MySQL result" ..?
"expecting `']' " ... ??

help...

thanxxx in advance!
eyal.

Anon

First, put some error checking around the part where you execute the query, something like this:

if (!($result = mysql_query($sql_statement,$db_connection_id)))
{
print "Error executing statement: ".mysql_error()."<BR>";
print $sql_statement."<BR>";
}
else
{

Do what you want

};

That will tell you what's wrong with your query.

Second, if you do a query in mysql, you can use the AS statement to rename your data, like this:

SELECT count(*) as Hits FROM Webserverlogtable;
or
SELECT field1.table1 as One FROM table1,table2