Travist6983

THANK YOU!!! @jl5501 You ROCK!!! my deepest thanks go out to you

I kinda thought that was what was causing the problem but how do you correctly write the statement i am not really a php programmer but figured i would give this a try to eliminate some work from my co-workers. basically what i was trying to do was the order the clients alphabetically by last name instead of by there database ID this was the old statement that i am trying to edit $query = "SELECT lastName, id, firstName, email FROM userAccounts WHERE assignedAgent = ".$_SESSION['agent']['agentID']; and you obviously can see the new statement that i created from reading a bunch of forum posts. Any help would be greatly appreciated thanks Travis

I am trying to figure out how to alphabetize a client list that draws from my data base here is the code i am playing with if any one could help nudge me in the right direction i would be forever grateful $query = "SELECT id, firstName, email, lastName, LEFT(lastName, 1) AS first_char FROM userAccounts WHERE UPPER(LEFT(lastName, 1)) BETWEEN 'A' AND 'Z' OR LEFT(lastName, 1) BETWEEN '0' AND '9' ORDER BY lastName WHERE assignedAgent = ".$_SESSION['agent']['agentID']; $clients = mysql_query($query); $current_char = ''; if( mysql_num_rows($clients) > 0 ) { while( $client = mysql_fetch_array($clients) ) { if ($client['first_char'] != $current_char) { $current_char = $client['first_char']; echo '<br />' . strtoupper($current_char) . '<br />-----<br />'; } echo "<tr>"; echo " <td>".$current_char['lastName']."</td>"; echo " <td>".$client['firstName']."</td>"; echo " <td>".$client['email']."</td>"; echo " <td>".$client['group']."</td>"; echo " <td align='center'><a href=\"editClient.php?clientID=".$client['id']."\">Edit Client</a></td>"; //echo " <td><a href='clientWebforms.php?clientID=".$client['id']."'>View Webforms</a></td>"; echo "</tr>"; } } else echo "<tr><td colspan='3' align='center'><font color='red'>You have no clients assigned! To have your clients assigned to you search for them using the 'Find Clients' button on the left navigation bar.</font></td>"; Thanks for any and all comments Travis

@oni-kun thank you thank you... i hadn't even thought of that that should work perfect thanks again

ok i am trying to create city pages such as birmingham.php that all it does is forward to the search result for birmingham we are a real estate company that is trying to get some better SEO with all our surrounding citys... our search results page land on listings.php i have done this to our footer of each page with this form action <form name="Birmingham" action="listings.php" method="post"> <input type="hidden" name="searchType" value="custom"> <input type="hidden" name="newSearch" value="true"> <input type="hidden" name="table" value="rs"> <input type="hidden" name="city" value="2192"> <input type="hidden" name="beforeListPrice" value="0"> <input type="hidden" name="afterListPrice" value="any"> <input type="hidden" name="featuredOnly" value="false"> </form> <a href="javascript:void[0];" onclick="document.forms['Birmingham'].submit(); return false;">Birmingham</a> is it possible to use this form action in like a PHP header forward? <?php header("location: javascript:void[0]; onclick="document.forms['Birmingham'].submit(); return false;""); ?> Any suggestions on this would be a great help Thank You

i truly appreciate you helping me but i cant seem to get it to work maybe this would help you more a bit to HELP me... Shown in red below is where we bring the photo into the page... i tried using what u suggested as <div id="PhotoArea" name="PhotoArea"> <img src="<?php echo $firstphoto; ?>" name="ImageFull" border="1" width="800" height="600" /> i tried using what u suggested as... <div id="PhotoArea" name="PhotoArea"> <img src="<?php $str = '$firstURL'; $a = explode('&', $str); $a[8] = "w=800"; $a[9] = "h=600"; $str = join('&', $a); echo $str; ?>" name="ImageFull" border="1" width="800" height="600" /> I am so not a php guy so any more help you can give me would be great thanks so much T

Ok not exactly sure if this is where i should ask this question but here goes We get an IDX feed everynight which feeds our listing detail page and also picture urls like this one... http://attach.realcomponline.com/?Path=PROPERTY/9AD81/D066A/9AD81ED066A848/76889EEA7BB4E6.jpg&g=100&sp=0&l=0&t=0&r=10000&b=10000&o=0&w=320&h=240 I would like to change the end of the string to be... http://attach.realcomponline.com/?Path=PROPERTY/9AD81/D066A/9AD81ED066A848/76889EEA7BB4E6.jpg&g=100&sp=0&l=0&t=0&r=10000&b=10000&o=0&w=800&h=600 to make the pictures bigger we have talked to our IDX feed and they will NOT change the string to have the bigger pictures but if you look at both urls the bigger pictures do look fine not pixelated any help or suggestions would be great thanks a million

Thank you soooo much

ok so i am new to PHP... I am not sure i will be able to explain this great but here goes i am trying to do an <?php include("First-Time-Buyers2.php");?> but the table it is in i want the height to be 600 and no bigger so that the content from First-Time-Buyers2.php doesn't make the page run on and on i want the whole page to fit in a 1024X768 screen with no scrolling except the contact from First-Time-Buyers2.php... i know how to accomplish this with an iframe but my boss wants it be an includes can anyone help? thanks T

as i said i am not good with php and bought a tamplate and my options for the contact form were asp or php and i couldnt get either of them to work so am i suppose to put that here mail($_REQUEST['myemail@mydomain.com'], $subject, " cause that looks different then <?php mail('youremail@domain.com', 'My Subject', 'My Message'); ?> thanks for the help

Ok i dont know anything about php but i am alright with html but anyways i bought a website template that i have customized but it is coming down to the contact page included in the template was a contact.php file that looks like this below but i dont know what to do to get it to send an email CAN ANYONE HELP THIS extreme novice? <? Error_Reporting(E_ALL & ~E_NOTICE); while ($request = current($_REQUEST)) { if (key($_REQUEST)!='recipient') { $pre_array=split ("&777&", $request); $post_vars[key($_REQUEST)][0]=$pre_array[0]; $post_vars[key($_REQUEST)][1]=$pre_array[1]; } next($_REQUEST); } reset($post_vars); $subject="From ".$post_vars['your_name'][0] ; $headers= "From: ".$post_vars['your_email'][0] ."\n"; $headers.='Content-type: text/html; charset=iso-8859-1'; $message=''; while ($mess = current($post_vars)) { if ((key($post_vars)!="i") && (key($post_vars)!="your_email") && (key($post_vars)!="your_name")) { $message.="<strong>".$mess[1]."</strong> ".$mess[0]."<br>"; } next($post_vars); } mail($_REQUEST['recipient'], $subject, " <html> <head> <title>Contact letter</title> </head> <body> <br> ".$message." </body> </html>" , $headers); echo ("Your message was successfully sent!"); ?> <script> resizeTo(300, 300); </script>

Ok so i am sooo confused on my code where am i going wrong <div class="navBarItem" <?php if( $setNav != "faq" ) echo "onMouseOver=\"this.className='navBarItemHover';\" onMouseOut=\"this.className='navBarItem';\"";?>><a href="faq.php">FAQ</a><br> <?php if( $setNav == "faq" ) { echo " <a href='faq.php'>Gown Shopping</a><br>"; echo " <a href='faq2.php'>The Appointment</a><br>"; echo " <a href='faq3.php'>Ordering the Gown</a><br>"; echo " <a href='faq4.php'>Fittings & Alterations</a><br>"; echo " <a href='faq5.php'>Other Services</a><br>"; } ?> </div> there is my code but it is saying undefiend variable but there are defiend arent they i am trying to get it so when you click on Faq it will then make my menu bigger with sub catagorize under faq any help would be greatly appreciated

PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\Inetpub\wwwroot\century21today.com\team\agentTools2.php on line 117 ...this is the error i am getting with that previous code i know the problem lies in the area highlighted in red <?php $str = 'REALCOMP:' echo $agentInfo['mlsnAgentID']; ?>

Ok i am kinda new to PHP and need some help i am trying to accomplish is in the first string below i need $str to include 'realcomp:<and our agents MLS ID> the MLS ID is coming from our database where REALCOMP is just the word or text i know the string at the bottom will work if i manually put in the <?php $str = 'REALCOMP:<Manually putting in MLS ID here> but i need it to come from our database <?php $str = 'REALCOMP:' echo $agentInfo['mlsnAgentID']; ?> <a href="http://we.showingdesk.com/Redirector.aspx?TYPE=1&ID1=REALCOMP&ID2=<?php echo $agentInfo['mlsnAgentID']; ?>&SIG=<?php echo base64_encode($str); ?>&KEY=900499-48334:108" target="_blank"><img src="images/logos/ShowingDeskWE.jpg" width="190" height="46" border="0"></a> Please help i am sooooo stuck Thanks