basic question

[boombanguk]

Hi,

I'm using some php to connect to my mysql database, which works fine. I then want to fetch some data from the table. Right now I have 2 scripts, connect.php and getrow.php. My question is, do I have to connect to the database both times ie at the top of the getRow.php code I also have to connect to the database, or can I just run the connect.php and then run the getRow.php afterwards?

thanks for any help
boombanguk

[rulian]

You do have to have a connect established before you can make any queries to the database.

The way most accomplish this, is to include the connect script on top of pages they need connectivity.

The connect script needs only to be included once for the page to work, even if it includes other files, they can all use that single connect script unless of course they connect eslewhere.

so
if you connect.php is

<?PHP

if ($DB=mysql_connect("localhost", "myusername", "mypass")) mysql_select_db("MyDB");
?>

then on your rows.php all you need to do is
<?PHP
include("connect.php");

the rest of your php.....

then that file will share that connect.php $DB link