Unable to connect to database?

Kazlaaz

This code works on one page, but when i add a little more code, I can't connect it to the database.

This code works here http://www.goaliepages.com/index.php NOTE: The area that I'm reffering to is the VOTE area to the right.

<?PHP
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("db_name",$db);
$result=mysql_query("select from poll_rotation");
$row=mysql_num_rows($result);
srand((double)microtime()1000000);
$random=rand(1,$row);
$imagenum=mysql_query("select * from poll_rotation where ID=$random");
while ($image=mysql_fetch_array($imagenum))
{
include '/home/kazlaaz/public_html/goalies/poll/booth.php';
display_booth($image[0]);
}
mysql_close($db);
?>

Yet this code does not seem to work on the next page located at: http://www.goaliepages.com/pictures/index.php

The code i added is:

<?
}
function dofooter()
{?>
<div align="center">
<p><a href="http://www.goaliepages.com/index.php" id="onyellow">Home</a>
<? ListGalleries(h); ?>
</p>
</div>

<? } ?>
<?
function dofooteradmin()
{?>
<div align="center">
<p><a href="index.php">Home</a> <? ListGalleries(h); ?> | <a href="help.php" onClick="NewWindow('help.php','Help','650','500','yes','center'); return false" onFocus="this.blur()">Help</a> </p>
</div>
</body>
</html>
<? } ?>

Any help would be appreciated. Thank you,

Jessica

abda53

can you show the script after you added to it?

Kazlaaz

Sorry for the spam but the entire code is as follows:

<? function doheader()
{ global $gallery, $sitetitle, $gallery; ?>
<html>
<head>

<title>Goalie Pages</title>
<link href="../../style01.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body bgcolor="#666666" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>

<td width="474" height="52" valign="top"><a href="http://www.goaliepages.com/index.php"><img src="../../images/newgoalie06_01.jpg" alt="Top Left Goalie Title Banner" border="0"></a></td>	  
  <td width="71" height="124" rowspan="2" valign="top"><img src="../../images/newgoalie06_02.jpg" alt="Top image"></td>	  
  <td rowspan="2" height="124" background="../../images/bg_top01.jpg" valign="top"></td>

<td rowspan="2" width="93" height="124" valign="top" align="right"><img src="../../images/newgoalie06_04.jpg" alt="Top left"></td>
</tr>
<tr>      

<td width="474" height="72" align="center" valign="bottom" bgcolor="#666666">

<?PHP
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("kazlaaz_goalie",$db);
$result=mysql_query("select from banners");
$row=mysql_num_rows($result);
srand((double)microtime()1000000);
$random=rand(1,$row);
$imagenum=mysql_query("select * from banners where ID=$random");
while ($image=mysql_fetch_array($imagenum))
{
printf("<a href=\"$image[2]\" target=\"_blank\"><img src=\"$image[1]\" border=0></a>");
}

</td>
</tr>
<tr>
  <td colspan="4"></td>
</tr>

</table>
<br>

<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td width="200" valign="top"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="28" colspan="3"><img src="../../images/nav_top01.jpg" alt="top nav image" width="153" height="28"></td>
</tr>
<tr>
<td width="7" valign="top" background="../../images/leftnavbg01.jpg"></td>
<td width="139" valign="top" bgcolor="#666699">
<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("kazlaaz_goalie",$db);
$result = mysql_query("SELECT * FROM navigation",$db);
while($myrow = mysql_fetch_array($result))
{
echo "<hr"." "."align=\"left\""." "."width=\"25%\""." "."noshade"." "."color=\"#9999CC\"".">";
echo "<a"." "."id=\"nav\""." "."href=\"".$myrow["url"]."\">".$myrow["name"]."</a>";
echo "<br>";
}
?>

</td>
<td width="7" valign="top" background="../../images/leftnavbg02.jpg"> </td>
</tr>
<tr bgcolor="#FFCC00">
<td height="5" colspan="3"></td>
</tr>
</table>
</td>
<td width="100%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="55" height="28"><img src="../../images/top_left_center.jpg" width="55" height="28"></td>
<td width="5" background="../../images/center.jpg"> </td>
<td align="center" background="../../images/center.jpg"><font color="#FFCC00"><img src="../../images/title_welcome01.jpg" alt="top title image" width="95" height="19"></font></td>
<td width="5" background="../../images/center.jpg"> </td>
<td width="55" height="28"><img src="../../images/top_right_center.jpg" width="55" height="28"></td>
</tr>
<tr>
<td background="../../images/center_left_center.jpg"> </td>
<td bgcolor="#666699"> </td>
<td bgcolor="#666699"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="19" height="19"><img src="../../images/yel_topleft.jpg" width="19" height="19"></td>
<td background="../../images/yel_midtop.jpg"> </td>
<td width="19" height="19"><img src="../../images/yel_topright.jpg" width="19" height="19"></td>
</tr>
<tr>
<td background="../../images/yel_midleft.jpg" bgcolor="#FFCC00"> </td>
<td bgcolor="#FFCC00">
<?
}
function dofooter()
{?>
<div align="center">
<p><a href="http://www.goaliepages.com/index.php" id="onyellow">Home</a>
<? ListGalleries(h); ?>
</p>
</div>

              </td>
            <td background="../../images/yel_midright.jpg">&nbsp;</td>
          </tr>
          <tr> 
            <td width="19" height="19"><img src="../../images/yel_bottomleft.jpg" width="19" height="19"></td>
            <td background="../../images/yel_midbottom.jpg">&nbsp;</td>
            <td width="19" height="19"><img src="../../images/yel_bottomright.jpg" width="19" height="19"></td>
          </tr>
        </table>
        <br>

        </td>
      <td bgcolor="#666699">&nbsp;</td>
      <td background="../../images/center_right_center.jpg">&nbsp;</td>
    </tr>
    <tr bgcolor="#FFCC00">
      <td height="5"></td>
      <td height="5"></td>
      <td height="5"></td>
      <td height="5"></td>
      <td height="5"></td>
    </tr>
  </table></td>
<td width="200" valign="top"><table border="0" cellspacing="0" cellpadding="0">
    <tr> 
      <td width="153" height="28" colspan="3"><img src="../../images/nav_associates01.jpg" alt="associates title" width="153" height="28"></td>
    </tr>
    <tr> 
      <td width="7" valign="top" background="../../images/leftnavbg01.jpg"> </td>
      <td width="139" bgcolor="#666699"> <br>

<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("kazlaaz_goalie",$db);
$result = mysql_query("SELECT * FROM banners_side",$db);
while($myrow = mysql_fetch_array($result))
{
echo "<a"." "."target=\"_blank\""." "."id=\"nav\""." "."href=\"".$myrow["url"]."\"><img"." "."border=\"0\""." "."src=\"".$myrow["filename"]."\"></a>";
echo "<p>";
}

?>
</td>
<td width="7" valign="top" background="../../images/leftnavbg02.jpg"> </td>
</tr>
<tr>
<td height="5" colspan="3" bgcolor="#FFCC00"></td>
</tr>
</table>
<br>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="153" height="28" colspan="3"><img src="../../images/nav_vote01.jpg" alt="vote title" width="153" height="28"></td>
</tr>
<tr>
<td width="7" valign="top" background="../../images/leftnavbg01.jpg"></td>
<td width="139" valign="top" bgcolor="#666699">

	  <br>

<?PHP
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("kazlaaz_goalie",$db);
$result=mysql_query("select from poll_rotation");
$row=mysql_num_rows($result);
srand((double)microtime()1000000);
$random=rand(1,$row);
$imagenum=mysql_query("select * from poll_rotation where ID=$random");
while ($image=mysql_fetch_array($imagenum))
{
include '/home/kazlaaz/public_html/goalies/poll/booth.php';
display_booth($image[0]);
}
mysql_close($db);
?>
<br>

</td>
<td width="7" valign="top" background="../../images/leftnavbg02.jpg"> </td>
</tr>
<tr bgcolor="#FFCC00">
<td height="5" colspan="3"></td>
</tr>
</table>
<p></p>
</td>
</tr>
</table>

</body>
</html>
<? } ?>
<?
function dofooteradmin()
{?>
<div align="center">
<p><a href="index.php">Home</a> <? ListGalleries(h); ?> | <a href="help.php" onClick="NewWindow('help.php','Help','650','500','yes','center'); return false" onFocus="this.blur()">Help</a> </p>
</div>
</body>
</html>
<? } ?>

[/COLOR]

It's a lot to scan through... and I know the problem is probably very simple, thanks for the help,

Jessica

Kazlaaz

I have a couple of other files, functions.php is as follows:

<?
$link = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname) or die("Could not select database");

function GetThumb($imagename)
{
global $thumbpath;
if(!file_exists($thumbpath.$imagename))
{
$imagename=str_replace ( "jpg", "gif", $imagename);
$imagename=str_replace ( "jpeg", "gif", $imagename);
}
return("uploads/thumbs/$imagename");
}

function ListGalleries($d)
{
global $link;
$result=mysql_query("SELECT * FROM galleries", $link);
if($d=="v")
{
while($row=mysql_fetch_object($result))
{
echo "<a href=\"show.php?gallery=".$row->Name."\">".$row->Name."</a>";
echo isnew($row->Name);
echo "<br>";
}
}
if($d=="h")
{
while($row=mysql_fetch_object($result))
{
echo " | ";
echo "<a href=\"show.php?gallery=".$row->Name."\">".$row->Name."</a>";
}
}
}

function getprevlink($gallery,$rank)
{
global $p;
$backrank=$rank-1;
$query="SELECT * FROM images WHERE ((rank='$backrank') AND (gallery='$gallery'))";//get the picture before this based of the rank
$result=mysql_query($query);
if($result) //if this is false there is no picture before this
{
$prevrow=mysql_fetch_object($result);
if($prevrow)
{
$prev="<a href=\"show.php?gallery=$gallery&p=$p&id=".$prevrow->id ."\"><img src=\"images/back.gif\" border=0></a>";
}
}
return $prev;
}

function getnextlink($gallery,$rank)
{
	global $p;
	$forwardrank=$rank+1;
	$query="SELECT * FROM images WHERE ((rank=$forwardrank) AND (gallery='$gallery')) ORDER BY rank";//get the picture after this
	$result=mysql_query($query);
	if($result) //if this is false there is no picture after this
	{ 
		$nextrow=mysql_fetch_object($result);
		if($nextrow)
		{
			$next.="<a href=\"show.php?gallery=$gallery&p=$p&id=".$nextrow->id ."\"><img src=\"images/forward.gif\" border=0></a>";
		}
	}
	return $next;
}

function isnew($gallery)
{
$query="SELECT images.gallery,
MAX( images.time ) AS MAX_OF_time,
UNIX_TIMESTAMP(images.time) as epoch_time
FROM images
WHERE
(
(gallery = '$gallery')
)
GROUP BY images.gallery, images.time
ORDER BY 2 DESC";
$result=mysql_query($query);
if($result)
{

		$row=mysql_fetch_object($result);
		$lastupdate=getdate($row->epoch_time);
		//echo $row->epoch_time;
		$timenow=getdate();
		if(($timenow["yday"]-$lastupdate["yday"])<=5 && $timenow["year"]==$lastupdate["year"])
		{
			$dlength = $timenow["yday"]-$lastupdate["yday"];
			if ($dlength == 0)
			{
				return "<font color=\"#CC0000\" size=\"2\"><b><i>Just Updated!</i></b></font>";
			}
			else if($dlength == 1)
			{
				return "<font color=\"#CC0000\" size=\"2\"><b><i>Updated Yesterday!</i></b></font>";//"<img src=\"images/new.gif\">";
			}
			else {
			return "<font color=\"#CC0000\" size=\"2\"><b><i>Updated $dlength days ago</i></b></font>";//"<img src=\"images/new.gif\">";
			}
		}
	}
}

?>[/COLOR]

show.php is as follows:

<?
require("config.php");
require("functions.php");

//$gallery="piercing";

if(isset($id)){ //there is an image to show
$result=mysql_query("SELECT * FROM images WHERE id=$id");
$thisimage=mysql_fetch_object($result);

$backlink="<a href=\"show.php?p=$p&gallery=$gallery\">Back to $gallery gallery</a>";

$prevlink=getprevlink($gallery,$thisimage->rank);
$nextlink=getnextlink($gallery,$thisimage->rank);
$comment=$thisimage->comment;
$title=$thisimage->title;
$theimage.="<img src=\"uploads/images/". $thisimage->name . "\" border=0>";
require("itheme.php");//include the theme file, this has php in it which uses all the variables we set above

}

elseif(isset($gallery))//no image to show so show the current gallery
{

$currows=1;
$curcols=0;
$result=mysql_query("SELECT * FROM images WHERE gallery='$gallery'");
$imagecount=mysql_num_rows($result);
$pagecount=ceil($imagecount /($rows*$cols));
for ($i = 0; $i < $pagecount; $i++) 
{
	$pagenum=$i+1;
	if($i==$p)
	{
		$pagelinks.="<font color=\"#CC0000\"><b>Page $pagenum</b></font> | ";
	}
	else {
	$pagelinks.="<a href=\"show.php?gallery=$gallery&p=$i\">Page $pagenum</a> | ";
	}

}
//if($p>0)//there is more than one page of thumnails and we're past the first page
{
	$datastart=$p*($rows*$cols);//current page times how many rows we're meant to show a page
	$dataend=$rows*$cols;//total of records to display
	$thelimit="LIMIT $datastart, $dataend";
	//$prevlink="<a href=\"show.php?gallery=$gallery&p=". ($p-1) ."\">Previous Page</a> | ";

}
$result=mysql_query("SELECT * FROM images WHERE gallery='$gallery' ORDER BY 'rank'  $thelimit", $link);
$content="<tr>";
//if($result) 
{
	$i=mysql_num_rows($result);
	$curwidth=0;
	while($row=mysql_fetch_object($result))
	{
		$curcols++;
		$i--;
		$imageinfo=getimagesize($thumbpath.$row->name);

		if($curcols>$cols || $curwidth > $tablewidth)//its time to go to the next line of images as set in config.php
		{
			$content.="</tr></table><table border=0 align=center><tr>";//add a row to the table
			$currows++;//we added another row so increment this
			$curcols=1;//set the coloumns to the start
			$curwidth=0;
		}
		$curwidth=$curwidth+$imageinfo[0];
		$thisthumb=GetThumb($row->name);
		$content.="<td>";
		$content.="<br><a href=\"show.php?p=$p&id=".$row->id ."&gallery=$gallery\">";
		$content.="<img src=\"". $thisthumb. "\" border=0 ". $imageinfo[3] ."></a><br>";
		//$content.=Date("Y.m.d.T.s",$row->time) . "</td>";
		//$times=getdate($row->time);
	}
	$content.="</tr>";
	$backlink="<a href=\"index.php\">Home</a>";
}
require("gtheme.php");//include the theme file, this has php in it which uses all the variables we set above

}

//else {
//gotopage("index.php");
//}
mysql_close($link);
?>[/COLOR]

Thanks again,

abda53

i might be wrong here.. but at the top of your functions.php

<?
$link = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname) or die("Could not select database");

im kinda tired but that dont look right..
same with this here
the top of the main page..
<? function doheader()
{ global $gallery, $sitetitle, $gallery; ?>
<html>
<head>

you can try doing a single link to your database
include('databaseset.php');
and use that for your database..