[Alphabetical Ordering from a database]

THANK YOU!!!

 

@jl5501 You ROCK!!!

 

my deepest thanks go out to you 

[Alphabetical Ordering from a database]

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

[Alphabetical Ordering from a database]

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

[PHP page forward with a form]

@oni-kun thank you thank you... i hadn't even thought of that

 

that should work perfect

 

thanks again

[PHP page forward with a form]

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

[MySQL Database Question]

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

[MySQL Database Question]

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

[[SOLVED] Really easy one i would think]

Thank you soooo much 

[[SOLVED] Really easy one i would think]

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

 

 

[PHP contact page help]

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

[PHP contact page 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>

[Set Nav Help Please]

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

 

[base64_encode]

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']; ?>

 

 

[base64_encode]

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