this: $country_result = $conn->query("SELECT b.auction, a.id FROM " . $DBPrefix . "vs_auctions a

connect to this database

<?php
$conn = new mysqli('localhost', 'root', 'pass', 'db');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

while these: $query = "SELECT a.id, b.auction FROM " . $DBPrefix . "auctions a

connect to this database

<?php
$DbHost = "localhost";
$DbDatabase = "db";
$DbUser = "root";
$DbPassword = "pass";
$DBPrefix = "vs_";
$main_path = ":\\xampp\\htdocs\\vset\\";
$MD5_PREFIX = "ca801ec4f5c664bc6a492f942b3a07eb";
?>


how do i rewrite this
$country_result = $conn->query to work like this $query =

Mysqli_querry($conn, "SELECT * ...")

skyhighweb:
this: $country_result = $conn->query("SELECT b.auction, a.id FROM " . $DBPrefix . "vs_auctions a

connect to this database

<?php
$conn = new mysqli('localhost', 'root', 'pass', 'db');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

while these: $query = "SELECT a.id, b.auction FROM " . $DBPrefix . "auctions a

connect to this database

<?php
$DbHost = "localhost";
$DbDatabase = "db";
$DbUser = "root";
$DbPassword = "pass";
$DBPrefix = "vs_";
$main_path = ":\\xampp\\htdocs\\vset\\";
$MD5_PREFIX = "ca801ec4f5c664bc6a492f942b3a07eb";
?>


how do i rewrite this
$country_result = $conn->query to work like this $query =

<?php

//make your connection like this

$conn = new Mysqli(//pass your arguments); //$conn holds an instance of the Mysqli Class . so from the class, you can easily call the methods
//you need

//query
$query = "SELECT b.auction, a.id FROM table_name"

//to execute the query

$conn->query($query);

//you can also store the response returned in a variable like so

$selected = $conn->query($query);
?>

Are you in Lagos and You need to learn and get certified in this modular courses:
A+
N+
MCSA
WED DESIGN
PMP
MCSE
CCNA
CCNP
IC3
LINUX RHCE V.6
ITIL
ORACLE DBA
ETHICAL HACKING (Certified ethical hacking)
PHP, MYSQL,C#
Kindly call 07036968890 or visit no.77 Ojuelegba Road (second floor), by Ojuelegba bustop