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
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
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
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
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
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
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
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
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
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
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
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
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,
/*
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
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
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
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
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.
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
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
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
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 =
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
--- 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
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
--- 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
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
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
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
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
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
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
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
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
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 -
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
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
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.
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
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
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]
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
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
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
*
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
45 matches
Mail list logo