why the Php function does not return proper value?

Question

I have got a small php function that does not return any value that I can see and I seek your assistance

function getAllVotes($id) {
    $votes = array();
    $q = "SELECT * FROM $tbl_name WHERE id = $id";
    $r = mysql_query($q);
    if (mysql_num_rows($r)) {
        $row      = mysql_fetch_assoc($r);
        $votes[0] = $row['vvotes_up'];
        $votes[1] = $row['vvotes_down'];
    }
    return $votes;
}


// $id = $_POST['id'];


$id = 3;
$cur_votes = getAllVotes($id);
echo $cur_votes[1];

?>

now the

echo $cur_votes[1];

does not print any thing on my screen how ever the $cur_votes actually is an array and I can confirm that by

echo $cur_votes;

Which returns " Array "

I don't understand why $cur_votes[1]; does not return me any thing. Could you please help me ? thanks.

var_dump($cur_votes);?

Shomz
– Shomz

2014-03-09 05:52:12 +00:00
Commented Mar 9, 2014 at 5:52 — Shomz
– Shomz, Commented Mar 9, 2014 at 5:52
Try echo $cur_votes[0];

manta
– manta

2014-03-09 05:52:49 +00:00
Commented Mar 9, 2014 at 5:52 — manta
– manta, Commented Mar 9, 2014 at 5:52
$cur_votes[0] is also without any output.

user3067037
– user3067037

2014-03-09 05:54:35 +00:00
Commented Mar 9, 2014 at 5:54 — user3067037
– user3067037, Commented Mar 9, 2014 at 5:54
Result to var_dump is array(0) { }

user3067037
– user3067037

2014-03-09 05:55:22 +00:00
Commented Mar 9, 2014 at 5:55 — user3067037
– user3067037, Commented Mar 9, 2014 at 5:55
Where is $tbl_name defined?

asprin
– asprin

2014-03-09 05:57:35 +00:00
Commented Mar 9, 2014 at 5:57 — asprin
– asprin, Commented Mar 9, 2014 at 5:57

Teja Korlapati · Accepted Answer · 2014-03-09 06:17:26Z

1

make the following changes to your query

     $tbl_name="tablename"; 
     "SELECT * FROM '{$tbl_name}' WHERE id = '{$id}'";

edited Mar 9, 2014 at 6:17

answered Mar 9, 2014 at 5:54

Teja Korlapati

711 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Shomz Over a year ago

Integers don't need to be escaped.

Marty Over a year ago

Encouraging SQL injection... Downvoting wouldn't be enough.

user3067037 Over a year ago

Same result with both .. nothing is returned and the array is empty

Teja Korlapati Over a year ago

can you check what your query returns?

user3067037 Over a year ago

Can you state the query ?

|

Collectives™ on Stack Overflow

why the Php function does not return proper value?

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related