Code: Select all
$sql = "
UPDATE $table_name
SET sold = 'yes'
WHERE id = \"$id\"";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query");Moderator: General Moderators
Code: Select all
$sql = "
UPDATE $table_name
SET sold = 'yes'
WHERE id = \"$id\"";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query");Code: Select all
$db_name = "db";
$table_name = "item";
$id = "20";
$connection = @mysql_connect("localhost", "username", "password")
or die("Couldn't connect.");
$sql = "
UPDATE $table_name
SET sold = 'yes'
WHERE id = \"$id\"";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query");
print "udated";Code: Select all
die(mysql_error());Code: Select all
$db_name = "db";
$table_name = "item";
$id = "20";
$connection = @mysql_connect("localhost", "username", "password")
or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("couldn't select database");
$sql = "
UPDATE $table_name
SET sold = \"yes\"
WHERE id = \"$id\"
";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query");
print "udated";Code: Select all
<?php
/* this function does not return any value, no variable needed */
@mysql_select_db($db_name, $connection) or die("couldn't select database");
/* this will not return anything of use in this context, you should only use a variable if you are expecting a result set to be returned, i.e. you are using SELECT instead of INSERT, UPDATE, DELETE etc. */
$sql = "
UPDATE $table_name
SET sold = 'yes'
WHERE id = '$id'
";
@mysql_query($sql,$connection) or die("Couldn't execute query");
?>