Mysql_fetch_array() help please.

[Hiei]

Hello everybody...well, i'm just wondering if anybody can help me out here. I've been fiddling around with this function for a while, and i still cant get it to work. Will sombody please explain to me how exactly its done? Thanks for your time!

[laserlight]

//assume connected to DB server and DB has been selected
//write the query
$query = "SELECT column1, column2 FROM table1";
//send the query
$result = mysql_query($query)
	OR die(mysql_error()); //error check for debugging
//loop through the result set
while ($row = mysql_fetch_array($result)) {
	//for current row: print data contained in column1, column2
	echo $row['column1'] . ', ' . $row['column2'] . '<br />';
}

[Hiei]

Ah...thank you...I think I understand a bit better now, but, It's still not working for some reason. Would you mind looking at my example, and explaining why?

      <?php 

  $query="SELECT * FROM table1.id, table2.id WHERE table1.id = '$var_id' AND table2.id = '$var_id'";

  $result=mysql_query($query) or die  ("Could not execute query : $q." . mysql_error());

  while ($row = mysql_fetch_array($result)) {
      $var = $row['column'];
      echo("$var");
    }

  ?>

[laserlight]

Chances are your query is incorrect.

You appear to be selecting from columns, not from tables.

So in:
SELECT * FROM table1.id, table2.id
table1.id should be table1
table2.id should be table2

[cafrow]

Originally posted by Hiei
Ah...thank you...I think I understand a bit better now, but, It's still not working for some reason. Would you mind looking at my example, and explaining why?

      <?php 

  $query="SELECT * FROM table1.id, table2.id WHERE table1.id = '$var_id' AND table2.id = '$var_id'";

  $result=mysql_query($query) or die  ("Could not execute query : $q." . mysql_error());

  while ($row = mysql_fetch_array($result)) {
      $var = $row['column'];
      echo("$var");
    }

  ?>

[/B]

Try this

      <?php 

  $query="SELECT id FROM table1, table2 WHERE table1.id = '$var_id' AND table2.id = '$var_id'";

  $result=mysql_query($query) or die  ("Could not execute query : $q." . mysql_error());

  while ($row = mysql_fetch_array($result)) {
      $var = $row['column'];
      echo("$var");
    }

  ?>

[Hiei]

Doh! Thank you! I feel so dumb now XD It still doesnt work though...the output, I mean.

cafrow, although that would work, i'm trying to select the entire row in those two tables where the $var_id is the same in each of their id columns. Here is what it looks like right now...

$query="SELECT * FROM table1, table2 WHERE table1.id = '$var_id' AND table2.id = '$var_id'";

$result=mysql_query($query) or die  ("Could not execute query : $q." . mysql_error());

while ($row = mysql_fetch_array($result)) {
$var = $row['column'];
echo("$var");

[pete_bisby]

Try this:

$query="SELECT table1.*, table2.* FROM table1, table2 WHERE table1.id = '$var_id' AND table2.id = '$var_id'"; 

Just be careful if you have the same column name in both tables - it may cause some ambiguity.

[Hiei]

Good idea...but it dident work.

[pete_bisby]

Why didn't it work? Is there an error reported on screen? If so, what is the error?

I've just created two tables and placed some data in them, re-ran the SQL query and it brings back the data from both tables correctly, as expected.

You'll have to tell us a little bit more about the reason why it isn't working.