NYCPHP Meetup

[Matthew Zimmerman]

Whooops... I realize there is some stuff missing from the query and 
from the database I illustrate here. I can give you the proper code if 
needed. I had just tried to dash of a scaled down example quiet 
quickly, but I realize the code I gave makes no sense.
But maybe it doesn't affect the question in hand.. that is... how keys 
appear in an array if you have similar named fields in different 
tables. (ie. images.id, format.id)

Matt



On Wednesday, September 11, 2002, at 01:25  PM, Matthew Zimmerman wrote:

> Hello,
>
> Sorry if this is a RTFM question, but this list has been such a great
> resource I wanted to start here.
>
> Just a question about printing from an array using PHP/MySQL
>
> My real database and code is a little more complex then this, but to
> illustrate my problem let me say
>
> 1. I have two tables: "images" and "format". They each have two fields
> "id" and "name".
>
> 2. I have a query that says
>
> $query= "SELECT images.id, format.id, format.name
> FROM images, format
> WHERE images.id=$id";  /* $id is a passed from a from*/
>
> 3. Then I assign the results to an array using
>
> $result= mysql_query($query);
>
> while ($row=mysql_fetch_array($result)
>
> 	{
> 		extract($row);
>
> 	}
>
> 4. Then I want to print the results which I would think would go like
> this:
>
> echo "$images.id, $format.id, $format.name";
>
> But it seems these are not the keys in the array, but instead there is
> just one $id key and the value of that is whatever "id" came last in
> the query. In other words, if the query read "Select format.id,
> images.id" then there would be a value in the array for $id equal to
> "images.id" and if query read "Select images.id, format.id" then there
> would be a value in the array for the key $id equal to "format_id".
>
> I expected there would be two keys in the array: images.id and 
> format.id
>
> Am I wrong to expect that?
>
> Thanks for any help. I am new to PHP and databases and this code I am
> using I got from a book, so maybe it is the wrong technique.
>
>
> Matt Zimmerman
> NYU
>
>
>
> --- Unsubscribe at http://nyphp.org/list ---
>
>