Database select problem

[mr_badger]

I'am getting this error on one of my pages "Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in".

this is the code

<?php require_once('../Connections/conn.php'); ?>
<?php
mysql_select_db($database_web78-salon, $web78-salon);
$query_rsTimes = "SELECT DISTINCT availDate FROM savailability ORDER BY availDate ASC";
$rsTimes = mysql_query($query_rsTimes, $web78-salon) or die(mysql_error());
$row_rsTimes = mysql_fetch_assoc($rsTimes);
$totalRows_rsTimes = mysql_num_rows($rsTimes);
?>

[AndyB]

Probably because $web78-salon is being interpreted as $web78 minus salon; same thing with the database name.

[mr_badger]

that makes sense, but I can't change the name, it has to have that minus.

[AndyB]

Really? Try a variant:

 

$db_name = 'database_web78-salon';
$db_user = 'web78-salon';
mysql_select_db($db_name,$db_user);

[mr_badger]

I have tried what you suggested and the errors have gone, but it says no database selected, I can't work out why it's saying this.

<?php
$db_name = web78-salon;
$db_user = web78-salon;
mysql_select_db("localhost,web78-salon,darwen");
$query_rsTimes = "SELECT DISTINCT availDate FROM savailability ORDER BY availDate ASC";
$rsTimes = mysql_query($query_rsTimes, $conn) or die(mysql_error());
$row_rsTimes = mysql_fetch_assoc($rsTimes);
$totalRows_rsTimes = mysql_num_rows($rsTimes);
?>

[AndyB]

Take a much closer look at my suggestion.  The variables I defined are strings, hence their definition within quotes.  The db_select query uses variables, not something enclosed in quotes as a single variable.

 

I'm skeptical that your database name and username are identical, but you should know what's what.

 

I'd suggest you move the definitions of host, database name, database user, database password, etc. into an included file (like connections.php perhaps) and make sure you define them as strings, and then in your script always refer to those defined variable names.

[mr_badger]

I think the problem is that my copy of dreamweaver is a copy downloaded from the internet, everything connects it just doesnt show my tables. Appartly this can be cause by not having the retail version of dreamweaver.