[RESOLVED] Help STOP adding to table

David_P

From an image upload form I want to be able to either select a Category from a drop down list to place my image under, or create a new Category. If I select a Category from the list I don't want it to be added again - in any fashion to the $cat (category) table, because it's already in there.

I tried to write a script that checks to see if a Category by that name already exists in the $cat table and if so skip it and go straight to the part where it puts the image information into the $table (picture table). I want the Category name (cat_name) to be entered into the cat_name field in the $table (picture table), but it's nbot doing that either.

The problem however, is that it's not working. The $cat table is being advanced 1. No name or desc is being entered but the id is advancing by 1. So I know that my script is not working because if should be skipping anything to do with the $cat table if there is already a cat_name in there by the name submitted by the form from the drop down menu. I wrote a script to populate the drop down menu with the category names (cat_name) from the $cat table. So yes, the name already exist in the table.

Can you see why this is not working?

If I decide to create a new Category rather than selecting one from the list it should skip down to the second part of this script and 1- add the new Category to the $cat table and add the picture info into the $table (picture table). I haven't tested this part yet, as Iwould like to fix the first problem first. But if you see a problem in this section to please tell me.

Thanks.

include("includes/dbconnect.php");

$cat_name = $_GET['cat_name'];

// Check to see if Category exists with this cat_name
$query = "SELECT cat_name FROM $cat WHERE cat_name = '$cat_name'";
$result = mysql_query($query) or die('Error, query failed: ' . mysql_error());

if ($cat_name == '')

{

$query = "INSERT INTO $cat VALUES ('', '$cat_name', '$cat_desc')";
 mysql_query($query);

$cat_name = mysql_real_escape_string($_POST['cat_name']);
$title = mysql_real_escape_string($_POST['title']); 
$desc = mysql_real_escape_string($_POST['desc']);
$thumb_w = $t_width;
$thumb_h = $t_height;

$query = "INSERT INTO $table VALUES ('', '$cat_name', '$title', '$desc', '$image_name', '$thumb_w', '$thumb_h')"; 
$result = mysql_query($query);

echo "<h2 style='color: #090'>Success! Picture Added</h2>
<br>
<a href='index_c.php'>View Pics</a>
<br><br>
<a href='image_upload_d.php'>Add Another Pic</a>
";

}

else

{


// Make the query

$title = mysql_real_escape_string($_POST['title']); 
$desc = mysql_real_escape_string($_POST['desc']);
$thumb_w = $t_width;
$thumb_h = $t_height;    

$query = "INSERT INTO $table VALUES ('', '$cat_name', '$title', '$desc', '$image_name', '$thumb_w', '$thumb_h')"; 
$result = mysql_query($query); 

echo "<h2 style='color: #090'>Success! New Category and Picture Added</h2>
<br>
<a href='index_c.php'>View Pics</a>
<br><br>
<a href='image_upload_d.php'>Add Another Pic</a>
";

mysql_close();
}

Roger_Ramjet

Several things here:

If you have an autoincrement column in a table and attempt to insert a record into that table, the autoinc is incremented before the insert runs. If the insert fails the autoinc column is NOT reset, which is why you are getting numbers used up.
I don't follow your logic?? If cat_name is an empty string then insert it into the cat table ???
You should be checking if get and post vars are set before trying to use them.
When you query to see if the cat already exists, then just count the rows returned to see if it does: should be mysql_num_rows == 1.

David_P

That is what I am trying to do here. If the Category already exist in the $cat then the script is suppose to skip this damn part and go to the second part. No sense in entering it twice. I have the cat_name set as a unique field so the name shouldn't be able to be entered twice.

But yes, I want it to check to see if the category name already exist and if it does don't mess with the $cat table. If this would work as it should then it wouldn't auto increment. But if you're saying that it's going to auto-increment whether or not anything is entered, then I guess I could just eliminate the id from the table. I probably don't need it anyway.

The picture info is being entered as it should except for the cat_name. Why is this not being entered into the picture table ($table)?

    include("includes/dbconnect.php");

$cat_name = $_GET['cat_name'];

// Make sure Category doesn't already exist, if it does skip down to second section
$query = "SELECT cat_name FROM $cat WHERE cat_name = '$cat_name'";
$result = mysql_query($query) or die('Error, query failed: ' . mysql_error());

if (mysql_num_rows($result) != 1)

{

$query = "INSERT INTO $cat VALUES ('', '$cat_name', '$cat_desc')";
 mysql_query($query);

$cat_name = mysql_real_escape_string($_POST['cat_name']);

$title = mysql_real_escape_string($_POST['title']); 
$desc = mysql_real_escape_string($_POST['desc']);
$thumb_w = $t_width;
$thumb_h = $t_height;

$query = "INSERT INTO $table VALUES ('', '$cat_name', '$title', '$desc', '$image_name', '$thumb_w', '$thumb_h')"; 
$result = mysql_query($query);

echo "<h2 style='color: #090'>Success! Picture Added</h2>
<br>
<a href='index_c.php'>View Pics</a>
<br><br>
<a href='image_upload_d.php'>Add Another Pic</a>
";

}

else

{


// Make the query

$cat_name = mysql_real_escape_string($_POST['cat_name']);
$title = mysql_real_escape_string($_POST['title']); 
$desc = mysql_real_escape_string($_POST['desc']);
$thumb_w = $t_width;
$thumb_h = $t_height;    

$query = "INSERT INTO $table VALUES ('', '$cat_name', '$title', '$desc', '$image_name', '$thumb_w', '$thumb_h')"; 
$result = mysql_query($query); 

echo "<h2 style='color: #090'>Success! New Category and Picture Added</h2>
<br>
<a href='index_c.php'>View Pics</a>
<br><br>
<a href='image_upload_d.php'>Add Another Pic</a>
";

mysql_close();
}

David_P

I dropped the id from the $cat table, but the table is still advancing by one. No info is being entered, it just adds a blank field. I need a script that will skip this part if a name of a category selected from the list is already in the table.

And the cat_name is still not being entered into the picture table ($table).

Roger_Ramjet

No I am not saying it will increment if you don't run a query. I am saying it will increment when you run a query - whether the query succeeds or not.

You may be trying to check if the category exists or not - but you are not succeeding. As I said, I don't follow your logic at all. 😕