wow a dolphin ow gay, is mysql for faggots or what?
Name:
Anonymous2009-08-03 19:39
Okay, seeing as this thread is worthless and shares the topic with my potential thread, I'll take over from here;
I'm learning PHP and MySQL and I have this:
sqlite> select * from foo;
1|foo|bar
2|baz|quux
3|hma|quux
4|HAX|bar
And this:
$sqldb = sqlite_open("dbase.db");
$result = sqlite_query($sqldb, "select * from foo where title = 'bar'");
$res = sqlite_column($result, "name");
var_dump($res);
And the result is string(3) "foo" . Why am I not getting some array of the first and fourth record? How do I extract all matching records, not just the first?
>>14 Why am I not getting some array of the first and fourth record? $res = sqlite_column
( `ー´)
Name:
Anonymous2009-08-03 20:17
>>16
Ugh.
I mean, of course, an array of the `title' fields of the first and fourth rows. The sqlite_query should narrow the database down to the first and fourth rows, and then the title column should be extracted, yes?
Name:
Anonymous2009-08-03 20:21
Okay, did that using sqlite_next. Is it the proper way or just a haxaround?
Name:
Anonymous2009-08-03 21:31
>>18
My friend, you are using PHP. There is no proper way.
Name:
Anonymous2009-08-03 23:16
Databases are just plain text files with a bunch of bloat slathered all over it to make look innovative.
Name:
Anonymous2009-08-04 1:47
Databases are just plain text files with a bunch of bloat slathered all over it to make look innovative.
>>20 structured data is just data reorganized around a bunch of other data
trees are just arrays with a bunch of references slathered all over to make it look innovative.
HURR DURR