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
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
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
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
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 values of
-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 reason you're
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
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
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 02,
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:[EMAIL
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
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 PROTECTED])
The
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
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 in
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,
is it
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
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
There is a single quote and semicolon on the line under /html 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
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.
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
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:
?
$server = ;
$user = ;
$pass = ;
$db = ;
$table = ;
?
?
$to = CKnott
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
22 matches
Mail list logo