dheeraja

Hi Guys, I am scratching my head to fetch the data from two tables having some conditions. Suppose I am having a table called "table1" having the field Table 1 [id(int) auto_inc, owner (int), supervisor (int), startdate (date), enddate(date), status (tinyint)] report_table [id(int) auto_inc, owner (int), supervisor(int), prdate(date), status(tinyint), project(int), component(int), workdone(text)] Now I want to know that the supervisor from table1 with startdate say "2010-11-20" and enddate "2010-11-27" submitted how many reports in report_table. that means I want to count the number of reports from 2nd table and arrange it in ascending order on the basis of count. So please anyone help me...

Hi Guys I am going through the regular expression and somewhere I got two rewrite rules with regular expression, but I am not exactly getting that what is mean of it, expressions are: rewritecond %{HTTP_HOST} !^www.example.com$ [NC] rewriterule ^(.*)$ http://www.example.com/$1 [R,L] Please tell me that what is the bold part telling, please help me.. Thank you

hello Guys, Please refer this site http://www.dreamvacationrent.com/, it is having a link called "Our Rental Properties" now when you click on it it will show the url with the page name "properties-rental.html" but actually the page is "properties.php" like wise is has done with other links values passed through url are seen by using + or - sign, so how could this be done. Please help me... Thank you.

Just do the following changes:- <? //foot start } else { $goto = "index.php"; require('inc.forward.php'); } //foot end ?>

Just put your script under the below code: if(isset($_POST['name'])) { //Your Code }

Hi Guys, I am looking for a way to format excel cells using PHP, I am exporting mysql data to excel file using below method: $fields = array("Date", "Time In", "Time Out", "Hours", "Project", "Component", "Sub-Component", "Work Done", "Supervisor Changes", PHP_EOL); file_put_contents($filename, implode("\t", $fields), FILE_APPEND); Now I want to make BOLD all this header fields, so please help me to this construct.. Thank you

just use CSS for any type of formatting like Put this code to head Section <style type="text/css"> .format_table {font-size: 24px; font-family:Arial; } </style> Now jst do the following stuff echo "<table class='format_table'>"; echo "</table>";

Hi Guys, I want to hide the page extension from URL but not getting how to do this stuff, suppose i m having a url "www.example.com/contact.php" then I just want that browser should show "www.example.com/contact". Thank you Dheeraj

It will be much better if you take a single field to database say "date" and its data type should be date, now store dates in the format of yyyy-mm-dd so you can just directly compare the dates and you can easily sort your record according to date.. Thank you Dheeraj

Hello, Firstly change $_GET['title'] to $_Get['quantity'] because you have a test field naming quantity. Now if you want to show a message at NO RESULT then use "$totalRows_Recordset1" variable like: if($totalRows_Recordset1 == 0)echo "No result found"; And its much better if you write quries by yourself, not use Dreamweaver for this type of typical stuffs, it mainly helps you with some common quries.