could cause your problems, at
least without not being able to actually see the failed queries.
Regards,
Krister Karlström, Helsinki, Finland
Chris wrote:
Please always cc the mailing list so others can offer extra
advice/suggestions etc.
Weaver Hickerson wrote:
they work in query analyzer
, then maybe that's the problem...? :)
Regards,
Krister Karlström, Helsinki, Finland
Weaver Hickerson wrote:
Krister -
I've included the query below - If I paste it in query analyzer on 2000, or
2005 it works fine.
Just coming through PHP4 to 2005, it hangs. I actually don't get an error
INTO legioCurrent (column_1, column_2, ...)
VALUES (?,?,...)
I would also like to propose for you to use the object oriented style,
since it's more readable and easier to get an overview of. You also
don't need to mess around with so many parameters.
Greetings,
Krister Karlström, Helsinki, Finland
Hi again Jason!
Jason Pruim wrote:
On Apr 4, 2008, at 2:35 PM, Krister Karlström wrote:
You also don't need to mess around with so many parameters.
What do you mean by this?
Since you're working in object context you mostly just refer to your
variable with the name of the object
.
In general, very few script are written in such a way that they work the
same way in a webserver environment and on command line. You should
design your scripts for either the environment.
Greetings,
Krister Karlström, Helsinki, Finland
Molteni Davide wrote:
Hi,
I have a problem with all my php
. However, I have seldom used PHP in a Windows environment so maybe
I'm the wrong person to answer your questions! :) I do however have a
command line application running on Windows XP that successfully uses
MySQL on a Linux server, never had any trouble with that...
Greetings,
Krister Karlström
Hi!
You can't use the MAX() function if you're not using a GROUP BY clause.
The MAX() function can only grab the maximum value of a grouped column,
as with MIN(), COUNT(), AVG() etc..
Greetings,
Krister Karlström, Helsinki
Jonathan Crawford wrote:
I think this is what you mean. You just
basically means that you don't need two tables
anymore. But you could at least consider this, if you are able to alter
the database design a bit.
Greetings,
Krister Karlström, Helsinki
Graham Cossey wrote:
Thank you for your input Jonathan but it's not quite what I need. I
need the latest action
of the columns you want.
I hope that this is what you wanted the query to do.. :)
Cheers,
Krister Karlström, Helsinki, Finland
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, this is a tricky one anyway...
/Krister Karlström
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|
+---+-++-+
4 rows in set (0.00 sec)
Hmm... Now I'm stuck! :)
Greetings,
Krister Karlström, Helsinki, Finland
Graham Cossey wrote:
I can't see how to accomplish what I need so if anyone has any
suggestions they would be gratefully received...
I'm
This will give you:
ERROR : Invalid use of group function
It seems like the use of an aggregate (or how is it spelled?) function
is not allowed in a join statement...
/Krister
Jon L. wrote:
You can try adding a quick test to the ON statement...
SELECT * FROM TableA
INNER JOIN TableB
to delete the gallery. I guess that you maybe want to use the
variable $galerie_id..? Well, I can't tell without any more information
about your application.
Greetings,
Krister Karlström, Helsinki, Finland
Ruprecht Helms wrote:
while($row = mysql_fetch_object($result))
{
$galerie_id=$row
13 matches
Mail list logo