newbeee

correct links sorry [redacted]/photogallery3%20DB/index-DB-version%20album%20one%20works%20and%20end%20ok%20but%20rest%20just%20show%20main%20image%20page%20not%20gallery.php and [redacted]/photogallery3%20DB/index-DB-version4%20keeps%20advancing%20to%20next%20album.php

Hi Hopefully someone can answer this for me as i have been getting rather annoyed with DW ! It keeps changing the layout of my code! aarrgghh adding in tabs realigning code here and there when i reload the file. how can i stop DW from doing this please.

i have been tried to get 'all' the categorys to be listed no mater what. but have them ordered by the stickypost (high number first) of the category table and then the comments stickypost field (again high number first) and then by the created_on in the comments (most recent date first - yyyy-mm-dd). if there are no comments or topics in the category then the categories still show. all of the topics or comments should have their 'confirmed' fields = 1, if not then these are disgarded and not used in the query. here are my tables... CREATE TABLE IF NOT EXISTS `forum_category` ( `category_id` bigint(20) NOT NULL auto_increment, `confirmed` text, `stickypost` tinyint(4) NOT NULL default '0', `category` text NOT NULL, `created_by` text NOT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4; INSERT INTO `forum_category` (`category_id`, `confirmed`, `stickypost`, `category`, `created_by`, `created_on`) VALUES (1, '1', 1, 'General', 'Jason (admin)', '2009-01-30 00:00:00'), (2, '1', 0, 'Your stories', 'Jason (admin)', '2009-01-30 00:16:57'), (3, '1', 0, 'Something else', 'Jason (admin)', '2009-01-30 00:27:59'); CREATE TABLE IF NOT EXISTS `forum_topics` ( `topic_id` bigint(20) NOT NULL auto_increment, `category_id` bigint(20) NOT NULL default '0', `topic` longtext NOT NULL, `username` text NOT NULL, `stickypost` tinyint(4) NOT NULL default '0', `created_by` text NOT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `confirmed` text, `views` bigint(20) NOT NULL default '0', KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; CREATE TABLE IF NOT EXISTS `forum_comments` ( `postcounter` bigint(20) NOT NULL auto_increment, `topic_id` bigint(20) NOT NULL default '0', `comment` longtext NOT NULL, `username` varchar(65) NOT NULL default '', `stickypost` tinyint(4) NOT NULL default '0', `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `confirmed` text, KEY `postcounter` (`postcounter`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; this is the query i have come up with so far and the fields i need available in the results. i know i have used the long way to query but this will help me understand the query so i can hopefully learn to do this myself one day. SELECT `forum_category`.`category_id`, `forum_category`.`category`, `forum_category`.`stickypost`, `forum_category`.`confirmed`, `forum_topics`.`category_id`, `forum_topics`.`topic_id`, `forum_topics`.`confirmed`, `forum_topics`.`views`, `forum_comments`.`postcounter`, `forum_comments`.`topic_id`, `forum_comments`.`created_on`, `forum_comments`.`username`, `forum_comments`.`confirmed` FROM forum_category WHERE `forum_category`.`confirmed` = '1' , JOIN forum_topics WHERE `forum_topics`.`confirmed` = '1', JOIN forum_comments WHERE `forum_comments`.`confirmed` = '1' ORDER BY `forum_category`.`stickypost` DESC, `forum_comments`.`created_on` DESC

sory i was not clear with my OP did not want to delete just to list them. what i did not say is that these posts could be valid but just not linked properly for errors in my code or something, so just wanted to list all the topics and the comments that may have category_id or topic_id but just linked to one another.

validated and now working using the methods shows in the error messages i got from w3c thanks for your help

I have my own forum scripts and wish to know if some posts have for what ever reason become unlinked. list all the results where the category_id number in the category table is not in the topic table field category_id and the second seperate query... list all the results where the topic_id number in the comments table not in the topic table field topic_id below are the tables i have and their fields that would be needed. CREATE TABLE IF NOT EXISTS `forum_category` ( `category_id` bigint(20) NOT NULL auto_increment, PRIMARY KEY (`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; CREATE TABLE IF NOT EXISTS `forum_topics` ( `topic_id` bigint(20) NOT NULL auto_increment, `category_id` bigint(20) NOT NULL default '0', KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; CREATE TABLE IF NOT EXISTS `forum_comments` ( `postcounter` bigint(20) NOT NULL auto_increment, `topic_id` bigint(20) NOT NULL default '0', KEY `postcounter` (`postcounter`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

i have tried to access the movies via the direct link and all seems ok, but for some reason the movie does not now show in Internet Explorer. All works ok in Fire Fox tho Can anyone suggest a way to fix this please. www dot round shaw dot com/?ac=cs (take out spaces also)

Hello, Just thought i'd add my thoughts on this. If the page is created on the fly and the files are not always the same then have the page create the zip of the chosen files. and then this zip could be stored in a temporary folder within your web folder i.e public_html. then the link to this file shown on the page. ok now for the part that removes this temporary zip file. have a cron job that runs another file that would check the date the file was created and delete all the files within this temporary folder that stores the zuip files apart from the files that have been created within the last hour and have this cron job run say every so many hours or how ever long you want to prevent your webspace from being eatten up by these temporary zip files. if you need any help with setting this up get back to me via a PM Jason

what is the best way to prevent SQL injections with what code i have so far.. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <? include("config.php"); if($_POST['submit'] == "submit") { $update = mysql_query("UPDATE `news` SET `news` = '" . $_POST['news'] . "'"); } else { $news = mysql_query("SELECT * FROM `news`"); ?> <textarea name="news" cols="80" rows="10"><?=@mysql_result($news, 0, 'news');?></textarea><br> <input name="submit" type="submit" value="submit"> <? } ?> </body> </html>

the news field in my database is a text type what i wish to know is how to have text that has line breaks within the text still show with these line breaks when i grab the data again to show it in the page it is ment for. at the moment all the text seems to just continue on one long line and breaks up when the end of the page is reached. edit file <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <? include("config.php"); if($_POST['submit'] == "submit") { $update = mysql_query("UPDATE `news` SET `news` = '" . $_POST['news'] . "'"); } else { $news = mysql_query("SELECT * FROM `news`"); ?> <textarea name="news" cols="80" rows="10"><?=@mysql_result($news, 0, 'news');?></textarea><br> <input name="submit" type="submit" value="submit"> <? } ?> </body> </html> display page <?=@mysql_result($mpsurgeries_news, 0, "mpsurgeries_news");?>

get data from mysql and use it via... $results[fieldname] i have used it once but can not remember or find it on my sites code. what is the correct way to do this please. i hope to use this to simplify the permission section of my site. this is my database... CREATE TABLE IF NOT EXISTS `permissions` ( `username` text NOT NULL, `Some Menu` tinyint(4) NOT NULL, `Forum Menu` tinyint(4) NOT NULL, `Menu1` tinyint(4) NOT NULL, `Another Menu` tinyint(4) NOT NULL, `Menu2` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`username`, `Some Menu`, `Forum Menu`, `Menu1`, `Another Menu`, `Menu2`) VALUES ('Steph', 0, 1, 1, 0, 0), ('Terry', 0, 0, 0, 0, 0), ('Tom', 0, 0, 0, 0, 0), ('James', 0, 0, 0, 0, 0), ('Jason', 1, 1, 1, 1, 1), ('Tina', 0, 0, 0, 0, 0), ('Sue', 0, 0, 0, 0, 0), ('Tim', 0, 1, 0, 0, 0), ('David', 0, 0, 0, 0, 0), ('Lil', 0, 0, 0, 0, 0); then a user logs in and the database is got with the permissions the user can do. i would then use the following to find out if they can use that page or not if ($permissions[menu2] = '1') { //show menu }

category about cats Jason 12 Jan 2009 04:11 category about dogs Jason 11 Jan 2009 06:00 category about dogs Jason 11 Jan 2009 06:00 it shows the dogs entry twice in phpmyadmin and on the site and there are only two categories at the moment for testing.. and should show just two category about cats Jason 12 Jan 2009 04:11 category about dogs Jason 11 Jan 2009 06:00

the following is now geting one of the entries twice! it should be getting each category once and order by... stickypost, (from the category table, high number first) then created_on, (from the comments table, recent date first) can anyone see whats wrong with the query. this is my table and the data. -- -- Table structure for table `forum_category` -- CREATE TABLE IF NOT EXISTS `forum_category` ( `category_id` bigint(20) NOT NULL auto_increment, `confirmed` text, `stickypost` tinyint(4) NOT NULL default '0', `category` text NOT NULL, `created_by` text NOT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `theip` text NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `forum_category` -- INSERT INTO `forum_category` (`category_id`, `confirmed`, `stickypost`, `category`, `created_by`, `created_on`, `theip`) VALUES (1, '1', 0, 'category about cats', 'Admin', '2008-12-30 01:02:03', ''), (2, '1', 0, 'category about dogs', 'Admin', '2008-12-30 01:02:03', ''); -- -------------------------------------------------------- -- -- Table structure for table `forum_comments` -- CREATE TABLE IF NOT EXISTS `forum_comments` ( `postcounter` bigint(20) NOT NULL auto_increment, `topic_id` bigint(20) NOT NULL default '0', `reportedby` text NOT NULL, `comment` longtext NOT NULL, `alreadyexists` text NOT NULL, `username` varchar(65) NOT NULL default '', `theip` text NOT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `confirmed` text, `approvedby` text, `approveddatetime` datetime NOT NULL default '0000-00-00 00:00:00', `editedby` text, `editeddatetime` datetime NOT NULL default '0000-00-00 00:00:00', `deletedby` text NOT NULL, `restoredby` text NOT NULL, KEY `postcounter` (`postcounter`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -- Dumping data for table `forum_comments` -- INSERT INTO `forum_comments` (`postcounter`, `topic_id`, `reportedby`, `comment`, `alreadyexists`, `username`, `theip`, `created_on`, `confirmed`, `approvedby`, `approveddatetime`, `editedby`, `editeddatetime`, `deletedby`, `restoredby`) VALUES (16, 7, '', 'dog', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''), (17, 1, '', 'cats comment 2', 'no', 'Jason', '', '2009-01-11 14:09:00', '1', 'Jason', '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', '', ''), (18, 1, '', 'cat topic 3', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''), (20, 1, '', 'last dogs', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''), (22, 1, '', 'new vt 8', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''), (23, 7, '', 'cat topic 3 - new to replace the blank entry', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''), (24, 8, '', 'tttttttt', '', 'Jason', '', '2009-01-11 22:11:00', '1', 'Jason', '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', '', ''), (15, 1, '', 'cats', 'no', 'Jason', '', '2009-01-11 00:00:00', '1', 'Jason', '0000-00-00 00:00:00', 'Jason', '0000-00-00 00:00:00', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `forum_topics` -- CREATE TABLE IF NOT EXISTS `forum_topics` ( `topic_id` bigint(20) NOT NULL auto_increment, `category_id` bigint(20) NOT NULL default '0', `topic` longtext NOT NULL, `username` text NOT NULL, `theip` text NOT NULL, `stickypost` tinyint(4) NOT NULL default '0', `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `confirmed` text, `updated_on` datetime NOT NULL default '0000-00-00 00:00:00', `views` bigint(20) NOT NULL default '0', `lastviewer` text NOT NULL, `approvedby` text, `approveddatetime` datetime NOT NULL default '0000-00-00 00:00:00', `editedby` text, `editeddatetime` datetime NOT NULL default '0000-00-00 00:00:00', `deletedby` text NOT NULL, `restoredby` text NOT NULL, KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `forum_topics` -- INSERT INTO `forum_topics` (`topic_id`, `category_id`, `topic`, `username`, `theip`, `stickypost`, `created_on`, `confirmed`, `updated_on`, `views`, `lastviewer`, `approvedby`, `approveddatetime`, `editedby`, `editeddatetime`, `deletedby`, `restoredby`) VALUES (1, 1, 'topic about cats', 'Admin', '', 0, '2009-01-11 14:09:00', '1', '2009-01-11 14:09:13', 13, 'Jason', 'Jason', '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', '', ''), (8, 1, 'cat topic 3', 'Jason', '', 0, '2009-01-11 22:11:00', '1', '2009-01-11 22:10:53', 0, '', 'Jason', '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', '', ''), (7, 2, 'topic about dogs', 'Jason', '', 0, '2009-01-11 14:17:00', '1', '2009-01-11 14:17:08', 0, '', 'Jason', '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', '', ''); SELECT cat.category_id , cat.category , cat.stickypost , t.category_id , t.topic_id , c.created_on , c.username FROM forum_comments AS c INNER JOIN forum_topics AS t USING ( topic_id ) INNER JOIN forum_category AS cat USING ( category_id ) INNER JOIN ( SELECT t.category_id , MAX(c.created_on) AS created_on FROM forum_comments AS c INNER JOIN forum_topics AS t USING ( topic_id ) WHERE c.confirmed = '1' AND t.confirmed = '1' GROUP BY t.category_id ) AS c2 ON ( c2.category_id = t.category_id AND c2.created_on = c.created_on ) ORDER BY `stickypost` DESC, `created_on` DESC

if the category pull down menu is changed then the list in the topics pull down menu changes to show the topics that are in that category chosen. all data is got from the mysql database. there maybe a lot of categories and topics in the furture, just in case that may help in creating a method to prevent the code needing changing again in the future, due to taking too long or something? <select name="categoryid"><? // get category_id $get_category_titles = mysql_query("SELECT * FROM `forum_category` WHERE `confirmed` = '1' ORDER BY `created_on` DESC"); $get_topic_titles = mysql_query("SELECT * FROM `forum_topics` WHERE `confirmed` = '1' ORDER BY `created_on` DESC"); for ($i = 0; $i < mysql_num_rows($get_category_titles); $i ++) { ?><option<? if ($posts['categoryid'] == mysql_result($get_category_titles, $i, 'category_id')) {echo(" selected");} ?> value="<?=mysql_result($get_category_titles, $i, 'category_id');?>"><?=mysql_result($get_category_titles, $i, 'category');?></option><? } ?></select> <select name="topicid"><? // get topics for ($i = 0; $i < mysql_num_rows($get_topic_titles); $i ++) { ?><option<? if ($posts['topicid'] == mysql_result($get_topic_titles, $i, 'topic_id')) {echo(" selected");} ?> value="<?=mysql_result($get_topic_titles, $i, 'topic_id');?>"><?=mysql_result($get_topic_titles, $i, 'topic');?></option><? } ?></select>

Please can someone help me here as i have no idea what i need to do or where to start. this is the method i as trying to do... <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form name="form2" method="post" action=""> <p> <select name="select1"> <option value="L1 - VALUE 1">L1 - OPT 1</option> <option value="L1 - VALUE 2">L1 - OPT 2</option> <option value="L1 - VALUE 3">L1 - OPT 3</option> </select> </p> <? // if OPT 1 is selected in the select1 pulldown then the following is placed the select2 options ?> <p> <select name="select2-1"> <option value="L2 - VALUE 1">L2 - OPT 1</option> <option value="L2 - VALUE 2">L2 - OPT 2</option> <option value="L2 - VALUE 3">L2 - OPT 3</option> </select> </p> <? // if OPT 2 is selected in the select1 pulldown then the following is placed the select2 options ?> <p> <select name="select2-2"> <option value="L3 - VALUE 1">L3 - OPT 1</option> <option value="L3 - VALUE 2">L3 - OPT 2</option> <option value="L3 - VALUE 3">L3 - OPT 3</option> </select> </p> <? // if OPT 3 is selected in the select1 pulldown then the following is placed the select2 options ?> <p> <select name="select2-3"> <option value="L4 - VALUE 1">L4 - OPT 1</option> <option value="L4 - VALUE 2">L4 - OPT 2</option> <option value="L4 - VALUE 3">L4 - OPT 3</option> </select> </p> </form> </body> </html>

i wish to have a basic form with a few fields to fill out, two of these are for the category and the topic if the category pulldown is changed the topic options change for the category chosen. but the page should not refresh as the other info will be lost. is ajax the way to do this if so is there a basic template someone can show me that i can change to fit in with what is needed.

I have nothing on paper just the idea to allow members of my site to see which members viewed their profile, where would i start as i have tried to think how this would be possible but can not find the best way. i first thought of having a 'blog' table i think thats what its called with all the memberID's that viewed that member. i.e. CREATE TABLE IF NOT EXISTS `whoviewedme` ( `id` bigint(20), `username` text NOT NULL, `viewedby` blob NOT NULL ) and the viewedby would have all the id's seperated by a comma. but what happens when two different members view the same profile, one of these id's would not be placed in the database? or would it corupt the data? anyone got any suggestions on how i should do this

i used the following DOC TYPE <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> and the header went all over the place it is now messed up. and the border line at the bottom of the page in firefox do not show up in IE

I have my page done but it does not show the same in FireFox and Internet Explorer, do i need to use a special DOC TYPE to get the same look in both? if so what one should i use? <html> <head> <title>Untitled Document</title> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <table width="900" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse"> <tr> <td width="68" height="1"><img src="images/spacer.gif" alt="" width="68" height="1" border="0"></td> <td width="146" height="1"><img src="images/spacer.gif" alt="" width="109" height="1" border="0"></td> <td width="137" height="1"><img src="images/spacer.gif" alt="" width="113" height="1" border="0"></td> <td width="481" height="1"><img src="images/spacer.gif" alt="" width="282" height="1" border="0"></td> <td height="1"><img src="images/spacer.gif" alt="" width="68" height="1" border="0"></td> </tr> <tr> <td rowspan="2" colspan="3" height="91" bgcolor="#FDA005" background="images/bluelinebot.gif"><img src="images/logo-new.jpg" alt="" height="91" border="0"></td> <td colspan="2" bgcolor="#FDA005" valign="top" height="84"> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber4" height="1"> <tr> <td width="5%" style="border-style: none; border-width: medium" height="51"> </td> <td style="border-style: none; border-width: medium" height="51" nowrap> </td> </tr> <tr> <td width="5%" style="border-style: none; border-width: medium" height="1"> </td> <td width="95%" style="border-style: none; border-width: medium" height="1"> </td> </tr> </table></td> </tr> <tr> <td bgcolor="#FDA005" height="7" background="images/blueline.gif"><img src="images/index_r2_c3.gif" alt="" name="index_r2_c3" width="282" height="7" border="0"></td> <td rowspan="2" bgcolor="#FFFFFF" height="41" align="right" valign="top" background="images/orangelinetop.gif"> <img src="images/index_r2_c4.gif" alt="" name="index_r2_c4" height="41" border="0" align="right"></td> </tr> <tr> <td height="34" align="left" valign="top" bgcolor="#FFFFFF"><img src="images/index_r3_c1.gif" alt="" name="index_r3_c1" width="68" height="34" border="0"></td> <td colspan="3" bgcolor="#FFFFFF" valign="top" height="34"> <p style="margin-bottom: -11"> </p> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#9CC2EB" width="100%" id="AutoNumber2"> <tr> <td width="16%" background="images/img02.jpg" class="topnavright" bgcolor="#2B60AA" align="center"><a href="" class="topmenulink">Home</a></td> <td width="16%" background="images/img02.jpg" class="topnavmid" bgcolor="#2B60AA" align="center"><a href="" class="topmenulink">Product Search</a></td> <td width="16%" background="images/img02.jpg" class="topnavmid" bgcolor="#2B60AA" align="center"><a href="" class="topmenulink">Manufacturer</a></td> <td width="16%" background="images/img02.jpg" class="topnavmid" bgcolor="#2B60AA" align="center"><a href="" class="topmenulink">Help</a></td> <td width="16%" background="images/img02.jpg" class="topnavleft" bgcolor="#2B60AA" align="center"><a href="" class="topmenulink">Contact</a></td> </tr> </table> </td> </tr> <tr> <td colspan="5" bgcolor="#FFFFFF" valign="top"> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber1"> <tr> <td width="100%" valign="top" style="border-style: none; border-width: medium"><!-- start --><p align="center" style="margin-left: 4; margin-right: 4; margin-bottom:9"> <table width="100%" align="center" border="0" cellpadding="10"> <tr> <td colspan="3"><img src="images/welcome.jpg" alt=""></td> </tr> <tr> <td><img src="images/lorry.jpg" alt="" width="250" height="165"></td> <td rowspan="2" valign="top" style="line-height:23px;"><div align="justify"></div></td> <td><img src="images/yard.jpg" alt=""></td> </tr> <tr> <td><a href=""><img src="images/contact.jpg" alt="" width="250" height="165" border="0"></a></td> <td><img src="images/yard2.jpg" alt="" width="250" height="165"></td> </tr> <tr> <td colspan="3" align="center"> </td> </tr> </table> </p><!-- end --></td> </tr> <tr> <td width="100%" style="border-style: none; border-width: medium"> </td> </tr> </table></td> </tr> <tr> <td colspan="5" bgcolor="#FFFFFF" valign="top" height="16"> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber3"> <tr> <td width="25%" style="border-style: none; border-width: medium" align="center"> <a href="index.php" style="text-decoration: none"><b><font face="Verdana" size="2" color="#2B60AA">Home</font></b></a></td> <td width="25%" style="border-style: none; border-width: medium" align="center"> <a href="" style="text-decoration: none"><b><font face="Verdana" size="2" color="#2B60AA">Map</font></b></a></td> <td width="25%" style="border-style: none; border-width: medium" align="center"> <a href="" style="text-decoration: none"><b><font face="Verdana" size="2" color="#2B60AA">Contact Us</font></b></a></td> <td width="25%" style="border-style: none; border-width: medium" align="center"> <p dir="ltr"><a href="" style="text-decoration: none"><b><font face="Verdana" size="2" color="#2B60AA">Product Search</font></b></a></td> </tr> <tr> <td width="25%" style="border-style: none; border-width: medium" align="center"> </td> <td width="25%" style="border-style: none; border-width: medium" align="center"> </td> <td width="25%" style="border-style: none; border-width: medium" align="center"> </td> <td width="25%" style="border-style: none; border-width: medium" align="center"> </td> </tr> </table></td> </tr> <tr> <td colspan="5" bgcolor="#9CC2EB" valign="top" height="8"></td> </tr> <tr bgcolor="#FDA005"> <td colspan="5" valign="top" height="26"> <p align="center" style="margin-top: 7; margin-bottom: 7"> </td> </tr> </table> </body> </html>

this is more likely the way i need to do it as i can not change the 'create_on' string as it is used later on in the script. but using this method you say did not work it seem to mess up the date and time to a random date and time. i am using mysql datetime as a default so it is stored in US format, when i get the data from the DB in to the string i need to have it converted to the GMT format.

i tried the following code but this seems to return the current date and time. the format i use in mysql is 0000-00-00 00:00:00 and would like to convert to this format... dd-mm-yyy hh:mm:ss echo gmdate("d M Y H:i", time($rows['created_on'])); can someone please help me out

having trouble getting boxes to show side by side but if the browser window is smaller the boxes cascade down the page. unlike tables which stay put and disapear out of view. all boxes should be same width say <table border="0"> <tr> <td width="200" height="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> <td width="200"> </td> </tr> </table>

I have not long moved my files from a plesk windows server to a linux server but forgot to check emails before changing nameservers. How do i access the emails without changing back the nameservers. as changing them back you defeat the object of moving and new emails would still get in the old mail biox while i check the old box for emails that have been sent while the nameservers were updating. and i really need these emails, as i dont know who sent them if any where sent. hope someone can help me out here,

SELECT `submittedby`, COUNT(*) AS postCount FROM `sites` WHERE `confirmed` = '1' GROUP BY `submittedby` HAVING postCount BETWEEN 90 AND 110 OR HAVING postCount BETWEEN 100 AND 1110 i have tried a few ways by adding brackets and can not work this out myself. what is the correct way to use many HAVING..?

what is the correct way to use AND & OR in query SELECT `username`, `md5` FROM `users` WHERE (`md5` == 'confirmed' OR `md5` == 'SUSPENDED') AND `username` = '".$username."' LIMIT 1