Ad:

PHP Discussion Thread
Unsolved
Views: 714

Jun 30th, 2009

need help with an array

Expand Post »

I am using wysiwygPro editor and i want to be able to display the menu titles coming from the database.

This is an example layout:

PHP Syntax (Toggle Plain Text)
$editor->links = array(
    array('title'=>'Home', 'URL'=>'/'),
    array('title'=>'About Us','URL'=>'/about/', 'children'=>array(
        array('title'=>'Company History','URL'=>'/about/history.php'),
        array('title'=>'Franchise Information','URL'=>'/about/franchise.php'),
        array('title'=>'Shareholders Information','URL'=>'/about/shareholders.php'),
    )),
    array('title'=>'Services', 'URL'=>'/services/'),
    array('title'=>'Contact Us', 'URL'=>'/contact/'),
);
$editor->links = array(
    array('title'=>'Home', 'URL'=>'/'),
    array('title'=>'About Us','URL'=>'/about/', 'children'=>array(
        array('title'=>'Company History','URL'=>'/about/history.php'),
        array('title'=>'Franchise Information','URL'=>'/about/franchise.php'),
        array('title'=>'Shareholders Information','URL'=>'/about/shareholders.php'),
    )),
    array('title'=>'Services', 'URL'=>'/services/'),
    array('title'=>'Contact Us', 'URL'=>'/contact/'),
);

So this is my SELECT query with the array. But i cant seem to get it right.

PHP Syntax (Toggle Plain Text)
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());				
if(mysql_num_rows($menuQ) > 0){
    echo 'array(';
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
            //echo $menuR['title'].'<br/>';
            $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/?mid='.$menuR['menu_id'].'');            
    }
    echo ');';
    $editor->links = array($mylinks);    
}
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());				
if(mysql_num_rows($menuQ) > 0){
    echo 'array(';
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
            //echo $menuR['title'].'<br/>';
            $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/?mid='.$menuR['menu_id'].'');            
    }
    echo ');';
    $editor->links = array($mylinks);    
}

can anyone correct me please?

thanks

Similar Threads

Can I ghost a RAID array??? in Windows NT / 2000 / XP
Creating dynamic array structures in C++
Array limit in C
struct dynamic 2d array alloc in C
string to integer array transformation in C

sassenach

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since Mar 2009

Permalink

Jun 30th, 2009

-2

Re: need help with an array

Please search in tutorialized.com

ayesha789

Reputation Points: 17

Solved Threads: 6

Posting Pro in Training

Offline

485 posts
since Jun 2009

Permalink

Jun 30th, 2009

-1

Re: need help with an array

php Syntax (Toggle Plain Text)
$result		= mysql_query($sql);//execute query
if(mysql_num_rows($result)>0)
{
	$i=0;
	while($row=mysql_fetch_object($res))
	{	
		$data[$i]['table_id']	= $row->table_id;
		$data[$i]['title']		= $row->table_title;
		$mylinks				= $data[$i]['title'];
		$i++;
 
	}
}
$result		= mysql_query($sql);//execute query
if(mysql_num_rows($result)>0)
{
	$i=0;
	while($row=mysql_fetch_object($res))
	{	
		$data[$i]['table_id']	= $row->table_id;
		$data[$i]['title']		= $row->table_title;
		$mylinks				= $data[$i]['title'];
		$i++;
		
	}
}

Now $mylinks is an array having the values titles.
Hope this will do the work.

Last edited by peter_budo; Jul 1st, 2009 at 1:03 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

jino

Reputation Points: 10

Solved Threads: 10

Junior Poster

Offline

114 posts
since Feb 2008

Permalink

Jun 30th, 2009

Re: need help with an array

What is your database layout like?

How are you handling the children? Do you have any logic in place for those.

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Jul 1st, 2009

Re: need help with an array

ok so i got it to work. this works:

PHP Syntax (Toggle Plain Text)
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());               
if(mysql_num_rows($menuQ) > 0){
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
        $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/index.php?mid='.$menuR['menu_id'].'');           
    }
    $editor->links = $mylinks;
}
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());               
if(mysql_num_rows($menuQ) > 0){
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
        $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/index.php?mid='.$menuR['menu_id'].'');           
    }
    $editor->links = $mylinks;
}

sassenach

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since Mar 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Automatically add a link & new page

Next Thread in PHP Forum Timeline: Upload File In Server

DaniWeb Message

Cancel Changes

User Name
Password