You should try echoing out mysql_error() to see what error is being returned from
MySQL or run mysql from the command line on your laptop and run the same query that
your script is running.
HTH
--Sam Masiello
On Wed, 29 May 2002 20:35:33 -0400 (EDT) "Eric P. McDonough&quo
He is not doing a sub select...he is doing a union. Unions are
implemented in MySQL 4.x
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002
Not really a MySQL question, but it is related to the MySQL web site
If I go to:
http://www.mysql.com/udmsearch/search.php
the "Support" link is spelled "Pupport" (on other pages it is spelled
correctly, however)....whoops :)
--Sam
Sam Masiello
Software Qualit
You are correct, Tyler.
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
The above URL has some more information on this.
HTH :)
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Tyler Longren [mailto
Is it only pulling up the first record in a script that you are writing
(like in a PHP script) or does it also exhibit this behavior if you enter
your query from the mysql command line interface?
If it is the former, I would imagine there is a problem with your script.
HTH
Sam Masiello
Hi Tim!
You could do something like this:
$sqlstr = "select date_format(EventStartDate, '%M %D %Y') as mydate, (rest of your
SQL string here)" ;
$result = mysql("mydb", $sqlstr, $connect) ;
$myformatteddate = mysql_result($result, 0, 'mydate') ;
This should do it for you :) HTH
he index that you want it to
use.
HTH
See: http://www.mysql.com/doc/M/y/MySQL_indexes.html
This link has some good info that might be of some help :)
HTH
Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Chai-Hup Chen [mailt
$row_count equal to the number of rows returned by your
query identified by $result).
See www.php.net/mysql for some good information on this as well.
HTH
Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Randy Johnson [mailto:[EMAIL