Re: [PHP-DB] Parse Error...

2002-12-02 Thread Chase
Thank you!! This appears to have solved it... I didn't even think of using the "$message" variable instead of the "print()"... Sheesh... I still have LOTS to learn!! Chase "Micah Stevens" <[EMAIL PROTECTED]> wrote in message 1038878012.23696.129.camel@tyrell">news:1038878012.23696.129.camel@

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Micah Stevens
Remember, the print() function sends stuff to the browser. If you wish to make the code output to the $message variable, you must use additional assignment statements. I made some quick changes to the code below, try that: " . ", " ; $to .= "Chase <[EMAIL PROTECTED]>"; $subject = "Price File

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Chase
Okay, you just jumped WAY outside my basic knowledge... However, it does make perfect sense, so I am off to the library... Chase "Jim Hunter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... In that case, your logic is not going to work. You have live PHP code

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Jim Hunter
In that case, your logic is not going to work. You have live PHP code inside a string. You are going to need to build the $message in pieces. Start with the HTML, then add the result from each itteration of your PHP loop to $message then add the trailing HTML to form the complete $message. Your

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Chase
There is a single quote and semicolon on the line under that I thought would be defining the end of the assignment. Should I have used double quotes instead of single? Chase "Micah Stevens" <[EMAIL PROTECTED]> wrote in message 1038870535.23725.123.camel@tyrell">news:1038870535.23725.123.cam

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Micah Stevens
There aren't any closing quotes on your $message variable or semicolon to tell the parser that you're done with the assignment statement. -Micah On Mon, 2002-12-02 at 15:05, Chase wrote: > When trying to execute the following script to send the contents of a table > via "mail()" I am getting

[PHP-DB] Parse Error...

2002-12-02 Thread Chase
When trying to execute the following script to send the contents of a table via "mail()" I am getting this error... Parse error: parse error, unexpected T_STRING in FILENAME.PHP on line 36 The portion of this code inside the HTML tags works great for displaying the table on the screen, but when I

Re: [PHP-DB] mysql - enum

2002-12-02 Thread Ruth Zhai
This is what I use: SHOW COLUMNS FROM table LIKE "field" I use the query result for a select field in HTML table. Ruth - Original Message - From: "Bastian Vogt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 11:41 PM Subject: [PHP-DB] mysql - enum > Hi, >

[PHP-DB] Call to undefined function: dbmopen()

2002-12-02 Thread vernon
I'm getting the "Fatal error: Call to undefined function: dbmopen()" error after defining a path and calling the dbmopen() funtion in the following code: function getcoor($zip){ $path = "/home/penpals/pub/cgi-bin/zipdb.db"; $dbm = dbmopen("$path", "r"); Does php have to be compiled with something

[PHP-DB] Fulltext matching

2002-12-02 Thread Peter Beckman
Is there any way in PHP and MySQL to find out the most used words in a full text index? Is there access to the index? In the index I want to show the words that occur the most in descending order limit 50. In addition, is there any way to search for, without boolean (using 3.23.??), words in a r

Re: [PHP-DB] Refining my search app..

2002-12-02 Thread Adam Voigt
A little cleaner: switch($_POST[column]) { case("foo"):$query = mysql_query("WHATVER");break; case("too"):$query = mysql_query("BLAH");break; default:$query = mysql_query("DOH");break; } while($row = mysql_fetch_array($query)) { // DO SOMETHING } -- Adam Voigt ([EMAIL PROTEC

[PHP-DB] Refining my search app..

2002-12-02 Thread Ryan Christensen
Here's the skinny: I'm starting development on a small search application & need some input on a small roadblock I've run into.. What I need: - Script needs to be able to search database for matching queries in a specified column. (Ex: from a dropdown list the user selects "foo" and types in "b

[PHP-DB] Re: Max execution time

2002-12-02 Thread Mike Mannakee
PHP meant Personal Home Page to the guy who originated it. Later people then decided to get cute and have redefined it to mean Php Hypertext Preprocessor. Take your pick. As for the max execution time, you're fine as long as the script completes what it's doing within the allotted time. If your

Re: [PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
another one: Is there some kind of explorer timeout for scripts that execute too long? Radovan "Ryan Jameson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'd use this: set_time_limit (3600); <>< Ryan -Original Message- From: Radovan Radic [mailto:[

Re: [PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
Thx for the quick response, i ll see if that helps me "Ryan Jameson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'd use this: set_time_limit (3600); <>< Ryan -Original Message- From: Radovan Radic [mailto:[EMAIL PROTECTED]] Sent: Monday, December 0

RE: [PHP-DB] Max execution time

2002-12-02 Thread Ryan Jameson (USA)
I'd use this: set_time_limit (3600); <>< Ryan -Original Message- From: Radovan Radic [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 8:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Max execution time Hi all (I post questions although i dont get answers, but i am trying. I m

[PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
Hi all (I post questions although i dont get answers, but i am trying. I must say i dont give answers because i dont know much about php yet) I have problems with script exceedded time. Script is executing mssql stored procedure which executes about 5-6 mins. I need to execute it and then get res

RE: [PHP-DB] php session

2002-12-02 Thread Ford, Mike [LSS]
> -Original Message- > From: Chris Barnes [mailto:[EMAIL PROTECTED]] > Sent: 02 December 2002 02:14 > > On Mon, 2002-12-02 at 02:43, John W. Holmes wrote: > > > > No, it shouldn't. > > > > So, the links are correct on one page, and they disappear > on the second > > page? Is there a rea

Re: [PHP-DB] mysql - enum

2002-12-02 Thread Ignatius Reilly
DESCRIBE tbl_name col_name Ignatius - Original Message - From: "Bastian Vogt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 1:41 PM Subject: [PHP-DB] mysql - enum > Hi, > > is it possible to get all possible va

[PHP-DB] mysql - enum

2002-12-02 Thread Bastian Vogt
Hi, is it possible to get all possible values of an enum-field from a mysql-table in php? The values might be changed in the database. Now I've got an select-field in my php-app where the user can select each value of the enum-field for a new record befor saving... Thanks for any reply, Bastian

Re: [PHP-DB] some data output formatting and grouping question...

2002-12-02 Thread Ignatius Reilly
Very simple procedurally (though not in SQL). Here's the pseudo-code: Execute: SELECT * FROM Y WHERE U = 'me' ORDER BY Y, X $flag = "last_y" ; // flag indicating whether or not your mysql_fetch_array() brings a new value of Y Loop your query result { if Y <> $flag['last_y'] { // thi

[PHP-DB] ODBC error...please help

2002-12-02 Thread Radim Klasek
Does anybody know, what does it mean: SQL error: [Microsoft][ODBC Visual FoxPro Driver]File 'datum_format.prg' does not exist., SQL state S0002 in SQLExecDirect I'm using DATUM_FORMAT function in SQL command and this error is shown. Thank you, Radim

RE: [PHP-DB] some data output formatting and grouping question...

2002-12-02 Thread Snijders, Mark
I think you should first make a new datamodel, cause if I see this, it isn't right (just my 2 cents) :-) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] some data output formatting and grouping question...

2002-12-02 Thread David Smith
I don't see an easy way to do this in one SQL statement. But, the following PHP does the trick for me (assuming MySQL): // get the list of Y values $r = mysql_query( "SELECT * FROM table GROUP BY Y" ); while( $y_val = mysql_fetch_array( $r ) ) $y_vals[] = $y_val['Y']; // For each Y, fetch