elseif (isset($_POST['search'])) { # Save-button was clicked $vname = $_POST['vendorname']; // connect to mysql $link = mysqli_connect("localhost", "root", "", "magna-billing"); // mysql search query $query = "SELECT `vendoraddress`, `vendorcontact`, 'vendorgst', 'vendorstateid', 'vendorcode' FROM `vendordetail` WHERE `vendorname` = $vname "; $result = mysqli_query($link, $query) ; if(mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $vadd = $row['vendoraddress']; $vcont = $row['vendorcontact']; $vgst = $row['vendorgst']; $vstate = $row['vendorstateid']; $vcode = $row['vendorcode']; } } mysqli_free_result($result); mysqli_close($link); else { echo "Undefined"; } } else { $vadd = ""; $vcont = ""; $vgst = ""; $vstate = ""; $vcode = ""; } ?>
$query = "SELECT `vendoraddress`, `vendorcontact`, 'vendorgst', 'vendorstateid', 'vendorcode' FROM `vendordetail` WHERE `vendorname` = $vname ";
'vendorgst'
'vendorstateid'
`vendorgst`
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)