Code: Select all
$sql = "SELECT o.name as custname, od.* " .
"FROM tblorder as o, orderdetail od, weekly as w " .
"WHERE o.orderid = od.orderid and od.productid = w.id" .
"ORDER BY o.orderid DESC";Moderator: General Moderators
Code: Select all
$sql = "SELECT o.name as custname, od.* " .
"FROM tblorder as o, orderdetail od, weekly as w " .
"WHERE o.orderid = od.orderid and od.productid = w.id" .
"ORDER BY o.orderid DESC";No need to concatenate at line breaks. "." doesn't concatenate. ".." would be good form.jaylin wrote:regards,Code: Select all
$sql = "SELECT o.name as custname, od.* " . "FROM tblorder as o, orderdetail od, weekly as w " . "WHERE o.orderid = od.orderid and od.productid = w.id" . "ORDER BY o.orderid DESC";
Code: Select all
"SELECT o.name as custname, od.* FROM tblorder as o, orderdetail od, weekly as w WHERE o.orderid = od.orderid and od.productid = w.id ORDER BY o.orderid DESC";It's a single dot to concatenate.neophyte wrote: "." doesn't concatenate. ".." would be good form.
Code: Select all
echo "foo"."bar"; //Correct
echo "foo".."bar"; //WrongCode: Select all
$sql = "SELECT o.name as custname, od.* " .
"FROM tblorder as o, orderdetail od, weekly as w " .
"WHERE o.orderid = od.orderid and od.productid = w.id" .
"ORDER BY o.orderid DESC";Not true. That's just shorthand SQL for aliasingWayne wrote:but that aside in your sql you need to change orderdetail od in your FROM to be orderdetail as od
Code: Select all
select foo from tbl as bobCode: Select all
select foo from tbl bobThe only error I see is no space at the end of the 3rd line, after w.idjaylin wrote:Code: Select all
$sql = "SELECT o.name as custname, od.* " . "FROM tblorder as o, orderdetail od, weekly as w " . "WHERE o.orderid = od.orderid and od.productid = w.id" . "ORDER BY o.orderid DESC";
Code: Select all
$sql = "SELECT o.name as custname, od.* "
. " FROM tblorder as o, orderdetail od, weekly as w "
. " WHERE o.orderid = od.orderid and od.productid = w.id"
. " ORDER BY o.orderid DESC";