Zikula Community

• Lobos
  
  

  • Rank: Expert
  • Registered: Dec 02, 2002
  • Last visit: Apr 30, 2010
  • Posts: 1474

  Posted: Mar 20, 2006 - 03:14 AM

  Hi there,
  
  could someone tell me how to convert this loop to work with adodb? I tried to do it with $res->GetArray(); but something is lost as it won't work as expected... so what is a good method to mimic mysql_fetch_array with adodb?
  
  while($root = mysql_fetch_array($res)){
  
  $root["prefix"] = $this->get_prefix($root['position']);
  $this->c_list[$root['id']] = $root;
  
  if($RootPos == $root['id'] AND $id != 0 AND $collapsed != ""){
  $this->list_by_id($id);
  continue;
  
  }else{
  
  // lets check if there is sub-categories
  if($collapsed == "" AND $id==0){
  $has_children = $this->has_children($root['position']);
  if($has_children == TRUE) $this->get_children($root['position'],0);
  }}}
  
  TIA,
  
  -Lobos
  
  --
  -Lobos
  Professional PHP Framework Services: Concept, Development and Deployment

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 191

  Posted: Mar 20, 2006 - 05:54 AM

  Not sure if this is what you're looking for, but this method

  Code

  SetFetchMode(ADODB_FETCH_ASSOC);

  tells the ADODB connection object to return associative arrays.

  • 
  •  
• Lobos
  
  

  • Rank: Expert
  • Registered: Dec 02, 2002
  • Last visit: Apr 30, 2010
  • Posts: 1474

  Posted: Mar 21, 2006 - 12:30 AM

  yes I understand this, and tried it as well... thanks
  
  -Lobos
  
  --
  -Lobos
  Professional PHP Framework Services: Concept, Development and Deployment

  • 
  •  
• markwest
  
  

  • Rank: Team Member
  • Registered: Mar 18, 2002
  • Last visit: Oct 21, 2009
  • Posts: 6606

  Posted: Mar 21, 2006 - 12:42 AM

  Lobos,
  
  Try the GetAssoc method of adodb.
  
  -Mark
  
  --
  Visit My homepage and Zikula themes.

  • 
  •  
• Lobos
  
  

  • Rank: Expert
  • Registered: Dec 02, 2002
  • Last visit: Apr 30, 2010
  • Posts: 1474

  Posted: Mar 23, 2006 - 02:45 AM

  Thanks Mark, I will keep this in mind but I haven't got the time to convert the rest of the class to adodb... the native PHP mysql functions will have to suffice for the moment... the class I am working with has been a bit tricky and took too much of my time already, but at least now I have unlimited category depth ;)
  
  -Lobos
  
  --
  -Lobos
  Professional PHP Framework Services: Concept, Development and Deployment

  • 
  •  
• yaaman
  
  

  • Rank: Registered User
  • Registered: Sep 30, 2009
  • Last visit: Sep 30, 2009
  • Posts: 1

  Posted: Sep 30, 2009 - 06:23 AM

  Hi,
  
  good method to mimic mysql_fetch_array() is $res->FetchRow()
  
  Thanks

  • 
  •  
•  
•  

Users on-line

• mazdev

This list is based on users active over the last 60 minutes.