|
|
Posted by _Raven on 08/17/06 15:25
"J.O. Aho" <user@example.net> wrote in message
news:4kje2gFcgc0qU1@individual.net...
> You aren't giving any info on how your table looks like, so it's a bit
> more guessing here.
Ok, the table is like so:
id auto_increment, not null, primary_key
uid int(5)
name varchar(255) not null
INDEXES:
keyname | type | field
PRIMARY | PRIMARY | id
name | UNIQUE | name
SAMPLE DATA IN TABLE:
1, 32, bill
2, 33, fred
3, 34, mark
4, 35, ralph
5, 36, jerry
#THE ACTUAL CODE:
$_GET['name'] = 'joe'; //From form
$sql = "SELECT MAX(uid) FROM mytable";
$query = mysql_query($sql);
$nextUID = mysql_result($query,0) + 1;
$nextUID = 37; //From query above
$sql = "INSERT INTO mytable (uid,name) VALUES ('" . $nextUID . "','" .
$_GET['name'] . "')";
$query = mysql_query($sql);
if(!$query){
$message = "<div align=\"center\"><strong>COULD NOT ADD " .
ucfirst($_GET['name']) . "!";
$message .= "The error was: " . mysql_error() ." The SQL was: " . $sql
.. "<br><br>";
$message .= "Affected Rows: " . mysql_affected_rows() .
"</strong></div><br><br>";
}else{
$message = "<div align=\"center\"><strong>" . ucfirst($_GET['name']) .
" Has Been Added!</strong></div><br><br>";
}
#OUTPUT FROM ABOVE:
COULD NOT ADD Joe! The error was: Duplicate entry 'joe' for key 2
The SQL was: INSERT INTO mytable (uid,name) VALUES (41,'joe')
Affected Rows: -1
> Are all columns unique? then you limit quite much what you can enter into
> your table, only the uid should be unique and a primary key.
No, only the name column is unique, except for the id col, which is primary
key and unique by default I believe
>
> //Aho
Navigation:
[Reply to this message]
|