[SOLVED] Inserting data from mysql... what is the best way?

[rebeat]

Hi,

 

Just wondering what the best method to insert a value from a database is. Does it need to include the username/password to grab the value, because my site has a lot of items, each page would need to update the price for that item from the database, so one visitor could visit 30 pages, each page has to open the database to extract. Does this slow the server down?

 

this is the method i am looking at:

<?php
$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("products",$db);
$result = mysql_query("SELECT * FROM products WHERE id=4", $db);
$myrow = mysql_fetch_array($result);
?>

<?php echo "Our Special Price is <b>$".$myrow["special2"]."</b>" ?>
<?php mysql_close() ?>

 

Is this the best way?

 

also is it a good idea to include <?php mysql_close() ?> in the footer to prevent it remaining open?

 

 

Cheers.

 

[bubblegum.anarchy]

FYI: mysql_connect() assures that the connection is closed when the script is complete so there is no need to add mysql_close(), unless you want to be super safe.

[rebeat]

FYI: mysql_connect() assures that the connection is closed when the script is complete so there is no need to add mysql_close(), unless you want to be super safe.

 

does mysql_connect() close the mysql connection? do i need to enter any value between () ? thx.

[bubblegum.anarchy]

The same mysql_connect() that you have in the second line of your own code.

[rebeat]

The same mysql_connect() that you have in the second line of your own code.

yes, but does the statement mysql_close(); close all database connections? or do i need to specify the connection, ie: mysql_close(db);

?

[bubblegum.anarchy]

You do not have to specify any closing database connections that are open via mysql_connect().  Just ignore all my posts!!