[PHP-DB] Q

2004-08-22 Thread Remember14a
Dear Friends, Data in the table is displayed by php query. .Say column A, in which name of company will be stored. Now i want to add another column B to table in which web addresse will be stored against each name in Column B.and same should be displayed in an html table, when seen in

Re: [PHP-DB] Q

2004-08-22 Thread Doug Thompson
[EMAIL PROTECTED] wrote: Dear Friends, Data in the table is displayed by php query. .Say column A, in which name of company will be stored. Now i want to add another column B to table in which web addresse will be stored against each name in Column B.and same should be displayed in an html

[PHP-DB] NULL and empty space

2004-08-22 Thread Craig Hoffman
I have an form where someone can choose to upload a photo. If the person does not upload a photo, an emtpy string is inserted in the DB. How can I have it insert 'NULL' in the DB instead of an empty string when they choose NOT to upload a photo but complete the form anyway? Any help is

Fwd: [PHP-DB] Q

2004-08-22 Thread Remember14a
Dear friends, Php query modification, guidance, please.not mysql alteration table.So thatQuery displays data in tabular form with "Onclick" link to web site in another column of table. Guidance, please. ---BeginMessage--- [EMAIL PROTECTED] wrote: Dear Friends, Data in the table is displayed by

[PHP-DB] Re: NULL and empty space

2004-08-22 Thread Daniel Schierbeck
Craig Hoffman wrote: I have an form where someone can choose to upload a photo. If the person does not upload a photo, an emtpy string is inserted in the DB. How can I have it insert 'NULL' in the DB instead of an empty string when they choose NOT to upload a photo but complete the form anyway?

Re: [PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-22 Thread Daniel Schierbeck
Balwantsingh wrote: May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls. tell how it can be done.

Re: [PHP-DB] Re: NULL and empty space

2004-08-22 Thread Craig Hoffman
I've tried that and thanks. Bad news is I still can't get it to work. Its always the simple things that causes problems. Any other suggestions? On Aug 22, 2004, at 10:41 AM, Daniel Schierbeck wrote: Craig Hoffman wrote: I have an form where someone can choose to upload a photo. If the person

Re: [PHP-DB] NULL and empty space

2004-08-22 Thread John Holmes
Craig Hoffman wrote: I have an form where someone can choose to upload a photo. If the person does not upload a photo, an emtpy string is inserted in the DB. How can I have it insert 'NULL' in the DB instead of an empty string when they choose NOT to upload a photo but complete the form anyway?

Re: Fwd: [PHP-DB] Q

2004-08-22 Thread Peter Ellis
Try using 0 and 1 in place of 'id' and 'email', depending on the order in which these are presented in the database. If the database presents id first, then id is 0. If email is first, email is 0. You should really read the PHP manuals on mysql_fetch_array() before assuming a particular

Re: [PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-22 Thread Daniel Schierbeck
Daniel Schierbeck wrote: Balwantsingh wrote: May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls.

FW: Fwd: [PHP-DB] Q

2004-08-22 Thread Darryl
I think he wants something like; Echo(a href=\$address\view website/a\n); Where $address = the db entry that will store the value -Original Message- From: Peter Ellis [mailto:[EMAIL PROTECTED] Sent: Sunday, August 22, 2004 6:57 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

[PHP-DB] php connect to remote oracle DB

2004-08-22 Thread Mohammad N. Tina
Hi all, I am new to php, but i found alot of tutorials on internet. I am trying to build a kind of web based reports system. i have oralce 8i and i want to use php, i have the following questions: 1-i noticed some examples use OCI and some ORA, which is better for me...currently i am using

[PHP-DB] Global Peace output

2004-08-22 Thread Remember14a
Dear friends, I have pasted table structure and php script below, Output I am getting is company name and web address, like pasted below Global Coalition For Peace http://www.globalcoalitionforpeace.net/ Physicians For Social Responsibility http://www.psr.org/ However, I want output

Re: [PHP-DB] Global Peace output

2004-08-22 Thread John Holmes
[EMAIL PROTECTED] wrote: Global Coalition For Peace http://www.globalcoalitionforpeace.net/ Physicians For Social Responsibility http://www.psr.org/ However, I want output page to print,url with link to website, With present script, its printing web address in table, however, onclick it

Re: [PHP-DB] Global Peace output

2004-08-22 Thread Remember14a
Dear friends, The html solution suggested by our friend, doesn't work.Try to understand question, please. The script should print company name its web address with onclick link to the web address. onclick link to the web address, html solution suggested by our friend doesn't work. Any

[PHP-DB] RE: [SPAM] [PHP-DB] Global Peace output

2004-08-22 Thread Vincent Jordan
You have no html link. Try echo $company bra href='$webaddress'$webaddress/abr -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, August 22, 2004 5:33 PM To: [EMAIL PROTECTED] Subject: [SPAM] [PHP-DB] Global Peace output Dear friends, I have

Re: [PHP-DB] Global Peace output

2004-08-22 Thread Peter Ellis
What errors are you getting? We can't help if we don't know what's wrong in the first place. Turn your PHP error reporting on (assuming it's a PHP error). -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Sun, 2004-08-22 at

Re: [PHP-DB] Global Peace output

2004-08-22 Thread John Holmes
[EMAIL PROTECTED] wrote: The html solution suggested by our friend, doesn't work.Try to understand question, please. The script should print company name its web address with onclick link to the web address. onclick link to the web address, html solution suggested by our friend doesn't work.

[PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-22 Thread Gezeala 'Eyah' Bacuño II
I only know how to in MS Excel. make your Report button open a new php page.. input name='excel' value='Report' type='button' onclick='fnExcel()' Javascript: function fnExcel(x) { ExcelWin = excel.php; window.open(ExcelWin,ExcelWin,alwaysRaised=yes, status=yes, menubar=yes, width=670px,

[PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-22 Thread balwantsingh
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadsheet (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP