[RESOLVED] how to remove this warning

kingdm

Hello mates.

I'm practicing my php knowledge in an XAMPP. I have this script :

<?php

$mysqli = new mysqli ("localhost", "testuser", "testpassword", "testdatabase");

$news = "
		SELECT
		DATE_FORMAT(date_membered,   '%b %e %Y') AS FormatTime
		FROM
		users
		";

$getNews = mysqli_query($mysqli, $news)
		or die(mysqli_error($mysqli));

$result = mysql_query($getNews);

while ($newsInfo = mysqli_fetch_array($getNews))
{
	$NDate = $newsInfo['FormatTime'];
}

echo $NDate;

mysqli_free_result($getNews);
mysqli_close($mysqli);

?>

Everytime I run this script, my expected output displays but with this warning:

Warning: mysql_query() expects parameter 1 to be string, object given in C:\xampp\htdocs\test\my_test.php on line 15.

How could I get rid of this? The line 15 it says is $result = mysql_query($getNews);.

Anyone? Thanks.

Rodders

The warning message tells you everything you need to know.
My boss told me a very good tip - don't ignore the errors and warnings! Even though they can be badly worded, they usually have some useful info to help you.

So, it says that the error is on line 15. You've identified what bit of code that is. The message says that the mysql_query() function expects a string in the first paramater. A string is just plain text like a SQL statement.

What you have done is passed the result object stored in $getNews. Why have you got two lines trying to run the query?

I think you can delete line 15 completely, it's not required.

kingdm

That would be my lesson of the day 🙂 Thanks Rodders.

After doing this, the warning is now gone. Thanks buddy. I got the same input from NogDog on another forums I posted.

Seems like I need to learn a lot of basics, anyway thanks. Really appreciated your input. Finally got rid of this warning.

Merry Christmas amigo.