MySQL Error 'CID=1'

Rider

This code used to work a month or so ago, but now it won't work. I have a script that manages authors so they can update content, etc. Anyways, when they go to fill out the form to add new content I get this error:

"Error inserting content into category 1: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' CID=1' at line 2"

I'm running MySQL version 4.0.13.

Any ideas? I can't figure it out.

To try it out go to http://www.riderworks.com/code/2/newcontent.php

Make sure you select Rider as the Author and News as the category.

-Rider

jek

Could you please post your code?

Rider

Code for newcontent.php

<!-- newcontent.php -->
<html>
<head>
<title> Add New Content </title>
</head>
<body>
<?php

//This is where my dbconnect info is.

if (isset($_POST['submit'])): 
  // A new content has been entered
  // using the form.

  $aid = $_POST['aid'];
  $contenttext = $_POST['contenttext'];
  $cats = $_POST['cats'];

  if ($aid == '') {
    die('<p>You must choose an author ' .
        'for this content. Click "Back" ' .
        'and try again.</p>');
  }

  $sql = "INSERT INTO Contents SET
          ContentText='$contenttext',
          ContentDate=CURDATE(),
          AID='$aid'";
  if (@mysql_query($sql)) {
    echo('<p>New content added</p>');
  } else {
    die('<p>Error adding new content: ' .
        mysql_error() . '</p>');
  }

  $jid = mysql_insert_id();

  if ($cats == '') $cats = array();

  $numCats = 0;
  foreach ($cats as $catID) {
    $sql = "INSERT IGNORE INTO ContentLookup
            SET CSID=$csid, CID=$catID";
    $ok = @mysql_query($sql);
    if ($ok) {
      $numCats = $numCats + 1;
    } else {
      echo("<p>Error inserting content into category $catID: " .
           mysql_error() . '</p>');
    }
  }
?>

<p>Content was added to <?=$numCats?> categories.</p>

<p><a href="<?=$_SERVER['PHP_SELF']?>">Add More Content</a></p>
<p><a href="contents.php">Return to Content Search</a></p>

<?php
else: // Allow the user to enter new content

  $authors = mysql_query('SELECT ID, Name FROM Authors');
  $cats    = mysql_query('SELECT ID, Name FROM Categories');
?>

<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
<p>Enter the new content:<br />
<textarea name="contenttext" rows="15" cols="45" wrap>
</text></p>
<p>Author:
<select name="aid" size="1">
  <option selected value="">Select One</option>
  <option value="">---------</option>
<?php
  while ($author = mysql_fetch_array($authors)) {
    $aid = $author['ID'];
    $aname = htmlspecialchars($author['Name']);
    echo("<option value='$aid'>$aname</option>\n"); 
  }
?>
</select></p>
<p>Place in categories:<br />
<?php
  while ($cat = mysql_fetch_array($cats)) {
    $cid = $cat['ID'];
    $cname = htmlspecialchars($cat['Name']);
    echo("<input type='checkbox' name='cats[]' value='$cid' />$cname<br />\n"); 
  }
?>
</p>
<p><input type="submit" name="submit" value="SUBMIT" /></p>
</form>
<?php endif; ?>
</body>
</html>

Rider

This is the sql for the ContentLookup table.

CREATE TABLE ContentLookup (
CSID INT NOT NULL,
CID INT NOT NULL,
PRIMARY KEY (CSID,CID)
);

Rider

I found the error. I put "jid" instead of "csid"

It all works now. Thanks Jek for the help. And whoever else.

-Rider