php script to extract thread titles

[Judge Dredd X]

I just wanted to let you know that this part:

PHP Code:

$connect=mysql_connect('localhost', 'root', 'glide75') or die(mysql_error());
echo "Connected to MySQL<br />"; 


Would output "Connected to MySQL" in addition to the mysql error if there is one.

So basically, if the connection fails, it will display the error and Connected to MySQL.

I am not very good at PHP, but I believe you could write an if statement for this.

PHP Code:

if ($connect) {
echo "Connected to MySQL<br />";
}
else {
die();
} 


[kh99]

Originally Posted by Microsuck

I just wanted to let you know that this part:

PHP Code:

$connect=mysql_connect('localhost', 'root', 'glide75') or die(mysql_error());
echo "Connected to MySQL<br />"; 


Would output "Connected to MySQL" in addition to the mysql error if there is one.

That's a good thought, but in the case of a connection error the echo line wouldn't execute because die() ends the script.

[Judge Dredd X]

Originally Posted by kh99

That's a good thought, but in the case of a connection error the echo line wouldn't execute because die() ends the script.

Ah!

So maybe instead of

PHP Code:

die(mysql_error()) 


He could use

PHP Code:

or echo("mysql_error()") 


?

Please don't bash me if the above doesn't work, I'm not experienced and I'm also not sure if "or" works with echo.

[kkinsey]

not sure if "or" works with echo

It doesn't.

However, you can concatenate strings, vars, and function calls inside the die() statement:

PHP Code:

//let's be verbose...
die("Connected to SQL, but this program sucks because ".$somereasonhere." and MySQL said: ".mysql_error()); 


HTH,