Pulling data from Database

CommandoS

I am using this code to pull data from my database but it is not working. Any ideas?

<?php

$db = new mysqli($host,$user,$pass,$name);

$query = "SELECT * FROM Sublist WHERE 1 LIMIT 0 , 30";
$result = $mysqli->query($query);

while($info = mysql_fetch_array($query,  MYSQL_ASSOC)) {
echo $info['scheduled_date'];
echo "<br>";
echo $info['customer_name'];
echo "<br>";
echo $info['status'];
echo "<br>";
echo $info['kaspersky_template'];
echo "<br>";
echo $info['pcpickup_template'];

 } 
?>

bradgrafelman

You never check to see if the connection (and DB selection) was successful, nor do you ever check to see if the query was successfully executed.

EDIT: Even bigger problem, you're trying to use a 'fetch' function from the [man]mysql[/man] extension while you connected and executed the query using the [man]MySQLi[/man] extension.

CommandoS

I do not know how to fix this. That's why I am asking.

bradgrafelman

CommandoS;11023641 wrote:
I do not know how to fix this. That's why I am asking.

... which is why I pointed out what you should be doing to get more information in the event an error occurs and also pointed out a coding mistake ([man]mysql_fetch_array/man used instead of [man]mysqli_fetch_array/man).

traq

also:

<?php

$db = new mysqli($host,$user,$pass,$name);

$query = "SELECT * FROM Sublist WHERE 1 LIMIT 0 , 30";
$result = $mysqli->query($query);

# as brad says, you need to be using mysqli_fetch_array.
# **However**
# you also need to pass the $result to the function, not the $query
# (_and_ use mysqli flags, not mysql).
while($info = mysql_fetch_array($query,  MYSQL_ASSOC)) {
/**  etc...  */

I would also recommend against using both the procedural and object-oriented APIs - you start by creating a mysqli object and running a query, but then switch to procedural functions to try to access the results.

This is going to cause confusion down the line (if it hasn't already). Choose one or the other (I prefer OO).