mysql_select_db problem

shinzon

Hi, I am very new (like a day old new) so please don't shout at for asking a stupid question or missing out a comma or a letter etc. (I am still getting to grips with it), when I try to tell PHP what database to use I get this error:

Parse error: parse error, unexpected T_VARIABLE in C:\FoxServ\www\phptesting\scripts\mysql_connect.php on line 7

this is the PHP:

<?php
//make a connection to the MySQL
$host = "localhost";
$user = "uname";
$pass = "password";
$connection = mysql_connect($host,$user,$pass) or die ("invalid connection");
$db = mysql_select_db("mydb",$connection) or die ("I could not connect to the database");
?>

thanks for any help you can give me it will greatly decrease my coffee intake!

Shinzon

nielsplus

I am newbie 2, so this is my first advise.
Maybe this will help, i always do it like this

/Connection database/

$conn = mysql_connect("localhost", "mysql_username", "Mysql_password")
or die("could not make connection.");

/ Select Database /

$selected = mysql_select_db("databasename", $conn)
or die("Error, no database found.");

hope this helps
niels

shinzon

excelent it worked thanks a lot, oh and my coffe intake has dropped from 3 cups an hour to 2 cups😃

thanks again

Shinzon

Mortimer_Jazz

Hello.
I'd be grateful if someone could point out the error with the first example.
I can't spot why one works, and the other doesn't :rolleyes:

shinzon

I had put them all on variables but the second one was all on the same line I think that was the problem...

Mortimer_Jazz

Okay thanks shinzon.
It's just that I can't see why assigning your values to variables should cause a problem. I had a look in the dictionary to see what a t_variable is, but it doesn't tell me much and I just can't see what's wrong with line 7.

Cheers anyway.

Mortimer_Jazz

Hi shinzon. This code has been bugging me, as I couldn't spot the error and nor could I replicate it.

I had an interesting conversation on MSN with a friend of mine (who's a php contractor). I've copied and pasted it below:

You may want to update your version of php if you keep encountering odd errors like this in the future.

Mortimer Jazz: I can't see where the error is though?
Justin: There is no error.
Mortimer Jazz: ah
Justin: It must be that particular version of php that is parsing incorrectly.
Mortimer Jazz: that's why I can't see it!
Justin: Yes.

Justin: I ran the exact same code on my php build and no error at all.

Hope this helps!
Mort