Java and database again..

[teongkia]

Hi i have this code:
Menu1_1=new Array("Member Listing","admin_database.php","",0,20,109);

How can i make it fetch the data from the column name from the database?
How can i insert <?php echo $row_rs7['name'];?> into it?
I tried on this Menu1_1=<?php echo $row_rs7['name'];?> but it doesn't work.Can anyone guild me?Thanks.

[fert]

mysql_query

[teongkia]

I have this:
mysql_select_db($database_mConn, $mConn);
$query_rs7 = "SELECT * FROM example1 WHERE id='3'";
$rs7 = mysql_query($query_rs7, $mConn) or die(mysql_error());
$row_rs7 = mysql_fetch_assoc($rs7);
$totalRows_rs7 = mysql_num_rows($rs7);

but my problem is how to insert the <?php echo $row_rs7['name'];?> into the Menu1_1=new Array("Member Listing","admin_database.php","",0,20,109);
I tried Menu1_1=<?php echo $row_rs7['name'];?> and the column name i put new Array("Member Listing","admin_database.php","",0,20,109); but it doesn't work..Plz help..

[fert]

you forgot a $ in front of Menu1_1 and Array isn't a class

[teongkia]

Er..I dun get what you mean.Anyway i have this:
Menu1=new Array("<img src='../frontpage-admin/menu-bar-wcm.gif'>","admin_theme.php","",7,48,108);
Menu1_1=new Array("Member Listing","admin_database.php","",0,20,109);
Menu1_2=new Array("Home","admin_home.php","",0,20,108);
Menu1_3=new Array("News & Events","admin_news.php","",0,20,108);
Menu1_4=new Array("About Us","admin_about.php","",0,20,108);
Menu1_5=new Array("Contact Us","admin_contact.php","",0,20,108);
Menu1_6=new Array("FAQs","admin_faq.php","",0,20,108);
Menu1_7=new Array("e-Education","admin_edu.php","",0,20,108);

I just want to set for Menu1_1 where i can change the link page(admin_database.php) from the database itself and do not need to go into code and change it.But i could not get what i wanted..Plz help..Thanks.

[fert]

you only use new when using classes, but array isn't a class it's a function and you need to change Menu1_1 to $Menu1_1

[teongkia]

Er sorry i still blur..Can you write me out the code?Actually i know nothing much about java but my task is to set the link from the database.For the case menu2[1]='<?php echo $row_rs6['name'];?>' i am able to link it to database.But for this one Menu1_1=new Array("Member Listing","admin_database.php","",0,20,109); i tried out Menu1_1='<?php echo $row_rs7['name'];?>' but couldn't work.. help me..Thanks..

[fert]

wait, do you connect to the database in admin_database.php?

[teongkia]

ya..

[fert]

insert this at the top of your code:
[code]
require("admin_database.php");
[/code]
that should solve your problem

[teongkia]

Er don't think so is the problem.The main problem is i don't know how to insert <?php echo $row_rs7['name'];?> into Menu1_1=new Array("Member Listing","admin_database.php","",0,20,109); for example: Menu1_1=<?php echo $row_rs7['name'];?> to get the data from the database.I tried this but failed and comes out the 'StartTop' is undefined problem when i load the page.The drop down list also become unavailable.Maybe am wrong with ' or " signs..