02-19-2004, 10:40 PM
Pages: 1 2
02-19-2004, 11:11 PM
02-19-2004, 11:16 PM
Sure thing...*flips open phpMyAdmin*
I love MySQL.
I love MySQL.
02-20-2004, 02:15 AM
Very cool 
02-20-2004, 02:21 AM
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?
And speaking of MySQL, what was that method of obtaining data from tables that you showed me? With arrays?
02-20-2004, 02:46 AM
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]
02-20-2004, 03:16 AM
02-20-2004, 11:53 AM
OMG!!! This is cool!!! Knowing you peeps care makes me well already. :*)
02-20-2004, 12:59 PM
I'm getting oodles of mysql errors, but he're a toast to rel.
*toast*
get well soon, buddy
*toast*
get well soon, buddy
02-20-2004, 05:13 PM
Done.
Pages: 1 2