Php and Mysql how do i get a 2d array

jasoncable

Hello,

I have been working on this for a couple weeks yet I must not be getting somthing. I want to be able to dispaly any part of a table on mysql. I want to be able to go somthing like $tablename[4][3] and it gives me the 4th line over and the 3rd line down. Is this possible?

Thanks in advance

matt_4013

This interests me 🙂 I'm working on it, and I'll get back to you!

Teen0724

I would love to be able to use an array of arrays. It would be cool, reminds me of APmatrix in C++.

matt_4013

is this what you're looking for?


    $db = mysql_connect("localhost", "user", "pass");
    mysql_select_db("dbname", $db);

$sql = "SHOW TABLES";
$result = mysql_query($sql, $db);

while($tablenames = mysql_fetch_row($result)) {

        $$tablenames[0] = array();
        $newsql    = "SELECT * FROM $tablenames[0]";
    	$rowresult = mysql_query($newsql, $db) or die("Could not execute query: $sql<br />".mysql_error());

        while($fields = mysql_fetch_assoc($rowresult)) {

    	        array_push($$tablenames[0], $fields);

        }

}

// Then refer to your variables using

$tablename[recordnumber]['fieldname'];

jasoncable

Matt, I get a bunch of parse errors when running your code. like $sql = "SHOW TABLES";

Are you having the same problems?

jasoncable

I had to retype the whole php part but after i did that, everything worked!
Many thanks, you have no idea how much this has helped me, I'm off to code!

matt_4013

Just a warning, if you're using this on a big database, it's going to use a hell of a lot of resources. Basically, it's getting every piece of data from the db and putting it into the variable. If you really need all that data go for it, but I would suggest doing a more efficient way 🙂