Simple query not working?

Question

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();

   ?>

it's a better practice to add `mysql_error()` to check if there's any error. So try this, `$result = mysql_query("SELECT id FROM table ORDER BY id DESC LIMIT 1") or die("Error :: " . mysql_error());` to check if any error is reported — Fallen, Jul 26 '14 at 18:38
`echo $row[0];` as [`mysql_fetch_row — Get a result row as an enumerated array`](http://php.net/manual/en/function.mysql-fetch-row.php) — Sean, Jul 26 '14 at 18:38
@Sean make your comment an answer and itll get accepted and upvoted... for more rep :) — John Ruddell, Jul 26 '14 at 18:40
I don't really understand the point of fetch_row. Why not always use fetch_array? The overhead must be trivial. — Strawberry, Jul 26 '14 at 18:45

score 2 · Accepted Answer · answered Jul 26 '14 at 18:48

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.

score 1 · Answer 2 · answered Jul 26 '14 at 18:40

1

You may try to use this:

echo $row[0];

instead of

echo $row["id"];

answered Jul 26 '14 at 18:40

Rahul Tripathi

168,305
31
280
331

score 1 · Answer 3 · answered Jul 26 '14 at 18:47

1

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'];

?>

answered Jul 26 '14 at 18:47

Brian DeMilia

13,103
1
23
33

Also thanks for your advice, isnt PDO the better option? I want to do PDO later. – DaViDa Jul 26 '14 at 18:58
It depends, http://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons , http://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use--net-24059 – Brian DeMilia Jul 26 '14 at 18:59
Thanks once again :) will look into this! – DaViDa Jul 26 '14 at 19:04

Simple query not working?

3 Answers3