atly appreciate peoples comments on potential problems pursuing
this approach from anyone with extensive experience using session vars.
Thanks ... Ross
. Ross Honniball JCU Bookshop Cairns Supervisor
. James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia
. Ph:07.4042.1157
fined in the 'common.php' file.
The 'mydb' class above won't, for example, have the 'query' function, even
after successfully connecting to a database.
Anyone know how to go about extending the Pear DB class?
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Austral
al number from an chosen starting date - eg. 1-1-1960, 1-1-1970,
whatever. Prior dates are simply stored as negative numbers.
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
if i have to do a combination then i need a day
> to right the various SQL statements
So do something like:
$query = "SELECT id, name , lastname , m_date from users where 1 ";
if (isset($_POST['name'])) {
$query .= "AND name like binary '%{$-POST['name
way to get this information?
--
Scot L. Harris <[EMAIL PROTECTED]>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsub
#x27;]= 'N';
$srvr['etime']['optional'] = false;
How would this need to be defined at the top of a class to taken on as a
class variable/array. Am i thinking of this wrong?
I can add them all as scalar variables, but i'd rather work with arrays
nd working with auto increment.
Now I want to change it so it will start auto incrementing from 1000. So
each entry will be:
1001, then 1002,
--
Michael Gale
Network Administrator
Utilitran Corporation
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.ne
ot;
In case you are thinking that this query might just return truck-loads of
results, this is not the case. If I REMOVE the BN_StkLevl table from the
above queries, then both work fine (also, if I remove BN_SupMast they both
work fine). It must be MySql somehow doing something odd.
So
ibly
expanding significantly than it may be another story. If it aint broke?
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
oints, but I am probably re-inventing the wheel.
Anyone know of any good classes they are using that do this sort of thing
already?
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
tement.
>
> I also had a look at HTML_Pager but, at a glance, it looks like some kind
> of web-page presenter?
>
> At 09:14 PM 3/08/2004, you wrote:
> >1. What prevents you from implementing the conditions directly in SQL?
You
> >can achieve a lot with CASE and IF.
> >2
----- Original Message -
From: "Ross Honniball" <[EMAIL PROTECTED]>
To: "php DB" <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 2:54 PM
Subject: Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT
clause
> At 10:22 PM 3/08/2004, you wro
Anyone recommend any really good books for beginner/intermediate using sql
hoping to improve sql skills?
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
s indeed greater than zero.
Does anyone know of any erratic behaviour when using the assignment operator?
Or am I doing something wrong?
(Note that this is actually the first time I have ever used the assignment
operator, so I'm pretty green really)
.
. Ross Honniball. JCU Bookshop Cairns, Qld
e
statement.
... end quote
There's more at http://dev.mysql.com/doc/mysql/en/Variables.html
So why not: select *, (StkhistMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08) as total
.
. rest of statement ...
.
and total > 0
Regards - Miles Thompson
At 10:10 PM 8/28/2004, Ross
he manual, but I can't find it.
Thanks ... Ross
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
think of any reason why it would be either difficult or ambiguous
for the SQL engine to allow you to use your calculated field name in the
WHERE part of the query.
If someone can give me a good reason why this is so, it will stop it
annoying me so much.
Regards ... Ross
.
. Ross Honniball. JCU Books
I can't simply do insert into cars
select * from cars where id=$id as this throws the primary key error.
How can I do this with out specifying each column?
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
. Ross Honniball. JCU Book
uestion_data[$test_name_en]}
but nothing works any help would be appreciated.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. Ross Honniball JCU Bookshop Cairns Supervisor
. James Cook Uni, McGregor Rd, Smithfield, Qld
with the quantity[] array.
Any help would be REALLY appreciated as this is really urgent.
Chris
. Ross Honniball JCU Bookshop Cairns Supervisor
. James Cook Uni, McGregor Rd, Smithfield, Qld. 4878, Australia
. Ph:07.4042.1157 Fx:07.4042.1158 Em:[EMAIL PROTECTED]
--
Hi All,
I use
SELECT COUNT(*) FROM whatever WHERE whatever
to determine how many rows a particular query will return (then use this count
to assist with pagination).
The problem is that this does not work if the query contains a GROUP BY
statement as, of course,
the query will return many
This is what I use when needing to do this:
1. Put all the values you want to search for in an array $vals (loop
around the first result)
2. $query = "
select count(Nome) from Aeromodelistas
where year(AnoQuota)=2005
and Sexo='Masculino' and Distrito IN ".sqlIn($vals)
;
function sq
It worked!
SELECT COUNT(*) FROM (SELECT COUNT(*) FROM ad.off_enrol GROUP BY
jcu_campus, sub_code) t1
Thank you list -:)
Martín Marqués wrote:
El Dom 26 Jun 2005 07:39, Ross Honniball escribió:
Hi All,
I use
SELECT COUNT(*) FROM whatever WHERE whatever
to determine how many rows a
I have never used the DISTINCT clause, so I won't attempt to help in any
detail, but look it up in the manual. I think it will help you.
Regards ... Ross
Larry Sandwick wrote:
Can you help me with this query below Mgr's could circumvent the process by
login 20 times in 1 day and change the l
Sounds like you just want some pretty basic variable substitution? As in
the page is submitted with, say, state=T and you need to code your
select statement like eg:
$query = "SELECT * FROM tbl WHERE state = '".$_REQUEST['state']."'";
then execute this query in your DB call.
Does that help?
Hi All,
Not a DB question, but this is the only list I'm subscribed to, OK?
Besides, everyone uses some kind of editor.
I'm presently using PSPAD as a PHP code editor which is very usable and
has a lot of features that I love and use every day.
However it doesn't do everything I'd like it t
script1.php:
echo 'script 1 before';
require_once('script2.php');
echo 'script 1 after';
script2.php:
echo 'hello from script 2';
which in IE visually produces:
script 1 beforehello from script 2script 1 after
However if I view the source in IE, I get:
script 1 before?hello from script 2scr
use?
Bastien
From: Martin Norland <[EMAIL PROTECTED]>
Reply-To: php-db@lists.php.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help. I am losing the plot...
Date: Tue, 05 Jul 2005 09:41:55 -0500
Ross Honniball wrote:
script1.php:
echo 'script 1 before';
require_once(&
to what you want
Bastien
From: Ross Honniball <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Really Good PHP editor
Date: Tue, 05 Jul 2005 17:55:49 +1000
Hi All,
Not a DB question, but this is the only list I'm subscribed to, OK?
Besides, everyone uses some kind of ed
Get rid of both your onload= statements and replace with...
window.onload=doboth
Then include the function below...
function doboth() {
changetext();
changead();
}
Not sure what you were getting at regarding the " thing, but I think the browser
must just over-ride the previous onload s
31 matches
Mail list logo