Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8

Thread: gonna cry...

  1. #1
    Senior Coder
    Join Date
    Aug 2009
    Location
    Mansfield, Nottinghamshire, UK
    Posts
    1,555
    Thanks
    57
    Thanked 148 Times in 147 Posts

    gonna cry...

    Cant believe i've godda ask this but can someone see something my tiered eyes can't.

    PHP Code:
    $linkFromRoot mysql_real_escape_string($linkFromRoot);
    mysql_query("INSERT INTO `pageUpdates` ('table_name') VALUES ('$linkFromRoot')") or die(mysql_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 ''table_name') VALUES ('public_html/about-us-the-mobile-makeover.php')' at line 1

    no matter seen it as i posted it
    Last edited by Phil Jackson; 10-19-2009 at 08:33 PM.
    Website Design Mansfield
    PHP Code:
    function I_LOVE(){function b(&$b='P'){$b.='P';}function a($_){return $_++;}$b='P';define("B",'H');b($b=implode('',array($b=a($b),$b=a(B))));b($b);return $b;}
    echo 
    I_LOVE(); 

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,500
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    Just a stab without testing ...

    Did you try this:
    PHP Code:
    $linkFromRoot mysql_real_escape_string($linkFromRoot);
    mysql_query("INSERT INTO pageUpdates (table_name) VALUES ('$linkFromRoot')") or die(mysql_error()); 

  • #3
    met
    met is offline
    Regular Coder
    Join Date
    Oct 2009
    Location
    United Kingdom
    Posts
    728
    Thanks
    4
    Thanked 119 Times in 119 Posts
    PHP Code:
    $linkFromRoot mysql_real_escape_string($linkFromRoot);
    $query mysql_query("INSERT INTO `pageUpdates` VALUES ('$linkFromRoot')") or die(mysql_error()); 

  • #4
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,500
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    I also questioned if this (table_name) was part of an example that got copy/pasted,
    and maybe should not be there. Not sure if he changed that name for the post or not.
    Sometimes people change table names when they post on here, thinking we'll hack it or something.

  • #5
    Senior Coder
    Join Date
    Aug 2009
    Location
    Mansfield, Nottinghamshire, UK
    Posts
    1,555
    Thanks
    57
    Thanked 148 Times in 147 Posts
    Quote Originally Posted by Phil Jackson View Post
    no matter seen it as i posted it
    yup that is correct
    Website Design Mansfield
    PHP Code:
    function I_LOVE(){function b(&$b='P'){$b.='P';}function a($_){return $_++;}$b='P';define("B",'H');b($b=implode('',array($b=a($b),$b=a(B))));b($b);return $b;}
    echo 
    I_LOVE(); 

  • #6
    Senior Coder
    Join Date
    Aug 2009
    Location
    Mansfield, Nottinghamshire, UK
    Posts
    1,555
    Thanks
    57
    Thanked 148 Times in 147 Posts
    hehe no table_name is an actual row, a hash made up of numerous elements.
    Website Design Mansfield
    PHP Code:
    function I_LOVE(){function b(&$b='P'){$b.='P';}function a($_){return $_++;}$b='P';define("B",'H');b($b=implode('',array($b=a($b),$b=a(B))));b($b);return $b;}
    echo 
    I_LOVE(); 

  • #7
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    please mark this thread as resolved then so it shows in the index that is is finished with and then we don't need to click on it for no reason.

    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • #8
    Senior Coder
    Join Date
    Aug 2009
    Location
    Mansfield, Nottinghamshire, UK
    Posts
    1,555
    Thanks
    57
    Thanked 148 Times in 147 Posts
    :-( sorry
    Website Design Mansfield
    PHP Code:
    function I_LOVE(){function b(&$b='P'){$b.='P';}function a($_){return $_++;}$b='P';define("B",'H');b($b=implode('',array($b=a($b),$b=a(B))));b($b);return $b;}
    echo 
    I_LOVE(); 


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •