mislaid it. Perhaps you could ask
for one here or go looking at hotscripts.com.
Hope that's of some help...
Russ
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 3:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] douplicate entry
Hi guys,
I have
whatver you will with
them..
echo checkbox value: $val;
}
:-)
HTH
Russ
-Original Message-
From: Smita Manohar [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 12:19 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] How to pass multiple checkbox values thru form??
hii
i have
$mailTo = [EMAIL PROTECTED];
$mailFrom = From:[EMAIL PROTECTED];
$mailSubject = This is an email...;
$mailBody = This is a message;
@mail($mailTo,$mailFrom,$mailSubject,$mailBody);
Try this, it works for me ;-)
Russ
-Original Message-
From: Manoj Japher [mailto:[EMAIL PROTECTED]]
Sent
Oops! wrong order of arguments...
I meant:
$mailTo = [EMAIL PROTECTED];
$mailFrom = From:[EMAIL PROTECTED];
$mailSubject = This is an email...;
$mailBody = This is a message;
@mail($mailTo,$mailSubject,$mailBody,$mailFrom);
Russ
-Original Message-
From: Manoj Japher [mailto:[EMAIL
)??
Thanks a lot for your help. :-)
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 24, 2002 12:12 AM
To: Russ; [EMAIL PROTECTED]
Cc: Ross Gerring
Subject: Re: [PHP-DB] auto_increment problem???
Russ,
Check your docs to confirm this, as you
as the wrong results are returned. MySQL doesn't throw up an
error either.
I'm using MySQL 3.23.49-nt-log. Can anyone enlighten me please ??
Cheers
Mr Russ Michell
Web Applications Developer
Itomic.com
Email: [EMAIL PROTECTED]
Tel: +61 (0)8 9321 3844
Fax: +61 (0)8 6210 1364
Post: PO Box 228, Innaloo
Cheers for helping me out guys.
It proved to fiddly and kludge-like to do what I wanted in SQL (I'll
wait until MySQL 4 stable version is about)
So I did some stuff with PHP arrays which worked fine.
Thanks a lot anyway.
Russ
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL
Chip:
Just use the names of the fields as the values too:
input type='text' name='Email' value='$Email' /
HTH :-)
Russ
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 1:58 AM
To: PHP_DB
Subject: [PHP-DB] keeping form field data
Perfect!
Thanks. I'm still trying to get a handle on the GROUP BY command. It's still a
little bit like magic to me. And in the manual, they don't really show how to
use it like the way I wanted to use it.
Thanks again,
russ
On Monday 12 August 2002 01:27 pm, Dan Koken wrote:
SELECT *
FROM
, manufacturer, model,
description, picture, created, modified, published FROM equipment WHERE
class = microphones;
I just got the exact same answer as if i would have done this:
SELECT * FROM equipment WHERE class = microphones;
so it didn't help.
Can anyone offer a hint?
Thanks,
russ
--
PHP
ORDER BY RAND()
Russ
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 1:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Random
In article 003601c241ad$225775e0$[EMAIL PROTECTED],
[EMAIL PROTECTED] says...
can someone help me
email addresses
are stored in your DB:
@mail($email,$from,$subject,$body);
}
or am I missing something??
Russ
-Original Message-
From: Bartek Pawlik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mail problem
Sorry to be a little
Just looking at our php.ini file and we use an external machine to send
mail with when calling the mail() function.
I think you just need to change the directive for the path/URI to the
mail server you wish PHP to use, in your php.ini file.
HTH :-)
Russ
-Original Message-
From: Bartek
In MySQL - SQL you can't use the column alias ('score' in your case)
until after the query has been executed.
There is a workaround though - see:
http://www.sitepointforums.com/showthread.php?s=postid=501671 for more
info.
Cheers.
Russ
-Original Message-
From: JJ Harrison [mailto
as
possible:
echo(tda href=javascript:popUp('bios/bio_ .
str_replace(% %,,$scoutname) .
.html') .
$scoutbio . /a/td);
}
//4). Complete your HTML table:
echo
/tr
/table
;
I'm not sure the syntax is 100% correct - best check out the manual eh?
;-)
HTH Russ :-)
-Original
Stick a '@' in front of the function/statement generating the error:
@unlink($filname); for example...
Russ
-Original Message-
From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 5:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Warnings and Error messages
Hi all:
I have a simple MySQL SELECT query:
Mr Russ Michell
Web Applications Developer
Itomic.com
Email: [EMAIL PROTECTED]
Tel: +61 (0)8 9321 3844
Fax: +61 (0)8 6210 1364
Post: PO Box 228, Innaloo, WA 6918, Australia
Street: Suite 24, 158 William St, Perth, WA 6000, Australia
to deploy
it.
Can anyone help me out?
Cheers.
Russ
Mr Russ Michell
Web Applications Developer
Itomic.com
Email: [EMAIL PROTECTED]
Tel: +61 (0)8 9321 3844
Fax: +61 (0)8 6210 1364
Post: PO Box 228, Innaloo, WA 6918, Australia
Street: Suite 24, 158 William St, Perth, WA 6000, Australia
No proof
George:
Thanks for that. That's pretty much what I realised anyway, while
composing the email. But I thought I'd send it off anyway!
Thanks a lot.
Russ :-)
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 2:52 PM
To: PHP DB Mailing List (E
content as a valid date simply an
integer (that we modify for display using PHP)
Does anyone know of a way (kludge or otherwise) I may be able to perform
such an ORDER BY, so that the dates in an HTML display table column are
ordered AS dates while using an INT field format??
Cheers folks.
Russ
$select .= \r/select;
return $select;
}//end function
All the best.
Russ
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 3:38 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Populating a dropdown list with ENUM
Seth:
You should have another colon ' : ' after your alnum expression:
if(ereg([[:alnum:]]+, $textandnumbers, $numbers)) {
print($numbersBR);
}
I'm not sure but you also may want to lose the double quotes or maybe
escape them.
Good luck.
Russ
-Original Message-
From: Seth
suppose you need to do this to, othewise you'd store your
numerical data in another column) like so:
Russ|27|6|Michell (stored as a single string in your table)
This is my first name, age, height, and surname respectively.
You could then just use the explode() function to remove the pipes, and
pick
with it..;
}
else
{
echo This aint a number so it must be a string, so do stringy
things with it...;
}
Any good?
Russ
-Original Message-
From: Matthew Nock [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text
into the DB will
automatically create a
new row in which to insert this data.
You should really do some basic checking before you do inserts, to ensure you don't
have multiple
entries: $check = mysql_num_rows($query);
if($check != 0) {
echo You have a duplicate entry!;
}
Cheers
Russ
On Mon, 17 Dec 2001
Russ -
Why not (MySQL) extract the field always, and code into your (php) generic mechanism
whether or
not a
particular field under that name appears? Using mysql_fetch_assoc() you could
exclude 'modified' from
your generic mechanism under particular circumstances. This avoids coding
Did you go look at: www.mysql.com??
Russ
On Fri, 14 Dec 2001 13:27:03 +0100 Andy [EMAIL PROTECTED] wrote:
Hi there,
I am wondering if I could have MySQL as a DB for an Application which needs
to have access a table of 1 Mio entries.
And how long would it take to get an entry out
specific to my problem. I have an incling this may not be as easy as I think, so does
anyone know
of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Sorry! just read-read my post, it should have been:
particular column ('modified') *NOT* to appear under specific circumstances,
somewhere along...
Cheers.
Russ
On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell
[EMAIL PROTECTED] wrote:
Hi there everyone:
I have
'email'
respectively.
Russ
On Sat, 24 Nov 2001 13:06:50 -0500 Noah Spitzer-Williams [EMAIL PROTECTED] wrote:
what's the LIKE query to see if an email address is valid?
For example, in PHP it's something like
if
(eregi(^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3
Glad someone knows more than I do, or that chap would be right up a certain creek
without a paddle..
Cheers
Russ
On Wed, 28 Nov 2001 09:44:26 - Jon Farmer [EMAIL PROTECTED] wrote:
No this will not do what the original poster requested
it will be something like the following
select
using relevant field names to display correct page content
while($row = mysql_fetch_array($result)) {
//generic method of extracting rownames according to '$table' (above) goes here
}//end loop
Does anyone have a clue how to do this???
Many Thanks!
Russ
. (and a little
bit of RFTM on
my part r.e: mysql_fetch_assoc() and mysql_fetch_array() ...
Many thanks for your help.
Russ
On Wed, 28 Nov 2001 17:49:54 +0200 Andrey Hristov [EMAIL PROTECTED] wrote:
echo table\r\n;
while($row = mysql_fetch_assoc($result)) { // if assoc is not available - will work
I use the former method when concatenating say a complex SQL query thru a loop or
loops, and me
being the person I am like to keep things standard and consistant so I use the same
method when I
wish to concatenate simpler strings.
Russ
On Tue, 27 Nov 2001 09:28:37 -0600 Boget, Chris [EMAIL
don't see how
these might do the job. Any help or pointers to web-resources would be most helpful!
If useful, I'm using the old fella: MySQL3.22.32
Cheers all.
Russ
#---#
Believe nothing - consider everything
Miguel:
1). Are you trying to connect an MS Access database to a MySQL database?
2). Are the databases and servers both/individually remote or local?
See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any.
Good luck.
Russ
On Tue, 20 Nov 2001 12:35:29 + Miguel
In which case you're best off helping him as I have no idea!
Russ
On Tue, 20 Nov 2001 08:10:02 -0600 Rick Emery [EMAIL PROTECTED] wrote:
1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a
mySQL database on a Win-NT machine.
2. Both mySQL servers are remote
connections? I guess it depends
on the type
of query you want from both DB's...
I'm sorry but that''s about as far as I can go!
Good luck though.
Russ
On Tue, 20 Nov 2001 14:12:58 + Miguel Loureiro [EMAIL PROTECTED] wrote:
Hello Russ:
Russ Michell wrote:
Miguel:
1). Are you
Exactly what I just suggested - hey do we have telepathic abilities or what?? :-)
Russ
On Tue, 20 Nov 2001 08:21:24 -0600 Rick Emery [EMAIL PROTECTED] wrote:
Hey Russ,
I'm wondering. Maybe this might work. What do you think?:
$server1 = mysql_connect(server_1,user1,password1
* You could cheat and wrap anchor tags around the DB content you want to display as a
hyperlink
* If you know which variable from the DB you wish to be displayed as a link then:
$variable = a href=\yourpage.php\$variable/a;
HTH :-)
Russ
On Tue, 20 Nov 2001 11:54:25 -0400 Joe Van Meer [EMAIL
Do you have a URL we can look at?
Russ
On Fri, 16 Nov 2001 12:44:14 +0100 Kevin Schaaps [EMAIL PROTECTED] wrote:
Hi everyone,
I've noticed something strange, and I was wondering if you knew the answer:
When I put the results of a query on a HTML page, the data that comes from
Maybe that's it??
Russ
On Fri, 16 Nov 2001 12:53:07 +0100 Kevin Schaaps [EMAIL PROTECTED] wrote:
Thanks Matt,
Here it is:
mysql_select_db ($dbname);
// -
--
// FLEET LIST
Kelvin:
If you're using MySQL - go check out:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
It has some great little MySQL data and time functions. I have personally found it
invaluable.
Good luck! :-)
Russ
On Wed, 14 Nov 2001 15:49:03 -0500 kelvin [EMAIL PROTECTED] wrote:
Hi
See the thread at:
http://www.phpbuilder.com/forum/read.php3?num=2id=163227thread=162776
for a php solution to this. Thanks to that Vincent chap over there in the netherlands.
Russ
On Tue, 13 Nov 2001 22:33:12 -0500 CK Raju [EMAIL PROTECTED] wrote:
I use PHP with MySQL on Linux box.
I
As we say here in Dallas: there are two kinds of people...those who live
in Texas...and those who wish they did.
Texas?? Never heard of it! Is that somewhere north of Manchester? ;-)
Russ
On Fri, 9 Nov 2001 14:22:22 - matt stewart [EMAIL PROTECTED] wrote:
As we say here in Dallas
Yes there is:
Using a php function called: nl2br()
When the data is called from the db and printed to the page use $textdata =
nl2br($textdata)
This will preserve the enter button being pressed.
Regards:
Russ
On Thu, 08 Nov 2001 09:54:16 -0600 Jay Fitzgerald [EMAIL PROTECTED] wrote:
Ok, I
be called
'myfile.txt' (with
a file suffix)
HTH
Russ
On Tue, 6 Nov 2001 14:56:00 +0200 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
[EMAIL PROTECTED] wrote:
I have this code:
?
$dir = getcwd();
$fpName = tempnam($dir, tableData);
$fp = fopen($fpName, w);
fputs($fp, $strData);
fclose($fp
$email_array_name;$i++( {
$mail .= $values,;
}
$mail .= \$subject\,\$body\,\From: $from\);;
Something like that anyway (that's just off the top of my head)
Regards.
Russ
On Fri, 2 Nov 2001 11:26:22 - Cami [EMAIL PROTECTED] wrote:
Hi guys,
Does anybody know how to send bulk emails
Hmmm this is true - but as someone once wrote on this list:
If someone want's to build a car with 4 reverse gears, we can tell them it's not a
very good idea,
but we can also show them how to do it.
Granted though - spam is a little different than cars!
Cheers.
Russ
On Fri, 2 Nov 2001 07:26
http://phorum.org/
Russ
On Thu, 1 Nov 2001 15:52:01 - Tom Hodder [EMAIL PROTECTED] wrote:
Hi,
can anyone recommend a good php discussion/bulletin board thats free, as I
need to choose one and have been over whelmed by the variety available.
Cheers
Tom Hodder
--
PHP
* currently registered
session vars
Note that a variable used in this way is refered to as 'myvar' and referenced a
snormal within the
script as: $myvar
HTH you out.
Russ
On Wed, 31 Oct 2001 09:55:33 -0600 Steve Cayford [EMAIL PROTECTED] wrote:
This is really off-topic for this list, but...
From
this is right (and I'm not even
convinced myselfanyone??)
Cheers
Russ
On Mon, 29 Oct 2001 15:26:58 - [EMAIL PROTECTED] wrote:
Russ:
see below for the question I posted and the reply I got. I hope it makes
some sense.
My Question was:
I have a RedHat 7.2 server which I configured
the server.
Make sure the 'username' @lsh101.siteprotect.com has been granted all the right
privileges on the
desired database:
GRANT SELECT,INSERT,UPDATE,DELETE
ON mydb.*
TO username@localhost (or [EMAIL PROTECTED])
IDENTIFIED BY 'your_password';
FLUSH PRIVILIGES;
HTH.
Russ
On Fri, 26 Oct 2001
User inserts date as a select menu for day, month and year: $day, $month, $year
You swap it around for an insert: $dateinsert = $year . $month . $day
Then query the DB: Select blah from blah where blah=blah order by datefield (Let MySQL
do the rest)
Good luck!
Russ
On Fri, 26 Oct 2001 12:10
Assuming you're using MySQL - 35 seconds is all it took to find:
http://www.mysql.com/doc/P/a/Pattern_matching.html
Good luck!
Russ.
On Thu, 25 Oct 2001 14:16:40 +0300 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
[EMAIL PROTECTED]
wrote:
How can I query for specified fields that has to contain atleast
the above kinda
eludes me.
Any (constructive) comments more than welcome.
Kind regards:
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room
: day,month,year
To perform queries into a MySQL DB re-arrange them:
$date = $yearselect . - . $monthselect . - . $yearselect;
HTH
Russ
On Tue, 23 Oct 2001 10:52:41 -0600 Jason [EMAIL PROTECTED] wrote:
I am having a hard time setting up a form for users to enter a date in the
format of 00/00
NOTE: I didn't read the entire post below...it's too early in the morning to
think about code.
haha I did that the other day when I tried (and failed) to help out someone else -
damn tired,
hadn't even had a whiff of beer...
Cheers for your help!
Russ
On Wed, 24 Oct 2001 09:10:59 -0400 Mike
these on the basis that the data in the DB reflects thatwhich was inputed via
login form
* If they details exist - login
* If not refuse
Cheers
Russ.
On Wed, 24 Oct 2001 09:33:21 -0400 Ryan Marrs [EMAIL PROTECTED] wrote:
I'm attempting to do basic authentication through PHP and am having little
$columns; $i++) {
$names = mysql_field_name($fields, $i) . \n;
$catselect .= b$names /binput type=\checkbox\
name=\category[$names]\ value=\yes\br\n;
}
You can see it happening at:
http://gertrude.anglia.ac.uk/intranet/myanet/index.php
Many thanks.
Russ
On Mon, 22 Oct 2001
,rules ,policies ,staffdev ,rules ,policies )
VALUES ('[EMAIL PROTECTED]','[EMAIL PROTECTED]','[EMAIL PROTECTED]')
See what I mean?
If anyone has any other pointers I would be more than happy to receive them!!
Cheers
Russ
to be inserted
$sql = substr($sql4,0,-1) . );
$query = mysql_query($sql,$connect) or die(mysql_error());
$confirm = You have now been subscribed to the following categories: $category_list;
}
}
Thanks v.much for your concern, but it works quite well now!
Cheers.
Russ
On Tue, 23 Oct 2001 11:39
().;
HTH
Russ
$body .= .box_header('test').;
$body .= h1text/h1;
$body .= .box_footer().;
On Sun, 21 Oct 2001 20:06:55 +0200 Luditus [EMAIL PROTECTED] wrote:
Hi there,
I am trying to send an email with html tags coming from functions.
Something is wrong with asigning the value to the variable
by that field etc etc
* You could also have some_limit set as a number from a select menu again on the web
page of
search results.
Good luck!
Russ
PS Where is this search engine? can I have a look??? go on - you know it makes
sense
On Thu, 18 Oct 2001 12:46:25 -0500 Rick Emery [EMAIL PROTECTED] wrote
(NOW()+0)
Not sure what the +0 achieves?? Try with just NOW().
Cheers.
Russ
On Thu, 18 Oct 2001 11:41:14 +0100 p.whiter [EMAIL PROTECTED] wrote:
Hi
I am trying to set-up a type of anti-flood block on one of my forms, the way
I am doing this is that when the first submission is made I log
Check this out:
http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm
Step by step instructions on how to connect Access to MySQL (from PC/workstation to
remote server)
Cheers.
Russ
On Thu, 18 Oct 2001 13:44:15 +0100 Tony McCrory [EMAIL PROTECTED] wrote:
You could try the MyODBC driver
Sure use:
SELECT * FROM table WHERE foo LIKE '%$bar%'
selects all records where 'bar' is found somewhere in the search string.
See also: http://www.mysql.com/doc/S/t/String_comparison_functions.html
HTH :-)
Russ
On Thu, 18 Oct 2001 15:57:56 +0200 Thomas \omega\ Henning [EMAIL PROTECTED
Take a good look at the manual page, it helped me out a bunch of times:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Good luck.
Russ
On Thu, 18 Oct 2001 14:02:34 +0100 p.whiter [EMAIL PROTECTED] wrote:
Hi
Thanks for your reply, I have tried this using NOW() and NOW()+0
For information:
For step by step info on using ODBC to connect MySQL to M$ Access go to:
http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm
Cheers.
Russ
On Wed, 3 Oct 2001 15:47:07 -0500 Carlos Augusto Abarca [EMAIL PROTECTED]
wrote:
This is absolutely not true. Although there isn
-structured set of links.
Or type in indented into the phpbuilder search field to find the original thread.
If you find a solid way of doing this, please let me know as I'm evaluating wether or
not it's
actually worth it.
Cheers.
Russ
On Mon, 1 Oct 2001 22:47:30 +0100 deco [EMAIL PROTECTED
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
Click a href=\#\
onClick=\MM_openBrWindow(file.php?myvar=set,mywin,'status=1,toolbar=0'this to
open new window/a
Good luck.
Russ
On Wed, 26 Sep 2001 05:41:05 -0700 its me [EMAIL PROTECTED
That's a one off though
It has NOTHING to do with databases!!!
Russ
On Wed, 26 Sep 2001 05:41:05 -0700 its me [EMAIL PROTECTED] wrote:
hi there.does anyone know how to pass a variable value to the new window i
opened with open()
of javascript
thanks.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk
If I have the right end of the stick you want:
SELECT * FROM table99_98,table00_01 WHERE table99_98.foo='$bar' AND
table00_01.foo='$bar';
Russ
On Mon, 24 Sep 2001 10:50:02 +0100 Cable, Christian [EMAIL PROTECTED] wrote:
system:
win NT4 server (IIS4, php4)
Problem:
I'm writing a web
Try:
REGEXP 'keyword?'; //Matches Zero or one instances of 'keyword'
REGEXP 'keyword+'; //Matches One or more instances of 'keyword'
REGEXP 'keyword*'; //Matches Zero or more instances of 'keyword'
Cheers.
Russ
';
On Fri, 21 Sep 2001 04:14:47 -0700 Ralph
($insertsql, $connection) or die(mysql_error());
}
Can anyone make any suggestions that would help me here?
Many thanks in advance!
Russ
#---#
Believe nothing - consider everything
Russ Michell
as part of the string in the 'affil_team' field but the above query refuses to
find
'footballSat'!! (No error is received though)
I'm using MySQL 3.22.32 + php4.0.3pl1
Cheers
Russ
#---#
Believe nothing - consider
as: footballSatfootballSun (etc etc) and also as: footballSat
footballSun (etc
etc)..
Any ideas??
Many thanks.
Russ
On Wed, 19 Sep 2001 09:12:36 -0500 Rick Emery [EMAIL PROTECTED] wrote:
When you printed-out the string variable containing the SELECT statement,
what did it look like
etc
Cheers again:
Russ
On Wed, 19 Sep 2001 09:26:07 -0500 Rick Emery [EMAIL PROTECTED] wrote:
$query = SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') AND affil_team RLIKE '$team+'
print $query
what were the contents of $query
-Original Message
both, and I apologise for seemingly wasting your time, but I do value
people's
ideas and opinions, and hopefully others do of mine also.
Regards:
Russ Michell (APU Webteam)
On Wed, 19 Sep 2001 09:41:47 -0500 Rick Emery [EMAIL PROTECTED] wrote:
YES!!! Exactly
Russ...do what Steve syas
use some help...
No he isn't he just thinks he is ;-)
Many thanks.
Russ
On Wed, 19 Sep 2001 10:01:07 -0500 Rick Emery [EMAIL PROTECTED] wrote:
It wasn't a waste of time. Now, the next time you have a similar problem
with a mySQL query, you'll follow this procedure.
Learning is NEVER a waste
Thanks for the password/info, however I have one further (possibly bumb) question, is
there a
commonly employed method of securing one's database to prevent hacker's peering in and
viewing
plain-text/hashed passwords?
I use MySQL 3.22.32 with php4.0.3
Cheers.
Russ
On Thu, 13 Sep 2001 19:28
are able to give.
Cheers
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w
Try:
$result = mysql_db_query ($DBName,select * from Contacts order by rand()
LIMIT 0,5 );
As your first example had the '0' and then the '5' after the LIMIT clause, the second
didn't have
th any '0'.
Cheers.
Russ
On Fri, 31 Aug 2001 20:59:16 +0100 Seb Frost [EMAIL PROTECTED] wrote:
I
!
Russ
On Fri, 31 Aug 2001 10:38:53 -0500 Jeff Oien [EMAIL PROTECTED] wrote:
I would like users to be able to request to have their password
sent to their email address if they forget it. I would also like it
encrypted in the database though. How is this best handled?
The security isn't real
Sorry it should have read:
if ($check != 0)
echo this username already exists, select another.;
}
else {
echo continue!;
}
Cheers.
Russ
On Fri, 31 Aug 2001 17:43:59 +0100 (GMT Daylight Time) Russ Michell
[EMAIL PROTECTED] wrote:
Have a registration screen
have (written). I know for a fact that
this function
('parse_dir') has only been declared once, so why is php lying to me!!?
Feel free *not to answer* instead of wasting your own time giving me jip for an off
topic query.
Cheers
Russ
Try to include your files with the command include_once() ... and not
include() ...
Well Br me! Cheers..
That did the job...
I thank you sir!
Cheers
Russ
On Fri, 24 Aug 2001 13:04:15 +0200 Walter, Marcel [EMAIL PROTECTED] wrote:
Try to include your files with the command include_once
) | | | ||
| password | varchar(12) | | | ||
+---+-+--+-+-++
6 rows in set (0.00 sec)
I hope this is what you wanted, can't think why though...
Russ
On Fri, 24 Aug 2001 11:09:06 -0400
help thus far!
Russ
Depending on how the date is stored (date + time, or just date)
On Wed, 22 Aug 2001 21:39:19 +0800 Gremlins Mailing List
[EMAIL PROTECTED] wrote:
- Original Message -
From: Russ Michell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 10:16
!
Thanks very much!
Russ
On Thu, 23 Aug 2001 11:09:32 +0200 Torgil Zechel [EMAIL PROTECTED] wrote:
This should work:
SELECT * FROM items WHERE TO_DAYS(NOW()) - TO_DAYS(submitDate) = 7;
-Ursprungligt meddelande-
Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Russ Michell
on board!
Cheers
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x
maurice 2001-09-23 2001-11-05 Maurcie's post this is
Maurice's test
4 russ category russmichell 2001-08-17 2001-08-27 Russ is theone this is another
test
9 russ category russmichell 2001-08-16 2001-08-19 Begon by Monday! This entry
should dissapear
10 russ category russmichell 2001-08
? (It's my luchtime too and I'm gonna go get some...)
Cheers once agin for trying.
Russ
On Tue, 21 Aug 2001 12:19:00 +0100 Lunny Damian [EMAIL PROTECTED] wrote:
Russ,
I recreated your table/data (it's lunchtime and I thought I'd take a look at
this) - my query returned the rows as below
I always love that feeling when you beat a problem that refuses to go away.
So do I - but I aint beaten it yet! :-(
I'm still getting '2' as being the number of posts in each category when '2' is
actually only the
number of posts in *one* of the categories...weird-huh?
Cheers.
Russ
On Tue
'];
}//end while
}//end else
}//end while
I used the WHERE clause on $name, which gives me the total postings for each category
as a *name*
as opposed simply to a *unique category*
Many thanks for all your efforts, it was those that led me to this solution!
Cheers.
Russ
On Tue, 21 Aug 2001
Use n12br() with the output from your DB to your webpage:
$content = n12br($content);
echo $content;
HTH :-)
Russ
On Thu, 16 Aug 2001 09:02:44 -0500 John Roach [EMAIL PROTECTED] wrote:
-- Hello,
I have a mysql db with a largetext field defined. When users enter
data, it drops all
for MySQL like Oracle..
Oh well.
Cheers anyway!
Russ
On Wed, 15 Aug 2001 11:50:43 -0500 Jeff Oien [EMAIL PROTECTED]
wrote:
I'm real sorry to say I don't know the answer to your question unless
there's a php function to get an average (or write one yourself) but
you say you've managed
MySQL data.
HTH :-)
Russ
On Mon, 13 Aug 2001 18:31:48 + Robert Trembath
[EMAIL PROTECTED] wrote:
Good Afternoon Everyone,
I am a fellow PHP developer that has run into a project where I need to
know if anyone has created anything like this.
I need to do Pearson Corilations on Data
in advance.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
1 - 100 of 153 matches
Mail list logo
