Back To Programming / Scripting / Coding Forum

mySQL database UPDATE table SET.... help

  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 25th, 2003, 7:20 pm

Quote:
<?php
error_reporting(E_ALL);
session_start();
include("top.php");
$id = $_SESSION["id"];
//echo $id;
$conn = mysql_connect("localhost","adm","******") or die(mysql_error());
$db = mysql_select_db("fs",$conn) or die(mysql_error());
$result = mysql_query("UPDATE users SET username='$username' WHERE id='$id'") or die(mysql_error());
echo "<p>Done!";
echo "<p>< a href='account.php'>Back To Account< /a>";
echo "<br>< a href='main.php'>Warehouse< /a>";
echo "<br>< a href='index.php'>Home< /a>";
include("bottom.php");
?>


could someone please tell me what is wrong with this, because it won't do what i ask it to (update selected row in table)please tell me whats wrong with it, or an alternative solution
btw I never get any errors while running this script, thats the scariest part of all, it wont work and wont show errors
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post October 25th, 2003, 7:20 pm

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 30th, 2003, 7:02 pm

Well I would try getting rid of the ' around your variables in the mysql query statement. So instead of using:

Code: [ Select ]
UPDATE users SET username='$username' WHERE id='$id'


I would use:

Code: [ Select ]
UPDATE users SET username=$username WHERE id=$id


Usually when you put single quots around variables they will not be replaced with the actual value of the variable. I am not sure if that is causing your problem, but I would try that first. I have a feeling that is your problem though, because that would explain why you get no errors. It is simply doing nothing because it cannot find any id that matches '$id' since that isn't being replaced with anything (it just stays as $id literally). Let us know what happens!
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 30th, 2003, 8:11 pm

man, I was honestly praying to God that what you said would work, since if it works my whole game is set, I can make the rest of it no problem
but Newton's (or Murphy's) Law says" everything that can go wrong, will"

Error:

Unknown column 'test' in 'field list'

test is the username and when username=$username in the sql query, it thinks of $username as a column (at least thats what i figure) please help, open to any and all suggestions
or could someone psot a script they use to update db
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 30th, 2003, 9:02 pm

Show the new code that you were using that produced the error you said above.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 30th, 2003, 9:14 pm

Quote:
<?php
error_reporting(E_ALL);
session_start();
include("top.php");
$id = $_SESSION["id"];
//echo $id;
$conn = mysql_connect("localhost","adm","******") or die(mysql_error());
$db = mysql_select_db("fs",$conn) or die(mysql_error());
$result = mysql_query("UPDATE users SET username=$username WHERE id=$id") or die(mysql_error());
echo "<p>Done!";
echo "<p>< a href='account.php'>Back To Account< /a>";
echo "<br>< a href='main.php'>Warehouse< /a>";
echo "<br>< a href='index.php'>Home< /a>";
include("bottom.php");
?>
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 30th, 2003, 10:48 pm

I do not have an answer for you yet, but I just wanted to let you know that I replaced your password above in your code examples to ****** because I wasn't sure if you used fake credentials there. We do not need anyone trying to hack into your server. If that was your actual info you used, I would at least change that part before you post it here. Many of these posts can be viewed by thousands of people.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 31st, 2003, 2:10 pm

Bigwebmaster wrote:
I do not have an answer for you yet, but I just wanted to let you know that I replaced your password above in your code examples to ****** because I wasn't sure if you used fake credentials there. We do not need anyone trying to hack into your server. If that was your actual info you used, I would at least change that part before you post it here. Many of these posts can be viewed by thousands of people.

tnx, but dont u think i know that, that isnt a real server, it just a test server on my comp, so i dont bother replacing passwords and usernames
the real db on the website is completely different
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 31st, 2003, 3:58 pm

Well that is good to know, however, some people will suprise on what they will post so I was just taking precautions to protect you. (Just in case).
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 31st, 2003, 4:03 pm

As far as you problem is concerned, this is how I usually use PHP to update the MySQL database:

Code: [ Select ]
$sql = "UPDATE users SET username = $username WHERE id = $id";
if ( !($result = $db->sql_query($sql)) )  {
  message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}
  1. $sql = "UPDATE users SET username = $username WHERE id = $id";
  2. if ( !($result = $db->sql_query($sql)) )  {
  3.   message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
  4. }


Just so you know this requires some functions that I use from PHPBB to do it the way I do. You might download PHPBB to take a look at it.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 31st, 2003, 4:23 pm

tnx for the concern

well i tried it the way you did it

Quote:
$sql = "UPDATE users SET username = $username WHERE id = $id";

if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}

and it gave me this:
$result = mysql_query($sql);

Fatal error: Call to a member function on a non-object in c:\apache\htdocs\account_edit2.php on line 11
line 11 is the line where the if statement is placed
then i tried this
Quote:
$sql = "UPDATE users SET username = $username WHERE id = $id";
$result = mysql_query($sql);
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}


and it gives same error referring to the if statement, i tried altering it around a bit and it didnt work, please check, maybe u typed something wrong in there, i'm going back to looking for an answer to this
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 31st, 2003, 4:27 pm

Well like I said, it requires some other functions that came with PHPBB to do it the way I did. You would need to get those functions. I am sure you probably do not need all this though, and you could probably do it without all the functions. However, if you look at the functions you might be able to figure out the correct way to do it. Here are the functions that come with PHPBB in the mysql.php file:

Code: [ Select ]
<?php
/***************************************************************************
*                 mysql.php
*              -------------------
*  begin        : Saturday, Feb 13, 2001
*  copyright      : (C) 2001 The phpBB Group
*  email        : support@phpbb.com
*
*  $Id: mysql.php,v 1.16 2002/03/19 01:07:36 psotfx Exp $
*
***************************************************************************/

/***************************************************************************
*
*  This program is free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
***************************************************************************/

if(!defined("SQL_LAYER"))
{

define("SQL_LAYER","mysql");

class sql_db
{

    var $db_connect_id;
    var $query_result;
    var $row = array();
    var $rowset = array();
    var $num_queries = 0;

    //
    // Constructor
    //
    function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
    {

        $this->persistency = $persistency;
        $this->user = $sqluser;
        $this->password = $sqlpassword;
        $this->server = $sqlserver;
        $this->dbname = $database;

        if($this->persistency)
        {
            $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
        }
        else
        {
            $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
        }
        if($this->db_connect_id)
        {
            if($database != "")
            {
                $this->dbname = $database;
                $dbselect = @mysql_select_db($this->dbname);
                if(!$dbselect)
                {
                    @mysql_close($this->db_connect_id);
                    $this->db_connect_id = $dbselect;
                }
            }
            return $this->db_connect_id;
        }
        else
        {
            return false;
        }
    }

    //
    // Other base methods
    //
    function sql_close()
    {
        if($this->db_connect_id)
        {
            if($this->query_result)
            {
                @mysql_free_result($this->query_result);
            }
            $result = @mysql_close($this->db_connect_id);
            return $result;
        }
        else
        {
            return false;
        }
    }

    //
    // Base query method
    //
    function sql_query($query = "", $transaction = FALSE)
    {
        // Remove any pre-existing queries
        unset($this->query_result);
        if($query != "")
        {
            $this->num_queries++;

            $this->query_result = @mysql_query($query, $this->db_connect_id);
        }
        if($this->query_result)
        {
            unset($this->row[$this->query_result]);
            unset($this->rowset[$this->query_result]);
            return $this->query_result;
        }
        else
        {
            return ( $transaction == END_TRANSACTION ) ? true : false;
        }
    }

    //
    // Other query methods
    //
    function sql_numrows($query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $result = @mysql_num_rows($query_id);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_affectedrows()
    {
        if($this->db_connect_id)
        {
            $result = @mysql_affected_rows($this->db_connect_id);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_numfields($query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $result = @mysql_num_fields($query_id);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_fieldname($offset, $query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $result = @mysql_field_name($query_id, $offset);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_fieldtype($offset, $query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $result = @mysql_field_type($query_id, $offset);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_fetchrow($query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $this->row[$query_id] = @mysql_fetch_array($query_id);
            return $this->row[$query_id];
        }
        else
        {
            return false;
        }
    }
    function sql_fetchrowset($query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            unset($this->rowset[$query_id]);
            unset($this->row[$query_id]);
            while($this->rowset[$query_id] = @mysql_fetch_array($query_id))
            {
                $result[] = $this->rowset[$query_id];
            }
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_fetchfield($field, $rownum = -1, $query_id = 0)
    {
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            if($rownum > -1)
            {
                $result = @mysql_result($query_id, $rownum, $field);
            }
            else
            {
                if(empty($this->row[$query_id]) && empty($this->rowset[$query_id]))
                {
                    if($this->sql_fetchrow())
                    {
                        $result = $this->row[$query_id][$field];
                    }
                }
                else
                {
                    if($this->rowset[$query_id])
                    {
                        $result = $this->rowset[$query_id][$field];
                    }
                    else if($this->row[$query_id])
                    {
                        $result = $this->row[$query_id][$field];
                    }
                }
            }
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_rowseek($rownum, $query_id = 0){
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }
        if($query_id)
        {
            $result = @mysql_data_seek($query_id, $rownum);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_nextid(){
        if($this->db_connect_id)
        {
            $result = @mysql_insert_id($this->db_connect_id);
            return $result;
        }
        else
        {
            return false;
        }
    }
    function sql_freeresult($query_id = 0){
        if(!$query_id)
        {
            $query_id = $this->query_result;
        }

        if ( $query_id )
        {
            unset($this->row[$query_id]);
            unset($this->rowset[$query_id]);

            @mysql_free_result($query_id);

            return true;
        }
        else
        {
            return false;
        }
    }
    function sql_error($query_id = 0)
    {
        $result["message"] = @mysql_error($this->db_connect_id);
        $result["code"] = @mysql_errno($this->db_connect_id);

        return $result;
    }

} // class sql_db

} // if ... define

?>
  1. <?php
  2. /***************************************************************************
  3. *                 mysql.php
  4. *              -------------------
  5. *  begin        : Saturday, Feb 13, 2001
  6. *  copyright      : (C) 2001 The phpBB Group
  7. *  email        : support@phpbb.com
  8. *
  9. *  $Id: mysql.php,v 1.16 2002/03/19 01:07:36 psotfx Exp $
  10. *
  11. ***************************************************************************/
  13. /***************************************************************************
  14. *
  15. *  This program is free software; you can redistribute it and/or modify
  16. *  it under the terms of the GNU General Public License as published by
  17. *  the Free Software Foundation; either version 2 of the License, or
  18. *  (at your option) any later version.
  19. *
  20. ***************************************************************************/
  22. if(!defined("SQL_LAYER"))
  23. {
  25. define("SQL_LAYER","mysql");
  27. class sql_db
  28. {
  30.     var $db_connect_id;
  31.     var $query_result;
  32.     var $row = array();
  33.     var $rowset = array();
  34.     var $num_queries = 0;
  36.     //
  37.     // Constructor
  38.     //
  39.     function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
  40.     {
  42.         $this->persistency = $persistency;
  43.         $this->user = $sqluser;
  44.         $this->password = $sqlpassword;
  45.         $this->server = $sqlserver;
  46.         $this->dbname = $database;
  48.         if($this->persistency)
  49.         {
  50.             $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
  51.         }
  52.         else
  53.         {
  54.             $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
  55.         }
  56.         if($this->db_connect_id)
  57.         {
  58.             if($database != "")
  59.             {
  60.                 $this->dbname = $database;
  61.                 $dbselect = @mysql_select_db($this->dbname);
  62.                 if(!$dbselect)
  63.                 {
  64.                     @mysql_close($this->db_connect_id);
  65.                     $this->db_connect_id = $dbselect;
  66.                 }
  67.             }
  68.             return $this->db_connect_id;
  69.         }
  70.         else
  71.         {
  72.             return false;
  73.         }
  74.     }
  76.     //
  77.     // Other base methods
  78.     //
  79.     function sql_close()
  80.     {
  81.         if($this->db_connect_id)
  82.         {
  83.             if($this->query_result)
  84.             {
  85.                 @mysql_free_result($this->query_result);
  86.             }
  87.             $result = @mysql_close($this->db_connect_id);
  88.             return $result;
  89.         }
  90.         else
  91.         {
  92.             return false;
  93.         }
  94.     }
  96.     //
  97.     // Base query method
  98.     //
  99.     function sql_query($query = "", $transaction = FALSE)
  100.     {
  101.         // Remove any pre-existing queries
  102.         unset($this->query_result);
  103.         if($query != "")
  104.         {
  105.             $this->num_queries++;
  107.             $this->query_result = @mysql_query($query, $this->db_connect_id);
  108.         }
  109.         if($this->query_result)
  110.         {
  111.             unset($this->row[$this->query_result]);
  112.             unset($this->rowset[$this->query_result]);
  113.             return $this->query_result;
  114.         }
  115.         else
  116.         {
  117.             return ( $transaction == END_TRANSACTION ) ? true : false;
  118.         }
  119.     }
  121.     //
  122.     // Other query methods
  123.     //
  124.     function sql_numrows($query_id = 0)
  125.     {
  126.         if(!$query_id)
  127.         {
  128.             $query_id = $this->query_result;
  129.         }
  130.         if($query_id)
  131.         {
  132.             $result = @mysql_num_rows($query_id);
  133.             return $result;
  134.         }
  135.         else
  136.         {
  137.             return false;
  138.         }
  139.     }
  140.     function sql_affectedrows()
  141.     {
  142.         if($this->db_connect_id)
  143.         {
  144.             $result = @mysql_affected_rows($this->db_connect_id);
  145.             return $result;
  146.         }
  147.         else
  148.         {
  149.             return false;
  150.         }
  151.     }
  152.     function sql_numfields($query_id = 0)
  153.     {
  154.         if(!$query_id)
  155.         {
  156.             $query_id = $this->query_result;
  157.         }
  158.         if($query_id)
  159.         {
  160.             $result = @mysql_num_fields($query_id);
  161.             return $result;
  162.         }
  163.         else
  164.         {
  165.             return false;
  166.         }
  167.     }
  168.     function sql_fieldname($offset, $query_id = 0)
  169.     {
  170.         if(!$query_id)
  171.         {
  172.             $query_id = $this->query_result;
  173.         }
  174.         if($query_id)
  175.         {
  176.             $result = @mysql_field_name($query_id, $offset);
  177.             return $result;
  178.         }
  179.         else
  180.         {
  181.             return false;
  182.         }
  183.     }
  184.     function sql_fieldtype($offset, $query_id = 0)
  185.     {
  186.         if(!$query_id)
  187.         {
  188.             $query_id = $this->query_result;
  189.         }
  190.         if($query_id)
  191.         {
  192.             $result = @mysql_field_type($query_id, $offset);
  193.             return $result;
  194.         }
  195.         else
  196.         {
  197.             return false;
  198.         }
  199.     }
  200.     function sql_fetchrow($query_id = 0)
  201.     {
  202.         if(!$query_id)
  203.         {
  204.             $query_id = $this->query_result;
  205.         }
  206.         if($query_id)
  207.         {
  208.             $this->row[$query_id] = @mysql_fetch_array($query_id);
  209.             return $this->row[$query_id];
  210.         }
  211.         else
  212.         {
  213.             return false;
  214.         }
  215.     }
  216.     function sql_fetchrowset($query_id = 0)
  217.     {
  218.         if(!$query_id)
  219.         {
  220.             $query_id = $this->query_result;
  221.         }
  222.         if($query_id)
  223.         {
  224.             unset($this->rowset[$query_id]);
  225.             unset($this->row[$query_id]);
  226.             while($this->rowset[$query_id] = @mysql_fetch_array($query_id))
  227.             {
  228.                 $result[] = $this->rowset[$query_id];
  229.             }
  230.             return $result;
  231.         }
  232.         else
  233.         {
  234.             return false;
  235.         }
  236.     }
  237.     function sql_fetchfield($field, $rownum = -1, $query_id = 0)
  238.     {
  239.         if(!$query_id)
  240.         {
  241.             $query_id = $this->query_result;
  242.         }
  243.         if($query_id)
  244.         {
  245.             if($rownum > -1)
  246.             {
  247.                 $result = @mysql_result($query_id, $rownum, $field);
  248.             }
  249.             else
  250.             {
  251.                 if(empty($this->row[$query_id]) && empty($this->rowset[$query_id]))
  252.                 {
  253.                     if($this->sql_fetchrow())
  254.                     {
  255.                         $result = $this->row[$query_id][$field];
  256.                     }
  257.                 }
  258.                 else
  259.                 {
  260.                     if($this->rowset[$query_id])
  261.                     {
  262.                         $result = $this->rowset[$query_id][$field];
  263.                     }
  264.                     else if($this->row[$query_id])
  265.                     {
  266.                         $result = $this->row[$query_id][$field];
  267.                     }
  268.                 }
  269.             }
  270.             return $result;
  271.         }
  272.         else
  273.         {
  274.             return false;
  275.         }
  276.     }
  277.     function sql_rowseek($rownum, $query_id = 0){
  278.         if(!$query_id)
  279.         {
  280.             $query_id = $this->query_result;
  281.         }
  282.         if($query_id)
  283.         {
  284.             $result = @mysql_data_seek($query_id, $rownum);
  285.             return $result;
  286.         }
  287.         else
  288.         {
  289.             return false;
  290.         }
  291.     }
  292.     function sql_nextid(){
  293.         if($this->db_connect_id)
  294.         {
  295.             $result = @mysql_insert_id($this->db_connect_id);
  296.             return $result;
  297.         }
  298.         else
  299.         {
  300.             return false;
  301.         }
  302.     }
  303.     function sql_freeresult($query_id = 0){
  304.         if(!$query_id)
  305.         {
  306.             $query_id = $this->query_result;
  307.         }
  309.         if ( $query_id )
  310.         {
  311.             unset($this->row[$query_id]);
  312.             unset($this->rowset[$query_id]);
  314.             @mysql_free_result($query_id);
  316.             return true;
  317.         }
  318.         else
  319.         {
  320.             return false;
  321.         }
  322.     }
  323.     function sql_error($query_id = 0)
  324.     {
  325.         $result["message"] = @mysql_error($this->db_connect_id);
  326.         $result["code"] = @mysql_errno($this->db_connect_id);
  328.         return $result;
  329.     }
  331. } // class sql_db
  333. } // if ... define
  335. ?>
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 31st, 2003, 4:49 pm

I looked a little more at your original script and I really do not see why that one shouldn't work. I went and viewed a few other sample scripts and they look simliliar to yours. Here is one I looked at:

Code: [ Select ]
$mysql_link = mysql_connect("hostname", "username", "password");
$mysql_select_db("database", $mysql_link);
$query = "Update table set field2 = $name";
$result = mysql_query($query);
  1. $mysql_link = mysql_connect("hostname", "username", "password");
  2. $mysql_select_db("database", $mysql_link);
  3. $query = "Update table set field2 = $name";
  4. $result = mysql_query($query);


It looks almost idential to yours, but the query is made in its own variable. Also have you already created the tables in your MySQL database that you are trying to update?
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 31st, 2003, 4:54 pm

yes i have created the tables, otherwise there would be nothin to update, and yeah, that script does look identical to mine except variable names, i honestly dont know y this doesn't work
  • mykh
  • Novice
  • Novice
  • No Avatar
  • Joined: Oct 25, 2003
  • Posts: 16
  • Status: Offline

Post October 31st, 2003, 5:06 pm

i just tried this on a completely different mySQL database, on my website, hoping that this was just an error with the mysql on my comp, and once again, nothing happens, and no errors.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post October 31st, 2003, 6:58 pm

Have you tested to make sure data is stored in the $username and $id variables? In other words they are not blank correct? Also I know you said you had the MySQL table setup, but do you have an ID in that MySQL table that matches the ID that you are sending through the $id variable?

Also, what version of MySQL and PHP are you using?

Finally have you tried to run that MySQL query manually through MyPHPAdmin or some other interface if you have it, just to make sure it actually works on your database?

I am just shooting blanks in the dark here, since you really haven't provided me much to work with but your little snippet of code. Hopefully one of these blanks will hit something soon :)
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post October 31st, 2003, 6:58 pm

1, 2

Post Information

  • Total Posts in this topic: 27 posts
  • Users browsing this forum: ScottG and 243 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.