₦airaland Forum

DaGC:
A few years ago, I would have believed that no Nigerian girl can do this....but considering that I've also been recipient of relationship proposals with some going as far as suggesting I leave my girl for them; then this is not impossible.

Love can make some people do crazy things.

sledjama:
triggers is totally unrelated to the issue here

GenBloodykilIer:
You're just simply a urine

cirmuell:
It's sad some people's life revolves around Nairaland. So you've defect, who cares? Move the phuck on dude, you've got just one pvc and can only vote once(that's if you've got a pvc at all gan)...enuff of all these wailing damn.

cyan2008:
guys

Thanks for the contributions and advice. But i have not been able to solve the problem.
what i need to achieve is to display one or more data from a row in table 1
such that whoever clicks on it will get corresponding rows from the other two tables.

Tolzeal:
Pour me ur name...

CoCoLav:


Those aren't the memories you should have abeg..

CoCoLav:
I pray it is the cable oo, my PC already has enough issues.

huptin:
i am a beneficiary of the banking sector reforms of OBJ.... entry level then was 190k with good allowances and profit sharing largesse. now nko? for where lets not even go there. terrible is the word. You get terrible targets to meet salary has not been increased, no more profit sharing, no more bonuses etc. And some one is here shouting transformation.... transformation ko, deformation ni.

spikesC:
I think you missed a bit of his question. He is talking about selection here not manipulation.

Trigger is usually used when you need to execute pre-defined queries based on events.
The op just wants to select data from different tables related by a foreign key.

spikesC:
Trigger? In joins?

Op, read on mysql joins

cyan2008:
Dear Friends,
i am very new in programming, and i am just learning PHP MYSQL DATABASE.
I need some good programmers to provide me with sql to join and display the information stored in database table in the manner illustrated below:

table 1 table 2 table 3
id name age id food drink id marks position
1 Ken 15 1 rice coke 1 50% 1st
2 John 20 2 beans fanta 2 30% 2nd

Now i need an sql statement that when someone clicks on any record from table 1, say on KEN, all record in the corresponding rows in the other two tables (table 2 and table 3) will be displayed. In other words, any record from table 1 (KEN) will serve as a master link to display the other records of Ken in table 2 and tables 3.

clikc on KEN-------------------------->>>display------>> rice, coke, 50%, 1st
click on JOHN ------------------------>>>display------>> beans, fanta, 30%, 2nd
and SO ON

Thanks so much guys.
08036730744

Blackett:
Dumbo. When you ignore a person, you don't quote them.

spikesC:
From the little research I did, it showed that the theory doesn't have a mathematical formula but rather implies that the output data can never be predicted but can only be a random value from the previous output values.

This implies that, if the OP can actually debate it with the lecturer, he would be allowed to develop a system that randomly selects a value from previous stock-market data which was fed into the system.

This randomness can certainly be mitigated by developing an algorithm that predicts the output by current market fluctuations (which stock is performing well), stock history value (how the stocks has been performing), previous time frame performance (how the stock performed in that particular time of every year) and other relational data. But then, it definitely won't be perfect

spikesC:
Pls don't get me wrong, I was actually thinking I don't understand the Random Walk Hypothesis implementation.
So am trying to make you explain more (of the implementation )

spikesC:
Tough job?
Randomly selecting numbers out of previous records?

Or am I missing something?

jonath0012:
Bros, can I pm you... I want to change my career entirely to IT ... Programming to be precise....., I need you input

MizMyColi:
Earnestly Anticipating.
Good Afternoon.

cmonek:
nice post here.. Currently running a PGD program in Computer Sci, really love the course but the Programming aspect can be tiring especially after writing your codes and encounters an error or series of error when you compile and run the codes.. Though abit tiring but I really love the DBMS aspect and I really want to major as a system analyst, a database administrator or a networker.. I hope not being an expert in programming wont deny me of becoming any of the three mentioned stuff?? I need an answer please..

ogunjobiali:
Ur post was encouraging. I read Computer Science from U.I and graduated.I find it hard to programme but can write little program in java,also php and mysql. I want to be a full time programmer but the profession at the moment is for everyone.

cnjy:
I am so frustrated with my final year project..this is literally the task I am asked to do

MizMyColi:
@The reddened
I can't seem to locate it.

I'm uploading screen shots.
Perhaps, you can help me pinpoint it's location.

MizMyColi:
Backup and download done

MizMyColi:
This is what I'm currently grappling with.
Please how do I remedy this.

I do not know the active webmasters in this section except that9javine, luigiajah, and nigerianvenom.

Please mention anyone else you think can help me tackle this.