mysql_db_query or mysql_query ... ???

[damianfossi]

what should i do on this case

i have a database with the ccbill of the members and i want to put on the link of a banner and i'm using on the code :

mysql_connect($server, $db_user, $db_pass) or die ("Database CONNECT Error (line XX)");
$ccbill = mysql_db_query($database, "SELECT ccbill FROM affiliates WHERE refid = '$ref'");

is correct that i use mysql_db_query, or mysql_query ???

[spags]

Well if you want to use mysql_query, you must do this (in this order)

mysql_connect( etc );
mysql_select_db("name of database");
mysql_query(sql statement);

otherwise, mysql_db_query takes the database as the first parameter
mysql_db_query("name of database", "sql statement");

See? the second method is depreciated, so it would be better to use the first 🙂