proctk

I also found this but it return no results I played around with INTERVAL to make sure there was dates that would result in a positive query [code=php:0] $get_childdob = mysql_query("SELECT owner_id, childdob FROM children WHERE childdob Between CURDATE() AND DATE_ADD(CURDATE(),INTERVAL 366 DAY)")or die (mysql_error()); [/code]

thank you for the update, it gave it a try and its no producing any results. I changed the +150 to 365 I found the below code that gets the values but I don't know how to change it to show birthdays in x days [code=php:0] $get_childdob = mysql_query("SELECT owner_id,childdob,IF( DAYOFYEAR(childdob) < DAYOFYEAR(CURDATE()), DAYOFYEAR(childdob)+366,DAYOFYEAR(childdob) )as birthdayofyear FROM children ORDER BY birthdayofyear")or die (mysql_error()); [/code]

below is what I have this far and it retuns nothing any idea why [code=php:0] include '../config/db.php'; $today = strtotime("Now"); $leadDate = strtotime("+350 day", $today); $get_childdob = mysql_query("SELECT * FROM children WHERE childdob BETWEEN CURDATE() AND '$leaddate'")or die (mysql_error()); while($row_get_childdob = mysql_fetch_assoc($get_childdob)){ $name = $row_get_childdob['childfirstname']; echo $name; } [/code]

HI, I'm trying to find script to run a query that will list all birthdays within 20 days. the date is stored in a column DOB in a mysql table as yyyy-mm-dd any help is great

Hi Below is code that I'm trying to use to display all entrys found in a table and sum the values of a column The problem is its not showing all the enterys when I click the letters the enterys show but it will not show all. any help is great [code=php:0] <div id="twoColumnLeft"> <?php include '../leftlinks.php'; ?> </div> <!-- InstanceEndEditable --><!-- InstanceBeginEditable name="EditRegion4" --> <div id="twoColumnRight">   <?php include ('../config/db.php'); $username = $_SESSION['username']; for ($x=65; $x<=90; ++$x):         echo '        <a href="users.php?index=' .chr($x). '">' .chr($x). "</a>\n";     endfor;   echo '        <a href="users.php?index=*">ALL'."</a>\n"; echo '<br />'; $index = strtoupper(substr($_GET['index'],0,1)); if($index != '*' && (ord($index) < 65 || 90 < ord($index))) $index = '*'; //if $index is *, then we replace with %, otherwise, we concat % to the end of index. $index = ($index == '*') ? '%' : $index.'%'; $query = ("Select users.last_name, users.first_name, users.username, users.user_level, users.signup_date, users.last_login, users.space, images.size, IFNULL(sum(images.size),0) as totalSize From `users`,images Where `last_name` Like '{$index}' group by images.owner_id = users.user_id"); $result=mysql_query($query)or die("Get Search results Error: ".mysql_error()); if(mysql_num_rows($result) >0) { ?> <table class='columntable'> <tr> <th class='tableheader' colspan='8'>Registered Users</th><br> </tr> <td class='rowLeft'><b>Change</b></td> <td class='rowLeft'><b>Last Name</b></td> <td class='rowLeft'><b>First Name</b></td> <td class='rowLeft'><b>User Name</b></td> <td class='rowLeft'><b>User Level</b></td> <td class='rowLeft'><b>Last Login</b></td> <td class='rowLeft'><b>Disk Space</b></td> <td class='rowRight'><b>Space Used</b></td> </tr> <?php while($r=mysql_fetch_assoc($result)) { ?>   <tr> <td class='rowLeft'><a href='manageUser.php?do=$id'>Edit</a></td>   <td class='rowLeft'><?php echo $r['last_name']; ?></td>   <td class='rowLeft'><?php echo $r['first_name']; ?></td>   <td class='rowLeft'><?php echo $r['username']; ?></td>   <td class='rowLeft'><?php echo $r['user_level']; ?></td>   <td class='rowLeft' title="<?php echo 'Sign up date: '.$r['signup_date']; ?>"><?php echo $r['last_login']; ?></td>   <td class='rowLeft'><?php echo $r['space']; ?></td>   <td class='rowRight'><?php echo $row_image_owner['totalSize']; ?></td> <?php  }?>     </tr> </table> <?php  }?>   </div> [/code]

I use wampp and my code works on there, only when I up load it do I run ito problems

anyone recomend a web hosting company

yes

can someone please help me correct this echo'<p>Vender:'.'<a href=http://$row_get_gifts['vender_webpage']" >$row_get_gifts['vender']</a></p>';

how would I figurethis out. my hosting company is domaindirect.

I get this error, thank you for showing me how to turn that feature on Fatal error: Call to undefined function: gregoriantojd() in /services/webpages/f/a/familyclick.ca/public/familyConfig.php on line 6 all my date formats are  Y,m,d

Below is the complet function and the string of code that I'm trying to use to calculate a persons age. It not wanting on my web server, for some reason when it gets to the point to exicute the string to calcualte the age the code stops runing. everythingis displayed until this point but nothing after.  there are no error message shown either. Any idea why this is happening. Thank you [code=php:0] <? function dateDiff($dformat, $endDate, $beginDate) {           $date_parts1=explode($dformat, $beginDate);           $date_parts2=explode($dformat, $endDate);           $start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]);           $end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]);           return $end_date - $start_date; } ?> [/code] [code=php:0] $ownerAge = floor(dateDiff("-", date("Y-m-d"), $dob)/365); [/code]

HI I'm trying to set the thum nails in the thumb nailes in a table, I'm having a hard time piecing the syntax together. can someone help me through it thatnak you [code=php:0] <table> <tr> <td> <a HREF =\"getImage.php?<?php  echo Photo_id=$row->Photo_id\; ?>"> <IMG SRC=\"getImage.php?<?php  echo Photo_id=$row->Photo_id\; ?>"  width=75 Height=75 alt=<?php echo $row->name>; ?><br> <a><?php echo $row->name; ?></a> &nbsp; <a href=\"deletephoto.php?<?php Photo_id=$row->Photo_id\; ?>" title='Delete Image'>Delete</a></div> </td> </tr> </table> [/code]

Thank you for the help. I have tried doing a seperate query for each table, however I',m having a hard time gettng ech budd_id to loop through each table correctly How i have structed this [code=php:0] $get_buddy_id =mysql_query(SELECT * FROM buddylinks WHERE owner_id = '$user_id'); while($row = mysql_fetch_assoc($get_buddy_id){ //Code to query each database goes hear and code to create table } [/code] the problem is this creates multiple tables and makes a mess of the dispaly.  The issue is the while loop getting the buddy_ids.  I have not figured out how to fixed that. this will be day three toying with this for me thank you for any help (what I',m trying to do seems easy, I'm probley not doing a good job explaining it :)

This problem has been hanging me up for two days. I changed my codee to [code=php:0]       <?php      $buddy_calendar = mysql_query("SELECT * FROM buddylink b, users u, calendar c, children C, parent p, sibling s WHERE b.owner_id = '$user_id' AND u.user_id = b.buddy_id AND c.userid = b.buddy_id AND C.owner_id = b.buddy_id AND p.owner_id = b.buddy_id AND s.owner_id = b.buddy_id ORDER by u.user_id;") or die ("Error: getting buddies user_id:<br>\n" .mysql_error()); while($row_buddy_info = mysql_fetch_assoc($buddy_calendar)){ echo $row_buddy_info['first_name']; } ?> [/code] nothing really changes it repeats the value over and over but less then in the first code that I posted

I just did some digging on what DISTINCT does. thank you for shating that, I can probably use it else where but will not help my problem. is it possible to assign the results of my while statement to an array value that can be used out side the apprentices

thanks for the reply. there will be many columns from which I need information  and I'm not sure what DISTINCT is, I'll have to do some seaching, I'm 90% confident that the proplem lys with getting the buddy_id and how it looks throygh the query,

below is code that I'm trying to use to get data from the listed tables and then pull the data and display some of ithe information in a table. background I have a table where people add people to there buddy list. buddies or registered users add information to their profile and when someone adds a user to  their buddy list then they can see certain pieces of information.  my biggest problem is looping through the buddy list and using each buddy id to search through the tables with their information attached. The code below echoes the the value but repeats the same value many times. thank you for any help complete code [code=php:0]       <?php    $get_buddies_id = mysql_query("SELECT * FROM buddylink WHERE owner_id ='$user_id'") or die ("Error: getting buddies user_id" .mysql_error()); while ($id_row = mysql_fetch_assoc($get_buddies_id)){ $buddy_id = $id_row['buddy_id'];    $buddy_calendar = mysql_query(" SELECT *   FROM `users` AS u INNER JOIN `calendar` AS c ON u.user_id = c.userid INNER JOIN `children` AS C ON u.user_id = C.owner_id INNER JOIN `parent`  AS p ON u.user_id = p.owner_id INNER JOIN `sibling`  AS s ON u.user_id = s.owner_id WHERE u.user_id = '{$buddy_id}' ORDER by u.user_id; ") or die ("Error: getting buddies user_id:<br>\n" .mysql_error()); while ($row_buddy_info = mysql_fetch_array($buddy_calendar)) echo $row_buddy_info['first_name']; } } ?> [/code]

Hi I use the below function to calculate the years between two years.  Everything works fine on my test server which uses mysql 5 and php 5 For some reason its not working on my web server, which uses verion 4.1php and 4.0.27 mysql. [code=php:0] <? function dateDiff($dformat, $endDate, $beginDate) {           $date_parts1=explode($dformat, $beginDate);           $date_parts2=explode($dformat, $endDate);           $start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]);           $end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]);           return $end_date - $start_date; } ?> [/code] statement to ge the value [code=php:0] $age = round(dateDiff("-",date("Y-m-d", time()), $dob)/365, 0); [/code] my page stops once it hits this line of code. no error messages are given.  I confirmed the error is with this because when I comment it out it works fine any help is grerwta

Not shure what you mean, it appears that the order of my code is the issue, this is blowing my mind. I had everything working great on my test server (XAMPP) and when I uploaded my webpage to my webhosting company(Domain Direct) this is when everything stoped working properly.

If it helps here is the info to loggin to my webpage and see what the code is doing. [URL=http://www.familyclick.ca]familyclick.ca[/URL] Click the family details menu option.  There is information setup of this user that should be dispayed. username: testUser password: f40h4tt6

Hi, I changed code to show where I'm currently at

because of the size I thought that it would be easier to post a file [code=php:0] <?php include 'db.php'; $user_id = $_SESSION['user_id']; echo $owner_id; //-Owner Profile-------------------------------------------------------------------------------------- $ownerQuery = "SELECT * FROM users WHERE user_id = '$owner_id'"; $ownerResult = mysql_query($ownerQuery)or die("Get Search results Error: ".mysql_error()); while($ownerR = mysql_fetch_assoc($ownerResult)) { $firstname = $ownerR['first_name']; $lastname = $ownerR['last_name']; $street_address = $ownerR['street_address']; $post_office_box = $ownerR['post_office_box']; $city = $ownerR['city']; $province = $ownerR['province']; $postal = $ownerR['postal']; $home_phone = $ownerR['home_phone']; $email_address = $ownerR['email_address']; $dob = $ownerR['DOB']; $spousefirstname = $ownerR['spousefirstname']; $spouselastname = $ownerR['spouselastname']; $currentDate = date('Y-m-d'); $age = floor(dateDiff("-", date("Y-m-d"), $dob)/365); // Owner Table echo"<table class='displayinfo'>"; echo"<tr>"; echo"<th class='displayhead' colspan='4'>Profile Owner</th><br>"; echo"</tr>"; echo"<tr class='blue'>"; echo"<td class='width'><b>First Name</b></td>"; echo"<td class='adjacent'><b>Last Name</b></td>"; echo"<td class='adjacent'><b>Date of Birth</b></td>"; echo"<td class='adjacent'><b>Age</b></td>"; echo"</tr>";     echo "<tr class='blue'>";   echo "<td class='width'>$firstname</td>";   echo "<td class='adjacent'>$lastname</td>";   echo "<td class='adjacent'>$dob</td>";   echo "<td class='adjacent'>$age</td>";   echo "</tr>" ; } echo "</table>"; echo "<br>"; //-------------------Spouses Information----------------------- if($spousefirstname =="" and $spouselastname =="") { }else{ $spouseQuery = "SELECT * FROM users WHERE user_id = '$owner_id'"; $spouseResult = mysql_query($spouseQuery)or die("Get Search results Error: ".mysql_error()); echo"<table class='displayinfo'>"; echo"<tr>"; echo"<th class='displayhead' colspan='5'>Spouse</th><br>"; echo"</tr>"; echo"<tr>"; echo"<td class='width'><b>First / Last Name</b></td>"; echo"<td class='adjacent'><b>Date of Birth</b></td>"; echo"<td class='adjacent'><b>Age</b></td>"; echo"<td class='adjacent'><b>Email</b></td>"; echo"<td class='adjacent'><b>Photos</b></td>"; echo"</tr>"; while($spouseR = mysql_fetch_assoc($spouseResult)) { $spousefirstname = $spouseR['spousefirstname']; $spouselastname = $SpouseR['spouselastname']; $spousedob = $spouseR['spousedob']; $currentDate = date('Y-m-d'); if(spousedob != ""){ $spouseage = floor(dateDiff("-", date("Y-m-d"), $spousedob)/365); }else{ } //Check If spouse is a registered user, if so offer link to view thier family profile if not display spouses name only $spouse_check = mysql_query("SELECT * FROM users WHERE first_name ='$spousefirstname' AND last_name='$spouselastname' AND DOB = '$spousedob'")or die("Get spouse check Error: ".mysql_error());   $spouseS=mysql_fetch_assoc($spouse_check);     $new_id = $spouseS['user_id'];   $spouseEmail = $spouseS['email_address'];     $spouse_find = mysql_num_rows($spouse_check); if(($spouse_find) == 1) { $spousePerson = "<a href='SearchDetails.php?owner_id=$new_id'>$spousefirstname $spouselastname</a>"; }else{ $spousePerson = $spousefirstname.' ' .$spouselastname; } // check if there found user has a photo ablum $spousePhotoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'")or die("Spouse Photo Error: ".mysql_error()); $sousePhoto_find = mysql_num_rows($spousePhotoCheck);   echo "<tr>";   echo "<td class='width'>$spousePerson</td>"; ;   echo "<td class='adjacent'>$spousedob</td>";   echo "<td class='adjacent'>$spouseage</td>";     // add link if email address found   if($spouseEmail!=""){   echo "<td class='adjacent'><a class='emailBullet' href='sendEmail.php?email=$spouseEmail'><img src='images/bemail.gif' alt='emalBullet'></a></td>";      }else{   echo "<td class='adjacent'></td>";   }   // add link if user has       if($spousePhoto_find >0){   echo "<td class='adjacent'><a class='emailBullet' href='photos/usersPhotoAlbum.php?owner_id=$new_id'><img src='images/camera.jpg' alt='cameraBullet'></a></td>";      }else{   echo "<td class='adjacent'> </td>";   }   echo "</tr>" ; } echo "</table>"; echo "<br>"; } //end spouse data checkS ////---------------------Childrens Information--------------------- $childQuery = "SELECT * FROM Links L, children C WHERE L.User_id = '$owner_id' AND C.child_id = L.child_id"; $childResult = mysql_query($childQuery)or die("Child Search Error: ".mysql_error()); if(mysql_num_rows($childResult) < 1) { // check if data found }else{ // closing else and end echo"<table class='displayinfo'>"; echo"<tr>"; echo"<th class='displayhead' colspan='5'>Children</th><br>"; echo"</tr>"; echo"<tr class='blue'>"; echo"<td class='width'><b>First / Last Name</b></td>"; echo"<td class='adjacent'><b>Date of Birth</b></td>"; echo"<td class='adjacent'><b>Age</b></td>"; echo"<td class='adjacent'><b>Email</b></td>"; echo"<td class='adjacent'><b>Photos</b></td>"; echo"</tr>"; while($childR = mysql_fetch_assoc($childResult)) { $childfirstname = $childR['childfirstname']; $childlastname = $childR['childlastname']; $childdob = $childR['childdob']; if(childdob != ""){ $currentDate = date('Y-m-d'); $childage = floor(dateDiff("-", date("Y-m-d"), $childdob)/365); }else{ } //Check If child is a registered user, if so offer link to view thier family profile if not display childs name only $child_check = mysql_query("SELECT * FROM users WHERE first_name ='$childfirstname' AND last_name='$childlastname' AND DOB = '$childdob'")or die("Child Registered Error: ".mysql_error());   $childS = mysql_fetch_assoc($child_check);     $new_id = $childS['user_id'];   $childEmail = $childS['email_address'];   $child_find = mysql_num_rows($child_check); if(($child_find) == 1) { $childPerson = "<a href='SearchDetails.php?owner_id=$new_id'>$childfirstname $childlastname</a>"; }else{ $childPerson = $childfirstname.' ' .$childlastname; } $childPhotoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'")or die("Child PhotoCheck Error: ".mysql_error()); $childPhoto_find = mysql_num_rows($childPhotoCheck);     echo "<tr>";   echo "<td class='width'>$childPerson</td>";   echo "<td class='adjacent'>$childdob</td>";   echo "<td class='adjacent'>$childage</td>";   if($childEmail!="") {   echo "<td class='adjacent'><a class='emailBullet' href='sendEmail.php?email=$childEmail'><img    src='images/bemail.gif' alt='emalBullet'></a></td>";   }else{   echo "<td class='adjacent'></td>";   }         // add link if user has       if($childPhoto_find >0){   echo "<td class='adjacent'><a class='emailBullet' href='photos/usersPhotoAlbum.php?owner_id=$new_id'><img src='images/camera.jpg' alt='cameraBullet'></a></td>";      }else{   echo "<td class='adjacent'></td>";   }   echo "</tr>"; } echo "</table>"; echo "<br>"; } //end $result check //-----------------------------Parents Information------------------------ $parentQuery = "SELECT * FROM Links L, parent C WHERE L.User_id = '$owner_id' AND C.parent_id = L.parent_id"; $parentResult = mysql_query($parentQuery)or die("Get Search results Error: ".mysql_error()); if(mysql_num_rows($parentResult) < 1) { // check if data found }else{ // closing else and end echo"<table class='displayinfo'>"; echo"<tr>"; echo"<th class='displayhead' colspan='5'>Parents</th><br>"; echo"</tr>"; echo"<tr class='blue'>"; echo"<td class='width'><b>First / Last Name</b></td>"; echo"<td class='adjacent'><b>Date of Birth</b></td>"; echo"<td class='adjacent'><b>Age</b></td>"; echo"<td class='adjacent'><b>Email</b></td>"; echo"<td class='adjacent'><b>Photos</b></td>"; echo"</tr>"; while($parentR = mysql_fetch_assoc($ParentResult)) { $parentfirstname = $parentR['parentfirstname']; $parentlastname = $parentR['parentlastname']; $parentdob = $parentR['parentdob']; $currentDate = date('Y-m-d'); if(parentdob != ""){ $parentage = floor(dateDiff("-", date("Y-m-d"), $parentdob)/365); }else{ } /*// check if there found user has a photo ablum $photoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'"); $photo_find = mysql_num_rows($photoCheck);*/ //Check If parent is a registered user, if so offer link to view thier family profile if not display parents name only $parent_check = mysql_query("SELECT * FROM users WHERE first_name ='$parentfirstname' AND last_name='$parentlastname' AND DOB = '$parentdob'")or die("Parent Register Check Error: ".mysql_error()); ;   $s=mysql_fetch_assoc($parent_check);     $new_id = $s['user_id'];   $parentEmail = $s['email_address'];     $parent_find = mysql_num_rows($parent_check); if(($parent_find) == 1) { $parentPerson = "<a href='SearchDetails.php?owner_id=$new_id'>$parentfirstname $parentlastname</a>"; }else{ $parentPerson = $parentfirstname.' ' .$parentlastname; }   // check if there found user has a photo ablum $parentPhotoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'")or die("Parent Photo Check Error: ".mysql_error()); $parentPhoto_find = mysql_num_rows($parnetPhotoCheck);   echo "<tr>";   echo "<td class='width'>$parentPerson</td>";   echo "<td class='adjacent'>$parentdob</td>";   echo "<td class='adjacent'>$parentage</td>";    if($parentEmail!=""){     echo "<td class='adjacent'><a class='emailBullet' href='sendEmail.php?email=$parentEmail'><img src='images/bemail.gif' alt='emalBullet'></a></td>";         }else{   echo "<td class='adjacent'></td>";   }         // add link if user has       if($parentPhoto_find >0){   echo "<td class='adjacent'><a class='emailBullet' href='photos/usersPhotoAlbum.php?owner_id=$new_id'><img src='images/camera.jpg' alt='cameraBullet'></a></td>";      }else{   echo "<td class='adjacent'></td>";   }   echo "</tr>" ; } echo "</table>"; echo "<br>"; } //end $result check //-----------------------------siblings Information------------------------ $siblingQuery = "SELECT * FROM Links L, sibling C WHERE L.User_id = '$owner_id' AND C.sibling_id = L.sibling_id"; $siblingResult = mysql_query($siblingQuery)or die("Get Search results Error: ".mysql_error()); if(mysql_num_rows($siblingResult) < 1) { // check if data found }else{ // closing else and end echo"<table class='displayinfo'>"; echo"<tr>"; echo"<th class='displayhead' colspan='5'>siblings</th><br>"; echo"</tr>"; echo"<tr class='blue'>"; echo"<td class='width'><b>First / Last Name</b></td>"; echo"<td class='adjacent'><b>Date of Birth</b></td>"; echo"<td class='adjacent'><b>Age</b></td>"; echo"<td class='adjacent'><b>Email</b></td>"; echo"<td class='adjacent'><b>Photos</b></td>"; echo"</tr>"; while($siblingR = mysql_fetch_assoc($siblingResult)){ $siblingfirstname = $siblingR ['siblingfirstname']; $siblinglastname = $siblingR['siblinglastname']; $siblingdob = $siblingR['siblingdob']; $currentDate = date('Y-m-d'); if(siblingdob != ""){ $siblingage = floor(dateDiff("-", date("Y-m-d"), $siblingdob)/365); }else{ } // check if there found user has a photo ablum $siblingPhotoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'")or die("Sibling Photo Error: ".mysql_error()); $siblingPhoto_find = mysql_num_rows($siblingPhotoCheck); //Check If sibling is a registered user, if so offer link to view thier family profile if not display siblings name only $sibling_check = mysql_query("SELECT * FROM users WHERE first_name ='$siblingfirstname' AND last_name='$siblinglastname' AND DOB = '$siblingdob'")or die("Sibling Registered User Error: ".mysql_error()); ;   $siblingS=mysql_fetch_assoc($sibling_check);     $new_id = $siblingS['user_id'];   $siblingEmail = $sinblingS['email_address'];     $sibling_find = mysql_num_rows($sibling_check); if(($sibling_find) == 1) { $siblingPerson = "<a href='SearchDetails.php?owner_id=$new_id'>$siblingfirstname $siblinglastname</a>"; }else{ $siblingPerson = $siblingfirstname.' ' .$siblinglastname; } /*  // check if user has a photo ablum $photoCheck = mysql_query("SELECT * FROM images WHERE owner_id = '$new_id'")or die("Get Sibling Photo Error: ".mysql_error()); ; $photo_find = mysql_num_rows($photoCheck);*/   echo "<tr>";   echo "<td class='width'>$siblingPerson</td>";   echo "<td class='adjacent'>$siblingdob</td>";   echo "<td class='adjacent'>$siblingage</td>";    if($siblingEmail!=""){     echo "<td class='adjacent'><a class='emailBullet' href='sendEmail.php?email=$siblingEmail'><img src='images/bemail.gif' alt='emalBullet'></a></td>";         }else{   echo "<td class='adjacent'></td>";   }         // add link if user has       if($siblingPhoto_find >0){   echo "<td class='adjacent'><a class='emailBullet' href='photos/usersPhotoAlbum.php?owner_id=$new_id'><img src='images/camera.jpg' alt='cameraBullet'></a></td>";      }else{   echo "<td class='adjacent'></td>";   }   echo "</tr>" ; } echo "</table>"; echo "<br>"; } //end $result check ?> [/code]

The attached file is the complete code that has been giving me a headack for the last two days. I'm thinking that there is a syntax error some where. the code works on my local server but does not on my web server.  The code will display ther tabel header and seems to end after that. This is confirmed as it does not include my menu bar which in loaded via 'include "leftlinks";.  any help or throughts why this is not working is great thank you Kevin [attachment deleted by admin]

ops thanks for pointing out my error however it still just rediects me to the next page updated code [code=php:0] <p><a href="lost_pw.php" onClick="<?php include('last_pw.php');?>">Get new Password</a></p> [/code]