simple connection problem

sri2002

I am trying to connect to mysql db from my php page. I am getting the error: supplied argument is not a valid MySql result resource as in www.enddebtmisery.com/sri/mirstest.php. I tried executing the command in the server and the query retreives record. Help pls.
My connection string is
$db = mysql_connect("localhost", endebtm_username","");
Mysql_select db("dbname,$db);
Help plz..
Thanks
Sri

goldenei

Mysql_select db("dbname,$db); <--check this line...
do u know whats the name of the database?

sri2002

Thanks for your reply. The db name and username are correct. I have checked it.
This is my code:
<html>
<body>
<?php
$db = mysql_connect("localhost", "endebtm_username", "");
mysql_select_db("endebtm_dbname",$db);
$result = mysql_query("SELECT * FROM mirs_test",$db);
printf("fname: %s<br>\n", mysql_result($result,0,"fname"));
printf("lname: %s<br>\n", mysql_result($result,0,"lname"));
printf("age: %s<br>\n", mysql_result($result,0,"age"));
?>
</body>
</html>
Thanks
Sri

sri2002

Still erroring out...Any clues?
Thanks
Sri

sri2002

Got it...I did not add the user to the DB...URRGHHH!!!
Thanks
Sri

virva

I use a code like this:

<?php

// in config.php I define the host, user, pw and database
include_once("config.php");

mysql_connect($db_host,$db_user,$db_passwd);
mysql_select_db($db_database);

function db_execute ($query) {
$result = mysql_query($query);
//this is not necessary
if(mysql_errno()!=0) die(mysql_error());
return $result;
}

Hope this helps.

sri2002

Thanks virva. Your code looks neat.
Thanks much
Sri

Stinger51

I didn't understand this code that you posted:

<?php

// in config.php I define the host, user, pw and database
include_once("config.php");

mysql_connect($db_host,$db_user,$db_passwd);
mysql_select_db($db_database);

function db_execute ($query) {
$result = mysql_query($query);
//this is not necessary
if(mysql_errno()!=0) die(mysql_error());
return $result;
}

The reason I ask is, I always use code like this :

$db_name = "testdb";
$conn = mysql_connect("localhost", $user, $pword) or die ("Couldn't connect.");
$db = mysql_select_db($db_name, $conn) or die ("Couldn't select local database -- $db_name");

So where is your "connection" parameter in your code when you do the select? How can that work without one?

Just curious.