$sql = "INSERT INTO user (username, pass) VALUES (" . $username . ", " . $password . ")";
Whether it is done in php or Heidisql I'm not sure how.
$sql = "INSERT INTO user (username, pass) VALUES (" . $username . ", " . $password . ")";
ALTER TABLE `yourtable`
ADD PRIMARY KEY (`id`),
CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT
require_once('mysql.php');
mysql_select_db("satb", $con);
$textid = $_POST['theid'];
if(count($textid) >= 1){
//$sql = "INSERT INTO book (page) VALUES ('" . $textpage . "')";
for($i = 1; $i < count($textid); $i++){
$sql = "UPDATE book SET id = ('" . $textid[$i] . "') WHERE id = 0";
//$sql = "INSERT INTO book (id) VALUES ('" . $textid[$i] . "')";
mysql_query($sql) or die('Error: ' . mysql_error());
}
}
Please login to leave a reply, or register at first.