Storing rand() output to mysql database ERROR

Question

I wanted to store the output of rand() function into my database, I have been getting the error!

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 'unique) VALUES('964350')' at line 1

This is my code

<?php

require_once('connect.php');

    $unique = rand(100000, 999999);

    $uni = "INSERT INTO registrations (unique) VALUES('$unique')";
    $result = @mysql_query($uni);

        if($result) {
            $sucmsg_arr[] = 'Registration Successful!';
    }

?>

SOehl · Accepted Answer · 2015-03-01 07:41:09Z

2

'unique' is a keyword like 'select' or 'delete'.

Try it with INSERT INTO registrations (`unique`) VALUES('$unique')

answered Mar 1, 2015 at 7:41

SOehl

4274 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SOehl Over a year ago

Note that "unique" is set into a Apostrops, not in qutation Marks!

Collectives™ on Stack Overflow

Storing rand() output to mysql database ERROR

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related