I'm trying to output data from my data base but all to no avail. I have checked my codes over and over again. Pls is there anything I'm doing wrong? My coding goes thus:

<?php

mysql_connect("localhost", "root", "" ) or die("We couldn't connect!" );

mysql_select_db("testsite" );

$result = mysql_query("INSERT * FROM users" );

while($row = mysql_fetch_array($result)) {

echo $row['name']." ".$row['email']." ".$row['password'];

echo "<br />";

}

mysql_close();


?>


Here is the error message I'm getting on my browser:

Parse error: syntax error, unexpected '[' in C:\xampp\htdocs\testsite\output.php on line 10

Line 10 is where I have my while loop accoding to the error message above.

Thanks

OCTAVO: I'm trying to output data from my data base but all to no avail. I have checked my codes over and over again. Pls is there anything I'm doing wrong? My coding goes thus:

<?php

mysql_connect("localhost", "root", "" ) or die("We couldn't connect!" );

mysql_select_db("testsite" );

$result = mysql_query("INSERT * FROM users" );

while($row = mysql_fetch_array($result)) {

echo $row['name']." ".$row['email']." ".$row['password'];

echo "<br />";

}

mysql_close();


?>


Here is the error message I'm getting on my browser:

Parse error: syntax error, unexpected '[' in C:\xampp\htdocs\testsite\output.php on line 10

Line 10 is where I have my while loop accoding to the error message above.

Thanks

Personaly I hate concatenation In echo statmnts, so frst of all,I sujest u chng d code to sumtin lyk

while($row = mysql_fetch_array($result)) {

echo "{$row['name']} {$row['email']} {$row['password']}";

try dis frst,let's c

CODE-EATER:


Personaly I hate concatenation In echo statmnts, so frst of all,I sujest u chng d code to sumtin lyk

while($row = mysql_fetch_array($result)) {

echo "{$row['name']} {$row['email']} {$row['password']}";

try dis fast,let's c

Ok, thanks my Oga. Lemme try.

OCTAVO:
Ok, thanks my Oga. Lemme try.

DNT 4get to close d while statement oo

It didn't work.
Got this error message:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\testsite\output.php on line 10

Abeg, is it INSERT * OR SELECT *

spikes C: Abeg, is it INSERT * OR SELECT *

Mtcheww, I no even c dat 1....select jor

Thank you guys
I don see my mistake. It is supposed to be SELECT. Thank you once again.