Professional Web Applications Themes

syntax error ??? - PHP Development

Hi, on login.php , we can see that : (...) $sql = "SELECT Login FROM logins WHERE Login='$fusername'"; $result = mysql_query($sql) or die("Couldn't execute query1."); (...) field : login from table: logins fusername is a valid form field. I just can't understand why I get the message Couldn't execute query1. I don't see any syntax error. :-( Thank you in advance Ben...

  1. #1

    Default syntax error ???

    Hi, on login.php , we can see that :

    (...)

    $sql = "SELECT Login FROM logins
    WHERE Login='$fusername'";
    $result = mysql_query($sql)
    or die("Couldn't execute query1.");

    (...)

    field : login from table: logins

    fusername is a valid form field.

    I just can't understand why I get the message Couldn't execute query1.
    I don't see any syntax error. :-(

    Thank you in advance


    Ben
    Ben Guest

  2. #2

    Default Re: syntax error ???

    On 30 Sep 2003 15:25:14 -0700, [email]microbenhotmail.com[/email] (Ben) wrote:
    >Hi, on login.php , we can see that :
    >
    >(...)
    >
    >$sql = "SELECT Login FROM logins
    > WHERE Login='$fusername'";
    > $result = mysql_query($sql)
    > or die("Couldn't execute query1.");
    >
    >(...)
    >
    >field : login from table: logins
    >
    >fusername is a valid form field.
    >
    >I just can't understand why I get the message Couldn't execute query1.
    >I don't see any syntax error. :-(
    Ask the database for more information; it knows more about the situation:

    $result = mysql_query($sql)
    or die("Couldn't execute query1 because: " . mysql_error());

    Post that error back here if it doesn't make the problem immediately clear.

    --
    Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
    Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])
    Andy Hassall Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Syntax error
    By middletree in forum Macromedia ColdFusion
    Replies: 11
    Last Post: May 2nd, 03:10 AM
  3. Syntax error?
    By Joneleth in forum MySQL
    Replies: 2
    Last Post: February 15th, 04:46 PM
  4. error : syntax error at or near $1 for over select rows
    By vinita bansal in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: December 27th, 06:51 PM
  5. SQL Syntax Error
    By Frank Py in forum ASP Database
    Replies: 2
    Last Post: July 11th, 07:38 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139