[How to use external database in drupal?]

Is it possible to use an external database in drupal without specifying it in the settings file? If so, how?

 

I tried using the simple:

mysql_select_db("mydatabase");
mysql_query("insert .....");

 

but no data was entered.

[[SOLVED] Search for values in arrays]

Maybe I should have made the question a little bit more specific although I will instead make it wider =) More specifically I am thinking about these two scenarios:

 

Array example values: 5, 6, 8, 12, 16, 23, 35

 

Scenario 1:

Finding out if either 5, 8 or 23 exist in the array.

 

Scenario 2:

Finding out if both 5, 8 and 23 exist in the array.

 

In the second case array_diff is definitely the best choice but what about the first? Same and count the result? If the arrays are large this might not be a good idea?

 

In_array is the obvious choice for a single value but I'm not entirely sure of the functionality of in_array when the needle is an array?

[[SOLVED] Search for values in arrays]

Which method is the most efficient if you wish to find out if a number of values all exist within an array?

[[SOLVED] Copying table - loss of data?]

Thanks for the explanation. I suspected it had something to do with memory loss of some kind.

[[SOLVED] Copying table - loss of data?]

I decided to compare every value of the two tables and it turned out that they are exactly the same. I am still very curious as to why there is this difference in size though.

[[SOLVED] Copying table - loss of data?]

I just copied a table in my database by exporting it and then simply replacing the table name before running the exported sql. I was surprised to see that the new table was maybe 5-6% smaller in total size (the rows and indices are the same) than the original one. Is there a chance of some data being lost? If so, is there any easy way that I can check this without checking every single value with a php script?

[[SOLVED] Accessing object array without name]

Thanks, just figured that out myself, it is actually called string =)

[[SOLVED] Accessing object array without name]

I have encountered an object that contains an unnamed array that looks like this:

 

stdClass Object ( [string] => Array ( [0] => 1 [1] => 4 [2] => 14 ) )

 

How do I access that array?

[Web service issue on IIS]

The link doesn't work, that's just a dummy url. Still, if you know about web services, the url doesn't really matter I suppose.

[Tagging Notes]

I suppose the notes are already stored in a database?

 

This is one way to do it:

 

1. Create two new tables in the database, one containing the tags themselves and one containing the relations between tags and notes.

 

2. Add for example a text area to the note form where the users can enter the tags separated by new row, comma or whatever you choose.

 

3. Collect and separate the tags and insert them into the database. You will probably want to add some validation here (max length, max number of tags etc.).

[Web service issue on IIS]

I have run into some problems using a web service on an IIS server. PHP5 runs on the machine and I am unable to use SOAP, which I normally do, since I do not have access to the php.ini file in order to add the extension for some time and we are kind of in a hurry. What other options do I have and how to I execute them?

 

I have never set up a web service on the other end myself and am not really up to date on the general structure of them.

 

I think the web service is only accessible locally and the only address I know of is where the differents methods are listed which is:

 

http://blabla.mysite.tld/dir1/myfile.asmx (and the service description at ?WSDL)

 

Very grateful for any help on this.