MySQL Error Help!

[Anon]

what should it do to fix this, i can seem to figure it out at all.

Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query() instead in C:\Program Files\Apache Group\Apache2\htdocs\dbtest\dbtest5.php on line 10

[mithril]

First off, this isn't an error, but a warning. Solution? It's really quite simple, do what the warning suggests🙂

The mysql_db_query() function is deprecated and will be removed from PHP at some point in the future. Use the mysql_select_db() and mysql_query() functions. Do:

  mysql_select_db("my_db");
  mysql_query("SELECT * FROM my_table");

instead of:

  mysql_db_query("my_db", "SELECT * FROM my_table");

-geoff

[Anon]

ahh i see, but that way i have my code formated to work is like this

$query = "select * from test_exp";
$result = mysql_db_query ("test_database", $query);

how would that work?

[mithril]

$conn = mysql_connect("host", "username", "password");
mysql_select_db("test_database");

$query = "select * from test_exp";
$result = mysql_query($query);

// do something with results

mysql_close($conn);

-geoff