[PHP-DB] Creating a file using php

2001-10-22 Thread Harpreet
Is there a command in PHP that can create a textfile and allows writing data to it dynamically? Can someone point me to a tutorial or site . Thanks in advance, help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http

RE: [PHP-DB] Creating a file using php

2001-10-22 Thread Harpreet
Blunt: NO!!! Duh Polite: Well its easier to post and get a reply rather then me going and serching fo it.;) regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 12:59 PM

[PHP-DB] Concatenating fields

2001-10-24 Thread Harpreet
as submit_column from sys_code_tbl order by category; echo OPTION selected value=\\/OPTION; $result = mysql_query($ssql); while ($row = mysql_fetch_array($result)) { echo OPTION value='.$row[submit_column].''.$row[fill_column].'/OPTION; } Help is appreciated. Regards, Harpreet Kaur Software Developer

[PHP-DB] New users on mysql using php

2001-10-25 Thread Harpreet
?? This way i can add or delete users that can have access to the mysql database through the web. I hope the above makes sense. Thanks, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] New users on mysql using php

2001-10-25 Thread Harpreet
, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:57 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] New users on mysql using php Do you have root access

[PHP-DB] Alternative for Union in MYSQL

2001-10-31 Thread Harpreet
lib_asset_tbl b on a.parent_id=b.asset_id union select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N' Help is appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Move next

2001-11-14 Thread Harpreet
Do we have a matching command for rs.movelast in PHP to get the data in the last record of the array $row=mysql_fetch_array($result); Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] Authenticate problem

2001-11-21 Thread Harpreet
for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/scripts/login.php on line 4 Error on connection string. How can i skip that message and send the user to the not logged page?? Please help. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database

[PHP-DB] JOBS in mysql

2001-11-07 Thread Harpreet
I have run JOBs in sql server and was wondering if we have ne thign similar in mysql or use PHP to write a script that would automatically run every 10 minutes. Help is apppreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http

[PHP-DB] working with views

2001-12-06 Thread Harpreet
where dev_device_view and cch_playlist_views are sql statements joining 2 tables using an inner join. Help is appreciated, regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] MYSQL query help

2001-12-14 Thread Harpreet
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id '' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP

[PHP-DB] Run php page automatically

2001-12-20 Thread Harpreet
appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

[PHP-DB] php with IIS

2007-03-08 Thread Harpreet
Is there a way to run our PHP pages through Microsoft's IIS? Regards, Harpreet Kaur -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] cron job and php

2002-04-16 Thread Harpreet Kaur
Thanks Lisi. The use of php in front of the path made /home/harpreet/crontest.php run one time when run from the telnet prompt. But it still doesnt run from the crontab. I created a mycron.txt file with the below statement. The put crontab mysql.txt to specify the cron. But it doesnt seem

[PHP-DB] subtracting one query from the other

2002-06-26 Thread Harpreet Kaur
Please help, I am stuck and my mind is frozen. I want to subtrack one query from the other. I have one query that brings all the records. The second gets another set of records. I want to subtract the second query from the first one . How do i do this? First query produces like 1000 records.