Jump to content

mikosiko

Members
  • Content Count

    1,327
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by mikosiko

  1. mikosiko

    Welcome Back!

    Finally!!... good to have it back
  2. Read carefully what you wrote (in red) and compare it with what you are doing in your select... you should be able to figure it out
  3. mikosiko

    SELECT Help

    In that code you have 2 issues: 1.- You can not mix mysql_ and mysqli_ APIs 2.- mysqli_query() (and in general all the "mysqli_" procedural methods/functions) need to have the database link as a parameter.... read http://php.net/manual/en/mysqli.query.php here are some usage's examples http://php.net/manual/en/mysqli-result.fetch-array.php
  4. food for the thought: (meaning for you to read and investigate the causes of the error and do not create a worst bandaid) http://dev.mysql.com/doc/refman/5.6/en/gone-away.html http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_wait_timeout http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_allowed_packet and a question: What type/size are your columns called SName (in both tables)?
  5. In case you are willing to explore the alternative Mysql also provide the FEDERATE storage engine to solve your scenario https://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html
  6. In your code you are using the variable $conn as your database connection for both your SELECT and for the INSERT. as mac_gyver mentioned before you should be using 2 different variable names for your database connections and use them in the right place
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.