mark2326l

I'm trying to calculate the number of days a particular property is vacant. From this query... SELECT Properties.PropId, Tenants.TenantId, Tenants.PropertyID, Tenants.TenantAdress, Tenants.MoveIn, Tenants.MoveOut, Properties.P_GpNo FROM Properties, Tenants WHERE Tenants.PropertyID=Properties.PropId AND Properties.P_GpNo ="3" AND TenantAdress = "5" ORDER BY Tenants.TenantId It returns.. MoveIn MoveOut 5 4 005 5 2012-12-28 2013-04-13 3 …

I have a MySQL DB with 2 Tables in particular, "Properties" and "Tenants". Each Table has a unique address Field "propAddress" & "TenAddress". I have a PHP page with a repeating reigon that lists all properties in the DB. What I'm trying to do is list all the tenants info …

This works in every browser I've tested except IE My .js [CODE]document.getElementById("location").innerHTML = object.city;[/CODE] My html [CODE]<div id="location" class='text1' ></div>[/CODE] I've spent hours searching the web, but have found no solution. Any advise? Thanks

Im listing files in a directory on a web page with links to the files. I'm trying to change the link color to something other than my typical. Below is the php link... [CODE]<?php echo("<a href= '$dirname/$file'>$file </a> ");echo "<br />"; ?>[/CODE] I want to change the class. Below is …

My goal is to have a directory password protected, and have the usernames and passwords stored in mysql. Having the htpasswd linked to my database using the mod_auth_mysql module looked like exactly what I needed, but when I enable the module it disables my site. Most of the sites I've …

This is my first project using JavaScript. I have a PHP page that loads text fields "if" called for. I thought JavaScript would be a great way to get the total of all Text Fields without Submit. The code below is an example of my problem. [CODE]<SCRIPT language = JavaScript> …

As the title says I want to have a text field appear using the if statement. My simplest attempt.... [CODE] <?php if($row_Recordset1['NoPages_A'] { echo<input type="text" name="firstM" id="firstM" />;} ?> [/CODE]

I have entry dates of my records in format yyyy-mm-dd. I have 2 drop down menus, one for Year, and one for Month to select. I have no idea how to return results without using the complete date. If I use a text box and enter the exact date (Y,m,d) …

I have several record sets for example.. $row_Recordset1['NoPages_A'] $row_Recordset1['NoPages_B'] $row_Recordset1['NoPages_C'] Each has a value of say A-"16", B-"16", C-"8". I can get the total value of "40" by the following.. [CODE] <?php $A=($row_Recordset1['NoPages_A']); $B=($row_Recordset1['NoPages_B']); $C=($row_Recordset1['NoPages_C']); $Pages=($A+$B+$C); echo "$Pages"; [/CODE] But I also want to get a value of "1" for …

I'm trying to upgrade my server from Mac 10.4.11 Server, running Apache 1.3; PHP 4.4.9; and mysql 5.0.45 (all pages work fine) to Mac 10.6 server with the latest (default) Apache, php, and mysql. Any page with a mysql connection is blank I can connect to mysql through mysql admin. …

I have a submit form with a text field. I want it to auto fill the date "7 days" from now into MySQL, and also be editable. The code below worked fine a few days ago, well until a new month is coming around the corner. [CODE]$SevenDay = date("d") + …

On a PC, Explorer or FireFox I get a box around any image that has a link associated with it. All browsers on my Mac appear as desired. My typical... [CODE]<a href="http://www.link.com/" target="_blank"><img src="images/MyPicture.gif" width="200" height="103" align="top" /> </a>[/CODE] Is there any way to get rid of these?

Data from MySql. I used nl2br() for line breaks, but wanted paragraph breaks. I wrote [CODE]function test($text) { $text = ereg_replace("\n", "<p> ", $text ); return $text ; } [/CODE] That worked but my editor wants indents not spaces between paragraphs. I thought [CODE]function test($text) { $text = ereg_replace("\n", "<br …

I have stories (some with images) displayed through a repeating region. Data of stories and image paths from MySql. Stories with no image have a blank image frame next to it, but only on MS Explorer. I thought I had this resolved using a variable style. All Mac browsers look …

I have stories and images displayed on a web page through a "repeat region" mostly designed with DV. I'm getting the data & image path from MySql. The image with the story is a link (to larger image) and is "thumbnail" size, reduced from the full size using a style. …