Skip to content

Instantly share code, notes, and snippets.

@dennisdegryse

dennisdegryse/multiple table select

Forked from anonymous/multiple table select
Last active August 29, 2015 14:12
Show Gist options
  • Save dennisdegryse/19d2fbdf6a9ac7b3a618 to your computer and use it in GitHub Desktop.
Save dennisdegryse/19d2fbdf6a9ac7b3a618 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multiple table select
<?php
session_start();
include("connection.php");
$temp = $_POST['productUpdateId'];
$arr = explode(":-",$temp);
$pId = $arr[0];
$_SESSION['updateNeedPId'] = $pId;
$sqlquery_get_name_details = "SELECT pD.p_name AS x, pN.p_det AS y FROM p_details pD, p_name pN";
$nameDet_ref = mysqli_query($con,$sqlquery_get_name_details);
if ($row = mysqli_fetch_array($nameDet_ref)) {
$pName=$row["x"];
$pDet=$row["y"];
$_SESSION['updateNeedPName']=$pName;
$_SESSION['updateNeedPDet']=$pDet;
}
@hashank99
Copy link

$sqlquery_get_name_details="SELECT D.p_details AS det , N.p_name AS name FROM p_details D WHERE p_id=".$pId.", p_name N"; SOMETHING WRONG IN THIS QUERY?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment