[RESOLVED] Help with phpo/mysql error

syren

I'm a little confused on what this error message means. Is my user name and password incorrect or the path to the database incorrect or what?

Error is
Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /home/syren/public_html/createtable.php on line 16
The query could not be executed
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/syren/public_html/createtable.php on line 21

I have been trying to play with user names and passwords but i used the one that i created in MYSQL editor. I have tried syren and syren_syren and syren_helpdesk and all sort of combinations. What should the format be and is this the problem?

Code is

<HTML>
<HEAD>
<TITLE></Title>
<body>
<?PHP

$Host="localhost";
$User="syren_syren";
$Password="*****";
$DBName="syren_helpdesk";
$TableName="Downtime";

$link = mysql_connect ($host, $User, $Password);
$Query ="CREATE table $TableName (id INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, Ticket varchar(6), System VarChar(20), Verbiage VarChar(85), Analyst VarChar(20), Worker VarChar(20))";

if (mysql_db_query ($DBName, $Query, $Link)) {
print ("The query was executed");
} else {
print ("The query could not be executed");
}
mysql_close ($Link);
?>

</body>
</html>

devinemke

use [man]mysql_error[/man] to debug your database connection routine

syren

how? The page is kind of confusing. Do I paste my code into some spot?

devinemke

change these lines:

$link = mysql_connect ($host, $User, $Password);

if (mysql_db_query($DBName, $Query, $Link)) {
print ("The query was executed");
} else {
print ("The query could not be executed");
}

to these:

$link = mysql_connect ($host, $User, $Password) or exit(mysql_error());

if (mysql_db_query($DBName, $Query, $Link)) {
print ("The query was executed");
} else {
print ("The query could not be executed"); exit(mysql_error());
}

syren

Devin, thanks for your help. I am still getting an error though

Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /home/syren/public_html/createtable.php on line 16
The query could not be executed

devinemke

what does [man]mysql_error[/man] have to say about your call to [man]mysql_connect[/man]?

syren

I dont know how to check... can you show me?

devinemke

as i already said before. replace this:

$link = mysql_connect($host, $User, $Password);

with this:

$link = mysql_connect($host, $User, $Password) or exit(mysql_error());

syren

Ooo I see, sorry. I replaced the code and i pasted what it said.

Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /home/syren/public_html/createtable.php on line 16
The query could not be executed

devinemke

let's backup here. strip out everything and just run this:

<?php
$link = mysql_connect('localhost', 'syren_syren', 'password') or exit(mysql_error());
var_dump($link);
?>

obviously replace password with your actual database password

syren

OK, making head way. I figured out the password and user name to user now. I get this echo. does it make sense?

resource(1) of type (mysql link)

syren

Back to this error.

Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /home/syren/public_html/createtable.php on line 27
The query could not be executed

<?PHP

$Host="localhost";
$User="syren_syren";
$Password="*****";
$DBName="helpdesk";
$TableName="Downtime";

$link = mysql_connect ($host, $User, $Password) or exit(mysql_error());
$Query ="CREATE table $TableName (id INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, Ticket varchar(6), System VarChar(20), Verbiage VarChar(85), Analyst VarChar(20), Worker VarChar(20))";

if (mysql_db_query($DBName, $Query, $Link)) {
print ("The query was executed");
} else {
print ("The query could not be executed"); exit(mysql_error());
}
?>

devinemke

<?php
mysql_connect('localhost', 'syren_syren', '*****') or exit(mysql_error());
mysql_select_db('helpdesk') or exit(mysql_error());

$result = mysql_query('CREATE table Downtime (id INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, Ticket varchar(6), System VarChar(20), Verbiage VarChar(85), Analyst VarChar(20), Worker VarChar(20))') or exit(mysql_error());
if ($result) {echo 'The query was executed';} else {echo 'The query could not be executed';}
?>

syren

It worked. Query was executed. Thank you so much for your time.