7;re mutually exclusive)
---> SELECT memberID from table where choice=2 OR choice = 3
That doesn't work (shows all memberIDs that chose either 2 or 3).
Can I maybe join the table upon itself on the memberID?
Other suggestions?
thanks,
bill hollett
--
PHP Database Mailing List (ht
Might be late, but here's what I have working.
"Troy A. Delagardelle" wrote:
> I am trying to encrypt a credit card number using rc4 and php and then dump
> it into a mySql database. Does anyone have any sample code that allows me
> to do this??
>
> I found the Class.RC4Crypt algorithm and woul
Is it possible to have an autoincrement field start with a number, so
the first record would be, let's say, 1000 instead of 1? The next would
be 1001 instead of 2, etc.
kind regards,
bill hollett
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.ph
ry to include tweaking the field for the different time zone.
kind regards,
bill hollett
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
No, it is similar to your situation. Server is in another time zone from the user. I
want the timestamp to be relative to the user, not the server.
Maybe do something in grenwich time, then interpret all queries from the db . . . ?
kind regards,
bill
Ryan Jameson wrote:
> BTW... are
On Sat, 19 May 2001, Matt Nigh wrote:
> hi, i'm building a website right now with a shows page on it which will
> scroll horizontally in a window. i have each show listed in a table called
> shows (db is called almavale_board) with the following fields:
>
> id - bandplaying - venue - date - time
e the correct extension on it to prevent errors.
kind regards,
bill
matthew knight wrote:
> i've created an application where users can upload images through the form
> upload, and to ensure that they are sending me an image, i take a look at
> the type of the file (ie. $upload
ies link the officer & details tables on OfficerID. You can link the extras &
details tables on the ExtrasID when you need.
kind regards,
bill hollett
Jesse Scott wrote:
> Hi again, another conundrum.
>
> What is the best way to deal with the following situation?
>
> You have a
gin_user);
unset ($login_password);
unset ($action);
echo "Thanks, you are now logged out.";
}
It might also help prevent confusion if you indented your code for each level of
curly brackets "{ }" you use. Having all your brackets flush left is tough to
read.
kind regards
Does it work when Javascript is turned off in the client browser?
Cara Lane - Designs In The Fast Lane wrote:
> I have noticed many posting about this topic and the overall answer seems to
> be it can't be done. Well, it can!
>
> I actually finally got it to work. It is actually quite simple. I
You need to split the value into an array using php, then list it out.
Lots of ways to do that, here's one.
$result4 = mysql_query( "SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID'");
$DCD = mysql_fetch_array ( $result4 );
print " \n
\n
\n
None\n
http://www.php.net/manual/en/features.file-upload.multiple.php
Its Me wrote:
> is there a way i can upload more than one file in the same page
> -ofcourse in 2 different form fields-???
>
>
> --
values .= ",'$email' " } else { $thevalues = "'$email'"; }
$query = mysql_query($sql,$connect) or die(mysql_error());
} // end while
// uncomment following lines for single row entry
// $sql= INSERT INTO $myanet02($thefields) values ($thevalues)";
// echo $
SELECT table_name.name, table_name.ID_city,
table_city.ID, table_city.city,
FROM table_name, table_city
WHERE table_name.ID_city=table_city.ID
Carlo loiudice wrote:
> Hi,
> I'm preforming a join between 2 Mysql tables in this
> way:
> table_name: ID,name,ID_city
> table_city: ID,city
>
> when I
I'm trying to insert information into a datetime field in a MySQL
database with the following:
INSERT INTO thisdb (event) VALUES ((now() + 3600);
But it only works sometimes. Why sometimes? What would be a better way
of doing it?
--
PHP Database Mailing List (http://www.php.net/)
To unsub
Aha. That seems to work.
thanks,
bill
Charles Lahlou wrote:
> >INSERT INTO thisdb (event) VALUES ((now() + 3600);
>
> try rather VALUES (now() + INTERVAL 3600 SECOND)
>
> charles lahlou
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e
Is there a better query than
SELECT *
FROM some_database
WHERE some_column <> ""
I had tried
WHERE some_column <> NULL but that didn't work.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To cont
c), you'll only end up working with checkboxes that have been checked.
kind regards,
bill
Chris Payne wrote:
> Hi there everyone,
>
> I have a loop which goes through my MySQL database and some PHP code which grabs
>results 9 at a time, and that works great. Now, I also have a
Drop the "$result" from the mysql_num_rows() so it reads:
$num_results=mysql_num_rows();
Depending upon the PHP version, that might do the trick for you.
kind regards,
bill
Mike Ford wrote:
> > -Original Message-
> > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]
that didn't work.
while ($crow=mysql_fetch_array($cresult)) {
$therow[]=$crow;
}
asort($therow["Year"]);
reset($therow);
asort($therow["Month"]);
reset($therow);
asort($therow["Day"]);
reset($therow);
ideas?
kind regards,
bill
--
PHP Database Mailing List (
tstamp LIKE '2002%'
Is there a simpler way than the first one?
kind regards,
bill hollett
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
there any way to trigger something via the ODBC
connection?
A cron job?
I'm open to suggestions.
kind regards,
bill
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
db on the linux computer.
How can I get a web page called after the ODBC call? Am I stuck with a
cron job on the linux box?
Bastien Koert wrote:
You should be able to open a web page from access (might need to write
a module) and call a page that would then run your script
Bastien
Fro
entry per line, you could just
use file() to convert the file to an array and then
loop 7 times--grabbing the first 7 elements (or news
items) of the array.
Best Regards,
Bill Zeller
--- Matthew Cothier <[EMAIL PROTECTED]>
wrote:
> I have a homepage which has a news headline system.
or tables.
I can run php scripts - connect to databases, retrieve and even
insert/update data, but I cannot view databases or tables.
Does anyone have a clue about what the problems may be or where I
should start?
---
Bill Green
20 Meadowview Drive
Asheville, NC 28804
--
[EMAIL PROTE
select * from tblCd
where cdId not in (select distinct cdId from tblOrders);
On Thu, Feb 28, 2002 at 12:37:49PM +1000, Adam Royle wrote:
> Hi.
>
> I need some guidance for writing an effective query (instead of processing
> through PHP).
>
> I lets says I have two tables, tblCDs and tblOrders.
; Andy
You need to join the two tables together:
select count(t.*) as c, f.archive, f.forum_id
from fo_topics t, fo_forums f
where t.forum_id = f.forum_id and f.archive != 1
might work. I assume you have a foreign key in fo_topics linking to fo_forums.
Bill
--
PHP Database Mailing List (http:
I haven't actually tried this, but if you use frames, could you submit
from the first dropdown and refresh the second if they are in seperate frames?
Not that I'd like to support that code.
On Wed, Mar 06, 2002 at 10:14:59AM -0800, fls wrote:
> I've got a dynamic dropdown on http://www.northjers
On Sat, Mar 23, 2002 at 11:46:36PM -0800, Jen Downey wrote:
> Hi all again!
>
> As Bill Morrow stated (in a private e-mail) I needed to use SET name =
> \"$update\""; instead of SET name = $update";
> It has stopped giving the error but it isn't updating
On Mon, Mar 25, 2002 at 02:42:08PM -0800, Andr?s Felipe Hern?ndez wrote:
> Hi, I hope you can help me with this:
>
> I have these 3 tables.
>
> exam (
> exam_id
> )
>
> questions (
> question_id
> exam_id
> )
>
> answers (
> answer_id
> question_id
> )
>
>
On Fri, Mar 29, 2002 at 11:46:24AM -0800, Kevin Won wrote:
> I'm writing a knowledgebase (basically a content management system) application
>where people are adding text via web forms then viewing this data on the web.
>standard bread-and-butter kind of stuff.
>
> of course people want to put
ly for me-
for the first record. Could anyone point out why it won't go on to any other records?
Thanks,
Newbie Bill
$idl) {
break;
}
$query = "SELECT type, manname, manlink FROM man_links WHERE recordno=$id";
$result =
I am having problems connecting to an Access database. I am using Windows
2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
the Access (.mdb) driver, and have a username and password. What's going
on?? Thanks, Bill
The code I have used is as fo
columns have NULL values. Thanks, Bill.
My current, inner join syntax is:
$class_query = "SELECT sample.Sample, type.type_name, chon_class.class_name,
chon_group.groupname, brecciation.brec_type
FROM sample,type,chon_class,chon_group,brecciation
WHERE sample.type = type.type
AND sample.chon_
on the
development machine. Could there be a version problem with the PHP module?
Any other suggestions would be greatly appreciated.
Thanks, Bill
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I can see absolutely no reason to store the name of
the image with the picture?
Why not, whether using one directory or one for each
user, just do id.gif?
Best Regards,
Bill Zeller
--- Steve Brett <[EMAIL PROTECTED]> wrote:
> that would generally work on the assumption that
>
with author.id = picture.owner
I see no downside to doing that and it seems to be a
relatively effecient way to ensure the uniqueness of
all image names.
Best Regards,
Bill Zeller
--- Sheridan Saint-Michel <[EMAIL PROTECTED]>
wrote:
> I don't know if having multiple users associated
&g
Dear [EMAIL PROTECTED],
> BE A MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! > >
> Before you say ''Bull'', please read the following.>
> This is the letter > you > have been hearing about
> on the news lately. Due to> the popularity of > this
> letter on the Internet, a national weekly news>
> progr
I am new to PHP so I am need someone to explain this problem to me. I am
trying to read items from a table and store them into an array. My current
function of choice to use is "mysql_fetch_array". The documentation says
that it returns FALSE if there are no more rows returned, but yet when the
q
Disregard the previous post. I figured out that mysql_num_rows() returns the
number of rows from the result of a SELECT query.
"Bill Blancett" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am new to PHP so I am need someone to ex
On Thu, Nov 01, 2001 at 04:43:00AM -0500, Ian Evans wrote:
> Cami wrote:
>
> > Try this:
> > mysql> select *,(case when title like '%The%' then substring (title, 5, 255)
> > when title like '%A%' then substring (title, 3, 255) when title like '%An%'
> > then substring (title, 4, 255) else title e
You should sort the addressees by domain first too, to give the MTA
a chance to opimize your spam delivery.
On Fri, Nov 02, 2001 at 04:44:06PM +, Shane Wright wrote:
> Hi
>
> I find that the best way to do it is with a script having a long/unlimited
> timeout, but limiting it to only a few
Harpreet wrote:
> I have run JOBs in sql server and was wondering if we have ne thign similar
> in mysql or use PHP to write a script that would automatically run every 10
> minutes.
Unix has cron: 'man crontab'
I think Win2k has it included. Otherwise you will have to get an add-on
service.
would be much easier to answer this question if we knew what
OS is running MYSQL.
I use linux and use cron for most MYSQL stuff.
My pc is NT and for that I use AT.
for win2k Professional, I believe there is a graphical version of AT.
bill
-Original Message-
From: Christian Sage [mailto
Jay Fitzgerald wrote:
> displays fine now -- thanks for that help so far -- but the problem now
> (this may be normal, but I am not sure) is when I connect to the db and
> "select * from jobs;" the db is writing the entries like this:
>
> ===
> mysql> select * from jobs;
>
>+
Change the second ifelse-- either get rid of it, or put it at the end.
Right now your logic is like this:
if (a equals b) {
...
} elseif (a does not equal b) {
...
} elseif (c equals d)
etc
One of the first two conditions will always match, so the rest of the
statement is skipped.
-bill
For the textarea, print the value between the tags-- there is no value
attribute:
You cannot do this with file inputs.
-bill
Rajesh Fowkar wrote:
Hi,
I can write a code like :
Thus I can set the value of $txtfield1 and it is reflected in the above
textbox.
How can such thing be done
My System:
Windows 98
Apache 1.3.27
PHP 4
mysql
Hello all, I am a PHP beginner and was wondering if I could get some help from some of
the more experienced on this list. I have been trying to use an html form (with
textboxes, radio buttons, and textareas) to input data into a mysql database.
Hello ,
i want to make an windows explorer like application in Php where on the left hand side
i have the folders with + or - sign and if i click on + sign it should show me the
sub-folders
in that folder just like we can see in windows explorer, and when i click on - then it
should fold back a
Absolutely. You just need to download the windows version and run the
installer. Runs fine. You can even run PHP and ASP scripts side-by-side
if needed.
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 08, 2007 9:57 AM
To: [email protected]; php-d
HP,
Apache, ODBC, FreeTDS and I cannot find something wrong, but obviously,
I am missing something here.
Thanks in Advance,
- Bill
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
mns in the table ... I have checked all of this. I have also
returned the result to a variable and echoed it to the screen ... the result
printed is "Resource id #2".
This is driving me crazy as I know it must be something quite simple that I
am overlooking. Any help is greatly app
erent
page or call to that database. My question is ... Is there a better way
and, if so, what is it? I guess I do not quite understand just how long a
connection is maintained. I hate to write code that doesn't clean up after
itself. Any suggestions are appreciate. TIA
Bill
--
PHP Da
53 matches
Mail list logo
