Posts: 3,616
Threads: 287
Joined: Jan 2003
http://thegeekery.org/relbook/
Take a look, and sign it if you please.
f only life let you press CTRL-Z.
--------------------------------------
Freebasic is like QB, except it doesn't suck.
Posts: 2,771
Threads: 96
Joined: Oct 2003
Ahhhh noooo, sorry zack i misspellt my name and accidentally pressed enter instead of backspace. =P could u remove the other post, thanx ;-)
Posts: 3,616
Threads: 287
Joined: Jan 2003
Sure thing...*flips open phpMyAdmin*
I love MySQL.
f only life let you press CTRL-Z.
--------------------------------------
Freebasic is like QB, except it doesn't suck.
Posts: 3,343
Threads: 83
Joined: Mar 2003
Very cool
Posts: 3,616
Threads: 287
Joined: Jan 2003
PJ keeps on making me laugh...
And speaking of MySQL, what was that method of obtaining data from tables that you showed me? With arrays?
f only life let you press CTRL-Z.
--------------------------------------
Freebasic is like QB, except it doesn't suck.
Posts: 3,343
Threads: 83
Joined: Mar 2003
Code:
// Define sql
$sql = "SELECT foo, joe AS bar
FROM blah
WHERE condition
AND other_condition
LIMIT number, number";
// Do query
if ( !$result = @mysql_query( $sql ) )
{
// die, with nice, formatted output. I suggest a function for this
die('
Database Query Error!
' . mysql_error() . '
$sql
Line: ' . __LINE__ . ', File: ' . __FILE__);
}
// Get each result, and store it in $row as we go
while ( $row = mysql_fetch_array( $result ) )
{
// Do what you will with each result
$foo = $row['foo'];
$joe = $row['bar']; // Note, the AS bar clause means joe is in bar
}
[end oracle's quick db tutorial]
Posts: 3,616
Threads: 287
Joined: Jan 2003
Oooh! I really have to study MySQL more in-depth...
f only life let you press CTRL-Z.
--------------------------------------
Freebasic is like QB, except it doesn't suck.
Posts: 3,288
Threads: 167
Joined: Nov 2001
OMG!!! This is cool!!! Knowing you peeps care makes me well already. :*)
Posts: 2,020
Threads: 24
Joined: Jun 2002
I'm getting oodles of mysql errors, but he're a toast to rel.
*toast*
get well soon, buddy
i]"I know what you're thinking. Did he fire six shots or only five? Well, to tell you the truth, in all this excitement, I've kinda lost track myself. But being as this is a .44 Magnum ... you've got to ask yourself one question: 'Do I feel lucky?' Well, do ya punk?"[/i] - Dirty Harry
Posts: 1,845
Threads: 44
Joined: Aug 2002
Done.