Posted by Jerry Stuckle on 07/25/07 03:45

scout3014@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.
jstucklex@attglobal.net
==================

[Back to original message]