Pulling data from database in PHP error

Question

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

Code:
<?php

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

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
    $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'];

 } 
?>

Error code: Fatal error: Call to a member function query() on a non-object in /home/projectu/public_html/sub/scheduled.php on line 20

Explosion Pills · Accepted Answer · 2013-02-06 23:49:01Z

2

Don't you mean

$result = $db->query($query);

Followed by

while ($info = mysqli_fetch_array($result)) {

answered Feb 6, 2013 at 23:49

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pulling data from database in PHP error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related