marquis
-
Posts
41 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by marquis
-
<html><head><link rel="stylesheet" href="CSS.css" type="text/css" /><title>Search Results</title></head><body align="center"><div id="sidebar"><img src="images/bigdoglogo.gif" width="225"height="79" border="0"><div id="menu"><a href="Home.html">Home</a><a href="AboutUs.html">About Us</a><a href="CMS.php">Realtor login</a><a href="newmembers.html">Member Signup</a><a href="memberlogin.html">Member's Login</a><a href="morgage.html">Mortgage Info</a><a href="contact.html">Contact Us</a></div></div></div><div id="content"></body><h1>Search Results</h1><br><br><?php$SQL = "SELECT * FROM estate ";$SQLTEST = "SELECT * FROM estate ";if($_GET["city"]) {$city=$_GET["city"];$SQL =" $SQL WHERE city='".$city."' ";}if($_GET["state"]) {if($SQL != $SQLTEST){$state=$_GET["state"];$SQL =" $SQL AND state='".$state."' ";}else{$state=$_GET["state"];$SQL =" $SQL WHERE state='".$state."' ";}}if($_GET["zipcode"]) {if($SQL!=$SQLTEST){$zipcode=$_GET["zipcode"];$SQL =" $SQL AND zipcode='".$zipcode."' ";}else{$zipcode=$_GET["zipcode"];$SQL =" $SQL WHERE zipcode='".$zipcode."' ";}}$pricemin=$_GET["pricemin"];$pricemax=$_GET["pricemax"];if($pricemax=="1")$pricemax="99999999999999";if($_GET["pricemin"]||$pricemax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND price BETWEEN ".$pricemin." AND ".$pricemax." ";}else{$SQL =" $SQL WHERE price BETWEEN ".$pricemin." AND ".$pricemax." ";}}//100$bathsmin=$_GET["bathsmin"];$bathsmax=$_GET["bathsmax"];if($bathsmax="1")$bathsmax="99999999999999";if($_GET["bathsmin"]||$bathsmax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND baths BETWEEN ".$bathsmin." AND ".$bathsmax." ";}else{$SQL =" $SQL WHERE baths BETWEEN ".$bathsmin." AND ".$bathsmax." ";}}$bedroomsmin=$_GET["bedroomsmin"];$bedroomsmax=$_GET["bedroomsmax"];if($bedroomsmax="1")$bedroomsmax="99999999999999";if($_GET["bedroomsmin"]||$bedroomsmax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND bedrooms BETWEEN ".$bedroomsmin." AND ".$bedroomsmax." ";}else{$SQL =" $SQL WHERE bedrooms BETWEEN ".$bedroomsmin." AND ".$bedroomsmax." ";}}if($_GET["county"]) {if($SQL!=$SQLTEST){$county=$_GET["county"];$SQL =" $SQL AND county='".$county."' ";}else{$county=$_GET["county"];$SQL =" $SQL WHERE county='".$county."' ";}}if($_GET["buyorlease"]) {if($SQL!=$SQLTEST){$buyorlease=$_GET["buyorlease"];$SQL =" $SQL AND buyorlease='".$buyorlease."' ";}else{$buyorlease=$_GET["buyorlease"];$SQL =" $SQL WHERE buyorlease='".$buyorlease."' ";}}if($_GET["typeofprop"]) {if($SQL!=$SQLTEST){$typeofprop=$_GET["typeofprop"];$SQL =" $SQL AND typeofprop='".$typeofprop."' ";}else{$typeofprop=$_GET["typeofprop"];$SQL =" $SQL WHERE typeofprop='".$typeofprop."' ";}}$con = mysql_connect(***********);if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("realestate", $con);$result = mysql_query($SQL);echo "<table border='5'> <tr> <th>Picture</th> <th><a href=\"resultssort.php?sort=1&SQL=$SQL\">Price</a></th> <th><a href=\"resultssort.php?sort=2&SQL=$SQL\">Baths</a></th> <th><a href=\"resultssort.php?sort=3&SQL=$SQL\">Bedrooms</a></th> <th>State</th> <th>City</th> <th><a href=\"resultssort.php?sort=4&SQL=$SQL\">Square Feet</a></th> </tr>";while($row = mysql_fetch_array($result)) { $accountnum=$row['accountnum']; echo "<tr>"; echo '<td><a href="descrip.php?accountnum='.$accountnum.'"> <img src="images/'.$row['imagename'].'" width="75" height="75"></a> </td>'; echo "<td>" . $row['price'] . "</td>"; echo "<td>" . $row['baths'] . "</td>"; echo "<td>" . $row['bedrooms'] . "</td>"; echo "<td>" . $row['state'] . "</td>"; echo "<td>" . $row['city'] . "</td>"; echo "<td>" . $row['squarefeet'] . "</td>"; echo "</tr>"; }echo "</table>";if(mysql_num_rows($result) == 0)ECHO "<h3>NO MATCHES FOUND</h3>";mysql_close($con);?></body></html>
-
sorry i havnt responded in a while i got grounded from the internet well i figured out that for some reason when i ftped the code to the server i was using for some reason it didnt go through. and about the search engine its nine miles of if statements if you want the code just ask
-
im trying to make a link that redirect u to a ip address<a href="http://69.92.201.75">http://69.92.201.75</a>when i do this i get this errorNot FoundThe requested URL /web/ohs/bpa/webpage/69.92.201.75 was not found on this server.
-
yea i was fearing that
-
in IE the hover stuff i wrote doesnt work in firefox it works fine /**************** Table stuff ****************/#itsthetable { font: 12px Verdana, sans-serif;}a, a:visited { color: white; text-decoration: none; display: block;}caption, th, td { vertical-align: top; text-align: left;}table caption, th, tfoot td { font-weight: normal; color: white;}table caption { background-color: red; padding: 8px;}table { border-spacing: 0; width: 650px; background-color: #333333;}td, th { padding: 8px;}thead th { background-color: white; border-bottom: 1px solid red; color: red;}tfoot th, tfoot td { background-color: white; border-top: 1px solid red; border-bottom: 15px solid red; color: red;}tbody td, tbody th { color: red;}tbody th a { color: white;}tbody tr:hover td, tbody tr:hover td a, tbody tr:hover th a { color: white; background-color: red;}
-
im not sure if this is possible is what i want to do is have the entire row of a table be a link to a different page. i see no reason why this cant be done since you can you the action listner "hover" to highlight the row when you mouse over it
-
ok i didnt just put that on this form to demoralize yall with my superior programing skills. i figured that was the how you did it but for some reason its not working
-
ok im trying to make a table in which every row is a link to a different pagehere is my code mysql_select_db("realestate", $con);$result = mysql_query($SQL);echo "<table border='5'> <tr> <th>Picture</th> <th>Address</th> <th>Price</th> <th>Baths</th> <th>Bedrooms</th> <th>State</th> <th>City</th> <th>Square Feet</th> <th>County</th> <th>Year Built</th> <th>Buy or Lease</th> </tr>";while($row = mysql_fetch_array($result)) { $accountnum=$row['accountnum']; echo '<a href="descrip.php?accountnum='.$accountnum.'">'; echo "<tr>"; echo '<td> <img src="images/'.$row['imagename'].'" width="75" height="75"> </td>'; echo "<td>" . $row['address'] . "</td>"; echo "<td>" . $row['price'] . "</td>"; echo "<td>" . $row['baths'] . "</td>"; echo "<td>" . $row['bedrooms'] . "</td>"; echo "<td>" . $row['state'] . "</td>"; echo "<td>" . $row['city'] . "</td>"; echo "<td>" . $row['squarefeet'] . "</td>"; echo "<td>" . $row['county'] . "</td>"; echo "<td>" . $row['yearbuilt'] . "</td>"; echo "<td>" . $row['buyorlease'] . "</td>"; echo "</tr>"; echo "</a>"; }echo "</table>";
-
i assume you do this in cssi want to make my website look like thishttp://www.bluechiphiltonhead.com/i want to make it to where when you resize the window instead of just making blank space to the right of the written stuff but do it evenly on both the left and right side the page i gave you is a pretty good example
-
<link rel="stylesheet" href="CSS.css" type="text/css" />
-
ok im a couple of days im going to be reformating my hard drive basicly the only think i want to keep is my databases. basicly all i need to know is if i can export then into a cd and then after i get everything back up and running to be able to import them back onto the mysql serverforgot to tell you that im using phpmyadmin if that any help
-
yes its linked and everything. like i sayed it all works in IE and firefox except in IE the side bar is not fixed
-
Application Design (150points)• Maintains state throughsessions with and withoutcookies• Encrypts highly sensitiveuser information• Forms fields are validatedbefore submission• Conditional logic is used toqualify SQL queries beforeexecuting them• Code is reused wherepossible (through includes,templates, or classes)• Code is original and not apre-built application1-71-71-71-71-71-78-158-158-158-158-158-1516-2216-2216-2216-2216-2216-2223-2523-2523-2523-2523-2523-25Administration (70 points)• Appropriate Web-basedreports are generated• Administrator has the abilityto add, modify and deletedata through a passwordprotected Web interface1-91-910-1810-1819-2719-2728-3528-35Grammar, Spelling,Punctuation, and Usage(25 points)0(3+ errors)5(2 errors)15(1 error)25(0 errors)TOTAL TECHNICAL POINTSSUMMARY TOTALS:Judge #1 (355 points maximum)FINAL TOTAL TECHNICALPOINTS(Subtotal divided by # of judges)Judge #2 (355 points maximum)Subtotalthat looks bad it was in a pdf file so thats as good as it get unless you want the entire file
-
well yea its just there is a regial state and national levels the regional judges arnt going to know what a tag is os basicly thats out of the question until state and then i and add it then so im still going to loose the points
-
i need me side bar to be fix on the page it wrks fine in firefox but not in IEhere is my CSS /**************** Page and tag styles ****************/body{margin:0; padding:0; color:#303030; background:#fafafa url(img/bodybg.gif) top left repeat-y; font:76% Verdana,Tahoma,sans-serif;}table{background-color:#ff8080;}ul{list-style:circle; margin:15px 0 20px 0; font-size:0.9em;}li{margin:0 0 8px 25px;}a{color:#d85d5d; font-weight:bold; text-decoration:none;}a:hover{color:#505050; text-decoration:underline;}img{float:none; margin:0 15px 15px 0; padding:1px; background:#ffffff; border:0px; solid #d0d0d0; border-style:none}a img{border-color:#d85d5d;}a img:hover{background:#d85d5d; border-color:#d85d5d;}/**************** Sidebar area styles ****************/#sidebar{position:absolute; top:0; left:0; width:220px; height:100%; overflow:hidden; background:#e0e0e0 url(img/sidebarbg.gif) top right repeat-y; text-align:right;}body > #sidebar{position:fixed;}#sidebar h1{margin:20px 18px 0 5px; color:#d85d5d; font-size:1.6em; letter-spacing:-2px; text-align:right;}#sidebar h2, #sidebar h3{margin:0 20px 18px 5px; color:#808080; font-size:1.1em; font-weight:bold; letter-spacing:-1px; text-align:right;}#sidebar h3{margin:20px 18px 4px 5px; color:#606060;}#sidebar p{margin:0 20px 18px 5px; color:#606060; font-size:0.8em;}#sidebar a{color:#808080}/**************** Navigation menu styles ****************/#menu a{display:block; width:202px; padding:5px 18px 5px 0; color:#606060; background:#e0e0e0 url(img/sidebarbg.gif) top right repeat-y; font-size:1.8em; font-weight:normal; text-decoration:none; letter-spacing:-2px;}#menu a:hover {color:#303030; background:#f0f0f0 url(img/sidebarbg.gif) top right repeat-y;}#menu a.active{padding:5px 18px 5px 0; background:#fafafa; border-top:2px solid #c0c0c0; border-bottom:2px solid #c0c0c0;}#menu a.active:hover{color:#505050; background:#fafafa;}/**************** Content area styles ****************/#content{width:520px; margin:0 0 0 240px; padding:20px 0; background:#fafafa;}#content p{margin:0 0 20px 0; line-height:1.5em;text-align:left;}#content h1{margin:0; color:#d85d5d; font-size:4em; letter-spacing:-5px; text-align:center;}#content h2{margin:0; color:#808080; font-weight:normal; font-size:2.5em; letter-spacing:-2px; text-align:center;}#content h3{clear:both; margin:30px 0 10px 0; color:#d85d5d; font-weight:normal; font-size: 2em; letter-spacing:-2px;text-align:center;}#content h4{color:#d85d5d; text-align:center;}#content h5{color:#d85d5d; text-align:center;}#content h6{color:#d85d5d; text-align:center;}
-
im doing a contest im witch we have to design a website. i have the website done and for it being my first on i though it was pretty good any how i was looking over the judges rubric and its sayed that all "forms are validated" i have no clue what that so i may be in the wrong forum but if someone could lead me in the righ direction on what that is and how to do it i would be very thankful
-
iv post this twice in php with no responces so im posting it here to see if yall can help me$accountnum=$row['accountnum'];echo '<center>';echo '<a href="descrip.php?accountnum=$accountnum">';im trying to send a varible through to descrip.php. instead of sending the value of $accountnum is sending the physical sting "$accountnum" im not sure how to fix this
-
Description:<br> <TEXTAREA name="description" rows=10 cols=40>Please type description here...</TEXTAREA><br><br>
-
<textarea rows="10" cols="50">Address: <input type="text"name="Address"size="30"><br><br></textarea>so like this
-
Address: <input type="text"name="Address"size="30"><br><br>i know this makes a line for the user to input text what i need to know how to do is make a box basicly like the one im typing it to make this post just not quite as big.
-
$con = mysql_connect("localhost","root","*******");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("realestate", $con);$result = mysql_query($SQL);while($row = mysql_fetch_array($result)) { echo '<center>'; echo '<a href="descrip.php">'; echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">'; echo '</center>'; echo '<br>'; echo '<br>'; echo "<table border='5'bgcolor='#ff8080'> <tr> <th>Address</th> <th>Price</th> <th>Baths</th> <th>Bedrooms</th> <th>State</th> <th>City</th> <th>Square Feet</th> <th>County</th> <th>Year Built</th> <th>Buy or Lease</th> </tr>"; echo "<tr>"; echo "<td>" . $row['address'] . "</td>"; echo "<td>" . $row['price'] . "</td>"; echo "<td>" . $row['baths'] . "</td>"; echo "<td>" . $row['bedrooms'] . "</td>"; echo "<td>" . $row['state'] . "</td>"; echo "<td>" . $row['city'] . "</td>"; echo "<td>" . $row['squarefeet'] . "</td>"; echo "<td>" . $row['county'] . "</td>"; echo "<td>" . $row['yearbuilt'] . "</td>"; echo "<td>" . $row['buyorlease'] . "</td>"; echo "</tr>"; echo "</table>"; echo "<br>"; echo "<br>"; }if(mysql_num_rows($result) == 0)ECHO "<h3>NO MATCHES FOUND</h3>";mysql_close($con);?>this out puts tables and a pic link for how ever many search results where found what im trying to to is have it to where when you click on the pic it take you to a new page that has a detailed description of the house. the problem is im not sure how to pick the row out of the table that corresponds to the pic that you clicked on.
-
that not the part im having trouble with echo '<a href="descrip.php">'; echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">';what would i add to this transfer the varible over i know that this is probly the dumbest question ever but i never realy learned html i just jumped into phpecho '<a href="descrip.php?accountnum=1">';echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">';and then $_GET["accountnum"];i think that might be it
-
im not sure if that would be the easyest way. what i was thinking the easyest way t do it is to sent a variblle to the description page. that varible wold contain i piece of info from the same table as the decription is coming from such as an account number and the run basicly this quieryselect * from estate where accountnum='the varible we sent through' then just echo the description.im just not sure if its possible to do that but if it is can someone tell me howso basicly the same thing a form would do with out the form
-
not realy sure where to put this topic pretty sure this is the right placehere is what im trying to do when you click on an image of a house i want it to take me to a new page that has a description the description is store in a database. i dont want to have to make a new page for every house in the database. if you need any more information just ask.