[SOLVED] mysql_query or "..."

[nathanmaxsonadil]

I was wondering why people go like this

$somevar = "mysql query";

$somevar2 = mysql_query($somevar);

instead of just going

$somevar = mysql_query("mysql query"); ?

[pocobueno1388]

I would say mostly for error handling. If you store the query as a string you can easily echo it out and see if theres a problem.

 

Also, it makes it easy to add to the query. If you just put it into the mysql_query(), you can't really do anything with it, it's stuck the way it is.

 

There may be other reasons that other people do it for, but those ones seem the most obvious to me.

[nathanmaxsonadil]

k thanks

[Wuhtzu]

Because they think it's easier / more readable to have the actual mysql query standing by it self instead of inside the mysql_query() function?

 

I personally do:

 

$get_or_insert_something = mysql_query("some query")

 

At least when I'm not using a framework or just creating some small script.

[Wuhtzu]

The reason pocobueno1388 list are pretty good too