197861ca

1mysql> select * from users;
2+------------+-----------+----------+-------------------------+----------+-------------+
3| contact_id | firstname | lastname | email                   | password | username    |
4+------------+-----------+----------+-------------------------+----------+-------------+
5|          9 | Bubba     | Thompson | dont@email.me           | asdf1234 | bubba       |
6|          8 | ****      | ******   | *************@gmail.com | asdf1234 | crankharder |
7+------------+-----------+----------+-------------------------+----------+-------------+
82 rows in set (0.00 sec)
9
10PHP:
11
12     49 $sql1= "SELECT * FROM users";
13     50 $results = mysql_fetch_array(mysql_query($sql1,$con));
14     51
15     52 var_dump($results);
16     53
17
18Source:
19
20array(12) {
21  [0]=>
22  string(1) "9"
23  ["contact_id"]=>
24  string(1) "9"
25  [1]=>
26  string(5) "Bubba"
27  ["firstname"]=>
28  string(5) "Bubba"
29  [2]=>
30  string(8) "Thompson"
31  ["lastname"]=>
32  string(8) "Thompson"
33  [3]=>
34  string(13) "dont@email.me"
35  ["email"]=>
36  string(13) "dont@email.me"
37  [4]=>
38  string(8) "asdf1234"
39  ["password"]=>
40  string(8) "asdf1234"
41  [5]=>
42  string(5) "bubba"
43  ["username"]=>
44  string(5) "bubba"
45}
46