MakeWebGames

# Simple problem solving

## Recommended Posts

This is a small test I have created, with use of other tests around the net.

This one will specifically attain to solving real-world problems that developers face each day.

Furthermore, I'm trying to keep the tasks as simple as possible - so, don't post answers, if you would like to have your answer reviewed PM me.

Given a database, and two tables called "skills" and "user" .

"skills" holds three columns, "id", "label" and "value".

"user" holds four columns, "id", "name", "email" "skill_ref".

Now, write a MySQL query to retrieve the user's "name" with the third highest skill number("value") for the skill with a "label" of "agility".

No PHP is required.

Given an array, with an undetermined set of elements which could be an array themselves, holding only integer values:

Create a function called findMin(\$int_arr), that will find the smallest integer throughout the 2-dimentional array.

Sample input:

`\$int_arr = array(4,90,array(7,3),4);`

Output should be:

```3
```

Feel free to ask questions and discuss.

##### Share on other sites

Nice little tasks, thanks spudinski for the sharing.

My solutions sent in PM.

##### Share on other sites

DJK solved the second task.

a_b has solved both tasks.

##### Share on other sites

DJK solved the second task.

a_b has solved both tasks.

DJK will solve the first task too, when DJK isn't being a lazy bugger. >.<

##### Share on other sites

C'mon Dj, it's a few lines of sql to build the structure. :P

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• #### Marketplace

• Discord Chat
• PBBG Directory
×
• Create New...