Is unset() the way?

[Aureole]

Say I have 3 queries on a page, I'll do things like...

 

<?php
$queryA = "";
$resultA = mysql_query( $queryA );

$queryB = "";
$resultB = mysql_query( $queryB );

$queryC = "";
$resultC = mysql_query( $queryC );
?>

 

Now I used to just use $query, $result etc. for all my queries but that caused problems with queries sometimes, but it gets annoying having to number/letter things.

 

As far as I'm aware, if I do something like this:

 

<?php
$var = "123";
$var = "abc";
echo( $var );
?>

 

The output will be "abc" as the second will overwrite the first, but when querying this doesn't seem to be the case sometimes... I had some really annoying problems and it took me ages to realize that it's because I kept using $query etc. over and over.

 

Like I said, it's growing tiresome naming/numbering each query so if I started doing something like this:

 

<?php
$query = "";
$result = mysql_query( $query );
unset( $query); unset( $result );

$query = "";
$result = mysql_query( $query );
unset( $query); unset( $result );

$query = "";
$result = mysql_query( $query );
unset( $query); unset( $result );
?>

 

Would that stop the problems I was experiencing?

[darkfreaks]

jusr do mysql_close  after eac query

[marcus]

You tell me

 

<?php

$var = "pie";

echo "Set: " . $var . "<br>\n";;

unset($var);

echo "Unset: " .$var;

?>

 

Set: pie
Unset: 

[Aureole]

Will mysql_close() do the trick?

[hitman6003]

mysql_close will disconnect you from the db which if you have more queries to execute isn't desirable...use mysql_free_result which will remove that query result from memory....

 

http://www.php.net/mysql_free_result

[marcus]

Nope. That closes the connection completely, tested it as well:

 

<?php

$c = mysql_connect('localhost','root') or die(mysql_error());
$d = mysql_select_db('users',$c);

$sql = "SELECT * FROM `users` WHERE `username`='marcus'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);

echo $row['aim'] . "<br>\n";

mysql_close();

$sql = "SELECT * FROM `users` WHERE `username`='lemonade'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);

echo $row['aim'] . "<br>\n";

?>

 

results:

 

lifeg0eson666

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\webserver\www\test\mysql close.php on line 15

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\webserver\www\test\mysql close.php on line 15
Access denied for user 'ODBC'@'localhost' (using password: NO)