adding User ID to mysql entry

[wazo]

Hi guys

When I add a entry I want the userid box to be filled with the Users Id

At the moment it keeps showing 0 in the table when I submit

Any help I would be thankful

<?php
$con = mysql_connect("localhost","notexper_two","three");
if (!$con){ die('Could not connect: ' . mysql_error()); }
mysql_select_db("notexper_one", $con);

$sql = "INSERT INTO jobs
(catergory, location, jobtitle, jobdescription, salary, jobstatus, company, firstname, surname, email, telephone, fax, userid)
VALUES
('$_POST[catergory]','$_POST[location]','$_POST[jobtitle]','$_POST[jobdescription]','$_POST[salary]','$_POST[jobstatus]',
'$_POST[company]','$_POST[firstname]','$_POST[surname]','$_POST[email]' ,'$_POST[telephone]' ,'$_POST[fax]', '".$_SESSION['username']."')";

if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }
echo "1 record added";
mysql_close($con);
?>

[Kailash Badu]

Please clarify your problem. Is the new row being added to the database or not?

[wazo]

yes the new row is added every other field works fine apart from the last one
userid

say userid 62 adds a listing ithe userid box shows as 0

[Kailash Badu]

What exact query is being run? To check, replace above code with this:

                              <?php
$con = mysql_connect("localhost","notexper_two","three");
if (!$con){ die('Could not connect: ' . mysql_error()); }
mysql_select_db("notexper_one", $con);

$sql = "INSERT INTO jobs 
    (catergory, location, jobtitle, jobdescription, salary, jobstatus, company, firstname, surname, email, telephone, fax, userid)
    VALUES
    ('$_POST[catergory]','$_POST[location]','$_POST[jobtitle]','$_POST[jobdescription]','$_POST[salary]','$_POST[jobstatus]',
'$_POST[company]','$_POST[firstname]','$_POST[surname]','$_POST[email]' ,'$_POST[telephone]' ,'$_POST[fax]', '".$_SESSION['username']."')";

print $sql;
if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }
echo "1 record added";
mysql_close($con);
?>

Let me know the result.

[wazo]

all that shows is the query im trying to do i want to know what is wrong in my script that is making the last field show as 0 everytime and not display the users id

[Kailash Badu]

all that shows is the query im trying to do i want to know what is wrong in my script that is making the last field show as 0 everytime and not display the users id

We need to know what values are exactly being entered in the database. In particular, I need to know what value does $_SESSION['username'] hold. That's why I told you to post back the result.

[Kailash Badu]

also:

listing ithe userid box shows as 0

Where is the userid box?