Echo MySQL Query in PHP

Question

Can someone please tell me why this isn't working. When I run the query in PHPMYADMIN it reports the correct value.

// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if (mysqli_connect_errno())
  {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($conn, "SELECT COUNT('id') AS RowCount FROM 'needs' WHERE ('status'=100)");


echo $result;

stop using mysql it is deprecated, use PDO or mysqli! read documentation! — Alex, Feb 20 '15 at 19:05

score 1 · Answer 1 · answered Feb 20 '15 at 18:53

1

You're combining mysqli and mysql_ functions. Either use mysqli, or use mysql_. But note, mysql_ functions are deprecated for security reasons.

answered Feb 20 '15 at 18:53

Guerila

11
2

score -1 · Answer 2 · answered Feb 20 '15 at 18:57

-1

Hi You need this code.

//If the query returns more 1 row you must use this.
...
$query = "USE database_name; SELECT COUNT(`id`) AS RowCount FROM `needs` WHERE (`status`=100);"

$result= mysql_query($query) or die(mysql_error());

if ($row= mysql_fetch_array($result))
   {  
     DO{
        echo $row["RowCount "];  
        }WHILE ($row=mysql_fetch_array($result));
    }
// now if you query returns only 1 wor use this.

$result= mysql_query($query) or die(mysql_error());
$rowQry= mysql_fetch_array($result);
echo $rowQry["RowCount "];

Luky

answered Feb 20 '15 at 18:57

David Olivares

1
1

2

Can you please explain how this answers the question? Without that, this is just code. – Surreal Dreams Feb 20 '15 at 19:01
@Luky I get an error: Parse error: syntax error, unexpected '$result' (T_VARIABLE) – user2520794 Feb 20 '15 at 19:02
(¬_¬)" ... Really? Are you missing something in your strange code? Cause I saw what are you missing. Read the error @user2520794. – bcesars Feb 20 '15 at 19:07
2

If you're going to rewrite the code to use only one mysql api, **don't use the obsolete one**. Use mysqli. – John Conde Feb 20 '15 at 19:12
1

@user2520794 The parse error is NOT coming from `$result...` but elsewhere. This answer is wrong and for a lot of reasons. – Funk Forty Niner Feb 20 '15 at 19:14
there was a missing semi-colon at the end of the $query line. No errors now, now the result just shows up blank with no value. – user2520794 Feb 20 '15 at 19:19

Echo MySQL Query in PHP

2 Answers2