PHP : Select from Database

Question

thank you for reading. I'm having a little problem with the next sentence:

$nats = mysql_query("SELECT id,name FROM reportSatus WHERE reportId = ". $_POST['id']);
$rnat = mysql_fetch_array($nats);

With print_r($rnat) :

Array(
[0] => 1
[id] => 1
[1] => Poca contaminacion
[name] => Poca contaminacion
[2] => 1
[reportId] => 1)

But in the database with the same sentence is:

id            name
1       Poca contaminacion
2       Mucha contaminacion

Any idea what can it be? Thank you in advance ~

You've fetched a row only once - thus you're getting a one row. If you checked the documentation you would see how it's supposed to use it if you want to fetch multiple rows. — zerkms
– zerkms, Commented Mar 16, 2014 at 22:12
while($row = mysql_fetch_array($nats)){ echo $row['name'] } — samayo
– samayo, Commented Mar 16, 2014 at 22:14
What's the problem? What do you want to achieve? Because I can see two things that might be confusing for novice PHP/mysqli users here. Besides, this is so dangerous, ". $_POST['id']. Read about SQL Injection. — Francisco Presencia
– Francisco Presencia, Commented Mar 16, 2014 at 22:16

jx12345 · Accepted Answer · 2014-03-16 22:46:00Z

1

try :

echo '<table><tr><th>id</th><th>name</th></tr>';
while ($row = mysql_fetch_assoc($nats)) {
    echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td></tr>";
}
echo '</table>';

edited Mar 16, 2014 at 22:46

answered Mar 16, 2014 at 22:15

jx12345

1,6682 gold badges22 silver badges40 bronze badges

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

7 Comments

Maky-chan Over a year ago

Now it prints : Array ( [0] => 2 [id] => 2 [1] => Mucha contaminacion [name] => Mucha contaminacion )

jx12345 Over a year ago

ok, try updated code above - is that closer to what you want?

Maky-chan Over a year ago

tried. No luck. Print this, missing the first one: 2 Mucha contaminacion

jx12345 Over a year ago

try $nats = mysql_query("SELECT id,name FROM reportSatus"); and see if they all come out

jx12345 Over a year ago

ok, good. Are you sure that the record "id = 2, name = Mucha contaminacion" actually has a reportId = 1?

|

Community · Accepted Answer · 2023-11-17 19:59:20Z

0

From documentation

Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined. By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).

That's actually the way it works, if you need more rows to be returned you will need to loop throw the records

while($rnat = mysql_fetch_array($nats))
{
    //print here
}

edited Nov 17, 2023 at 19:59

CommunityBot

11 silver badge

answered Mar 16, 2014 at 22:13

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

2 Comments

Maky-chan Over a year ago

Still missing values. Prints: Array ( [0] => 2 [id] => 2 [1] => Mucha contaminacion [name] => Mucha contaminacion )

Fabio Over a year ago

It returns what you are selecting, if you loop then it will return all available records for your select

Collectives™ on Stack Overflow

PHP : Select from Database

2 Answers 2

7 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related