accessing database in wamp environment

[scout3014]

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

[Jerry Stuckle]

sc*******@gmail.com wrote:

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

What's the result of your mysql_select_db call? It returns true/false
depending on whether the request worked/failed. If you get false back,
what's the error?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Rik]

On Wed, 25 Jul 2007 05:36:00 +0200, <sc*******@gmail.comwrote:

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"

0. Echo errors on select_db: mysql_select_db("Leave", $con) or
die(mysql_error());
1. Does the database exist in MySQL? (if not: mysql_query('CREATE DATABASE
Leave');)
2. MySQL can be set to disallow capitals in database/tablenames, check the
config and/or a more appropriate group like comp.databases.mysql if you
have trouble with it ...

--
Rik Wasmus

[scout3014]

On Jul 25, 11:45 am, Jerry Stuckle <[e-mail]:

[e-mail] wrote:

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

What's the result of your mysql_select_db call? It returns true/false
depending on whether the request worked/failed. If you get false back,
what's the error?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================- Hide quoted text -

- Show quoted text -

if (!mysql_select_db("leave", $con)){
die (mysql_error());
}

using the following code, the error message is as shown:
Unknown database 'leave'

Like i was saying my database name was "Leave" with capital L so i do
not know why they put in in small case

[Jerry Stuckle]

sc*******@gmail.com wrote:

On Jul 25, 11:45 am, Jerry Stuckle <[e-mail]:

>[e-mail] wrote:

>>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

What's the result of your mysql_select_db call? It returns true/false
depending on whether the request worked/failed. If you get false back,
what's the error?

- Show quoted text -

if (!mysql_select_db("leave", $con)){
die (mysql_error());
}

using the following code, the error message is as shown:
Unknown database 'leave'

Like i was saying my database name was "Leave" with capital L so i do
not know why they put in in small case

Well, I'm not sure who "they" is - but looks like you need to change the
mysql_select_db call.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================