[SOLVED] SELECT * FROM Command error

[Foser]

<?php
mysql_connect("localhost", "root", "password") or die(mysql_error);
mysql_select_db("tutorial1") or die(mysql_error);

$personalinfo = mysql_fetch_array(mysql_query("SELECT * FROM personalinfo")) or die(mysql_error);

echo "Name:" .$personalinfo['name']. "<br>Age:" .$personalinfo['age']. "<br>Sex Type:" .$personalinfo['sex'];
?>

 

Not that i get an error or anything but its just not showing up the associative sql array...

 

thanks! ^^

[chigley]

<?php
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("tutorial1") or die(mysql_error());

$personalinfo = mysql_fetch_array(mysql_query("SELECT * FROM personalinfo")) or die(mysql_error());

echo "Name:" .$personalinfo['name']. "<br>Age:" .$personalinfo['age']. "<br>Sex Type:" .$personalinfo['sex'];
?>

 

You got your mysql_error() syntax wrong!

[Foser]

changed the error syntax, didn't do anything,

[MadTechie]

try

print_r($personalinfo);

at the end

[Foser]

I get the correct information, don't know why I'm not getting it.

 

Array ( [0] => Foster [Name] => Foster [1] => 15 [Age] => 15 [2] => Male [sex] => Male )
1

[MadTechie]

can you post the results (or some of them)

[Foser]

Name:
Age:
Sex Type:Array ( [0] => Foster [Name] => Foster [1] => 15 [Age] => 15 [2] => Male [sex] => Male )
1

 

thats what i get

 

aand for my info in my mysql datase, i only have one line in it. which is

Full Texts  	Name 	Age 	Sex
      	Foster 	15 	Male

[Foser]

I hate to bump, but here it is...

 

*bump*

[MadTechie]

echo "Name:" .$personalinfo['Name']. "<br>Age:" .$personalinfo['Age']. "<br>Sex Type:" .$personalinfo['Sex'];