[SOLVED] Help with getting data!

[doucie]

@$db = new mysqli_connect('localhost','root','','restaurant');

if(mysqli_connect_errno())

{

echo 'Could not connect to the database';

exit;

}

$query="SELECT name FROM ingredients";

$result=$mysqli_query($db,$query);

$num_results=mysqli_num_rows($result);

echo $num_results;

 

I would expect this to echo out a number, but it does nothing, not even an error.  Help!

[wildteen88]

remove the @ from infront of the mysqli connection line.

[doucie]

Cheers. The book I'm reading has an @. Hopefully not too many typos!

 

Ive removed the @ but now get the following error

 

Function name must be a string in C:\wamp\www\reporting\my_functions.php on line 13

 

Line 13 is $result=$mysqli_query($db,$query);

[per1os]

We need more than just line 13 bud. Post at least the first 50 lines so we can look at it more indepth.

[Barand]

It looks like you can't make up your mind whether to to use mysqli in its object style or its proceduaral style.

 

You can either call

$db = new mysqli('localhost', 'root', '', 'restaurant');

and then use the class methods

 

or use the procedural style, as the rest of your code does, with

$db = mysqli_connect('localhost', 'root', '', 'restaurant');

[doucie]

Barand - Changed that line to procedural, like the rest.

Still get the same error

All the code below

 

function get_ingredients()

{

echo 'All the ingredients are listed below.';

$db=mysqli_connect('localhost','root','','restaurant');

if(mysqli_connect_errno())

{

echo 'Could not connect to the database';

exit;

}

$query="SELECT name FROM ingredients";

$result=$mysqli_query($db,$query);

$num_results=mysqli_num_rows($result);

echo $num_results;

 

}

[per1os]

$result=$mysqli_query($db,$query);

should be

$result=mysqli_query($db,$query);

 

no $ infront of functions.

[doucie]

Nice one, fixed.  Thanks all.