MySQL not accepting data into table

[The_Stewart]

Weeks! Weeks I say! This has me baffeled. I want to insert some data to a table. It just won't work for me.
This is my code:

<?php

$con = mysql_connect(<host>, <name>, <pass>);

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$dog = 'fish';
$photo = 0;

mysql_select_db(<database>, $con);

mysql_query("INSERT INTO breeds (id, breed, photo) 
VALUES (NULL, $dog, $photo)");

mysql_close($con);

?>

The table is as follows:
AUTO_INCREMENT, VARCHAR, DECIMAL
All NOT NULL

What am I doing wrong?

[laserlight]

What am I doing wrong?

You forgot to quote the strings used in the SQL statement. Also, you should leave out the id column since it is autoincremented.

As a result, you might write:

mysql_query("INSERT INTO breeds (breed, photo) VALUES ('$dog', '$photo')");

[The_Stewart]

Wow. Shows how much I know. Thanks for that. I shall come here more often.

[bradgrafelman]

Don't forget to mark this thread resolved.