Database connection issue

Question

The following query is not executing and I am stumped as to why. The query is returning my die clause of 'error querying database' yet all of my info is exact.

Have I got a syntax error in my query variable?

<?php
$db_host     = 'localhost';
$db_user     = 'root';
$db_pass     = 'root';
$db_database = 'bbg_db_2'; 

$dbc = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a database connection');

$query = "SELECT category_name, category_desc FROM categories";
$result = mysqli_query($dbc, $query) or die ('error querying database');

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

    $catname = $row['category_name'];
    $catdesc = $row['category_desc'];

    echo "<li>$catname</br><span>$catdesc</span></li>";
}

mysqli_close($dbc);
?>

Post the output of mysqli_error() after the failed query. It should tell you exactly what's going wrong. — Michael Mior
– Michael Mior, Commented Jul 20, 2011 at 15:02

Maxim Krizhanovsky · Accepted Answer · 2011-07-20 15:02:14Z

4

You have missed mysql_select_db($db_database) in your code.

answered Jul 20, 2011 at 15:02

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

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

Comments

Yasen Zhelev · Accepted Answer · 2011-07-20 15:03:31Z

4

mysql_connect should be mysqli_connect, cause you use mysqli_query after that and use mysqli_select_db to select database

answered Jul 20, 2011 at 15:03

Yasen Zhelev

4,0454 gold badges33 silver badges57 bronze badges

Comments

Lightness Races in Orbit · Accepted Answer · 2011-07-20 15:06:09Z

3

Two problems:

You connected with the mysql API, but then tried to query with the mysqli API;
You never selected the database with mysqli_select_db.

Performing some basic error checking with mysqli_error($dbc) would have revealed this to you pretty quickly.

^{Also, as a style note, ARGH tabs inside lines! Bad! Wrong! Tabs are for indentation, not alignment.}

answered Jul 20, 2011 at 15:06

Lightness Races in Orbit

387k77 gold badges672 silver badges1.1k bronze badges

6 Comments

Richard Bell Over a year ago

Thankyou so much. I will stop with the tabs :o)

Richard Bell Over a year ago

Sorry to bother you but I have implemented mysqli_error($dbc) which revealed that I hadn't selected the database and so I altered my code accordingly, however now I still do not get any results... no error message and nothing visible within my page. Am I missing something?

Lightness Races in Orbit Over a year ago

@Richard: My first bullet point, perhaps. Or maybe there are just no results.

Richard Bell Over a year ago

Thanks for getting back to me. I have amended the API to mysql which has not solved the problem. I can't see how there can be no results as I have a populated table in place. Im stuck. Probably some schoolboy error... I'll keep playing. Thanks anyway :o)

Lightness Races in Orbit Over a year ago

@Richard: At the risk of encouraging you to write a new question where you can't reproduce the issue for us to diagnose, perhaps give that a go anyway.

|

Marc B · Accepted Answer · 2011-07-20 15:02:21Z

1

Try:

... or die(mysqli_error());

instead, which will output the exact reason the query's failing.

answered Jul 20, 2011 at 15:02

Marc B

362k44 gold badges433 silver badges508 bronze badges

Comments

jeroen · Accepted Answer · 2011-07-20 15:05:04Z

0

You are mixing up mysql and mysqli. You will need to pick one.

answered Jul 20, 2011 at 15:05

jeroen

91.8k22 gold badges118 silver badges132 bronze badges

Collectives™ on Stack Overflow

Database connection issue

5 Answers 5

Comments

Comments

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related