nabeel21

I am not sure if I understand your concern, but if you are trying to access a remote file (that is not in folder "httpdocs") then: 1. edit php.ini and set allow_url_fopen setting to "on" 2. in your code use: <?php include 'http://www.example.com/file.php?foo=1&bar=2'; ?> More help here: http://us.php.net/manual/en/function.include.php

1. Install PHP using the installer on Windows machine (running IIS) - Install PHP to C:\PHP 2. Add PHP Directory to Windows Path -- instructions on php.net http://us.php.net/manual/en/faq.installation.php#faq.installation.addtopath 3. Now download the Windows Binaries ZIP Package from php.net -- http://us.php.net/downloads.php 4. Extract and overwrite all files in C:\PHP -- Do this to get all extension files and other files necessary for IIS to work with PHP 5. Open php.ini and uncomment the ldap extension 6. Restart computer -- everything should work

$query = "select * from table_name where column_name like \'$searchterm%\'"; If you want your search to be exactly the same as $searchterm then $query = "select * from table_name where column_name like \'$searchterm\'";

hmmm.. only thing i can think of is that the \"is_registered\" column hold numbers only.. so try UPDATE staffemails SET is_registered =0 WHERE staff.users_username = \'$user\' and staffemails.staff_id = staff.staff_id Lets see if it works this way.... --goodluck

From the mysql manual http://www.mysql.com/doc/en/SELECT.html For the second part... 1. Make a form 2. define an action 3. put your textfield in there 4. make a submit button then on the other page just call the value from the precious page using echo $searchterm; --hope this helps. If you need more help, paste your code.

You will have to use Task Scheduler (windows) or cron jobs (Linux) to automatically run a PHP script that will check the time/data and will send out emails as necessary. --goodluck

SELECT * FROM hotels WHERE hotelname LIKE \'%j%\' OR hotelcountry LIKE \'%j%\' OR hoteladdress LIKE \'%j%\' and make sure that the data in mysql table is all lowercase, cuz you are using \"j\". goodluck

I think this desc column is causing a problem. I remember having this kind of problem but when i changed the column name to something else... it worked. Please give it a try. goodluck

shivabharat > I think \'mysqldump\' should be executed at the shell and it is not a mysql internal command. To call mysqldump do this: C:>cd mysqlbin C:mysqlbin>mysqldump database > export.sql OR C:mysqlbin>mysqldump database > \"C:myfolderexport.sql\"

I would like to know that too. Plus what are these forum and phpfreaks.com running on? Is it MySQL?

.MYD is the MySQL Database file... looks like it is misplaced/corrupt or has been moved ... Make sure the file is in the \'data\' folder under Mysql. hope it helps..

From MySQL manual: I had the same issue and wanted to store the date in mysql in a custom format. I defined the column to be a TEXT instead of DATETIME and populated it with PHP [php:1:44d99b4a40]<?php $datetime = date(\"d/m/Y h:i\"); ?>[/php:1:44d99b4a40] Hope it helps.

if i understand this right... I think you should update the \'postdate\' field everytime a person posts a reply. When u change the parent_id also update the \'postdate\'. Then you can sort the data with the replied ones at the top. --hope this makes sense

Barand: Thanks alot man... it works perfectly. -- thankssss

Here are 2 tables which share the same columns (CITY and COUNTY) TB1 (Main table that stores the info of all cities and counties) CITY-------------------------COUNTY --------------------------------------- Tampa----------------------Hillsborough Orlando---------------------Orange Frostproof-------------------Polk Arcadia----------------------Desoto County----------------------Collier Tallahassee-----------------Leon ---------------------------------------------- TB2 (Contains info for all cities and counties who have submitted data) CITY--------------------------COUNTY --------------------------------------- Arcadia----------------------Desoto County----------------------Collier Tallahassee-----------------Leon ------------------------------------------------ Now I want to query TB1 and find out which city/county has NOT submitted their data. The query should return CITY-------------------------COUNTY ---------------------------------------- Tampa----------------------Hillsborough Orlando---------------------Orange Frostproof------------------Polk Thanks in advance.