[PHP-DB] Formatting - Solved

2012-11-26 Thread Ethan Rosenberg, PhD
Dear list Here is the answer ORIGINAL centerbSearch Results/b/centerbr / center !-- This is the block that prints about one screen full down bellow the Search Results header -- table border=4 cellpadding=5 cellspacing=55 rules=all frame=box style=table-layout: fixed; tr

[PHP-DB] Formatting

2012-11-25 Thread Ethan Rosenberg, PhD
Dear list - When I run the following code, the results are preceded by at least one screen full of blank lines. I am showing you a large code block since I do not know where the error is: if(isset($_REQUEST['Sex']) trim($_POST['Sex']) != '' ) { if ($_REQUEST['Sex'] === 0)

Re: [PHP-DB] formatting a word doc using php ?

2010-09-20 Thread Richard Quadling
On 17 September 2010 21:41, Vinay Kannan viny...@gmail.com wrote: Hello Xperts, I am trying out a couple of things and have come across this requirement, where in a php script should create a doc file with specific formatting, I can create the file, havent tried it yet, but shouldnt be a

[PHP-DB] formatting a word doc using php ?

2010-09-17 Thread Vinay Kannan
Hello Xperts, I am trying out a couple of things and have come across this requirement, where in a php script should create a doc file with specific formatting, I can create the file, havent tried it yet, but shouldnt be a problem I guess, but how do I format the doc file is the question, google

RE: [PHP-DB] formatting a word doc using php ?

2010-09-17 Thread Ashay Chaudhary
...@gmail.com] Sent: Friday, September 17, 2010 1:42 PM To: PHP DB Subject: [PHP-DB] formatting a word doc using php ? Hello Xperts, I am trying out a couple of things and have come across this requirement, where in a php script should create a doc file with specific formatting, I can create the file

Re: [PHP-DB] formatting a word doc using php ?

2010-09-17 Thread Aleksei Sapunov
by Maarten, who's an incredibly smart guy. : Ashay -Original Message- From: Vinay Kannan [mailto:viny...@gmail.com] Sent: Friday, September 17, 2010 1:42 PM To: PHP DB Subject: [PHP-DB] formatting a word doc using php ? Hello Xperts, I am trying out a couple of things and have

[PHP-DB] Formatting output with json_encode

2008-07-14 Thread Ron Piggott
I am using json_encode to output the results of a mySQL query which is part of a jquery ajax. $result = json_encode($array); echo $result; The output on my screen is: {0:John 14:27,verse_reference:John 14:27} How do I format json_encode output? I would like John 14:27 to be what is

Re: [PHP-DB] Formatting output with json_encode

2008-07-14 Thread Evert Lammerts
Check out http://www.json.org/ for JSON structures. In javascript an Array object is a special implementation of the Object object (like all objects other than Object) - an Array object can only have numerical indices, an Object object can have textual indices too. If you json_encode a php array

Re: [PHP-DB] Formatting in Text Area

2008-02-02 Thread bedul
i'm just add Tobias script. put rtrim and ltrim to have a better result. - Original Message - From: Tobias Franzén [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, February 01, 2008 10:24 PM Subject: Re: [PHP-DB] Formatting in Text Area Hi Patricia, You can impose width

Re: [PHP-DB] Formatting in Text Area

2008-02-01 Thread Evert Lammerts
VanBuskirk, Patricia wrote: I have a customer description text area field on my form which feeds through php to FMP, What's FMP? Is that what links this email to the db-list? and spits out a confirmation page and email. The issue I am having is this ... as the customer types, the text

Re: [PHP-DB] Formatting in Text Area

2008-02-01 Thread Tobias Franzén
at php and learn much better by example. Thanks Evert! Trish -Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Friday, February 01, 2008 8:21 AM To: VanBuskirk, Patricia Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Formatting in Text Area VanBuskirk, Patricia

[PHP-DB] Formatting in Text Area

2008-02-01 Thread VanBuskirk, Patricia
I have a customer description text area field on my form which feeds through php to FMP, and spits out a confirmation page and email. The issue I am having is this ... as the customer types, the text wraps. Many put their own hard returns and spaces in to organize their description. It seems

RE: [PHP-DB] Formatting in Text Area

2008-02-01 Thread Bastien Koert
$text = nl2br($text); bastien Date: Fri, 1 Feb 2008 08:07:17 -0500 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Formatting in Text Area I have a customer description text area field on my form which feeds through php to FMP, and spits out a confirmation page

[PHP-DB] Formatting in Text Area

2008-02-01 Thread VanBuskirk, Patricia
-Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Friday, February 01, 2008 8:21 AM To: VanBuskirk, Patricia Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Formatting in Text Area VanBuskirk, Patricia wrote: I have a customer description text area field on my form which

[PHP-DB] Formatting MySQL Queries

2007-01-24 Thread Brent Anderson
Hello. My team and I are looking for a way to return an entire table of MySQL data with columns delimited by tabs and rows delimited by carriage returns. How exactly would this work - I'm not a PHP expert and, although I know MySQL, I don't know where to begin with formatting a query

Re: [PHP-DB] Formatting MySQL Queries

2007-01-24 Thread Niel Archer
Hi SELECT * FROM table INTO OUTFILE 'file_name' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Formatting a form box

2006-01-12 Thread Alex Major
Hi there, On one of my forms, there is a section where users can put images etc..and then it is displayed on my php pages. My question is how do I make it so that the html formatting is automatically done. For example when someone is typing something, and wants to start a new paragraph although

RE: [PHP-DB] Formatting a form box

2006-01-12 Thread Bastien Koert
use the nl2br() function to convert the newlines to br bastien From: Alex Major [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Formatting a form box Date: Thu, 12 Jan 2006 16:33:01 + Hi there, On one of my forms, there is a section where users can put images etc

RE: [PHP-DB] Formatting a form box

2006-01-12 Thread Miguel Guirao
solution, but I'm pretty sure there others!! Mike Guirao -Original Message- From: Alex Major [mailto:[EMAIL PROTECTED] Sent: Jueves, 12 de Enero de 2006 10:33 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Formatting a form box Hi there, On one of my forms, there is a section where

RE: [PHP-DB] Formatting a form box

2006-01-12 Thread tg-php
PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Formatting a form box Date: Thu, 12 Jan 2006 16:33:01 + Hi there, On one of my forms, there is a section where users can put images etc..and then it is displayed on my php pages. My question is how do I make it so that the html formatting

Re: [PHP-DB] Formatting a form box

2006-01-12 Thread El Bekko
need!! This is just one solution, but I'm pretty sure there others!! Mike Guirao -Original Message- From: Alex Major [mailto:[EMAIL PROTECTED] Sent: Jueves, 12 de Enero de 2006 10:33 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Formatting a form box Hi there, On one of my forms

Re: [PHP-DB] Formatting a form box

2006-01-12 Thread Alex Major
($_POST['testarea']); } ? Look at the source code after you submit if you have any doubts/questions. -TG = = = Original message = = = use the nl2br() function to convert the newlines to br bastien From: Alex Major [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB

[PHP-DB] formatting a date from mysql

2005-12-12 Thread Eternity Records Webmaster
I need to figure out how to format the date format: year-month-day (2005-12-06). It is a date(8) field in a mysql table that i pulled out of the table with php 5.0.5. I need it in the format: Tue December 6, 2005 (or in mysql's formatting: 6-12-2005). I am using the reformatting for display only.

Re: [PHP-DB] formatting a date from mysql

2005-12-12 Thread Adrian Bruce
farily straight forward to withinn the query itself, check out http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html or for php http://uk.php.net/date RTFM Regards Adrian Eternity Records Webmaster wrote: I need to figure out how to format the date format: year-month-day

RE: [PHP-DB] Formatting numbers

2003-07-24 Thread David Smith
Thanks. That works perfectly. David Smith -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 3:36 PM To: David Smith; php-db Subject: Re: [PHP-DB] Formatting numbers I am a little new to PHP, but I am trying to pull numbers from

Re: [PHP-DB] formatting a timestamp

2003-06-02 Thread Gürhan Özen
Rick, Please give more information about your problem. Are you trying to format a timestamp field in a MySQL table? If yes, you can do something like, SELECT DATE_FORMAT( columnname, '%m-%d-%y : %T-%i' ); Hope this helps... Gurhan On Sat, 2003-05-31 at 01:38, Rick Dahl wrote: I want to print

[PHP-DB] formatting a timestamp

2003-05-31 Thread Rick Dahl
I want to print out a timestamp of length 14. I want to have it formatted like: mm-dd-yy : hh-mm I have looked but all I can find is how to format a date and I don't want that. I want the time also. Rick Don't burn the day...away ~ DJM

Re: [PHP-DB] formatting a timestamp

2003-05-31 Thread Rolf Brusletto
*This message was transferred with a trial version of CommuniGate(tm) Pro* Rick, You can use date() in the following fashion.. $timeStamp = time(); date('m-d-y : h-m', $timeStamp); where $timestamp is a unix epoch timestamp. Hope this helps! Rolf Brusletto http://www.phpexamples.net Rick Dahl

[PHP-DB] Formatting txt from a database

2002-12-12 Thread Lisi
I am retrieving text stored in a database, and I want to strip out any HTML tags and then only display the first 30 characters with ... to show the user that there is more text to view. My problem is with stripping out HTML tags, the code is stripping out the text enclosed within the HTML tags

Re: [PHP-DB] Formatting txt from a database

2002-12-12 Thread DL Neil
Lisi, To save reinventing the wheel would strip_tags() be any use to you? (see manual) =dn I am retrieving text stored in a database, and I want to strip out any HTML tags and then only display the first 30 characters with ... to show the user that there is more text to view. My problem is

Re: [PHP-DB] Formatting txt from a database

2002-12-12 Thread Matt Vos
- From: Lisi [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 3:55 AM Subject: [PHP-DB] Formatting txt from a database I am retrieving text stored in a database, and I want to strip out any HTML tags and then only display the first 30 characters

[PHP-DB] formatting table column to display as a hyperlink using Oracle

2002-03-27 Thread Franden, Craig
Hi, I am using a small php script to return records from an oracle8.1.6 database. I would like to have one of the columns contents display the data as a hyperlink and I am not quite sure how to do it. Here is the code that returns the data (which is correct). The table formatting is the issue.

Re: [PHP-DB] formatting table column to display as a hyperlink using Oracle

2002-03-27 Thread olinux
What are you trying to link to? Most likely you need to pass a few variables in the URL This should give you an idea: echo TDA HREF=whateverpage.php?var1=$var1record=$column_value$column_value/ATD; olinux --- Franden, Craig [EMAIL PROTECTED] wrote: Hi, I am using a small php script to

RE: [PHP-DB] formatting w/ table

2002-02-15 Thread Rick Emery
Further, I recommend replacing your echos with the following: echo trtd width=\30%\BType Of Car: /B/tdtd. $myrow['car_type']./td/tr\n; echo trtd width=\30%\BModel Of Car: /B/tdtd. $myrow['car_model']./td/tr\n; echo trtd width=\30%\BYear Of Car: /B/tdtd. $myrow['car_year']./td/tr\n; echo trtd

RE: [PHP-DB] Formatting Strings in MySQL

2001-07-02 Thread Jesse S. Williams
Message- From: Artur Correia [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 11:37 AM To: Jesse S. Williams Subject: Re: [PHP-DB] Formatting Strings in MySQL Hey, Thanks in advance for your trouble replying this. I havent tried it out yet - nor will I untill August. I'm still planning

[PHP-DB] Formatting Strings in MySQL

2001-07-01 Thread Jesse S. Williams
Electronic Data Systems -Original Message- From: Artur Correia [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 30, 2001 12:45 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Formatting Strings in MySQL Hey How can I get a string (or number) from mySQL like 123123123 to display 123 123 123

[PHP-DB] Formatting Strings in MySQL

2001-06-30 Thread Artur Correia
Hey How can I get a string (or number) from mySQL like 123123123 to display 123 123 123?? Tks I'm kinda rookie Artur -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list