Help With MySql Query and Displaying Results

bunker

Hi,

got this code:

$sql = mysql_query("SELECT m., a. FROM menu_izq m, article a WHERE m.port = '$port' AND m.lang = '$lang' AND a.port = m.port AND a.cat = '$cat'");

echo $row["m.link"];

And I know there is a field in menu_izq called link and it has values!!

Why isnt this working!!??

Thx in advanced!!

drew010

it appears that $row is never assigned any values, so they wont magically appear in it.
you will need to use something like [man]mysql_fetch_array[/man] to retrieve a result set from the query.

bunker

Sorry,

Actually the echo bit is like this:

while ($row = mysql_fetch_array($sql)) {
echo $row["m.link"];
}

Sorry again!

subwayman

try:

while ($row = mysql_fetch_array($sql)) {
echo $row['link'];
}

You only need to use the table name in the query. The row returned will use just the column name as the key in the array.

bunker

mmmmm...

And if there are fields on both tables with the same name?? how would I show the value of menu_izq.title and article.title?

Thx in advanced!

dotty

then you list the names out in your query instead of using *

$sql = mysql_query("SELECT m.link,m.lang,m.port, a.link, a.lang, a.port 
FROM menu_izq m, article a 
WHERE m.port = '$port' AND m.lang = '$lang' 
AND a.port = m.port AND a.cat = '$cat'");

while ($row = mysql_fetch_array($sql)) { 
echo $row['link']; 
}

I think !

subwayman

SELECT m.link AS mlink, ....
.
.
echo $row['mlink'];

When you use mysql_fetch_array with a query returning multiple columns with the same name then the LAST column with the name is assigned to the associated key. If you want the others then you need to use the numerical index of the array, e.g. $row[6] of the column you want is the 7th column in the query. However, I find using the table.column AS usefulname is much more friendly and help with self documentation (as well as my ageing brain...)