PHP - Moved: Why Doesnt This Mysql Query Work?

i made a submitter, that workes:

<?php
include 'sqlconnect.php';

 
$sql = sprintf(
       "INSERT INTO aktiviteter
            (`title`, `firma`, `beskrivelse`, `information`, `pris`, `rabat`,
             `adresse`, `by`, `postnummer`, `telefon`, `hjemmeside`)
        VALUES
            ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
        mysqli_real_escape_string($con, $_POST['title']),
        mysqli_real_escape_string($con, $_POST['firma']),
        mysqli_real_escape_string($con, $_POST['beskrivelse']),
        mysqli_real_escape_string($con, $_POST['information']),
        mysqli_real_escape_string($con, $_POST['pris']),
        mysqli_real_escape_string($con, $_POST['rabat']),
        mysqli_real_escape_string($con, $_POST['adresse']),
        mysqli_real_escape_string($con, $_POST['by']),
        mysqli_real_escape_string($con, $_POST['postnummer']),
        mysqli_real_escape_string($con, $_POST['telefon']),
        mysqli_real_escape_string($con, $_POST['hjemmeside'])
        );
 
if (!mysqli_query($con, $sql))
{
    die('Error: ' . mysqli_error($con));
}
echo "Aktiviteten er uploaded";
 
mysqli_close($con);

but then i changed a few parameters and now it doesnt. i cant figure out why

<?php
include 'sqlconnect.php';

$sql = sprintf(
       "INSERT INTO menus
            (`navn`, `kommentar`, `pris`, `target`)
        VALUES
            ('%s', '%s', '%s', '%s')",
        mysqli_real_escape_string($con, $_POST['navn']),
        mysqli_real_escape_string($con, $_POST['kommentar']),
        mysqli_real_escape_string($con, $_POST['pris']),
        mysqli_real_escape_string($con, $_POST['target']),
        );
 
if (!mysqli_query($con, $sql))
{
    die('Error: ' . mysqli_error($con));
}
echo "menuen er uploaded";
 
mysqli_close($con);

can anyone spot the mistake i made?

Hey guys, I have a mysql switch statement that shows different things based on the row value.

Here it is...

<?php
switch ($rows['icon']) {
    case 1:
        $picture = '<img src=\"img/apple.gif\" title=\"apple\" alt=\"apple\" />';
        echo $picture;
        break;
        
    case 2:
        $picture = '<img src=\"img/banana.gif\" title=\"banana\" alt=\"banana\" />';
        echo $picture;
        break;
        
    case 3:
        $picture = '<img src=\"img/orange.gif\" title=\"orange\" alt=\"orange\" />';
        echo $picture;
        break;
        
    default:
        echo "$rows[icon] is something other than 1 2 or 3";
        break;
}  
?>


Here is how the other code looks like.



<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');


mysql_connect("localhost", "", "")or die("cannot connect");
mysql_select_db("test")or die("cannot select DB");
$tbl_name="test_mysql";
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count=mysql_num_rows($result);

if (isset($_POST['Submit'])) {
    for($i=0;$i<$count;$i++){
        $month   = $_POST['month'];
        $date    = $_POST['date'];
        $message = $_POST['message'];
        $title   = $_POST['title'];
        $id      = $_POST['id'];
        $icon    = $_POST['icon'];         // ILYA
        $monthday= $month[$i]."<br>".$date[$i];
        $sql1="UPDATE $tbl_name 
                    SET monthday='$monthday', 
                        month='$month[$i]', 
                        date='$date[$i]', 
                        message='" . mysql_real_escape_string($message[$i]) . "', 
                        title='" . mysql_real_escape_string($title[$i]) . "',
                        icon='$icon[$i]'                        
                    WHERE id=".$id[$i];                        // ILYA

    if(!($result1 = mysql_query($sql1))){                   
        "<BR>Error UPDATING $tbl_name ";                              
        exit();                                             
        }                                                   
    }
}
$result=mysql_query($sql);
$count=mysql_num_rows($result);


?>

Dont mind the other UPDATE code its part of something else.

Anyways, why is the case automaticaly going to the last one... with the words: is something other than 1 2 or 3


Also, this is with multiple rows at once so I think that that may the problem...

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=351058.0

If you also have any feedback on my code, please do tell me. I wish to improve my coding base.

Basically when you fill out the register form, it will check for data, then execute the insert query. But for some reason, the query will NOT insert into the database. In the following code below, I left out the field ID. Doesn't work with it anyways, and I'm not sure it makes a difference.

Code:

  Code: [Select]
mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
Full code:

Code: [Select]
<?php
include_once("includes/config.php");
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><? $title; ?></title>
<meta http-equiv="Content-Language" content="English" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
</head>
<body>
 
<div id="wrap">
 
<div id="header">
<h1><? $title; ?></h1>
<h2><? $description; ?></h2>
</div>
 
<? include_once("includes/navigation.php"); ?>
 
<div id="content">
<div id="right">
<h2>Create</h2>
<div id="artlicles">
<?php
 
if(!$_SESSION['user'])
{
 
        $username = mysql_real_escape_string($_POST['username']);
        $password = mysql_real_escape_string($_POST['password']);
        $name = mysql_real_escape_string($_POST['name']);
        $server_type = mysql_real_escape_string($_POST['type']);
        $description = mysql_real_escape_string($_POST['description']);
 
        if(!$username || !$password || !$server_type || !$description || !$name)
        {

        echo "Note: Descriptions allow HTML. Any abuse of this will result in an IP and account ban. No warnings!<br/>All forms are required to be filled out.<br><form action='create.php' method='POST'><table><tr><td>Username</td><td><input type='text' name='username'></td></tr><tr><td>Password</td><td><input type='password' name='password'></td></tr>";
        echo "<tr><td>Sever Name</td><td><input type='text' name='name' maxlength='35'></td></tr><tr><td>Type of Server</td><td><select name='type'>
       
        <option value='Any'>Any</option>
        <option value='PvP'>PvP</option>
        <option value='Creative'>Creative</option>
        <option value='Survival'>Survival</option>
        <option value='Roleplay'>RolePlay</option>
       
        </select></td></tr>
       
        <tr><td>Description</td><td><textarea maxlength='1500' rows='18' cols='40' name='description'></textarea></td></tr>";
        echo "<tr><td>Submit</td><td><input type='submit'></td></tr></table></form>";
        }
        elseif(strlen($password) < 8)
        {
        echo "Password needs to be higher than 8 characters!";
        }
        elseif(strlen($username) > 13)
        {
                echo "Username can't be greater than 13 characters!";
        }
        else
        {
                $check1 = mysql_query("SELECT username,name FROM servers WHERE username = '$username' OR name = '$name' LIMIT 1");
               
                if(mysql_num_rows($check1) < 0)
                {
                        echo "Sorry, there is already an account with this username and/or server name!";
                }
                else
                {
                        $ip = $_SERVER['REMOTE_ADDR'];

                        mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
                        echo "Server has been succesfully created!";
                }
        }
       
}
else
{
        echo "You are currently logged in!";
}
 
?>
</div>
</div>
 
<div style="clear: both;"> </div>
</div>
 
<div id="footer">
<a href="http://www.templatesold.com/" target="_blank">Website Templates</a> by <a href="http://www.free-css-templates.com/" target="_blank">Free CSS Templates</a> - Site Copyright MCTop
</div>
</div>
 
</body>
</html>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321864.0