[PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
Anatol - you seem to be mixing up PHP with Firebird internal UDF, the two have nothing in common. FIRST. Can you actually access Firebird from PHP ( forget UDF totally at this stage ). PHP on Linux needs installing with php_ibase.so in order to access the ibase_/fbird_ functions. Once you

Re: [PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Anatol Ogórek
Uytkownik Lester Caine napisa: Anatol - you seem to be mixing up PHP with Firebird internal UDF, the two have nothing in common. FIRST. Can you actually access Firebird from PHP ( forget UDF totally at this stage ). PHP on Linux needs installing with php_ibase.so in order to access the

Re: [PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
Anatol ogrek wrote: I got php+firebird working without any problem. I am also able to create and compile simple udf for firebird. Good to hear :) I found that one UDF in php source so I thought that maybe someone of you managed to use that extension. I miss read what you were doing - where is

[PHP-DB] KEYBOARD

2004-12-01 Thread balwantsingh
May pls. help me. Can anybody guide me whether virtual keyboard can be made using PHP. Actually i am developing a site for our internal use where we will not give keyboard to user, the data can be entered by help of touchscreen pasted on the monitor. with best wishes balwant -- PHP Database

[PHP-DB] [PHP-DEV] KEYBOARD

2004-12-01 Thread balwantsingh
May pls. help me. Can anybody guide me whether virtual keyboard can be made using PHP. Actually i am developing a site for our internal use where we will not give keyboard to user, the data can be entered by help of touchscreen pasted on the monitor. with best wishes balwant -- PHP Database

[PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread Ross Honniball
Hi All, In MySql, you CAN'T do the following: SELECT sales * cost AS total WHERE total 100 Instead, you need to say: SELECT sales * cost AS total WHERE sales * cost 100 I'm just curious WHY you can't do it. You can, for example, specify ORDER BY total. I can't think of any reason why it would

Re: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread Jason Wong
On Wednesday 01 December 2004 17:53, Ross Honniball wrote: If someone can give me a good reason why this is so, it will stop it annoying me so much. I'm sure someone on the _MYSQL_ list will give you a jolly good reason or two. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread Ignatius Reilly
Very simply, because a clause WHERE sales * cost 100 would look up to sales and cost in the expression as SELECT fields. Your clause will wotk if you add sales and cost to the SELECT fields, but that would not be economical: - you don't need them in the result - you will execute the caclulation

[PHP-DB] Job interview test - I give up...

2004-12-01 Thread Tristan . Pretty
I recently saw a job that I thought I'd be good for, so they sent me a test... All good.. but I realised that I couldn't do it.. I got sooo damned close, but could not finish... :-( Anyhoo, here's the test: http://www.beertastic.co.uk/test_problem.zip And the test parameters are below If anyone

[PHP-DB] PHP-HTML-select deny

2004-12-01 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi, what can i do, where users can't select and copy my text from web-page. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Brent Baisley
OK. No offense, but that seems fairly easy. Here's one possible answer: select categories.*,count(dv_id) from categories left join dvds on dv_caid=ca_id group by ca_name having ca_name not like 'T%'; On Dec 1, 2004, at 8:13 AM, [EMAIL PROTECTED] wrote: I recently saw a job that I thought I'd be

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Jason Wong
On Wednesday 01 December 2004 20:50, PHPDiscuss - PHP Newsgroups and mailing lists wrote: Hi, what can i do, where users can't select and copy my text from web-page. Don't display any text. If they can see it they can copy it. If you're really determined, then use images instead of text. What

Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Tristan . Pretty
No offence taken! I've never had to use JOIN before... and the test was supposed to take an hour.. I didn;t wanna cheat... and it took me ages to even realise what I was supposed to be doing... (Plus [EMAIL PROTECTED] hungover :-( ) Anyhoo, I'll try what you've suggested... Cheers.. we live,

Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Raymond Chua Sing
/* NOTE: this is what I came up with though I don't have the time to test it. I think theres another way to solve this just by using a different sql statement. */ function getNumDvdsInCategories() { $query = SELECT ca_id , ca_name FROM categories, dvds WHERE

RE: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Bastien Koert
don't bother, its not possible... bastien From: [EMAIL PROTECTED] (PHPDiscuss - PHP Newsgroups and mailing lists) To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP-HTML-select deny Date: 1 Dec 2004 12:50:03 - Hi, what can i do, where users can't select and copy my text from web-page. Thanks -- PHP

RE: [PHP-DB] Multi-User Update Problem

2004-12-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 30 November 2004 14:45, SCALES, Andrew wrote: Thanks very much for your help. The main difficulty I was having really was unlocking the record again if the user crashed out

RE: [PHP-DB] [PHP-DEV] KEYBOARD

2004-12-01 Thread Gryffyn, Trevor
If the touch screen emulates a mouse, then you could do something in HTML + Javascript. It wouldn't have anything to do with PHP, just a mouse driven entry page in HTML. You could put Internet Explorer (or most other browsers) in kiosk mode (aka full screen mode) to hide the fact that it's in a

Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Brent Baisley
I code much better with drink than after drink. You never had to use JOIN before? Obviously you are not married. Although marriage tends to be a left join or right join as opposed to a straight join, which allows you to force an order.

Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Tristan . Pretty
Right Not married... Not as great a PHP/MySQL developer as I though... Alot of nots today... :-( I'll take a read or that link... This time next year, I'll be a professional...! (what, I don;t know..) Brent Baisley [EMAIL PROTECTED] 01/12/2004 15:10 To [EMAIL PROTECTED] cc [EMAIL

[PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
I posted this over on mysql list. Not trying to be redundant, but would like to get some feedback. Basically I'm wondering. I am creating a search form , dynamic query, that could potentially have in the area of 40+ where statements. i.3. 1- where x = y and -- PHP Database Mailing List

Re: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
Sorry ..hit the wrong button --- Stuart Felenstein [EMAIL PROTECTED] wrote: I posted this over on mysql list. Not trying to be redundant, but would like to get some feedback. Basically I'm wondering. I am creating a search form , dynamic query, that could potentially have in the area of

Re: [PHP-DB] KEYBOARD

2004-12-01 Thread Christopher Way
I would think client side scripting would be a much better candidate for that. Perhaps JavaScript? - Original Message - From: balwantsingh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 4:09 AM Subject: [PHP-DB] KEYBOARD May pls. help me. Can anybody guide

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Bastien Koert
so...best to build the statement dynamically and execute it once only if the input box has a value in it... $sql = select * from table where 1 ; if (isset($_POST['field1'])){ $sql .= and column1 = '.$_POST['field1']. '; ... if (isset($_POST['fieldN'])){ $sql .= and columnN =

[PHP-DB] Basic JOIN tutorial - RE: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Gryffyn, Trevor
Looks like you got a lot of good responses. I downloaded the zip file but then got slammed with some priority stuff and havn't had a chance to take a look at this. So in the interest of not forgetting and of closing this reply window :) just a quicky response. I had a lot of trouble initially

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Stuart Felenstein
--- Bastien Koert [EMAIL PROTECTED] wrote: so...best to build the statement dynamically and execute it once only if the input box has a value in it... And that is the way I'm building it. Just thinking about the scenario that somone actually chooses 75% of the options - would that

RE: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread Gryffyn, Trevor
Yeah, I've asked this question myself a million times. It'd be very useful and maybe some DB system knows how to do this, but for the most part you just have to deal with this reality. I believe that it's a matter of timing, really. You can't use the alias in the WHERE clause because it hasn't

Re: [PHP-DB] Basic JOIN tutorial - RE: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Stuart Felenstein
--- Gryffyn, Trevor [EMAIL PROTECTED] wrote: If you have Microsoft Access or something else that graphically lets you create queries, you might try building a query that you know works and returns what you need, then looking at the SQL VIEW to see how the syntax goes. It can help you

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Gryffyn, Trevor
I think you may hit the limit on the number of characters in the SELECT statement before you hit the max number of WHERE items. It's a good question though.Try doing a worst case scenario (pick all the options, enter data that's the max character length for each item, etc). Either through

[PHP-DB] getting data back when inserting

2004-12-01 Thread Aaron Todd
I was wondering if somone might be able to suggest a command to me...I am inserting data into a MySQL database that has an auto-incrementing primary field. When I insert the data I would like to somehow get the value of the auto-incrementing primary field. I thought I could just run a SELECT

RE: [PHP-DB] getting data back when inserting

2004-12-01 Thread Gryffyn, Trevor
I know this is only semi-helpful, but maybe it'll give you a kick in the right direction. In Microsoft SQL-Server you'd use @@IDENTITY to get the ID of the last row you inserted. There's bound to be something similar in other DB systems. identity is what SQL Server calls auto-number type

Re: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread dpgirago
Ross, If someone can give me a good reason why this is so, it will stop it annoying me so much. From the MySQL manual for version 4.0.16: It is not allowed to use a column alias in a WHERE clause, because the column value may not yet be determined when the WHERE clause is executed. See

RE: [PHP-DB] getting data back when inserting

2004-12-01 Thread Stefan
You should easily use mysql_insert_id(); otherwise you could use something like: SELECT max(id) FROM ... But I think the first command is what you're looking for. Stefan -Ursprüngliche Nachricht- Von: Aaron Todd [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Dezember 2004

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread denys
Bastien Koert a écrit : don't bother, its not possible... bastien From: [EMAIL PROTECTED] (PHPDiscuss - PHP Newsgroups and mailing lists) To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP-HTML-select deny Date: 1 Dec 2004 12:50:03 - Hi, what can i do, where users can't select and copy my text from

RE: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Norland, Martin
Hi, what can i do, where users can't select and copy my text from web-page. If you send text to the user, the user can always retrieve that text as just that. Whatever secret l33t code you're trying to protect, is just copied from some dhtml tutorial anyway. Whatever text on the page you

Re: RE: [PHP-DB] how to implement pages of results

2004-12-01 Thread ragan_davis
Thanks, guys. limit $start, $range works fine in conjuction with the $pagenum solution offered by Martin. I think my problem all along was that I was going under that assumption that the $start value was referring to the actual row number in the table, rather than the row number as found in

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Jason Wong
On Thursday 02 December 2004 00:37, denys wrote: wouldn't it be possible to display the text in a form text area and put it state to disabled ? But if someone really want your text he just have to rewrite it... sigh View source copy paste -- Jason Wong - Gremlins Associates -

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread denys
Jason Wong a écrit : On Thursday 02 December 2004 00:37, denys wrote: wouldn't it be possible to display the text in a form text area and put it state to disabled ? But if someone really want your text he just have to rewrite it... sigh View source copy paste ooops, I feel a bit

Re: [PHP-DB] Basic JOIN tutorial - RE: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Tristan . Pretty
Bloody marvelous...!!! Many thanks.. I'll set myself a few challenges, and see what happens...! Cheers, Tris... Gryffyn, Trevor [EMAIL PROTECTED] 01/12/2004 15:47 To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject [PHP-DB] Basic JOIN tutorial - RE: [PHP-DB] Job interview test - I give

Re: [PHP-DB] getting data back when inserting

2004-12-01 Thread Aaron Todd
Thanks a bunch...thats exactly what I was looking for. Aaron Stefan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You should easily use mysql_insert_id(); otherwise you could use something like: SELECT max(id) FROM ... But I think the first command is what you're looking for.

AW: [PHP-DB] getting data back when inserting

2004-12-01 Thread Stefan
The actual problem was the leading number in some of your arguments (4_h_1, 4_h_2, etc) Stefan -Ursprüngliche Nachricht- Von: Aaron Todd [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Dezember 2004 18:33 An: [EMAIL PROTECTED] Betreff: Re: [PHP-DB] getting data back when

RE: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread aNNa
Hi, what can i do, where users can't select and copy my text from web-page. Not that I've ever seen the need but this would deter casual copying: Make a Flash movie with a dynamic, non-selectable text field. The movie can load the text (actionscript command is loadVariables) from a database

RE: [PHP-DB] Question on the use of where statements

2004-12-01 Thread Bastien Koert
actually that would reduce it since a fewwer number of rows would potentially match the query...ensure that there is a composite index on a good selection of the columns to mkae the query quicker bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB]

RE: [PHP-DB] getting data back when inserting

2004-12-01 Thread Bastien Koert
mysql_insert_id bastien From: Aaron Todd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] getting data back when inserting Date: Wed, 1 Dec 2004 11:01:19 -0500 I was wondering if somone might be able to suggest a command to me...I am inserting data into a MySQL database that has an

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Bastien Koert
right click view source copy n paste disabling doesn't matter bastien From: denys [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP-HTML-select deny Date: Wed, 01 Dec 2004 17:37:22 +0100 Bastien Koert a écrit : don't bother, its not possible... bastien

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Robby Russell
On Wed, 2004-12-01 at 12:50 +, PHPDiscuss - PHP Newsgroups and mailing lists wrote: Hi, what can i do, where users can't select and copy my text from web-page. Thanks render the text to an image. -- /*** * Robby Russell | Owner.Developer.Geek *

[PHP-DB] Re: Subject: [PHP-DB] KEYBOARD

2004-12-01 Thread Neil Smith [MVP, Digital media]
It's all client-side Javascript. I'll send you by email (off-list) an example I wrote this week for touchscreen number data entry so you can see how to do it. Then you're on your own ! This is *not* a PHP *or* a DB question, please keep general web-development questions to a more appropriate