30 replies to this topic

[SERB-4-LIFE]

ok Gio here is the problem i added the file through mysql that was easy now i get an error so have a look at my connect file if everything is good with it

<?php
                           $username = "username";
                            $password = "password";
                            $host =  "host";
                            $database = "database";

                            mysql_connect($host,$username,$password) or die("Error connecting to Database!
" . mysql_error());

                            mysql_select_db($database) or die("Cannot select database!
" . mysql_error());
?>

i canged username, pass,host,databasename for protection but i have the corect username and pass i can connect to the database and i get this error

Could not execute query : SELECT * from counter where id='1'.No Database Selected

[Jamie Huskisson]

remove double spacing between the equals sign and value of $host ?

it could be that you've forgotten to end an existing database connection before you've made that one

[Gio]

ok Gio here is the problem i added the file through mysql that was easy now i get an error so have a look at my connect file if everything is good with it

<?php
                           $username = "username";
                            $password = "password";
                            $host =  "host";
                            $database = "database";

                            mysql_connect($host,$username,$password) or die("Error connecting to Database!
" . mysql_error());

                            mysql_select_db($database) or die("Cannot select database!
" . mysql_error());
?>

i canged username, pass,host,databasename for protection but i have the corect username and pass i can connect to the database and i get this error

Could not execute query : SELECT * from counter where id='1'.No Database Selected

<?php
$username = "username";
$password = "password";
$host =  "localhost";
$database = "database";

$connect = mysql_connect($host,$username,$password) or die("Error connecting to Database! " . mysql_error());
mysql_select_db($database , $connect) or die("Cannot select database! " . mysql_error());
?>

I would do it like that

[ludwigw]

Um.....is that a copy and paste code? If so where does the connect.php come from?

Can this be explained a bit more since the only understanding on php i have is <? include() ?> but Im trying to learn.

So can someone please explain this a bit more? Maybe Gio you can add me

[email protected] = MSN
infnit123 = AIM

[adam123]

<?php
$username = "username";
$password = "password";
$host =  "localhost";
$database = "database";

$connect = mysql_connect($host,$username,$password) or die("Error connecting to Database! " . mysql_error());
mysql_select_db($database , $connect) or die("Cannot select database! " . mysql_error());
?>

I would do it like that

I would do it like this:

if ($dbc = @mysql_connect ('localhost', 'username', 'password'))
{
if (!@mysql_select_db ('dbname'))
{
die ('<p>Could not select the database because: <b>' . mysql_error() . '</b>.</p>');
}
}
else
{
die ('<p>Could not connect to MySQL because: <b>' . mysql_error() . '</b>.</p>');
}

[Ruben K]

way to necropost

[bondy]

Gio

I have somethng similar, however I want a log to record when a link has been used.

At the moment the user is given a list of links he can download. Selecting one sends him to a download.php page which displays the one link to download.

On this page the user and code is logged, however the user may decide not to select the link to download therefore the log is false.

please help.

[madcom]

my header function gives an error... what can i do..
please help me