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.

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.

I have two tables: 1. tb1 2. tb2 They share the same column called \"County\". I want to select all entries from tb1 that are NOT in tb2. E.g. If a county \"xyz\" is in tb2 then i dont want it to show up when i run the query on tb1.

read this http://www.phpfreaks.com/tutorials/40/0.php might be helpful... its a tutorial on making a membership system...

you can work offline as long as u have to the PHP script files on ur computer. Just d/l and configure ur computer to run php files. I think u will also need to d/l MySQL to run phpnuke. just shout when u need help

if i understood ur question correctly, U can return the max sequence number by Select max(unique_id) from table; Where unique_id is a column that stores sequence numbers.. Then u can use that number and increment it by 1 and insert it into the database. -hope it helps

I use HapEdit... and i like it. It supports ASP, PHP, HTML... You can d/l it from here http://hapedit.free.fr/download.php3