SQL Server vs MySQL and PHP vs ColdFusion

Question

This query works fine with ColdFusion, yet I can't get it to work in PHP. The PHP doesn't like my joins. What is different in the two queries?

<cfquery name="getArt" datasource="mssqlcf_PDartist1">
select * from artwork a
join Categories b on (b.CID = a.CID)
join SubCategories c on (c.CID = b.CID and c.SCID = a.SCID)
where AID = #AID#
order by DisplayOrder
</cfquery>


<?php
$dbname = 'pdartist2';
$table = 'artwork';
$result = mysql_query("SELECT * from artwork") or die(mysql_error());
a join Categories b on (b.CID = a.CID)
join SubCategories c on (c.CID = b.CID and c.SCID = a.SCID)
where AID = $AID
order by DisplayOrder
mysql_free_result($result);
?>

No I mean that PHP (or ColdFusion, for that matter) sends strings to the database server. It does not care in the least whether they contain joins or not. — Tomalak
– Tomalak, Commented Nov 26, 2011 at 21:10
So why does the query work on my Cold Fusion site and not on the PHP site? Could it be that PHP is case sensitive and Cold Fusion is not. Since the tables are named in all lowercase!? — The old dog
– The old dog, Commented Nov 26, 2011 at 21:12
Because you have a PHP syntax error right there. This has nothing to do with SQL. Mark's answer points that out very nicely. — Tomalak
– Tomalak, Commented Nov 26, 2011 at 21:13

Mark Byers · Accepted Answer · 2011-11-26 20:40:47Z

2

You ended the PHP string too early. The quotes must surround the entire SQL query:

$result = mysql_query("SELECT *
    FROM artwork a
    JOIN Categories b ON b.CID = a.CID
    JOIN SubCategories c ON c.CID = b.CID AND c.SCID = a.SCID
    WHERE AID = $AID
    ORDER BY DisplayOrder") or die(mysql_error());

answered Nov 26, 2011 at 20:40

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server vs MySQL and PHP vs ColdFusion

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related