fInfo???

[NoteMe]

Is that a keyword in PHP or something. I just used about 45 minutes to track down an error while I was trying to get out some records from my MySQL database, and I finaly found out that it was tripping on the field called fInfo.

When I inserted the record, there was no error, but when I was trying to get it again...then hell break lose..

[The Hobo]

I don't see how it being a PHP keyword would cause a problem. If it was a MySQL keyword, then it would definitely cause a problem.

A search of fInfo on mysql.com turns up nothing, so I don't think that's the case.

Can you post the code that it's crapping on?

[NoteMe]

When I did insert the record I used this code:

if (!$Ja){
	$fDato = addslashes($fDato);
	$fBy = addslashes($fBy);
	$fNavn = addslashes($fNavn);
	$fInfo = addslashes($fInfo);
	$fSted = addslashes($fSted);
	$query = mysql_query("INSERT INTO fremover VALUES('', '$fBy', '$fDato', '$fSted', '$fNavn', '$fInfo', '$fBildebox')");
}

and it worked....

then I tried to get it again on a other site. With this code:

<?php
	$resultat = mysql_query("select fArrID, fSted, fNavn, fInfo, fBildebox from fremover where fBy like 'O' and fDato >= ".$StartDato." ORDER BY fDato",$db);
	$row = mysql_fetch_array($resultat);

And it gave me an error.

Then I found out that it didn't want to make me select the fInfo field. So in myPHPAdimn, I changed the field to fText. And changed line to:

<?php
        $resultat = mysql_query("select fArrID, fSted, fNavn, fText, fBildebox from fremover where fBy like 'O' and fDato >= ".$StartDato." ORDER BY fDato",$db);
	$row = mysql_fetch_array($resultat);

and now it worked.

PS: Of course I then changed the line for the insert form too.


I used 45 minutes to find out of this. And it nearly killed me.