displaying column(s)

Calaisness

I am having troubles displaying a query:

$query= "SELECT c.cardID, s.cardID FROM cards s, cards c where s.cardID <> c.cardID";

How can I display the columns ?

BIOSTALL

Well... first off.... how cum your selecting c.cardID from a table called 'cards c'>> shouldnt you be selecting it from a table called c??

Secondly.. if you wana see all results from a query.. i would suggest doing suming like:

$result = mysql_query("SELECT c.cardID, s.cardID FROM c, s WHERE c.cardID<>s.cardID", $connection);
while ($row=mysql_fetch_array($result)) {
   $c_cardid = $row['c.cardID'];
   $s_cardid = $row['s.cardID'];

$returned .= $c_cardid." - ".$s_cardid."<br>";
}

echo $returned;

Ask if you want to know anything else

BIOSTALL

LoganK

Are you using SQL server/Access, or have you done work in the past involving SQL server/access?

BIOSTALL - The "cards s" and "cards c" line is a way in SQL server or Access to alias the table name. They don't have to use "AS", i.e., "cards AS s". It's useful in aliasing the same table twice so you can join the table to itself.

kakki

maybe you can write

SELECT c.cardID as first, s.cardID as second .........
and then you can do mysql_fetch_array() with the result
OR
you do a fetch_row on the result and print the numerical values

LoganK

If he's using SQL server, he can't, because SQL server only allows one-character aliases.

kakki

LOL

why do they charge money for that ???

LoganK

The one-character only aliases speeds up the query at run-time...hate to say it, but SQL server is faster than my beloved MySQL.

Calaisness

Hi again,
I tried it and now I have a parse error in the bold (I think)...
using the same table is eating my lunch!

$result = mysql_query("SELECT c.cardID, s.cardID FROM cards c, cards s WHERE

c.cardID<>s.cardID");
while ($row=mysql_fetch_array($result)) {
$c_cardid = $row['c.cardID'];
$s_cardid = $row['s.cardID'];

$returned = $c_cardid" - "$s_cardid "<br>";
}

echo $returned;

LoganK

You need to use the PHP concatenator (".") between vars/text. Like this: $c_cardid . " - " . $s_cardid . "<br />";