When attempting to store data in a MySQL database, it refuses to find
the database, thought I'm sure it is typed correctly (I am
copy/pasting it from phpMyAdmin). Here is the coding in question:

<?php
$username="username"; // Not actual username
$password="password"; // Not actual password
$database="brettuz_sdm"; // Copy and pasted from phpMyAdmin

$Time=$_POST['Time'];
*/ Submitted from a form, there are many variables, all in the same
fashion as this */

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO sdms VALUES ('','$Time')";

mysql_query($query1);
mysql_close();
?>

When submitting the form, I get a blank white page with "Unable to
select database" (just as specified in coding)

All my server host could tell me was "Check the database connection in
the page that the form submits to".... DUH =/

What is the problem here?

---

Clarification of Question by brettuzzi-ga on 09 Dec 2004 14:17 PST

the variable $query is $query1, typo. that's not the problem.

Try removing the @ from your select_db call. That supresses the real error message.

I think you'll need to quote the "localhost" reference in the
mysql_connect() function.

Also, you can use the function mysql_error() in your 'or die' messages
- this should give you a nice error. So try something like:


mysql_connect("localhost",$username,$password) or die("Could not
connect - ".mysql_error() );

@mysql_select_db($database) or die( "Unable to select database - ".mysql_error() );


Hope it helps,

Paul