Alex Zeisler: BenutzerID in Tabelle schreiben

Beitrag lesen

Hallo!

Wie kann ich eine UserID, die ich mittels session mitschicke in eine Tabelle schreiben?

LG
Alex

Code:
BenutzerId: <?php echo $_SESSION["user_id"]; ?><br>
            Username: <?php echo $_SESSION["user_user"]; ?><br>
            Vorname: <?php echo $_SESSION["user_firstname"]; ?><br>
        Nachname: <?php echo $_SESSION["user_lastname"]; ?><br />
    Status: <?php echo $_SESSION["status"]; ?>

<?php

include("projects.php");
include ("checkuser.php");

$projecttype = ($_POST["projecttype"]);
$projecttitle = ($_POST["projecttitle"]);
$projectdescription = ($_POST["projectdescription"]);
$pcid = ($_SESSION["user_id"]);

$query = "INSERT INTO projects VALUES
 ('$projecttype', '$projecttitle', '$projectdescription', '$pcid')";

echo "$query";

mysql_query($query) or die ('Error, Query failed('.mysql_error().')');
 echo "A new project was posted<p>";

mysql_close($verbindung);

?>