CODEWITHSUNDEEP
phpmysqlsqldatabaseecho
DaViDa
DaViDa

Reputation: 641

Simple query not working?

I am trying to get a single value from the database. Somehow it does not echo out. I know about the security deprecation and will use PDO later on this is just as test. I filled in the correct table. When I use the sql I have in phpmyadmin it correctly gives me the value i want.

  <?php
    include 'connectdb.php';

    $result = mysql_query("SELECT id FROM table ORDER BY id DESC LIMIT 1");

    $row = mysql_fetch_row($result);


    echo $row["id"];

    mysql_close();

   ?>

Upvotes: 0

Views: 71

Answers (3)

Sean
Sean

Reputation: 12433

per the docs ->mysql_fetch_row — Get a result row as an enumerated array http://php.net/manual/en/function.mysql-fetch-row.php so you want 

echo $row[0];

--
note: also from the docs -> Warning [mysql_ functions/] extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.

Upvotes: 2

Brian DeMilia
Brian DeMilia

Reputation: 13248

This is how you would do this in mysqli (as you point out, you should not be using mysql_ functions)

You can put $con elsewhere and use include each time you use a query. (Replace the values in the connection string with what they actually are, in your case.)

<?php

$con = mysqli_connect('localhost',$mysql_user,$mysql_password,$mysql_dbname); if (!$con) { die('Could not connect: ' . mysqli_error($con)); } mysqli_select_db($con,"xyz");

$result = mysqli_query("select id from table order by id desc limit 1");

$result_row = mysqli_fetch_array($result);

echo $result_row['id'];

?>

Upvotes: 1

Rahul Tripathi
Rahul Tripathi

Reputation: 172398

You may try to use this:

echo $row[0];

instead of

echo $row["id"];

Upvotes: 1

Related Questions