Re: [PHP-DB] problem in recorset that seems temporary

2008-01-25 Thread Krister Karlström
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

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
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

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
, 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

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlström
| +---+-++-+ 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

Re: [PHP-DB] Help with JOIN query

2008-03-06 Thread Krister Karlströ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

Re: [PHP-DB] Re: Help with JOIN query

2008-03-07 Thread 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

Re: [PHP-DB] Re: Help with JOIN query

2008-03-07 Thread Krister Karlström
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

Re: [PHP-DB] mssql_connect error only on command line

2008-04-02 Thread Krister Karlström
. 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

Re: [PHP-DB] mssql_connect error only on command line

2008-04-02 Thread Krister Karlström
. 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

Re: [PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Krister Karlström
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

Re: [PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Krister Karlström
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

Re: [PHP-DB] PHP4, mssql_* and SQL Server 2005

2008-11-05 Thread Krister Karlström
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

Re: [PHP-DB] PHP4, mssql_* and SQL Server 2005

2008-11-05 Thread Krister Karlström
, 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