"Use of undefined constant" error

dico

Hi there,

I get the following error when trying to select stuff from a MySQL DB.

Notice: Use of undefined constant timestamp - assumed 'timestamp' in D:\websites\mysite\index.php on line 93

The server has windows with php and mysql installed.

I've developed 100s of php/mysql sites on linux boxes but this is a box some other guy setup. Any help?

Thanks,

-dr

AstroTeg

I'd check line 93 of index.php. You may have forgotten a $ in front of a variable name.

dico

No... everything is fine...

What actually does work is this... rather then using something like $row[whatever], I can use $row[3] or whatever number corresponds with that 'whatever'. Then everything works fine.

Any ideas now??

Thanks,

-dr

AstroTeg

Originally posted by dico
What actually does work is this... rather then using something like $row[whatever], I can use $row[3] or whatever number corresponds with that 'whatever'. Then everything works fine.

Try $row['whatever']. Also check if you are pulling the data out with mysql_fetch_array() or are you using something else?

dico

This is what I have..... I will try adding the ' to the line['whatever'}

Thanks,

-dr

$link_id = mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db($DBName,$link_id) or die("Unable to select database $DBName");

	$sql = "SELECT d.*,e.* FROM dates d, events e WHERE e.id=d.bid ORDER BY d.timestamp DESC";
	$result = mysql_query($sql);

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

			echo "<option value='$line[did]'> $line[name] (" . date('m/d/Y g:ia',$line[2]) . ")\n";

	}

	mysql_close($link_id);