mysql with php on windows server

aevans4e

hey all... ive got windows 2000 pro and mysql from the mysql.com site not ms sql... and php.. using iis as the webserver ( the server that came with win2kpro )
and im trying to connect to a db... i can do a mysql -u root -p in dos window it works just fine.. but when i try $db = mysql_connect("host","user","password")
it gives me some error about not being able to connect

can anyone help

thanks

nnichols

Please post the error that you are getting.

hkucsis

There is only 1 user (root) after setting up MySQL, you may forget to create other users....

aevans4e

here is the code im using to connect

$db = mysql_connect("host","user","password") or die("Mysql error: ") .mysql_error;
mysql_select_db("learn", $db);

$query = "select * from learn order by uid";

$result = mysql_query($query);

$num_results = mysql_num_rows($result);

and here is the error

Parse error: parse error, unexpected T_VARIABLE in c:\inetpub\wwwroot\email.php on line 6

any ideas?

xblue

your syntax is wrong. should be:

$db = mysql_connect("host","user","password") or die("Mysql error: ".mysql_error());

aevans4e

ok i changed that line to
$db = mysql_connect("localhost","root","password") or die("Mysql error: " .mysql_error());

still

Parse error: parse error, unexpected T_VARIABLE in c:\inetpub\wwwroot\email.php on line 6

ddc

There are some excellent Apache/php/mySQL installation packages available for download from www.firepages.com.au
These install complete packages on various Windows operating systems quickly using standard parameters.
I use these over a Win 2000 op system without having to setup Windows as a server.

tsinka

Hi,

can you post the complete code from <?PHP to ?> ? If there is some code before the mysql_connect line you might have forgotten to close a string or to put a ; at the end of a previous line.

BeastRider

Originally posted by xblue
No keyboard found. Press F1 to continue...

Now... THAT IS FUNNY!!! 😃