#1
  1. No Profile Picture
    baerinfodat
    Guest
    Devshed Newbie (0 - 499 posts)
    Hello to all specialists

    I have a Problem with together MySQL, PHP3 and Apache-Server on Windows95.

    I run Apache-Server as Webserver , also on this machine runbs MySQLWIN32.

    Ihave written a simple PHP3 code as follows:


    <html>
    <Title>Datenbanktest</title>
    <head>
    <a>Datenbank wird erzeugt...</a><br>
    </head>

    <body>

    <!--Datenbank erstellen-->
    <?
    mysql_connect("localhost", "username") ;
    @mysql_select_db("databasename");

    $create = "CREATE TABLE test
    (
    Name CHAR(50),
    )";

    MYSQL_QUERY($create);


    mysql_close();
    ?>

    <a>Fertig.</a>
    </body>

    </html>

    if let it run I get an errormessage as follows:

    Warning: MySQL Connection Failed: Can't create IP socket (10036) in D:ProgrammeApache_GroupApachehtdocs/create_table_katalog.php3 on line 11

    Warning: MySQL Connection Failed: Can't create IP socket (10036) in D:ProgrammeApache_GroupApachehtdocs/create_table_katalog.php3 on line 28

    Warning: -1 is not a MySQL link index in D:ProgrammeApache_GroupApachehtdocs/create_table_katalog.php3 on line 28

    Warning: -1 is not a MySQL link index in D:ProgrammeApache_GroupApachehtdocs/create_table_katalog.php3 on line 31

    I need help because iÓm really no know whats gonna happen here.

    Thanks in advanced

    Oliver

    Thanks for your information but I have started MYSQL wi┤th the command mysqld
    already and the same problem appears.


    [This message has been edited by baerinfodat (edited 07-08-99).]
  2. #2
  3. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    It appears you haven't started mysql.

    Run mysqld from the command line.
  4. #3
  5. No Profile Picture
    baerinfodat
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks for your information but I have started MYSQL wi┤th the command mysqld
    already and the same problem appears.

    Do you have another idea
  6. #4
  7. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    First, I'd suggest that you access the return values for the functions you are calling. i.e.:
    $linkid=mysql_connect("localhost","username");

    Then, I'd verify the connection:

    if (!$linkid){
    print mysql_error();
    exit;
    }

    That might give you some more information.

    Also, have you tried logging into mysql directly from a DOS shell? Actually, I'd do THAT first.

    BTW, I'm not sure why you are getting the warning about "-1 is not a mysql link index".

    According to the docs you should never get a negative number on a connection attempt. 0 for failure or the link id which is a positive integer.

    Curious....

    Rod
  8. #5
  9. No Profile Picture
    Tony Peters
    Guest
    Devshed Newbie (0 - 499 posts)
    Try updating to Winsock 2.
    I had this problem, and that cured it.

    The original version of Winsock with came with Win95 was buggy

Similar Threads

  1. Warning: mysql_fetch_row(): ??
    By commodus in forum PHP Development
    Replies: 31
    Last Post: November 16th, 2005, 05:52 PM
  2. Custom error message for MySQL connection
    By dbr1066 in forum PHP Development
    Replies: 6
    Last Post: February 12th, 2004, 12:25 PM
  3. Replies: 1
    Last Post: February 5th, 2004, 12:50 AM
  4. MYSQL connection to JSP (not again!! :) )
    By JSP_Neubee in forum Java Help
    Replies: 1
    Last Post: January 20th, 2004, 09:34 AM
  5. Replies: 0
    Last Post: January 16th, 2004, 01:33 PM

IMN logo majestic logo threadwatch logo seochat tools logo