i'm so tired and it's so hot...

[taya]

and i though i found a great code for displaying random photo from MySQL database...

it works perfect in a separate file

but when i put it into file.php
it always sais i have a parse error in line 34!

the code of my concern starts with "mysql_connect('localhost'..."

<?
require ("page.inc");

$homepage = new Page();

$homepage -> SetContent(
"<table width=\"100%\" align=\"center\" background color=\"white\" border=0 cellspacing=0 cellpadding=20>
<tr valign=\"top\"><td>

<table width=\"65%\" border=\"0\" cellspacing=0 cellpadding=0 valign=\"top\">
<tr valign=\"top\">
<td><p valign=\"top\"> <br>Welcome!</p></td>
</tr>

<tr><td><br><form action=\"\" method=\"post\">
<p class=\"header\">Search</p>
From:<input type=text size=\"5\">&nbsp;&nbsp;
To:<input type=text size=\"5\">
<br><br>
<INPUT TYPE=\"button\" VALUE=\"Search\"
style=\"font-family:Georgia, Times New Roman, Times, serif; font-size:12pt; background:99cc99;\">
</form>
</td></tr>
</table>

</td>

<td>
<table width=\"35%\" border=0 cellspacing=0 cellpadding=0 align=\"right\">
<tr valign=\"top\">
<td>".
mysql_connect('localhost', 'photo_database', 'password');
mysql_select_db('bride');

// Edit this number to however many links you want displaying
$num_displayed = 1;

// Select random rows from the database
$result = mysql_query ("SELECT * FROM photos ORDER BY RAND() LIMIT $num_displayed");

// For all the rows that you selected
while ($row = mysql_fetch_array($result))

{
echo ("<img src='.$row["photo"].' border=0 alt='.$row["brideid"].'></a>");
}
."</td></tr>

</td>

</tr>
</table>
</td>
</tr>
</table>");

$homepage -> Display();

?>

[dalecosp]

Is that a period or dot instead of a semicolon right there above the line you mention? :rolleyes:

Hey, nothing personal, it's hot here, too.... 😉

[m_tt]

hope this helps...

	require("page.inc");

$content 	= '';
$content	.= '
	<table width="100%" align="center" bgcolor="white" border="0" cellspacing="0" cellpadding="20">
		<tr>
			<td valign="top">
			<table width="65%" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td valign="top"><p><br>Welcome!</p></td>
				</tr>
				<tr>
					<td>
					<br>
					<form action="" method="POST">
						<p class="header">Search</p>
						From: <input type="text" size="5" name="from">
						To: <input type="text" size="5" name="to">
						<BR><BR>
						<input type="submit" value="Search" style="font-family:Georgia, Times New Roman, Times, serif; font-size:12pt; background:99cc99;">
					</form>
					</td>
				</tr>
			</table>
			</td>
			<td>
			<table width="35%" border="0" cellpadding="0" cellspacing="0" align="right">
				<tr>
					<td valign="top">
					';

					$con = mysql_connect("localhost","photo_database","password")or die(mysql_error());
						   mysql_select_db("bride",$con)or die(mysql_error());

						   $num_displayed = 1;

						   $result = mysql_query("SELECT * FROM photos ORDER BY RAND() LIMIT " . $num_displayed)or die(mysql_error());
						   		if (mysql_num_rows($result) > 0)	{
									while($row = mysql_fetch_array($result))	{
										$content .= '<img src="' . $row['photo'] . '" border="0" alt="' . $row['brideid'] . '">';
									}
								} else {
									// No results
								}

					$content .= '
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
	';

$homepage = new Page();
$homepage->SetContent($content);
$homepage->Display();

CLEAN CODE IS KEY

[taya]

M@tt, al, forum, i love you!!!!!!!!!!!!!!!!!!!!!

<kisses>