connecting to database

Frango

hello im a total newbie, but solved my first problem by reading someone else's thread (a rogue semicolon was my downfall)

but now it still wont work, it just says no database selected, how do i select a database?

obrienkev

Are you using mysql or sql server or what database?

mysql_select_db ("db_name"); // mysql

Frango

I'm using mysql

should i insert that code? Here's the code:

<?
include("../config.php");
$username=trim($username);
$password=trim($lpassword);
if($username=="" || $password =="")
{
header("Location: index.php?error=wu");
exit;
}
$sql="select password from admin where username='$username'";
$result=mysql_query($sql) or die (mysql_error());
while($row=mysql_fetch_array($result))
{
$dbpass=$row[0];
}
if($dbpass==$password)
{
session_start();
$admin_username=$username;
session_register("admin_username");
}
else
{
header("Location: index.php?error=wu");
exit;
}
?>

laserlight

Where is the code that connects to the database server? You can place the database selection code right after that.

Frango

$dbServer = "localhost"; //
$dbuserName = "moneyreayf1"; //
$dbpassword = "password"; //
$dbName ="moneyreayf1_rate"; //
$site_title = "Moneyrea YFC"; //
$site_copyright = "Copyright 2006 Moneyrea YFC"; //

this was a script i bought and these are the bits to configure, everything should work, i tried to slip in the code above like this:

$dbServer = "localhost"; //
$dbuserName = "rambo"; //
$dbpassword = "password"; //
$dbName ="rambo_rate"; //
$mysql_select_db ("db_name"); // mysql
$site_title = "Moneyrea YFC"; //
$site_copyright = "Copyright 2006 Moneyrea YFC"; //

i changed the db to the database username and the name to databases name (ie rambo_rate)

rincewind456

should i insert that code?

ANywhere you like, as long as it's after the connection to the database has been made, and before the first query is made.

Frango

cheers, but what does that mean??

sorry, im a bit of a dunce when it comes to this stuff!!

laserlight

i changed the db to the database username and the name to databases name (ie rambo_rate)

The problem is that you need to connect to the database. For the old mysql extension, this means you should look out for mysql_connect().

Frango

<?
$dbServer="local host";
$userName="rambo";
$password="password";
$dbName="rambo_rate";

$con=mysql_connect ($dbServer, $userName, $password) or die ('Cannot connect to the database.');
$db=mysql_select_db ($dbName);
?>

this is my connection file, so would i do this:

<?
$dbServer="local host";
$userName="rambo";
$password="password";
$dbName="rambo_rate";
$mysql_select_db ("rambo_rate"); // mysql

$con=mysql_connect ($dbServer, $userName, $password) or die ('Cannot connect to the database.');
$db=mysql_select_db ($dbName);
?>

Frango

actually i see that the mysql_select_db ("rambo_rate"); // mysql
is at the end of the code... but i am sure the names are right, but it still says no database selected

laserlight

Almost there, but try something along these lines:

<?php
$dbServer = "localhost";
$userName = "rambo";
$password = "password";
$dbName = "rambo_rate";
$con = mysql_connect($dbServer, $userName, $password)
	OR die('Cannot connect to the database.');
$db = mysql_select_db ($dbName)
	OR die('Cannot select database.');
?>