Re: [PHP-DB] printing with php

2003-05-28 Thread Ronan Chilvers
Crikey !! However, this is still server-side, and the impression I got was that the printing was going to be client-side. I may be wrong though, in which case, this seems to do the trick just fine BTW, its also on the PHP site ... printer module. Ronan e: [EMAIL PROTECTED] t: 01903 739 9

Re: [PHP-DB] hotornot functionality

2003-05-28 Thread Mengü Gülmen
I think the best way is to use sessions. when the user comes to the site or he submits a rating, start a session and create a variable, in which you store the images' id that the user rated like $var="1,1423,523" etc.. then use it in your query mysql_query("select id from images where id not in ($v

RE: [PHP-DB] hotornot functionality

2003-05-28 Thread Snijders, Mark
i would do it totally different if i understand you right.. you start with row number one, show it, give it a rate, then show number 2, and show number 1 as last rated pic!!! then you have the problem of reaching the last record!! but !! i also see another problem: if you do row 1,2,3,4 you al

Re: [PHP-DB] hotornot functionality

2003-05-28 Thread Alex Harris
Why not have a field called last in the db? You set it equal to true for the last image and then check it for all of the images. If it's true, you just null the next option and the user can't go any farther. From: Matthew Horn <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] hotor

[PHP-DB] hotornot functionality

2003-05-28 Thread Matthew Horn
I am toying with the idea of implementing functionality similar to the hotornot.com site -- for a different purpose, mind you, but the same kind of user experience. Here's what it does: 1. A picture is served up. 2. User clicks on a radio button scale from 1 to 10 to "rate" the picture. 3. The

[PHP-DB] [plain SQL Problem] Group By

2003-05-28 Thread Sapporo
Hi, sorry if this is off topic. I hope you don't mind a plain SQL question here. I know I can do what I want using subqueries (I'm on Oracle9i here), but I would really like to avoid them for performance reasons. Here's my example data: > DESC dept NameType

[PHP-DB] Re: header problem with IIS

2003-05-28 Thread Peter Misun
problem was with switch in W2k server there is - Performance Options -> Application response - and it can be switched to "Applications" or "Background services" after switching from second one to first one (app...), everything works fine now (without CGI Error) 5o Peter Misun wrote: > ru

[PHP-DB] database model

2003-05-28 Thread Snijders, Mark
hello I use mysql can somebody tell me if it's possible to create a database model, like you can do in access... so you can see the relationships between tables (exporting to access and then to it really sucks :((( ) so please another option if possible thanks

Re: [PHP-DB] Double Trouble!

2003-05-28 Thread Ronan Chilvers
On 25 May,2003 at 17:34 S. Cole wrote: > I can't seem to find out why I am getting two copies of the same entry in my > database. I reckon you're calling the script twice. Can we see the scripts that you call this one from ? > > ==

Re: [PHP-DB] printing with php

2003-05-28 Thread Ronan Chilvers
Hi Carol I don't think you'll strike lucky here !! PHP is a server-side, not client-side language and therefore doesn't know anything about the client's printer or its settings. You can use PHP to create a page that is formatted nicely and will therefore print well. There are also some IE sp

Re: [PHP-DB] MS-SQL date format problem

2003-05-28 Thread Peter Misun
as Robert and me observed (from source code) - that switch isn't there in 4.1.2 after installing 4.3.1 there is no problem with date format - switch is working 5o Robert Twitty wrote: > I don't have access to the source code for PHP 4.1.2, but I would not be > suprised if this was the case.

[PHP-DB] printing with php

2003-05-28 Thread carol
Hy there, I have a problem... I have a linux server, apache, php, and mysql instaled. I can make all kind of queries but I nedd to printed them (using the browser but not usig file->print->page setup-.>...) in a specified format (like A3, landscape, border=2cm, and all kind of things like th

[PHP-DB] ODBC driver for ORACLE

2003-05-28 Thread Alain BARBU
Hi, Is there any free ODBC Driver for ORACLE 9i to use with PHP, APACHE, LINUX ? Regards Alain