PHP Help, Just Some Small Stuff.

[JoshuaLuke]

Hey,

I'm testing my PHP skills with some MySQL stuff. I have a variable which is:

$mysql_error_handler = '<center><font face="Arial">MySQL Error:' . mysql_error();

Then I have a little or die script on my mysql_connect:

or die ($mysql_error_handler);

BUT. When I input something wrong, the output to the page is only: MySQL Error: When it should show something like MySQL Error: ERROR HERE FROM mysql_error();, but it doesn't, so why not?

 

[Adil]

$mysql_error_handler = "<center><font face='Arial'>MySQL Error:" . mysql_error();

That may work, not too sure though. Also, where are you declaring this variable?

 

[JoshuaLuke]

$mysql_error_handler = "<center><font face='Arial'>MySQL Error:" . mysql_error();

That may work, not too sure though. Also, where are you declaring this variable?

Still doesn't work, what do you mean 'declaring'? It's to use multiple times for MySQL connections, i've done all my requiring etc. This is the only thing that i'm confused with

 

[Adil]

Still doesn't work, what do you mean 'declaring'? It's to use multiple times for MySQL connections, i've done all my requiring etc. This is the only thing that i'm confused with

E.g where are you instantiating the variable?
What file are you declaring it in?

 

[JoshuaLuke]

E.g where are you instantiating the variable?
What file are you declaring it in?

Oh, the same one as the mysql_connect (global.php).

 

[Variable]

I agree with Adil. Also are you using a specific source or so?

 

[Frenchies]

Try just doing die(mysql_error());
If that works, maybe just create a function.

final public function myError($thingy) {
        // $thingy = the variable you set to connect to the database.
       return die("MySQL Error: " . mysql_error($thingy) . "has occurred.");
}

I just coded that on my phone, so I am not sure if it will work.

 

[Livar]

I believe you're using uberCMS to develop on (habbo related)?

 

[JoshuaLuke]

Fixed, please close thread