query, include, echo...

Anon

Below is the main.php file I am trying to get to work, I am unfortunately a novice jumping in the deep end because I have no choice 😉 any help would be much appreciated as I've spent half a day fiddling with this... all it gives is a blank page and no results from the database.

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php

$hostname = "localhost";
$usernamedb = "jonkane";
$passworddb = "password";
$dbName = "informotion";

$db = MYSQL_CONNECT($hostname, $usernamedb, $passworddb);
@mysql_select_db("$dbName");

$result = mysql_query("SELECT * FROM clientDetails WHERE clientName='Madfish'",$db);

?>
</head>

It may seem strange to be trying to put the echo in an include page but I am trying to set up a template that lots of other .php files will read, displaying certain variables depending on what client .php page it is (hence the WHERE clientName='Madfish'). Hope this all makes sense to someone 🙂

The include file db.include has only this so far:

<?php echo $result; ?>

Anon

After the query

<< $result = mysql_query("SELECT * FROM clientDetails WHERE clientName='Madfish'",$db); >>

$result is an array you need to fetch with

mysql_fetch_array();

Anon

Thanks very much for your reply.

I have finally got it working as I want it. See below.

//CODE IN madfish.php

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php

mysql_connect ('localhost', 'informotion', 'password');

mysql_select_db ('informotion');

$query = "SELECT * FROM syndicateDetails WHERE clientName='Madfish'"; // CHANGE THE CLIENTNAME TO THE SAME AS IN THE DATABASE FOR EACH PARTICULAR CLIENT

$result = mysql_query($query);

$row = mysql_fetch_array($result);
$dailyHoroKeyword = $row[HoroKeyword];
$dailyHoroshortcode = $row[Horoshortcode];
$txtDatshortcode = $row[txtDatshortcode];
$txtDatKeywordname = $row[txtDatKeywordname];
$clientURL = $row[clientURL];
$clientName = $row[clientName];

?>
</head>

//CODE IN db.include