Skip to main content
1 of 3

viewing a column in mysql database using php script

im trying to print a row from a table in mysql using php script here is the code but its not working show Bad query apparently there is no issue:

$conn = mysqli_connect($servername, $username, $password, $db); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }

else{

echo "Connected successfully";

}

$any = "show columns from help_category"; $chk = mysqli_query($any) or die("Bad Query: $sql"); echo""; echo"Type";

while($row = mysqli_fetch_assoc($chk))

{

echo"{$row['Type']}";

}

echo"";