johntp

I appreciate all the help. I figued it out. <?php include "./php/connect.php"; // Data could be pulled from a DB or other source // Read records $result = mysql_query("SELECT * FROM location;") or die(mysql_error()); // Put them in array for($i = 0; $cities[$i] = mysql_fetch_assoc($result); $i++) ; // Delete last empty one array_pop($cities); // Cleaning up the term $term = trim(strip_tags($_GET['term'])); // Rudimentary search $matches = array(); foreach($cities as $city){ if(stripos($city['city'], $term) !== false){ // Add the necessary "value" and "label" fields and append to result set $city['value'] = $city['city']; $city['label'] = "{$city['city']}, {$city['state']} {$city['zip']}"; $matches[] = $city; } } // Truncate, encode and return the results $matches = array_slice($matches, 0, 5); print json_encode($matches); ?>

I don't think I explained well enough, but thank you for your answer. I created the database "location" with the columns "city", "state", and "zip". I inputed the information in the database. My question is how do I output the MYSQL query into an array. I have tried the following but I think I'm doing it wrong. <?php //error_reporting(E_ALL); //ini_set('display_errors', '1'); include "./php/connect.php"; $query_users = "SELECT * FROM location"; $result = mysql_query($query_users); $new_array = array(); while ($row = mysql_fetch_assoc($result)) { $new_array["$row[0]"] => $row[1]; } return $new_array; ?>

Hello, We are currently using the following code to have state, and zip codes auto-filled when you choose a city. I would like to convert it to a database that it gets the info from. I have tried many different ways with no success. Could somone please give me some advice as to how i can do this? <?php $cities = array( array('city'=>'New York', state=>'NY', zip=>'10001'), array('city'=>'Los Angeles', state=>'CA', zip=>'90001'), array('city'=>'Chicago', state=>'IL', zip=>'60601'), array('city'=>'Houston', state=>'TX', zip=>'77001'), array('city'=>'Phoenix', state=>'AZ', zip=>'85001'), array('city'=>'Philadelphia', state=>'PA', zip=>'19019'), array('city'=>'San Antonio', state=>'TX', zip=>'78201'), array('city'=>'Dallas', state=>'TX', zip=>'75201'), array('city'=>'San Diego', state=>'CA', zip=>'92101'), array('city'=>'San Jose', state=>'CA', zip=>'95101'), array('city'=>'Detroit', state=>'MI', zip=>'48201'), array('city'=>'San Francisco', state=>'CA', zip=>'94101'), array('city'=>'Jacksonville', state=>'FL', zip=>'32099'), array('city'=>'Indianapolis', state=>'IN', zip=>'46201'), array('city'=>'Austin', state=>'TX', zip=>'73301'), array('city'=>'Columbus', state=>'OH', zip=>'43085'), array('city'=>'Fort Worth', state=>'TX', zip=>'76101'), array('city'=>'Charlotte', state=>'NC', zip=>'28201'), array('city'=>'Memphis', state=>'TN', zip=>'37501'), array('city'=>'Baltimore', state=>'MD', zip=>'21201'), ); // Cleaning up the term $term = trim(strip_tags($_GET['term'])); // Rudimentary search $matches = array(); foreach($cities as $city){ if(stripos($city['city'], $term) !== false){ // Add the necessary "value" and "label" fields and append to result set $city['value'] = $city['city']; $city['label'] = "{$city['city']}, {$city['state']} {$city['zip']}"; $matches[] = $city; } } // Truncate, encode and return the results $matches = array_slice($matches, 0, 5); print json_encode($matches); ?>

When using the ZipArchive I'm getting this following error upon opening the .zip file. "error: expected central file header signature not found (file #4)." Then i hit OK and get "Cannot open file: it does not appear to be a vilid archive." Code: <?PHP class Zipper extends ZipArchive { public function addDir($path) { $this->addEmptyDir($path); $nodes = glob($path . '/*'); foreach ($nodes as $node) { if (is_dir($node)) { $this->addDir($node); } else if (is_file($node)) { $this->addFile($node); } } } } $zip = new Zipper; $zip->open('theZipName.zip',Zipper::CREATE); $zip->addDir($targetPath); ?>

i have tried using it, but every time i try to unzip a file it tells me "Error: Invalid compressed data to expand (inflate) the file."

Hey guys i have a script that will zip files, but i want to zip a folder. I have looked at a bunch of script that do this but all the files are messed up when i try to extract them. This is the only script that worked great. Could some one help me modify it to be able to zip a folder? zip.lib.php <?PHP class zipfile { /** * Array to store compressed data * * @var array $datasec */ var $datasec = array(); /** * Central directory * * @var array $ctrl_dir */ var $ctrl_dir = array(); /** * End of central directory record * * @var string $eof_ctrl_dir */ var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00"; /** * Last offset position * * @var integer $old_offset */ var $old_offset = 0; /** * Converts an Unix timestamp to a four byte DOS date and time format (date * in high two bytes, time in low two bytes allowing magnitude comparison). * * @param integer the current Unix timestamp * * @return integer the current date in a four byte DOS format * * @access private */ function unix2DosTime($unixtime = 0) { $timearray = ($unixtime == 0) ? getdate() : getdate($unixtime); if ($timearray['year'] < 1980) { $timearray['year'] = 1980; $timearray['mon'] = 1; $timearray['mday'] = 1; $timearray['hours'] = 0; $timearray['minutes'] = 0; $timearray['seconds'] = 0; } // end if return (($timearray['year'] - 1980) << 25) | ($timearray['mon'] << 21) | ($timearray['mday'] << 16) | ($timearray['hours'] << 11) | ($timearray['minutes'] << 5) | ($timearray['seconds'] >> 1); } // end of the 'unix2DosTime()' method /** * Adds "file" to archive * * @param string file contents * @param string name of the file in the archive (may contains the path) * @param integer the current timestamp * * @access public */ function addFile($data, $name, $time = 0) { $name = str_replace('\\', '/', $name); $dtime = dechex($this->unix2DosTime($time)); $hexdtime = '\x' . $dtime[6] . $dtime[7] . '\x' . $dtime[4] . $dtime[5] . '\x' . $dtime[2] . $dtime[3] . '\x' . $dtime[0] . $dtime[1]; eval('$hexdtime = "' . $hexdtime . '";'); $fr = "\x50\x4b\x03\x04"; $fr .= "\x14\x00"; // ver needed to extract $fr .= "\x00\x00"; // gen purpose bit flag $fr .= "\x08\x00"; // compression method $fr .= $hexdtime; // last mod time and date // "local file header" segment $unc_len = strlen($data); $crc = crc32($data); $zdata = gzcompress($data); $zdata = substr(substr($zdata, 0, strlen($zdata) - 4), 2); // fix crc bug $c_len = strlen($zdata); $fr .= pack('V', $crc); // crc32 $fr .= pack('V', $c_len); // compressed filesize $fr .= pack('V', $unc_len); // uncompressed filesize $fr .= pack('v', strlen($name)); // length of filename $fr .= pack('v', 0); // extra field length $fr .= $name; // "file data" segment $fr .= $zdata; // "data descriptor" segment (optional but necessary if archive is not // served as file) $fr .= pack('V', $crc); // crc32 $fr .= pack('V', $c_len); // compressed filesize $fr .= pack('V', $unc_len); // uncompressed filesize // add this entry to array $this -> datasec[] = $fr; // now add to central directory record $cdrec = "\x50\x4b\x01\x02"; $cdrec .= "\x00\x00"; // version made by $cdrec .= "\x14\x00"; // version needed to extract $cdrec .= "\x00\x00"; // gen purpose bit flag $cdrec .= "\x08\x00"; // compression method $cdrec .= $hexdtime; // last mod time & date $cdrec .= pack('V', $crc); // crc32 $cdrec .= pack('V', $c_len); // compressed filesize $cdrec .= pack('V', $unc_len); // uncompressed filesize $cdrec .= pack('v', strlen($name) ); // length of filename $cdrec .= pack('v', 0 ); // extra field length $cdrec .= pack('v', 0 ); // file comment length $cdrec .= pack('v', 0 ); // disk number start $cdrec .= pack('v', 0 ); // internal file attributes $cdrec .= pack('V', 32 ); // external file attributes - 'archive' bit set $cdrec .= pack('V', $this -> old_offset ); // relative offset of local header $this -> old_offset += strlen($fr); $cdrec .= $name; // optional extra field, file comment goes here // save to central directory $this -> ctrl_dir[] = $cdrec; } // end of the 'addFile()' method /** * Dumps out file * * @return string the zipped file * * @access public */ function file() { $data = implode('', $this -> datasec); $ctrldir = implode('', $this -> ctrl_dir); return $data . $ctrldir . $this -> eof_ctrl_dir . pack('v', sizeof($this -> ctrl_dir)) . // total # of entries "on this disk" pack('v', sizeof($this -> ctrl_dir)) . // total # of entries overall pack('V', strlen($ctrldir)) . // size of central dir pack('V', strlen($data)) . // offset to start of central dir "\x00\x00"; // .zip file comment length } // end of the 'file()' method /** * A Wrapper of original addFile Function * * Created By Hasin Hayder at 29th Jan, 1:29 AM * * @param array An Array of files with relative/absolute path to be added in Zip File * * @access public */ function addFiles($files /*Only Pass Array*/) { foreach($files as $file) { if (is_file($file)) //directory check { $data = implode("",file($file)); $this->addFile($data,$file); } } } /** * A Wrapper of original file Function * * Created By Hasin Hayder at 29th Jan, 1:29 AM * * @param string Output file name * * @access public */ function output($file) { $fp=fopen($file,"w"); fwrite($fp,$this->file()); fclose($fp); } } // end of the 'zipfile' class ?> zip.php <?PHP include("zip.lib.php"); $ziper = new zipfile(); $ziper->addFiles(array("file.pdf","file.jpg")); //array of files $ziper->output("myzip.zip"); ?> Thanks in advance

Hey guys, I'm using jquery tools external overlay, and all is working fine, but i want to have a button on the external page that will close the overlay. Anyone struggled with this before, or know how to do this?

It is shared ...

Hey guys, I need to upload files to a network share through my webserver. Is this possible? I tried to be lazy and just make a virtual directory to the folder share, and when running the script it created the folders, but did not move the images. Is there a better way to do this or am i just out of luck? INFO: PHP 5.2.8 IIS 6.0 Windows Server 2003

Thanks sasa, Thats exactly what i needed. I can't beleive it's that simple.

You may want to do somehting like this if you're trying to log somone out. <?php // logout.php session_start(); unset($_SESSION); // you may want to delete the session cookie if (isset($_COOKIE[session_name()])) { setcookie(session_name(), '', time()-60); } session_destroy(); echo 'You have been logged out.'; ?>

Kind of. Say you have a topics table with topicid of 1-6. then when you have somone enter their userinformation, it inserts their userid and every topicid into the completed table. Topics Table. TopicID 1 2 3 4 5 6 Users Table (somone inserts the user john. UserID john Completed Table (Then for every TopicID i want to create a row in completed with the userid john.) TopicID UserID Done 1 John 0 2 John 0 3 John 0 4 John 0 5 John 0 6 John 0

I explainded it pretty bad. I need loop through the Topics table and insert and insert every topic id with the same userid. so if i had topics 1 to 3 then it would loop through and insert into completed (UserID, TopicID, done) Value ("$userid", "TopicID[1]", 0); insert into completed (UserID, TopicID, done) Value ("$userid", "TopicID[2]", 0); insert into completed (UserID, TopicID, done) Value ("$userid", "TopicID[3]", 0); But i want to do it with one line, and the it can change from 1 to 3, to 1 to 10 and so on.

Hey guys, My table is setup like below. I'm trying to insert the UserID to completed for every TopicID there is with a done value of 0. I can get all the topicIDs with a simple sql query, but how do make a insert the same username for every topicid? I feel im not explaining this that well, but i hope someone gets what i mean. UsersCompletedTopics UserID (primary)UserID (forign)Title UsernameTopicID (forign)TopicID(primary) emaildoneq1 [/td][td]recno (primary)a1 Here is the code I'm working with. <?php include "php/conn.php"; include "php/code.php"; $name = ($_POST['name']); $email = ($_POST['email']); $uname2 = ($_POST['uname']); $query = "INSERT INTO Users (Username, email) VALUES ( '$uname2', '$email' )"; mysql_query($query) or die('Error, insert query failed: '.mysql_error()); $query2 = "Select UserID FROM Users WHERE username = '$uname'"; $query2=mysql_query($query2); while($query2=mysql_fetch_object($query2)) { $UserID=$query2->UserID; } $query3 = "SELECT TopicID FROM Topic"; $result3 = mysql_query($query3) or die(mysql_error()); while($row3 = mysql_fetch_array($result3)){ }

so now no errors, it's just blank? try putting the following code at the top of those pages and then run it again. <?php error_reporting(E_ALL); ini_set('display_errors', 1); ?>

hmmmm do you have mysqli enabled in php.ini?

What do you mean by "Program" ? Could you give a little more detail as to what your doing?

Thank you soooo much. Didn't work at first so i changed $return[str_pad($row[0], 5, "0", STR_PAD_LEFT)] = array ( round($dist, $this->decimals), $row['city'] ); to $return[str_pad($row[0], 5, "0", STR_PAD_LEFT)] = array ( round($dist, $this->decimals), $row[3] ); Thanks again.

Hey guys, I found this free zip code calculator that works pretty well. I have been messing with it for 3 hours now trying to figure out how to make it show the city name next to the zip code. EX . Zip code 97214, Portland is 0 miles away from 97214 right now it displays Zip code 97214, is 0 miles away from 97214 here is my code demo.php (main page) <!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Zip Code Range and Distance Calculation Demo</title> <style type="text/css" lang="en"> BODY, P { font-family: sans-serif; font-size: 9pt; } H3 { font-family: sans-serif; font-size: 14pt; } </style> </head> <body> <?php /* DEMO for using the zipcode PHP class. By: Micah Carrick Questions? Comments? Suggestions? email@micahcarrick.com */ require_once('zipcode.class.php'); // zip code class // Open up a connection to the database. The sql required to create the MySQL // tables and populate them with the data is in the /sql subfolder. You can // upload those sql files using phpMyAdmin or a MySQL prompt. You will have to // modify the below information to your database information. mysql_connect('localhost','uname','pw') or die(mysql_error()); mysql_select_db('db') or die(mysql_error()); echo '<h3>A sample getting all the zip codes withing a range: 2 miles from 97214</h3>'; $z = new zipcode_class; $zips = $z->get_zips_in_range('97214', 2, _ZIPS_SORT_BY_DISTANCE_ASC, true); if ($zips === false) echo 'Error: '.$z->last_error; else { foreach ($zips as $key => $value) { echo "Zip code <b>$key</b>, is <b>$value</b> miles away from <b>97214</b>.<br />"; } } echo "$city"; ?> </body> </html> zipcode.class.php <?php // constants for setting the $units data member define('_UNIT_MILES', 'm'); define('_UNIT_KILOMETERS', 'k'); // constants for passing $sort to get_zips_in_range() define('_ZIPS_SORT_BY_DISTANCE_ASC', 1); define('_ZIPS_SORT_BY_DISTANCE_DESC', 2); define('_ZIPS_SORT_BY_ZIP_ASC', 3); define('_ZIPS_SORT_BY_ZIP_DESC', 4); // constant for miles to kilometers conversion define('_M2KM_FACTOR', 1.609344); class zipcode_class { var $last_error = ""; // last error message set by this class var $last_time = 0; // last function execution time (debug info) var $units = _UNIT_MILES; // miles or kilometers var $decimals = 2; // decimal places for returned distance function get_distance($zip1, $zip2) { // returns the distance between to zip codes. If there is an error, the // function will return false and set the $last_error variable. $this->chronometer(); // start the clock if ($zip1 == $zip2) return 0; // same zip code means 0 miles between. // get details from database about each zip and exit if there is an error $details1 = $this->get_zip_point($zip1); $details2 = $this->get_zip_point($zip2); if ($details1 == false) { $this->last_error = "No details found for zip code: $zip1"; return false; } if ($details2 == false) { $this->last_error = "No details found for zip code: $zip2"; return false; } // calculate the distance between the two points based on the lattitude // and longitude pulled out of the database. $miles = $this->calculate_mileage($details1[0], $details2[0], $details1[1], $details2[1]); $this->last_time = $this->chronometer(); if ($this->units == _UNIT_KILOMETERS) return round($miles * _M2KM_FACTOR, $this->decimals); else return round($miles, $this->decimals); // must be miles } function get_zip_point($zip) { // This function pulls just the lattitude and longitude from the // database for a given zip code. $sql = "SELECT lat, lon, city from zip_code WHERE zip_code='$zip'"; $r = mysql_query($sql); if (!$r) { $this->last_error = mysql_error(); return false; } else { $row = mysql_fetch_array($r); mysql_free_result($r); return $row; } } function calculate_mileage($lat1, $lat2, $lon1, $lon2) { // used internally, this function actually performs that calculation to // determine the mileage between 2 points defined by lattitude and // longitude coordinates. This calculation is based on the code found // at http://www.cryptnet.net/fsp/zipdy/ // Convert lattitude/longitude (degrees) to radians for calculations $lat1 = deg2rad($lat1); $lon1 = deg2rad($lon1); $lat2 = deg2rad($lat2); $lon2 = deg2rad($lon2); // Find the deltas $delta_lat = $lat2 - $lat1; $delta_lon = $lon2 - $lon1; // Find the Great Circle distance $temp = pow(sin($delta_lat/2.0),2) + cos($lat1) * cos($lat2) * pow(sin($delta_lon/2.0),2); $distance = 3956 * 2 * atan2(sqrt($temp),sqrt(1-$temp)); return $distance; } function get_zips_in_range($zip, $range, $sort=1, $include_base) { // returns an array of the zip codes within $range of $zip. Returns // an array with keys as zip codes and values as the distance from // the zipcode defined in $zip. $this->chronometer(); // start the clock $details = $this->get_zip_point($zip); // base zip details if ($details == false) return false; // This portion of the routine calculates the minimum and maximum lat and // long within a given range. This portion of the code was written // by Jeff Bearer (http://www.jeffbearer.com). This significanly decreases // the time it takes to execute a query. My demo took 3.2 seconds in // v1.0.0 and now executes in 0.4 seconds! Greate job Jeff! // Find Max - Min Lat / Long for Radius and zero point and query // only zips in that range. $lat_range = $range/69.172; $lon_range = abs($range/(cos($details[0]) * 69.172)); $min_lat = number_format($details[0] - $lat_range, "4", ".", ""); $max_lat = number_format($details[0] + $lat_range, "4", ".", ""); $min_lon = number_format($details[1] - $lon_range, "4", ".", ""); $max_lon = number_format($details[1] + $lon_range, "4", ".", ""); $return = array(); // declared here for scope $sql = "SELECT zip_code, lat, lon FROM zip_code "; if (!$include_base) $sql .= "WHERE zip_code <> '$zip' AND "; else $sql .= "WHERE "; $sql .= "lat BETWEEN '$min_lat' AND '$max_lat' AND lon BETWEEN '$min_lon' AND '$max_lon'"; $r = mysql_query($sql); if (!$r) { // sql error $this->last_error = mysql_error(); return false; } else { while ($row = mysql_fetch_row($r)) { // loop through all 40 some thousand zip codes and determine whether // or not it's within the specified range. $dist = $this->calculate_mileage($details[0],$row[1],$details[1],$row[2]); if ($this->units == _UNIT_KILOMETERS) $dist = $dist * _M2KM_FACTOR; if ($dist <= $range) { $return[str_pad($row[0], 5, "0", STR_PAD_LEFT)] = round($dist, $this->decimals); } } mysql_free_result($r); } // sort array switch($sort) { case _ZIPS_SORT_BY_DISTANCE_ASC: asort($return); break; case _ZIPS_SORT_BY_DISTANCE_DESC: arsort($return); break; case _ZIPS_SORT_BY_ZIP_ASC: ksort($return); break; case _ZIPS_SORT_BY_ZIP_DESC: krsort($return); break; } $this->last_time = $this->chronometer(); if (empty($return)) return false; return $return; } function chronometer() { // chronometer function taken from the php manual. This is used primarily // for debugging and anlyzing the functions while developing this class. $now = microtime(TRUE); // float, in _seconds_ $now = $now + time(); $malt = 1; $round = 7; if ($this->last_time > 0) { /* Stop the chronometer : return the amount of time since it was started, in ms with a precision of 3 decimal places, and reset the start time. We could factor the multiplication by 1000 (which converts seconds into milliseconds) to save memory, but considering that floats can reach e+308 but only carry 14 decimals, this is certainly more precise */ $retElapsed = round($now * $malt - $this->last_time * $malt, $round); $this->last_time = $now; return $retElapsed; } else { // Start the chronometer : save the starting time $this->last_time = $now; return 0; } } } ?> The database row for the city is city. I tried to add a call for that in the other sql quries, and then do a $city= $row['city']; but no luck. Any suggestions?

Hey guys, You might be the wrong people to ask, but here goes. I have a flash document that i use a guest book with. I use php for flash to talk to mysql, and am currently in a bind. I am trying to figure out how to make flash take an HTML table from php i have tried but I'm not sure if it's possible for flash to recognize HTML tables. I guess my question is can you import a table structured sql query from php into flash? Here is my PHP Code for calling and printing the stuff i need <?php case 'read' : // Fetch all comments from database table $sql = 'SELECT * FROM `' . $table . '`'; $allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error()); $numallComments = mysql_num_rows($allComments); // Fetch page-wise comments from database table $sql .= ' ORDER BY `id` DESC LIMIT ' . $_GET['NumLow'] . ', ' . $numComments; $fewComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error()); $numfewComments = mysql_num_rows($fewComments); // Generate Output for Flash to Read print '&totalEntries=' . $numallComments . '&'; print "<br>&entries="; if($numallComments == 0) { print "No entries in the guestbook, as yet.."; } else { while ($array = mysql_fetch_array($fewComments)) { $name = mysql_result($fewComments, $i, 'name'); $email = mysql_result($fewComments, $i, 'email'); $comments = mysql_result($fewComments, $i, 'comments'); $time = mysql_result($fewComments, $i, 'time'); $state = mysql_result($fewComments, $i, 'state'); print " <table width='293' border='0' cellpadding='0' cellspacing='0'> <tr> <td width='100'>$name</td> <td width='193'>$email</td> </tr> <tr> <td>$state</td> <td>$time</td> </tr> <tr> <td colspan='2'>$comments</td> </tr> </table>"; $i++; } } // Print this only when there aren't any more entries.. if($_GET['NumLow'] > $numallComments) { print 'No More Entries!&'; } break; ?>

Hey guys is it possible in php to launch a program like word from a local intranet site with a hyperlink? If it's not possible with php, is it possible with something else? Thanks in Advance.

i beleive you want to do this. $test1= explode("|",$row['favs]); $test= $test1[1]; echo "$test"; change the 1 to 2 if it's not displaying the right side of the | that you want.and then to put it in the database use $test

That should be $query = "SELECT * FROM blockbook, user WHERE blockbook.user_id = '$user_id'";

You need to change everything related to that Query. <? /*****************************************************************************************/ $query2 = "SELECT * FROM blockbook, user WHERE blockbook.user_id = user.id "; $result2 = mysql_query($query2)or die(mysql_error()); ?> <div class="smallerText"> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#99CC99"> <TR ALIGN=CENTER bgcolor="#CCFF66"> <td><font color=red><b>C/A</b></font></TD> <td><font color=red><b>JN</b></font></TD> <td ><font color=red><b>TOC</b></font></TD> <td ><font color=red><b>TOV</b></font></TD> <td ><font color=red><b>NOV</b></font></TD> <td ><font color=red><b>Regu</b></font></TD> <td ><font color=red><b>Multi Days Book</b></font></TD> <td ><font color=red><b>Cust Name</b></font></TD> <td ><font color=red><b>Pick Address</b></font></TD> <td ><font color=red><b>Destination</b></font></TD> <td ><font color=red><b>Tel</b></font></TD> <td ><font color=red><b>WR</b></font></TD> <td ><font color=red><b>Date</b></font></TD> <td ><font color=red><b>Time</b></font></TD> <td ><font color=red><b>Comments</b></font></td> </tr> <? while ($row2 = mysql_fetch_array($result2)) { extract($row2); echo "<tr align=center> <td>" . $row2['user_id'] . "</td> <td>" . $row2['job_id'] . "</td> <td>" . $row2['typeOfcustomer'] . "</td> <td>" . $row2['typeOfvehicle'] . "</td> <td>" . $row2['noOfVehicle'] . "</td> <td>" . $row2['regul'] . "</td> <td>" . $row2['mon'] . "," . $row2['tue'] . "," . $row2['wed'] . ", " . $row2['thur'] . "," . $row2['fri'] . "," . $row2['sat'] . ", " . $row2['sun'] . "</td> <td>" . $row2['cust_name'] . "</td> <td>" . $row2['cust_address'] . "</a></td> <td>" . $row2['des'] . "</td> <td>" . $row2['cust_tel'] . "</td> <td>" . $row2['reqVehicle'] . "</td> <td>" . $row2['dateDay'] . "/" . $row['dateMO'] . "/" . $row['dateYr'] . "</td> <td>" . $row2['timeHr'] . ":" . $row['timeMin'] . "</td> <td>" . $row2['comment'] . "</td> </tr>"; } ?></table></div><? } /*****************************************************************************************/

show us some code please.