Member Avatar for fuggles

For some reason the post is not getting inserted into my database.

if($_SESSION['permissions']>=1) {
		$query="INSERT INTO news (id, title, poster, posterid, body) VALUES ('$id','$title','$poster','$posterid','$body')";
		$result=mysql_query($query,$con);
		header("location:index.php");
	}
  • 3 Contributors
  • 3 Replies
  • 84 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by liamfriel
Member Avatar for Will Gresham

Is the '$_SESSION' value set?

Change your query to this:

$result = mysql_query($query,$con)or die("Error: " . mysql_error());

Does it output any errors with that in place?

Edited by Will Gresham because: n/a
Member Avatar for fuggles

I'll try that. And it appears to be working, it redirects me back to my index. And the $_SESSION is set, otherwise it wouldn't redirect me.

Member Avatar for liamfriel

what is wrong with it? does it enter into the database but the values are not there? Otherwise the die() would give you an errror?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.