Timeline for CodeIgniter Active Record Subqueries
Current License: CC BY-SA 4.0
25 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 16, 2020 at 17:04 | history | edited | gen_Eric | CC BY-SA 4.0 |
added 11 characters in body
|
| S Nov 16, 2020 at 17:04 | history | suggested | Zoran Jankov | CC BY-SA 4.0 |
Added links
|
| Nov 13, 2020 at 23:13 | review | Suggested edits | |||
| S Nov 16, 2020 at 17:04 | |||||
| May 23, 2017 at 11:33 | history | edited | Community Bot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| S Jul 4, 2014 at 7:56 | history | suggested | ann | CC BY-SA 3.0 |
improved formatting
|
| Jul 4, 2014 at 7:48 | review | Suggested edits | |||
| S Jul 4, 2014 at 7:56 | |||||
| Jul 25, 2012 at 13:20 | history | edited | gen_Eric | CC BY-SA 3.0 |
Added github link
|
| Jul 25, 2012 at 6:15 | comment | added | gen_Eric |
@zfm: When you call end_subquery it nests it under the last opened start_subquery. So the example on pastebin will do what you want. :-D
|
|
| Jul 25, 2012 at 6:12 | comment | added | gen_Eric |
@zfm: The pastebin example will actually generate: SELECT word, (SELECT number FROM (numbers) WHERE numberID = 2 AND ab IN (SELECT test FROM (testing) WHERE a = 12)) AS number FROM (words) WHERE wordID = 3 :-D
|
|
| Jul 25, 2012 at 3:26 | comment | added | zfm |
@Rocket: from what you wrote on pastebin, it was two subqueries on the same level. Is it possible to have something like $sub2 = $sub->subquery... so the result will be something like SELECT * FROM A WHERE xxx IN (SELECT xxx FROM B WHERE yyy IN (SELECT ... ))
|
|
| Jul 24, 2012 at 13:20 | comment | added | gen_Eric |
@zfm: Yes you can! start_subquery keeps track of how many times it was called, so when end_subquery is called, it knows where to put the subquery. pastebin.com/KxfrHb1J
|
|
| Jul 24, 2012 at 2:35 | comment | added | zfm | nice... anyway, can we do a subquery under the subquery? on the other word, can I have unlimited recursively subqueries? | |
| Oct 7, 2011 at 16:57 | comment | added | gen_Eric | If anyone's curious, the latest version of this is here: github.com/NTICompass/CodeIgniter-Subqueries | |
| Jan 28, 2011 at 5:09 | vote | accept | gen_Eric | ||
| Jan 28, 2011 at 5:09 | vote | accept | gen_Eric | ||
| Jan 28, 2011 at 5:09 | |||||
| Jan 27, 2011 at 14:57 | answer | added | RobertPitt | timeline score: 16 | |
| Jan 20, 2011 at 14:31 | history | edited | gen_Eric | CC BY-SA 2.5 |
added 420 characters in body
|
| Jan 20, 2011 at 14:29 | comment | added | gen_Eric | @RobertPitt: I've added an example to the question. | |
| Jan 20, 2011 at 11:45 | comment | added | RobertPitt | Can you give us an example usage ? | |
| Jan 19, 2011 at 22:33 | answer | added | Hailwood | timeline score: 5 | |
| Jan 19, 2011 at 21:55 | history | rollback | gen_Eric |
Rollback to Revision 1
|
|
| Jan 19, 2011 at 21:55 | comment | added | gen_Eric |
@Time Machine: $db is an array because every time you call start_subquery it makes a new database object. This allows subqueries inside subqueries.
|
|
| Jan 19, 2011 at 21:50 | comment | added | user36 | Why is $db an array? | |
| Jan 19, 2011 at 21:31 | history | edited | BenV |
edited tags
|
|
| Jan 19, 2011 at 21:24 | history | asked | gen_Eric | CC BY-SA 2.5 |