List:General Discussion« Previous MessageNext Message »
From:Beauford Date:January 14 2003 8:20pm
Subject:Linux Mysql vs Windows Mysql
View as plain text  
Hi,

I just installed MySQL and PHP on Windows XP and have a question. I created
a test database on Windows (exactly the same as the test one I use in Linux)
and copied a test PHP script which accesses Mysql and displays some
information. On Linux it works perfectly, but on Windows I get the following
error. Are there different commands or syntax on the two different
platforms?

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in e:\directory\index.php on line 21.

This is the exact code below:

<?
PRINT "<HTML>";
PRINT "<HEAD>";
PRINT "<TITLE>ADDRESSES</title>";

PRINT "</HEAD>";

PRINT "<BODY BGCOLOR=white TEXT=#000000 LINK=#FF0000 VLINK=#000066
aLINK=#FF0000>";

$out[]=0;   // I also got an error about this - without it here I get an
undefined variable error below....

    mysql_connect("localhost:3308", "user", "password") or
        die("could not connect");
    mysql_select_db("address");

    $query = "SELECT * FROM data";
    $result = mysql_query ($query);

     while ($line = mysql_fetch_row($result)) {

        $out[]=$i;

}

?>

<form action="<? echo $PHP_SELF; ?>" method="post">

<P><TABLE WIDTH="400" BORDER="0">


<TR><TD ALIGN="left">Name :</TD><TD ALIGN="left"><INPUT
TYPE="text"
NAME="lastname" SIZE="20" VALUE="<? echo
$out[0][1]?>"></TD></TR>
<TR><TD ALIGN="left">Name :</TD><TD ALIGN="left"><INPUT
TYPE="text"
NAME="lastname" SIZE="20" VALUE="<? echo
$out[0][2]?>"></TD></TR>
<TR><TD ALIGN="left">City:</TD><TD ALIGN="left"><INPUT
TYPE="text"
NAME="city" SIZE="20" VALUE="<? echo
$out[0][3] ?>"></TD></TR>

</TABLE>

</FORM>



Thread
Linux Mysql vs Windows MysqlBeauford14 Jan
  • Re: Linux Mysql vs Windows MysqlJeremy Zawodny15 Jan
    • Re: Linux Mysql vs Windows MysqlMichael T. Babcock15 Jan