Paranorman's Posts
Nairaland Forum › Paranorman's Profile › Paranorman's Posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 (of 43 pages)
Chai! |
I don't know if your tables are properly normalized, But if you wanna extract data from four tables, you needa use Sql joins. If you can't post the tables' structures here, post the tables and how the are related, I mean the primary keys in a table and the corresponding foreign key in a related table. I will check out your code when I get on PC |
MySQL joins will solve your problem. Take your time and learn simple join examples from W3school website. |
You mean the statement to executed should only contain unique operands(the numbers) that cannot be repeated, but the set (1, 3, 4, 6) may not be exhausted. You may use all operators, combine or just a single one? |
Craigston:Sure bro. I've only scratched javascript's surface, ain't pro. Still learning. My approach will work fine for a small range, but if the range spans accross thousands of data one will grow white beards, especially for a not-so-patient person like me. Besides, it just a challenge anyway. |
Craigston:Hahahahaha, I pray so Bros. I am still a rookie sha. the op was going on about using range, functions bla, bla, bla... I just solved his problem using a single function, the second function wasn't even necessary. |
i did PHP, using a recursive function, Mr. kodejuice function jarvis(&$i, &$j, &$count) { |
I will post my solution tomorrow. I like challenges. |
I don't have an idea of the rent of flats in the island, never cared for such. Rent can be quite expensive on the mainland, but choose where you can easily get straight buses to the island. Traffic situation after work hours is also something to consider. For me, I lcan do with Berger, Iyana-Ipaja, Ikeda, Oshodi. |
francollimasso:please do and post the solution here. |
francollimasso: |
'sale' is a noun, used in the wrong grammertical context in your topic. It should be 'sell'. Make corrections, pal. What is 'spacially'? You meant 'especially'? |
![]() I thought I was the only one that felt this way. I once was offered a position in an app/software development company; I was gonna be trained in few languages, especially good o' PHP. When I was told I wan gonna be starting with ZEND, lost interest. I specifically told the HR dude I don't like to be get started with frameworks. I just don't like building skills/foundation on frameworks. |
For the umpteenth time, programming languages are tools, they have their strengths and weaknesses. |
Gbemishile1:Been looking for such games a for a while now. From which site do you download yours for free? |
It's 'brand' new, not 'brown'. Make the due correction pal. |
The surname, firstname and other-names are a pair that makes up your full name. So, "my name is" is the correct form. ![]() |
Template of the view code: CREATE VIEW viewNoServiceYear AS After the view as been saved in your employee database, Query the view thus: SELECT FROM viewNoServiceYear When creating the view, include the fields/columns of your target from their respective tables from your database. This should solve your problem. Remember views are 'read only'. Content of your database cannot be modified from a view. So, views are safe and are updated automatically. |
Bro, if you want to sacrifice performance for flexibility, then you can create another column for the current date and/or time. MySQL has a function for that. Alternatively, you can create a View using the query I wrote up there. Sql views are saved and updated automatically,they are 'read only' too. |
oga OP, all you need is a calculated field in your SQL query. for a table to be well normalized, calculated fields must not be part of the original design. so your column 'C' should not be part of your DB table, instead, you generate it using a query - calculated virtual fields your table only need a column containing info about each employee's employment year, say 'employmentYear'; then query your db thus: study the following mysql functionsSELECT CONCAT(A, B) FORMAT(X, D) CURRDATE(), CURRTIME() NOW() MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() HOUR(), MINUTE(), SECOND() DATEDIFF(A, B) SUBTIMES(A, B) FROMDAYS(INT) |
This is serious. |
Yeah. Just like how to be a pilot in 30 minutes. ![]() |
Ishilove:2011 |
freecocoa:None I suppose, but I read your comments in this trend. So, what do you believe in? |
freecocoa:What do you believe in freecocoa? |
Billyonaire:You guys to share. I know nothing about it. |
profstar: ![]() Bro, current laws and equation in physics forbits time travel. This is another topic for another day. But time travel is real. |


