Ask a Question related to Dreamweaver AppDev, Design and Development.
-
The_FedEx_Guy #1
PHP PAGE SHOWING BLANK PAGE
Hi ppl,
Am having trouble with Dreamweaver/PHP.
I have Sokkit v3.5 (Formerly known as PHPTriad) With Apache/2.0.49 (Win32)
PHP/4.3.6 and MySQL 3.23.49 and Dreamweaver MX 2004 with the 7.0.1 update
And I'm trying to call up and display items from mySQL. I'm working on
localhost
The Query works fine in DW. But when I Preview in Browser all I can see is a
Blank page. No error Messages on it at all and I have enabled Error Checking in
PHP.ini to E_ALL
Hope someone can help.
<?php include('Connections/connect.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_connect, $connect);
$query_Recordset1 = "SELECT Name, Description, Price FROM menu WHERE Catergory
="sundries"";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1,
$startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $connect) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<HTML>
<HEAD>
<TITLE>Spice Mill</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #C9A3A2;
margin-top: 0px;
}
.style1 { font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
font-size: 18px;
}
.style2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif}
-->
</style></HEAD>
<BODY LEFTMARGIN=0 MARGINWIDTH=0>
<TABLE WIDTH=720 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD>
<IMG SRC="images/index_01.jpg" WIDTH=47 HEIGHT=151 ALT=""></TD>
<TD>
<IMG SRC="images/index_02.jpg" WIDTH=633 HEIGHT=151 ALT=""></TD>
<TD>
<IMG SRC="images/index_03.jpg" WIDTH=40 HEIGHT=151 ALT=""></TD>
</TR>
<TR>
<TD>
<IMG SRC="images/index_04.jpg" WIDTH=47 HEIGHT=44 ALT=""></TD>
<TD><img src="images/index_05.jpg" alt="" name="" width="633" height="44"
border="0"></TD>
<TD>
<IMG SRC="images/index_06.jpg" WIDTH=40 HEIGHT=44 ALT=""></TD>
</TR>
<TR>
<TD>
<IMG SRC="images/index_07.jpg" WIDTH=47 HEIGHT=22 ALT=""></TD>
<TD>
<IMG SRC="images/index_08.jpg" WIDTH=633 HEIGHT=22 ALT=""></TD>
<TD>
<IMG SRC="file:///C|/wwwroot/spice/images/index_09.jpg" WIDTH=40 HEIGHT=22
ALT=""></TD>
</TR>
<TR>
<TD background="images/index_10.jpg"> </TD>
<TD valign="top" bgcolor="#FFFFFF">
<?php do { ?>
<table width="602" height="81" border="0" align="center">
<tr>
<td width="173"> </td>
<td width="284"><div align="center"><span
class="style1">Starters</span></div></td>
<td width="131"> </td>
</tr>
<tr>
<td valign="top"><strong class="style2"><?php echo
$row_Recordset1['Name']; ?></strong></td>
<td valign="top"><p align="left" class="style3"><?php echo
$row_Recordset1['Description']; ?></p></td>
<td valign="top"><div align="right" class="style2"><?php echo
$row_Recordset1['Price']; ?></div></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
<p> </p> <p> </p>
<p> </p>
<p> </p></TD>
<TD background="images/index_12.jpg"> </TD>
</TR>
<TR>
<TD>
<IMG SRC="images/index_13.jpg" WIDTH=47 HEIGHT=139 ALT=""></TD>
<TD background="images/index_14.jpg"> </TD>
<TD>
<IMG SRC="images/index_15.jpg" WIDTH=40 HEIGHT=139 ALT=""></TD>
</TR>
</TABLE>
</BODY>
</HTML>
<?php
mysql_free_result($Recordset1);
?>
The_FedEx_Guy Guest
-
Edit page shows blank page!
We have a serious problem with Contribute 3: We browse to the page we wish to edit, and then click 'Edit'. Contribute fetches the templates etc;... -
Edit Page -- Blank Page
When one of my users clicks on Edit Page, it goes the editting section of contribute but a blank page comes up. You cannot make any edits to this... -
Edit page returns a blank draft page
The connection to my website is validated. I can see the home page as expected. But when I go to "Edit page" online, it comes back with a blank... -
1 page (of 220) exports as a blank pdf page
I am bewildered. I export every page, chapter by chapter. But page number 9 always comes out as a blank white page in the pdf file. Has anybody got... -
Link target to blank page and sizing new page
SimpleQ wrote: :: Hello, :: :: I'm linking a simple thumbnail to open a larger image in a new :: brower page. I'm trying to size the border of... -
Joe Makowiec #2 Re: PHP PAGE SHOWING BLANK PAGE
On 17 Feb 2005 in macromedia.dreamweaver.appdev, The_FedEx_Guy wrote:
I suspect that this line is the problem. Try changing the double quotes> $query_Recordset1 = "SELECT Name, Description, Price FROM menu
> WHERE Catergory ="sundries"";
around sundries to single quotes and see if it works:
$query_Recordset1 = "SELECT Name, Description, Price FROM menu WHERE
Catergory = 'sundries'";
--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]
Joe Makowiec Guest
-
The_FedEx_Guy #3 Re: PHP PAGE SHOWING BLANK PAGE
Hi Joe,
Thanx for the advice, you were correct. Ur a life saver!
Thanx again!
The FedEx Guy
The_FedEx_Guy Guest
-
Joe Makowiec #4 Re: PHP PAGE SHOWING BLANK PAGE
On 18 Feb 2005 in macromedia.dreamweaver.appdev, The_FedEx_Guy wrote:
No problem. What happened was that you were trying to use a double> Hi Joe,
> Thanx for the advice, you were correct. Ur a life saver!
>
> Thanx again!
quoted string inside another double quoted string:
$query_Recordset1 = "SELECT ... WHERE Catergory = "sundries"";
When PHP hit the first double quote around "sundries", it figured that
the string ended there. Since the string ended, it figured that the next
text it encountered must be a keyword of some sort. It then got confused
as to what it was supposed to do with the keyword sundries, threw up its
hands and gave up.
--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]
Joe Makowiec Guest
-
Michael Fesser #5 Re: PHP PAGE SHOWING BLANK PAGE
.oO(Joe Makowiec)
I would have expected a parse error or something. In most cases PHP> $query_Recordset1 = "SELECT ... WHERE Catergory = "sundries"";
>
>When PHP hit the first double quote around "sundries", it figured that
>the string ended there. Since the string ended, it figured that the next
>text it encountered must be a keyword of some sort. It then got confused
>as to what it was supposed to do with the keyword sundries, threw up its
>hands and gave up.
doesn't die in silence.
Micha
Michael Fesser Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
