gpetropoulos

Ever wonder how to import data from an xls file into your mysql database?
Well the answer is by creating the insert statements in your xls file and then using a mysql client tool such as MySQL Workbench, SQL Yog etc.

Use the below code to create your import queries (in the Formula builder in your xls file)
=CONCATENATE("insert into table_name (table_column1,table_column2,table_column3,...table_columnX) values (";B19;",";C19;",'";D19;"','";E19;"','";F19;"',";G19;");")

If we would like to use dropdown menu in drupal the best practice is to use the module "Nice Menus".
Click here for more instructions about nice menu installation,settings etc.

Furthermore if we would like to use nice menus in our custom template we can use the below links:

For Drupal 6 we use the following php snippet:
print theme('nice_menus_primary_links', 'down');

*base_path():Returns the base URL path of the Drupal installation. At the very least, this will always default to /.
*path_to_theme():Return the path to the current themed element.

So when we are theming our drupal site or we need to get the actual path, we can use the following PHP code:

echo base_path().path_to_theme();