Another Undefined Index

[kingdave2nd]

Hello everybody,

i want to read an entry from a mysql server with this little PHP Script.

$tbl_variousinf_result=mysql_query("SELECT * FROM tbl_variousinf");
while($tbl_variousinf=mysql_fetch_array($tbl_variousinf_result))
{
echo $tbl_variousinf['company'];
}

Now i get the following error message:

Notice: Undefined index: company in u:\selfprog\websites\rr\includes\variousinf.php on line 17

Have anyone an idea?

Thx

KingDave2nd

[leatherback]

I'd think there is no colum compagny in your table.

Make sure your caps'are OK!

J

[kingdave2nd]

I'm blond but not stupid :-)

The column company already exist

KD2nd

[Savaal]

Try this line instead. I have had luck with it in the past.

echo "$tbl_variousinf[company]";

It somehow doesn't always like single quotes inside brackets when it is to print to the screen. I don't really know why. If it is in an echo command, or any command that normally is in double quotes, eliminate the single quotes from inside the array brackets... Hope this helps...