Posted by scout3014 on 07/25/07 03:36

Hi

I am using WAMP5 to create web applications. I have a problem as far
as accessing the database is concerned. This following code is used to
access database:

$con = mysql_connect("localhost", "root", "");
if (!con) {
die('Could not Connect' . mysql_error());
}
mysql_select_db("Leave", $con);
$data = mysql_query("SELECT * FROM loginInfo WHERE username=" .
$username);
if(!$data){
die('Invalid username: ' . mysql_error());
}
else{
....... //processing login
.......
}

When i activate this code by logging in, the following is shown:
"Invalid username: No database selected"

I would like to know if there is anything wrong with my database
connection for my database is correct. My database name on e
SQLiteManager is 'Leave' and my table is "loginInfo"

Help is much appreciated

Regards
Eugene

• Next in forum: Re: accessing database in wamp environment
• Prev in forum: Re: when will php support alias name?
• Thread view: accessing database in wamp environment

[Reply to this message]