Hi all,
I'm not exactly new to PHP but I haven't used MySQL that much, so I'll ask you guys about this one.
I have a database with one row of data, which consists of a date and two integers. However, when I query the database with this:
$query = "SELECT * FROM history";
$theQuery = mysql_query($query, $connect);
$array = mysql_fetch_array($theQuery);
... and I do a print_r
, I get the following:
Array
(
[0] => 2010-08-17
[date] => 2010-08-17
[1] => 17454
[posts] => 17454
[2] => 1058
[members] => 1058
)
Am I doing something wrong? I plan on having many rows with a ton of data and printing it to a table, THEN how would I go about sorting through it?