DaniWeb Forum Index > Web Development > PHP

mysql and php - some clarity please

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: May 2009

Posts: 15

Reputation: Namibnat is an unknown quantity at this point

Solved Threads: 1

Namibnat

Offline

Newbie Poster

mysql and php - some clarity please

Oct 24th, 2009

Please could someone just clear up, or point me to the right thing to read regarding mysql and php.

Once you have made a query and saved it to results, I understand that the query accessed with a number of functions to extract that, such as mysql_fetch_array() and so on.

It returns an "associative array". What does that mean. I seem to always get it working just by trial and error, but I don't actually understand it.

I don't really like to ask questions like this on forums because it seems like I am lazy, but I also can't sit an read endless tutorials hoping that somewhere I will get it. But I am really happy to read tutorials, even if they are fairly verbose, as long as that connection is make clear to me.

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Oct 24th, 2009

An associative array is one with named keys.
Ex.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
array(
  'name' => 'Name here',
  'other' => 'Other data here'
);
array(
  'name' => 'Name here',
  'other' => 'Other data here'
);