Simple Code obviouse error im sure, Please help

djwinder

Hi everyone

I'm sure the error here is an obviouse one but i can not see it and have been trying to sort it for a good hour. i want to display the contents of the 'welcome' field but it doesnt display the content but everything else displays. thanks in advance.


<?PHP
require ('C:/web/root/includes/header.php');

include ('db_connect.php');

$olddata = "SELECT welcome FROM settings WHERE clubid = 1"; 
$res = mysql_query($olddata); 
$olddata = mysql_fetch_assoc($res); 
$olddata = $olddata['welcome']; 

?>

<tr>
<td width="780" colspan="4" border="1" align="left" bgcolor="#FFFFFF">

  <p>&nbsp;</P>

  <b> welcome message below </b>

  <p> <?php echo $olddata; ?> </p> 

  <p>&nbsp;</P>


</td>
</tr>


<?PHP require ('C:/web/root/includes/footer.php');?>

thorpe

You really need to take a look at some debugging techniques. At no stage do you even check to see if your query even worked before you attempt to use it. Try...

$res = mysql_query($olddata) or die(mysql_error());
if ($res) {
    $olddata = mysql_fetch_assoc($res);
}
$olddata = $olddata['welcome'];

djwinder

I am very new to php, sql, html so appreashiate the debugging advice, it has given the error of 'Access denied for user 'ODBC'@'localhost' (using password: NO)' this is confusing because the db_connect.php file which connects to the database does work as it is used in other scripts successfully. do you know what might be wrong?

thorpe

Can we see db_connect.php? (Cover your password)

djwinder

here is the db-connect file and the constants file that is called within it. cheers for the help


//db_connect.php

<?php

include ('constants.inc');

$connection = mysql_connect($GLOBALS['host'],$GLOBALS['user'],$GLOBALS['pass']) or die ("couldn't connect to server"); 

$db = mysql_select_db ($GLOBALS['db_name'], $connection) or die ("Unable to select the database");

?>



//constants.inc

<?php

$GLOBALS['db_name'] = 'dhstshop';
$GLOBALS['host'] = 'localhost';
$GLOBALS['user'] = 'root';
$GLOBALS['pass'] = '*********';
$GLOBALS['thumbw'] = 100;                  //The Width Of The Thumbnails
$GLOBALS['thumbh'] = 75;                   //The Height Of The Thumbnails
$GLOBALS['imagepath'] = "/shop/admin/images/";         //Path To Place Where Images Are Uploaded. No Trailing Slash
$GLOBALS['thumbpath'] = "/shop/admin/images/thumbs/";  //Path To Place Where Thumbnails Are Uploaded. No Trailing Slash


?>