strange...

[brcolow]

Ok i have a script that defines a varible $db_host as localhost and when i try to use it i get this error

Notice: Use of undefined constant localhost - assumed 'localhost' in D:\www[url]www.flashstand.com\brcolow.php[/url] on line 14

what can i do to fix it, and what does the error mean?

[tomhath]

Would be easier to diagnose if you had posted the code. But my guess is that you didn't put quotes around the word localhost, so php assumed you meant the constant 'localhost' (because that's what the error message says...)

[brcolow]

alrighty, i fixed that thanks 🙂
but now its weird, the script displays nothing and i dont see why it wont work

@ $db = mysql_connect("$db_host", "$db_username", "$db_password");

if (!$db)
{
	echo "<b><font color=\"red\">Error!</b></font> Could not connect to database.";	
	exit;
}

mysql_select_db("$database1");
	$query = "INSERT INTO news (name, email, title, body, date) VALUES ('$news_name', '$news_email', '$news_title', '$news_body', '$news_date')";
		$result = mysql_query($query);
	if ($result)
		echo "<b><font color=\"blue\">Success</font></b> - News Post added to database and is displayed on front page.";

[brcolow]

bump - please help!

[gtibok]

Originally posted by brcolow

mysql_select_db("$database1");
	$query = "INSERT INTO news (name, email, title, body, date) VALUES ('$news_name', '$news_email', '$news_title', '$news_body', '$news_date')";
		$result = mysql_query($query);
	if ($result)
		echo "<b><font color=\"blue\">Success</font></b> - News Post added to database and is displayed on front page.";

Insert does not return anything. You told your script to echo if $result exists. But $result is null, and the query was succesfull, and the script did just what you told him to do.

Computers act what we ask them, not what we want to

[brcolow]

so what do i do?

[jeffwhite]

if(mysql_errror($result)="")
{
echo "Success"
}
else
{
echo mysql_error();
}

Something like that.