2 replies to this topic

[robertpeter07]

hi guys! I want to ask why do you have to use a variable to query from mysql?
what makes this difference from the above example?

<?php
$query = "SELECT * FROM Person";
mysql_query($query);
?>

querying using mysql_query function:

<?php
mysql_query("SELECT * FROM Person");
?>

could someone explain me the difference and why use the first sample instead of second sample or vice versa?

Peter

[Vaielab]

Both do exactly the same thing.

If you have a large script, and your code is not clean, in the first example, you may overwrite the variable $query.

But having your sql code separated is easier to read.

So both are good.

Some fan of micro-optimization will tell you that the second way is faster since you don't have to store the string inside a variable... but that is not what will really slow your code.

[Orjan]

Using the first method eases debugging, as you can print the $query variable so you can see if your query is right even after eventually inserted variables in the query. Otherwise, no difference. more of a personal preference.