$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 one form in which i print records from mysql datab
e of these, but have 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 e
e OK too, and fairly simple to deploy, just make sure you
kil off the session each time a new order instruction is given.
I havn;t used cookies yet, so consult php.net for that one, but I would
have thought that a little overkill! ;-)
HTH :-)
Russ
-Original Message-
From: Achilleas Mar
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
$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-
Fro
e is empty)??
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,
Chip:
Just use the names of the fields as the values too:
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 when reloading a form
I have my email checker
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:[
n
as far 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
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:
&g
ECT DISTINCT type, id, staff_member, class, 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
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 h
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
f the field in which 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
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:
as less code as
possible:
echo("" .
$scoutbio . "");
}
//4). Complete your HTML :
echo "
";
I'm not sure the syntax is 100% correct - best check out the manual eh?
;-)
HTH Russ :-)
-Original Message-
From: bo [mailto:[EMAIL PROTECTED]]
Sent:
- and you really don't wanna know what "RTFM" means but you
could find out at:
http://www.astro.umd.edu/~marshall/abbrev.html#R
Russ
-Original Message-
From: José Moreira [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 11:19 PM
To: 'Martin Clifford'; P
I think I need to use some kind of COUNT() but am unsure how 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
Stree
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
&qu
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
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 Maili
s 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
}//end if
}//end while
$select .= "\r";
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
Seth:
You should have another colon ' : ' after your alnum expression:
if(ereg("[[:alnum:]]+", $textandnumbers, $numbers)) {
print("$numbers");
}
I'm not sure but you also may want to lose the double quotes or maybe
escape them.
Good luck.
Russ
--
sweet-as
Russ
-Original Message-
From: Matthew Nock [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text to numerical
Hi Russ,
thanks for the reply ... if that will evaluate whether a (in this case
th 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] Co
e field (I 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
each set of data you put 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 duplic
> 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 circu
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 tak
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 the
27;t
find anything
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 - consi
UNT(related_discipline) FROM WHERE
related_discipline='RAIL' ORDER
BY related_discipline";
That should do it.
Russ
On Wed, 12 Dec 2001 10:06:04 EST [EMAIL PROTECTED] wrote:
> Hi I am new to this list and need some help with PHP and MYSQL.
>
> We have a database that h
I would add each item's unique item id to an array and pass the array as the session
variable. Then
use serialize($array) and unserialze($array) to pass the array from script to script.
You could then
loop thru the array at the checkout and insert the vars into your database.
HTH
Russ
O
Check out the php-navigation section at hotscripts.com. I found exactly that on there
a couple of
weeks back, it utilises cookies.
Cheers
Russ
On Tue, 11 Dec 2001 23:23:02 +0700 RSalomo <[EMAIL PROTECTED]> wrote:
> helo,
>
> i have site navigation, for example: you are her
2_75_1/002-6473897-5819259
Good luck!
Russ
On Tue, 11 Dec 2001 16:03:17 +0100 es said <[EMAIL PROTECTED]> wrote:
> dear russ,
> thanks a lot for the immediate help!!!
> theproblem i'm chewing on is in fact a bit more complicated, because i got
> this 'mysql_insert_id(
to become a whole query and add the SQL 'WHERE' clause
$sql = $sql1 . $sql3 . $sql5 . "WHERE X=Y";
That should do it for ya.
Russ
On Tue, 11 Dec 2001 14:59:27 +0100 es said <[EMAIL PROTECTED]> wrote:
> hello again,
> russ gave me a wonderful tip, but now i'
se these vars ($key and $val) to perform your DB inserts updates etc.
I hope that was of use to you.
Regards:
Russ
On Tue, 11 Dec 2001 12:14:01 +0100 es said <[EMAIL PROTECTED]> wrote:
> hi there,
> this time i've got another problem with my set of database-tables:
> i crea
ou. (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 "\r\n";
> while($row = mysql_fetch_assoc($result)) { // if as
me2]; //etc
}//end while loop
I'd like to be able to have this dynamically enabled as below:
//loop using relevant field names to display correct page content
while($row = mysql_fetch_array($result)) {
//generic method of extracting rownames according to
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 lik
nd or at the beginning of the string stored in the column '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 somethi
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,
ert_id(), unfortunately I
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
#---#
&qu
* 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 = "$variable";
HTH :-)
Russ
On Tue, 20 Nov 2001 11:54:25 -0400 Joe Van Meer <[EMAIL PROT
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 = my
uot;mysql_select_db()" Using separate DB 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]> wro
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.
>
>
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
stripslashes($last)."'>\n";
3). Careful what you print in your posts, some may find it offensive:
> echo "Something's fucked up with yo script ya
> herd...";
HTH
Russ
On Mon, 19 Nov 2001 16:59:51 -0800 pjc <[EMAIL PROTECTED]> wrote:
> I just start
Well depending on what results you have displayed in bold, you're using the HTML
tag, which
automatically bolds any text inbetween.
You should be a bit more consistent with its use:
* Your use: Class
* Proper use: Class or: Class
Maybe that's it??
Russ
On Fri, 16 Nov 2001 12:5
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 dat
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
See the thread at:
http://www.phpbuilder.com/forum/read.php3?num=2&id=163227&thread=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 M
> >>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:
>
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:
leData0TMRRy"?? if it should be a file, it should 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 = te
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
O
uot;;
for($i=0; $i<$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
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.
>
VARS'); rids you off *all* 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:
sure 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:
>
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
o connect
top 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 PRIV
or is there an easier method? I already have various directory
recursion
scripts I got from phpbuilder, but the exact method of performing the above kinda
eludes me.
Any (constructive) comments more than welcome.
Kind regards:
Russ
#---#
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
a DB table called:
'users'
* SELECT 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 att
> 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 Oc
r form they'll be in the order: 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 tim
list .= "$key\n";
}
$category_list .= "";
//Remove the last comma from data 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: $cate
the inclusion of the
contents of the
var: $sql1 (within $sql2 and in $sql4)
Cheers once again.
Russ
On Mon, 22 Oct 2001 12:28:38 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:
> Construct your INSERT a piece at a time. Something like:
>
> $sql = "INSERT INTO $myanet02
&
tegory has been repeated in the
list of
fields to be inserted into. If I select say, 3 categories, then this is what happens:
INSERT INTO myanet_categories (staffdev ,rules ,policies ,staffdev ,rules ,policies )
VALUES ('[EMAIL PROTECTED]',
$myanet02 (staffdev,strategies,rules,news,information,policies)
VALUES(";
//loop while categories have been ticked
for($i=0;$i\n";
}
You can see it happening at:
http://gertrude.anglia.ac.uk/intranet/myanet/index.php
Many thanks.
Russ
On Mon, 22 Oct 2001 12:28:38 -0500 Rick E
Hi everyone:
I've been fiddling with this all day, and well - if it was working you wouldn't be
reading this right now! ;-)
My script should take the selections made by users and process them via
straightforward MySQL inserts:
//Get all table column names, dynamically display them as checkboxe
r('test').";
$body .= "text";
$body .= "box_footer().";
HTH
Russ
$body .= ".box_header('test').";
$body .= "text";
$body .= ".box_footer().";
On Sun, 21 Oct 2001 20:06:55 +0200 Luditus <[EMAIL PROTECTED]> wrote:
>
headings to sort by that field" etc etc
* You could also have 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 Em
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 us
Sure use:
SELECT * FROM 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 \"omeg
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 t
>(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
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. Altho
ain and
print out a
complete tree-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
mes, (dependant on a set variable to define which table to query) then
your
universal update query can be set dependant upon the values of the field names of the
initial query.
good luck!
Russ
On Mon, 1 Oct 2001 15:27:52 -0600 =?iso-8859-1?Q?Ren=E9_Fournier?=
<[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()
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
Click this to
open new window
Good luck.
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 t
the moment this retrieves the password hash. I can't use the MySQL password()
function because
I'm not passing a variable for it to operate upon. So how can I use php to 'unhash'
it??
What am I missing here?
Many thanks.
Russ
#--
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 serve
rse) VALUES
('$valName','$valAddress','$valAge','$valCourse')";
$result = mysql_query($insertsql, $connection) or die(mysql_error());
}
Can anyone make any suggestions that would help me here?
Many thanks in advance!
Russ
#---
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
w, there, I could 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
Thank you again 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!
}
else {
while($row = mysql_fetch_array($result)) {
etc 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('$passwor
ery to the string 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 state
est has been, trying to find 'footballSat', so $team = 'footballSat'.
'footballSat'
exists 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 M
own, on how I may be able to go on with
this?
Many thanks.
Russ
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The
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
;all for any help you are able to give.
Cheers
Russ
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings'
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
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]> wro
have the user input their password and email address (the one
they registered
with) and query the database for a username on the basis of the inputted info, and
email it using
mail() to that email address!
Use the same method for a lost username, they can then input their password and email
1 - 100 of 193 matches
Mail list logo
