Jump to content

drums

Members
 View Profile  See their activity

  • Posts

    32

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by drums

    [SOLVED] Can't I have 2 queries on a page?

    in PHP Coding Help

    Posted

    I created a new dB that is simpler with 13 fields but there must be a conflict because I get no errors or data.

    So I make a query for each of the 5 data entry spots on the page. Do I need to close it or something? I can't figure what else the problem could be...

    <? 
$query = mysql_query("select * from xlsdata where spot='1st'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} 
?>
<h2><?php echo $record['date-event']; ?></h2>
<p><?php echo $record['beginning']; ?>
<blockquote>
<?php if(!empty($record['bullet1'])) echo "<li>".$record['bullet1']."</li>"; ?>
    <?php if(!empty($record['bullet2'])) echo "<li>".$record['bullet2']."</li>"; ?>
    <?php if(!empty($record['bullet3'])) echo "<li>".$record['bullet3']."</li>"; ?>
    <?php if(!empty($record['bullet4'])) echo "<li>".$record['bullet4']."</li>"; ?>
    <?php if(!empty($record['bullet5'])) echo "<li>".$record['bullet5']."</li>"; ?> 
    <?php if(!empty($record['bullet6'])) echo "<li>".$record['bullet6']."</li>"; ?>
    <?php if(!empty($record['bullet7'])) echo "<li>".$record['bullet7']."</li>"; ?>
    <?php if(!empty($record['bullet8'])) echo "<li>".$record['bullet8']."</li>"; ?>
    <?php if(!empty($record['bullet9'])) echo "<li>".$record['bullet9']."</li>"; ?>
    </blockquote>
<?php echo $record['end']; ?></p>

<? 
$query = mysql_query("select * from xlsdata where spot='2nd'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} 
?>
<h2><?php echo $record['date-event']; ?></h2>
<p><?php echo $record['beginning']; ?>
<blockquote>
<?php if(!empty($record['bullet1'])) echo "<li>".$record['bullet1']."</li>"; ?>
    <?php if(!empty($record['bullet2'])) echo "<li>".$record['bullet2']."</li>"; ?>
    <?php if(!empty($record['bullet3'])) echo "<li>".$record['bullet3']."</li>"; ?>
    <?php if(!empty($record['bullet4'])) echo "<li>".$record['bullet4']."</li>"; ?>
    <?php if(!empty($record['bullet5'])) echo "<li>".$record['bullet5']."</li>"; ?> 
    <?php if(!empty($record['bullet6'])) echo "<li>".$record['bullet6']."</li>"; ?>
    <?php if(!empty($record['bullet7'])) echo "<li>".$record['bullet7']."</li>"; ?>
    <?php if(!empty($record['bullet8'])) echo "<li>".$record['bullet8']."</li>"; ?>
    <?php if(!empty($record['bullet9'])) echo "<li>".$record['bullet9']."</li>"; ?>
    </blockquote>
<?php echo $record['end']; ?></p>
<? 
$query = mysql_query("select * from xlsdata where spot='3rd'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} 
?> ... to spot='5th'

     

    Need to make my data entry file read top down instead of left-right

    in PHP Coding Help

    Posted

    Sorry if this is a repeat because the first didn't like the CSV attachment but when I switched it it said I aleready posted but didn't see it...

    This is hard to explain so please bear with me. I have a program that updates a dB with a CSV file so all the data is imported in a straight line or row of the CSV file. Called thusly: 

    <? 
$query = mysql_query("select * from xlsdata where page='calendar'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} ?>

    I then display the data this way (only showing 2 of 5):

    <h2><?php echo $record['header1']; ?></h2>
<p><?php echo $record['para1']; ?>
<blockquote>
<?php if(!empty($record['bullet1'])) echo "<li>".$record['bullet1']."</li>"; ?>
    <?php if(!empty($record['bullet1-2'])) echo "<li>".$record['bullet1-2']."</li>"; ?>
    <?php if(!empty($record['bullet1-3'])) echo "<li>".$record['bullet1-3']."</li>"; ?>
    <?php if(!empty($record['bullet1-4'])) echo "<li>".$record['bullet1-4']."</li>"; ?>
    <?php if(!empty($record['bullet1-5'])) echo "<li>".$record['bullet1-5']."</li>"; ?> 
    <?php if(!empty($record['bullet1-6'])) echo "<li>".$record['bullet1-6']."</li>"; ?>
    <?php if(!empty($record['bullet1-7'])) echo "<li>".$record['bullet1-7']."</li>"; ?>
    </blockquote>
<?php echo $record['para1-end']; ?></p>

<h2><?php echo $record['header2']; ?></h2>
<p><?php echo $record['para2']; ?>
<blockquote>
<?php if(!empty($record['bullet2'])) echo "<li>".$record['bullet2']."</li>"; ?>
    <?php if(!empty($record['bullet2-2'])) echo "<li>".$record['bullet2-2']."</li>"; ?>
    <?php if(!empty($record['bullet2-3'])) echo "<li>".$record['bullet2-3']."</li>"; ?>
    <?php if(!empty($record['bullet2-4'])) echo "<li>".$record['bullet2-4']."</li>"; ?>
    <?php if(!empty($record['bullet2-5'])) echo "<li>".$record['bullet2-5']."</li>"; ?> 
    <?php if(!empty($record['bullet2-6'])) echo "<li>".$record['bullet2-6']."</li>"; ?>
    <?php if(!empty($record['bullet2-7'])) echo "<li>".$record['bullet2-7']."</li>"; ?>
    </blockquote>
<?php echo $record['para2-end']; ?></p>

    This has worked fine as usually I make each row a page and call them that way. This time however, I just have one page that I'm updating (5 areas with 10 cells for each) and I want to make it easier for the user to fill out the spreadsheet. So I would rather that each row is one of 5 data entry points on that page. So I want the data pulled by row and column going down instead of across the same row (each header cell is uniquely named).

    So in case I'm not being followed, I've attached the CSV file (as PDF because it won't allow a csv upload) so you can visualize (Row 1 is the header with A1 being the identifier, A2 data1, A3=data2 and so on to A11), then I repeat that 4 times in the same row for all the data entry cells.

    Instead I would like the header row to be just the identifier and the 10 header cells and then have the rows below the header row the 5 different entry points on the page (1st - 5th). This way it is a little more visible appealing to the user filling out this spreadsheet and since they are going to be moving things up (each event on the page has a date starting in its header) by deleting the data in the first row then moving all the others up and making a new one in the 5th row.

     

    So I was thinking I could use AND but I don't think it will know where to put the data unless it fills top down until the EOF by nature.

    <? 
$query = mysql_query("select * from xlsdata where placement='1st' AND placement='2nd' AND placement='3rd' AND placement='4th' AND placement='5th'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} 
?>

    So if I went this way would I have to have the query at each spot in the doc like this:

    <? 
$query = mysql_query("select * from xlsdata where placement='1st'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} ?>

     

    <? 
$query = mysql_query("select * from xlsdata where placement='1st'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} ?>

    Then the data grab: 

    <h2><?php echo $record['header1']; ?></h2>
<p><?php echo $record['para1']; ?>
<blockquote>
<?php if(!empty($record['bullet1'])) echo "<li>".$record['bullet1']."</li>"; ?>
    <?php if(!empty($record['bullet1-2'])) echo "<li>".$record['bullet1-2']."</li>"; ?>
    <?php if(!empty($record['bullet1-3'])) echo "<li>".$record['bullet1-3']."</li>"; ?>
    <?php if(!empty($record['bullet1-4'])) echo "<li>".$record['bullet1-4']."</li>"; ?>
    <?php if(!empty($record['bullet1-5'])) echo "<li>".$record['bullet1-5']."</li>"; ?> 
    <?php if(!empty($record['bullet1-6'])) echo "<li>".$record['bullet1-6']."</li>"; ?>
    <?php if(!empty($record['bullet1-7'])) echo "<li>".$record['bullet1-7']."</li>"; ?>
    </blockquote>
<?php echo $record['para1-end']; ?></p>

    Then for the next position and so on:

    <? 
$query = mysql_query("select * from xlsdata where placement='2nd'") or die("SQL error: " . mysql_error());if (FALSE === ($record = mysql_fetch_array($query))){    
} ?>

    Then the data grab: 

    <h2><?php echo $record['header1']; ?></h2>
<p><?php echo $record['para1']; ?>
<blockquote>
<?php if(!empty($record['bullet1'])) echo "<li>".$record['bullet1']."</li>"; ?>
    <?php if(!empty($record['bullet1-2'])) echo "<li>".$record['bullet1-2']."</li>"; ?>
    <?php if(!empty($record['bullet1-3'])) echo "<li>".$record['bullet1-3']."</li>"; ?>
    <?php if(!empty($record['bullet1-4'])) echo "<li>".$record['bullet1-4']."</li>"; ?>
    <?php if(!empty($record['bullet1-5'])) echo "<li>".$record['bullet1-5']."</li>"; ?> 
    <?php if(!empty($record['bullet1-6'])) echo "<li>".$record['bullet1-6']."</li>"; ?>
    <?php if(!empty($record['bullet1-7'])) echo "<li>".$record['bullet1-7']."</li>"; ?>
    </blockquote>
<?php echo $record['para1-end']; ?></p>

    So assuming you are following what I'm trying to do, does anyone know how to accomplish this?

     

    Thanks in advance for your time/help.

     

     

    [attachment deleted by admin]

    Need help making a blockquote and line items conditional

    in PHP Coding Help

    Posted

    I have some code I bought a few years ago that allows my clients to update content on their site using an Excel spreadsheet. Well this particular application sometimes has line items so I need to come up with a way to do this since it didn't like the fact I put the tags in the echo statement.

    <?php echo <h2> $record['header1']; </h2> ?>
<?php echo <p> $record['para1']; </p> ?>
<blockquote><?php echo <li> $record['bullet1']; </li> ?>
          <li><?php echo $record['bullet1-2']; </li> ?>
            <?php echo <li> $record['bullet1-3']; </li> ?>
            <?php echo <li> $record['bullet1-4']; </li> ?>
            <?php echo <li> $record['bullet1-5']; </li> ?>
            <?php echo <li> $record['bullet1-6']; </li> ?>
            <?php echo <li> $record['bullet1-7']; </li> ?>
    </blockquote>
<?php echo <p> $record['para1-end']; </p> ?>

    So I took them out but I'm stuck with having bullet points when I don't want them.

    <h2><?php echo $record['header1']; ?></h2>
<p><?php echo $record['para1']; ?></p>
<blockquote><li><?php echo $record['bullet1']; ?></li>
          <li><?php echo $record['bullet1-2']; ?></li>
            <li><?php echo $record['bullet1-3']; ?></li>
            <li><?php echo $record['bullet1-4']; ?></li>
            <li><?php echo $record['bullet1-5']; ?></li>
            <li><?php echo $record['bullet1-6']; ?></li>
            <li><?php echo $record['bullet1-7']; ?></li>
    </blockquote>
<p><?php echo $record['para1-end']; ?></p>

     

    Can someone help me add the condition where if there is no data the bullet point doesn't display?

    (please ignore my non-compliant code using blockquote instead of UL)

     

    Thanks very much for your time!

    Need help getting parsed data into web page

    in PHP Coding Help

    Posted

    I have posted this question elsewhere and have not gottn the help to get this working.

    I hired someone to do this for a client and I'm now trying to apply it to another site for populating a calendar. Basically it's a MySQL dB that reads the data from an excel (csv) spreadsheet. I am not getting any errors (except in MySQL it says I don't have an index) but no data is going through. The php is being parsed through html.

    Calendar

    The csv file has a header row of date, month, Day1-31 and 2 notes fields.

    Yet nothing displays

     

    Does anyone have any ideas what I'm doing wrong?

     

    dB is here: http://1leachfamily.com/cabin.csv file

    And you can see it's going in by looking here:http://1leachfamily.com/xls/view.php

    <?php $page_title = "Cayucos Cabin Calendar ";

$url=$_SERVER['PHP_SELF'];
mysql_connect("localhost","xxx","xxx") or die("Error Connecting to server ".mysql_error());
mysql_select_db("xxx") or die("Error Connecting to db : ".mysql_error());
?>
<HTML lang="en-us">
<HEAD>
<TITLE><?php echo $page_title ?> ~ August</TITLE>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Expires" content="never">
<noscript>
JavaScript must be enabled on your web browser to navigate this web site.
</noscript>

</head>
<? 
$query=mysql_query("select * from xlsdata where year='2007' and month='August'");
while($record=mysql_fetch_array($query))
{	
$yearname = $record['year'];
$monthname = $record['month'];
$day1name = $record['day1'];
$day2name = $record['day2'];
$day3name = $record['day3'];
$day4name = $record['day4'];
$day5name = $record['day5'];
$day6name = $record['day6'];
$day7name = $record['day7'];
$day8name = $record['day8'];
$day9name = $record['day9'];
$day10name = $record['day10'];
$day11name = $record['day11'];
$day12name = $record['day12'];
$day13name = $record['day13'];
$day14name = $record['day14'];
$day15name = $record['day15'];
$day16name = $record['day16'];
$day17name = $record['day17'];
$day18name = $record['day18'];
$day19name = $record['day19'];
$day20name = $record['day20'];
$day21name = $record['day21'];
$day22name = $record['day22'];
$day23name = $record['day23'];
$day24name = $record['day24'];
$day25name = $record['day25'];
$day26name = $record['day26'];
$day27name = $record['day27'];
$day28name = $record['day28'];
$day29name = $record['day29'];
$day30name = $record['day30'];
$day31name = $record['day31'];
$note1name = $record['note1'];
$note2name = $record['note2'];
}
?>

<BODY background="images/baseball_bg.jpg" bgproperties="fixed" class="grnbars">
<TABLE align="center" cellpadding="0" cellspacing="0" width="740" border="0">
<tr>
	<td>
<TABLE width="10%" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#030165">
	<tr>
		<td>
<img src="images/cay_morro_sm.jpg" alt="Cayucos" width="200" height="87" border="0"> 
		</td>
	</tr>
</TABLE>
<P>
<TABLE width="10%" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#030165">
	<tr>
		<td>
	<TABLE cellspacing=1 cellpadding=0 align="center" width="99%" border="0">
		<tr>
			<td bgcolor="#EBF0FF" align="center" class="norm_text" nowrap>
<?=$monthname?> <?=$yearname?> <?=$headingname?>
			</td>
		</tr>
	</TABLE>
		</td>
	</tr>
</TABLE>
<br>
<TABLE cellpadding="0" cols="12" align="center" width="75%" border="0">
	<tr>
		<td align="center" width="50" bgcolor="#030165">
<a href="10-07cal.htm"><span class="whtcapbg">Oct</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="11-07cal.htm"><span class="whtcapbg">Nov</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="12-07cal.htm"><span class="whtcapbg">Dec</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="1-08cal.htm"><span class="whtcapbg">Jan</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="2-08cal.htm"><span class="whtcapbg">Feb</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="3-08cal.htm"><span class="whtcapbg">Mar</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="4-08cal.htm"><span class="whtcapbg">Apr</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="5-08cal.htm"><span class="whtcapbg">May</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="6-08cal.htm"><span class="whtcapbg">Jun</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="7-08cal.htm"><span class="whtcapbg">July</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="8-08cal.htm"><span class="whtcapbg">Aug</span></a>
		</td>
		<td align="center" width="50" bgcolor="#030165">
<a href="9-08cal.htm"><span class="whtcapbg">Sep</span></a>
	</td>		
</tr>
</TABLE>

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                  Start the Days of the Week                             -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->


<TABLE cellpadding='0' cols="7" align='center' width='75%' bgcolor='030165' border='0'>
<tr bgcolor="#EBF0FF">
	<td align="center" width="87" class="dblcapbg">SUN</td>
	<td align="center" width="87" class="dblcapbg">MON</td>
	<td align="center" width="87" class="dblcapbg">TUE</td>
	<td align="center" width="87" class="dblcapbg">WED</td>
	<td align="center" width="87" class="dblcapbg">THU</td>
	<td align="center" width="87" class="dblcapbg">FRI</td>
	<td align="center" width="87" class="dblcapbg">SAT</td>
</tr>
<tr align=left valign=top>
	<td width='87' class='h2' height='87' bgcolor='030165'>

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                      Start Days of Week 1                                  -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->

<!-- SUNDAY -->
<strong> </strong>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#030165">
<!-- MONDAY -->
<strong> </strong>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#030165">
<!-- TUESDAY -->
<strong> </strong>
	</td>
	<td width='87' class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- WEDNESDAY -->
<strong>1</strong><br>
<?=$day1name?>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- THURSDAY -->
<strong>2</strong><br>
<?=$day2name?>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- FRIDAY -->
<strong>3</strong><br>
<?=$day3name?>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- SATURDAY -->
<strong>4</strong><br>
<?=$day4name?>
		</td>
	</tr>
	<tr valign="top">
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                      Start Days of Week 2                                  -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->

<!-- SUNDAY -->
<strong>5</strong><br>
<?=$day5name?>

		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- MONDAY -->
<strong>6</strong><br>
<?=$day6name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- TUESDAY -->
<strong>7</strong><br>
<?=$day7name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- WEDNESDAY -->
<strong>8</strong><br>
<?=$day8name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- THURSDAY -->
<strong>9</strong><br>
<?=$day9name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- FRIDAY -->
<strong>10</strong><br>
<?=$day10name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- SATURDAY -->
<strong>11</strong><br>
<?=$day11name?>
		</td>
	</tr>
	<tr valign="top">
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                      Start Days of Week 3                                  -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->

<!-- SUNDAY -->
<strong>12</strong><br>
<?=$day12name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- MONDAY -->
<strong>13</strong><br>
<?=$day13name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- TUESDAY -->
<strong>14</strong><br>
<?=$day14name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- WEDNESDAY -->
<strong>15</strong><br>
<?=$day15name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- THURSDAY -->
<strong>16</strong><br>
<?=$day16name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- FRIDAY -->
<strong>17</strong><br>
<?=$day17name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- SATURDAY -->
<strong>18</strong><br>
<?=$day18name?>
		</td>
	</tr>
	<tr valign="top">
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                      Start Days of Week 4                                  -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->

<!-- SUNDAY -->
<strong>19</strong><br>
<?=$day19name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- MONDAY -->
<strong>20</strong><br>
<?=$day20name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- TUESDAY -->
<strong>21</strong><br>
<?=$day21name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- WEDNESDAY -->
<strong>22</strong><br>
<?=$day22name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- THURSDAY -->
<strong>23</strong><br>
<?=$day23name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- FRIDAY -->
<strong>24</strong><br>
<?=$day24name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- SATURDAY -->
<strong>25</strong><br>
<?=$day25name?>			</td>
	</tr>
	<tr valign="top">
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">

<!-- ++++++++++++++++++++++++++++++++++++++ -->
<!--                                                                                        -->
<!--                      Start Days of Week 5                                  -->
<!--                                                                                        -->
<!-- ++++++++++++++++++++++++++++++++++++++ -->

<!-- SUNDAY -->
<strong>26</strong><br>
<?=$day26name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- MONDAY -->
<strong>27</strong><br>
<?=$day27name?>
		</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- TUESDAY -->
<strong>28</strong><br>
<?=$day28name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- WEDNESDAY -->
<strong>29</strong><br>
<?=$day29name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- THURSDAY -->
<strong>30</strong><br>
<?=$day30name?>			</td>
		<td width="87" class="reg_text" height="87" bgcolor="#EBF0FF">
<!-- FRIDAY -->
<strong>31</strong><br>
<?=$day31name?>
		</td>
		<td width="87" class="reg_text" height="87" >
<!-- SATURDAY -->
<strong></strong>
<br>
		</td>
	</tr>
</TABLE>
<script language="JavaScript1.2" src="footerclose.js"></script>
	</td>
</tr>
</TABLE>

</body>
</html>

     

    Any help is greatly appreciated

    Problem with array fetch

    in MySQL Help

    Posted

    Didn't have the squiggly brackets:
    [code]{    
    $headingname = $record['heading'];
        $titlename = $record['title'];
        $bodyname = $record['body'];
        $imagename = $record['image'];
        $footername = $record['footer'];
    }
    [/code]
    Thanks go to Lycander at LittleBlackDog.com

    Problem with array fetch

    in MySQL Help

    Posted

    I have a script that was done for my client on one site and I want to add it to other sites as well. I am able to write to the dB but retrieving the data only brings in one column. Can anyone tell me what I am doing wrong?
    [code]<?
    $query=mysql_query("select * from xlsdata where date='6/13/2006'");
    while($record=mysql_fetch_array($query))
        $headingname = $record['heading'];
        $titlename = $record['title'];
        $bodyname = $record['body'];
        $imagename = $record['image'];
        $footername = $record['footer'];
    ?>
    <h1><?=$headingname?></h1>
    <h2><?=$titlename?></h2>
    <?=$bodyname?>
    <br><img src="images/<?=$imagename?>" border="0" alt="<?=$imagename?>"><br><strong><?=$footername?>[/code]
    The only thing that shows is the heading.
    Thanks.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.