utton; or
B) pop-up a notice telling the user they can delete that particular
record.
Hope that makes sense.. any ideas?
Thanks!
Aaron
Hi All,
Solved my problem!
Here's the code in case anyone really cares :P
$col = explode(",",$threadsColumn);
$col_search = "(";
for ($i=0;$imailto:[EMAIL PROTECTED]
Sent: June 26, 2003 10:26 AM
To: Aaron Wolski
Cc: [EMAIL PROTEC
Hi Adam,
Thanks...typing errors can be a killer sometimes.
However, the cleared up the "Array" display error but not the displaying
the contents what's in the $columns array.
Thanks for your help!
Aaron
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]
Sent
Hi All,
Hopefully someone here can point me in the right direction.
I need to create a SELECT statement based on some criteria select and
entered into a form.
Form variables:
$threadsColumn = "manufactuer,colour";
$string = "n";
Code:
$columns[] = explode(",",$threadsColumn)
Strlen
:
-Original Message-
From: Dallas Freeman [mailto:[EMAIL PROTECTED]
Sent: March 12, 2003 4:22 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Cropped Text
I dunno what it is called so that is why I am asking, so that I can
search the web about it.
What do you call the method of croppi
Mine :)
Aaron
-Original Message-
From: Marie Osypian [mailto:[EMAIL PROTECTED]
Sent: March 6, 2003 2:53 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Store
I was wondering if anyone was using a good store that was open sourced
in
php.
Marie O
--
PHP Database Mailing List (http
Try escaping the $catid like:
WHERE cat_id='$catid'
Aaron
-Original Message-
From: Alawi shekh albaity [mailto:[EMAIL PROTECTED]
Sent: March 1, 2003 1:04 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] What wrong in this SQL
What wrong with this code in sql :
$SQ
**
%
Ive been able to get the cart_ids associated with each province
selected but I am having lots of trouble displaying the result FOR the
selected $provinces.
Can anyone help me with where I am erroring?
Thanks a ton!
Aaron
--
PHP Database Mailing List
y array from a form field?
grrr!
Somebody else replied with isset($varname). Try that. The count()
function
is working as expected (see
http://www.php.net/manual/en/function.count.php). So maybe it's not the
best
choice for trying to find out what you want.
> -----Original Message-
&g
;t seem to be recognizing that the option
value="" is empty!
Any more ideas??
*sigh*
Aaron
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: February 5, 2003 4:03 PM
To: 'Aaron Wolski'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking fo
"bye";
}
if (count($products) == 0) {
echo "hello";
}
else {
echo "bye";
}
NOTHING works!!!
Any help.. puuulease?
Aaron
Hi All,
Again.. a little off topic - sorry (again!).
Have a form that allows me to select a bunch of product names from a
drop down combo box.
I'm trying to create code like "in ('Product name1','Product Name2) to
be inserted into an SQL statement.
I figured that since $products was ALREADY
$str_products = $products;
}
echo $str_products;
}
Aaron
Solved the issue...
Just thought I'd post the query that did it.
$provinceQuery = db_query("SELECT * FROM ProvinceSelectTable AS t1,
OrderTable AS t2 WHERE t1.value=t2.province GROUP BY t2.province");
Thanks for any help thought to provide me :)
Aaron
-Original Message--
Table.
I could simply just display all provinces/states from the ProvinceTable
but then there would be entries for selection that had NO orders.
Any idea on this? Thanks guys!
Aaron
Select SUM(colname) as newColName FROM SomeTable WHERE value='value';
Reference the 'newColName' as your variable.
Aaron
-Original Message-
From: Cesar Aracena [mailto:[EMAIL PROTECTED]]
Sent: January 17, 2003 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SUM(co
his?
Any thoughts?
Thanks!
Aaron
You want to look at nl2br() function.
It takes newlines from a text like:
Hello
My name is
Aaron
Which when outputted normally would look like:
Hello my name is aaron
Using echo nl2br($dbquery); would produce:
Hello
My name is
Aaron
In your HTML code which then would output in a browse
Write your own.
You'll spend more time trying to find something than it will take you to
create your own. Plus.. anything that you do find will need
modifications anyway so may as well write your own.
Define the scope/parameters
Write out the logic
Program the script
:)
Aaron
-Ori
LIMIT 5,10
LIMIT 10,15
Something like that should work.
Aaron
-Original Message-
From: conbud [mailto:[EMAIL PROTECTED]]
Sent: December 16, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing A Certain # Range
Hello,
Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux
What's your table structure looks like?
Aaron
-Original Message-
From: mike karthauser [mailto:[EMAIL PROTECTED]]
Sent: December 9, 2002 9:48 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Enlarging tables
We have been entering data into a mysql table and it has got to id=127
and
Hi Jeff,
One thing you can try is setting the cookie twice.. with and without the
secure setting.
Your code will pick up the nonsecure in the nonsecure area and function
fine.. just as your code will pick up the secure in the secure area and
function fine.
Should work.
Aaron
-Original
Or that too
hehe
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: December 6, 2002 3:51 PM
To: 'John'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Here goes!
You're missing the
mysql_query($sql) or
die(mysql_error());
to actually fire the data into the
spirations, mtype) VALUES
('$first','$last','$age','$email',
'$location','$eye','$hair','$experience','$aspirations','$mtype')";
Just a few thoughts here.
Aaron
-Original Message-
Fr
Sure thing,
Give it a whirl.
Aaron
-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: December 6, 2002 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Data not entering DB
Questions:
Is this the right email addy to post help questions, and may I post the
php code within
Why don't you post the actual data you are pulling FROM the Db.. then
show HOW you want it formatted.
Might be better for us to give you a solution or something.
Aaron
-Original Message-
From: Art Chevalier [mailto:[EMAIL PROTECTED]]
Sent: December 5, 2002 3:21 PM
To: [EMAIL PROT
is adding a pre-written virtual tour/still photo tour page-set to
the OpenRealty stock php site; eg: http://jonroig.com/freecode/openrealty/
I'm willing to pay top rate to the person who is qualified to complete the work in a
timely and professional manner.
Thanks,
Aaron
Aaron Lagady
Well...
1 day = 60*60*24 = 86400
You figure it out from there :)
Just one example.
Aaron
-Original Message-
From: Dankshit [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2002 12:06 PM
To: PHP; PHP1
Subject: [PHP-DB] Help with date
How can i add days to a date
Hmm
You learn something new everyday :)
Aaron
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 2:27 PM
To: Aaron Wolski; 'NIPP, SCOTT V (SBCSI)'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] INSERT question...
> Try... $query =
Try... $query = "INSERT INTO accounts (accnts,timestamp)
VALUES(''.$accnts[0].'','TIMESTAMP(10)')";
Might work?
Aaron
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 2:16 PM
To: '[EMAIL
eaders);
}
}
}
Any thoughts on why I get the email twice?
Thanks all. Much appreciated!
Aaron
more about the code supplied below though.
How does this work?
As long as they HAVE a string that gets compared in the DB then what
good is this? They can still gain access to the users account.
Thanks again.
Aaron
-Original Message-
From: Jeremy Wilson [mailto:[EMAIL PROTECTED]]
Sent:
Hmm.. I would get it into a unix_timestamp (unless someone can suggest a
reasoning for now doing so).
Select unix_timestamp(storedDate) as date FROM SomeTable where blah
blah"
Should work like that?
Aaron
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Ok..
I guess it depends on how your date is stored. I always use
unix_timestamps.
If you are too.. then the format I supplied should work as indicated.
Aaron
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: November 18, 2002 2:19 PM
To: 'Php-Db'
S
Yes indeed!
We often forget cause we're so busy with our own projects. However, so
are the people who helped us out originally.
Thanks to you - you know who you are!
*sings* Lets drink to the hard working people Lets drink to the good
(PHP) and the evil (ASP/VB)
haha :)
My client is the one doing the setup of accounts.
How would the account holder know of his password before it got
encrypted?
Hense the email.
Aaron
-Original Message-
From: Peter Beckman [mailto:beckman@;purplecow.com]
Sent: November 15, 2002 12:35 PM
To: Aaron Wolski
Cc: '
() of
the app.
Thanks again.
Aaron
-Original Message-
From: Jason Vincent [mailto:jayv@;nortelnetworks.com]
Sent: November 15, 2002 12:05 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Email Encryption?
What I was getting it is, have the 'users'
is supposed to simplify their lives not
complicate :(
Aaron
-Original Message-
From: Cal Evans [mailto:cal@;calevans.com]
Sent: November 15, 2002 11:54 AM
To: Aaron Wolski; 'Hutchins, Richard'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Email Encryption?
Instead of emailing them
The user account is setup via the Admin util.
The details are emailed to the account holder.
Profile and Login information are contained within.
Aaron
-Original Message-
From: Hutchins, Richard [mailto:Richard.Hutchins@;GetingeCastle.com]
Sent: November 15, 2002 11:43 AM
To: [EMAIL
layed logins details and reek havoc
on the store, etc.
*shrugs* Sadly this isn't open for debate as a solutions IS required.
Any thoughts?
Aaron
-Original Message-
From: Jason Vincent [mailto:jayv@;nortelnetworks.com]
Sent: November 15, 2002 11:42 AM
To: Aaron Wolski; [EMAIL
Just thinking here..
PGP is not an option as it would mean EACH user being setup would need
the company's public key to decrypt. Not possible as they setup a few
hundred accounts each month.
Hmm.. anything else?
Argh :(
Aaron
-Original Message-
From: Aaron Wolski [mailto:aa
7;ve never really worked
with PGP and wouldn't have the first clue.
Does anyone have any experience with this or can offer and advise at
all?
Again, sorry for the OT discussion.
Aaron
Link: http://www.rinkrake.com/blah.php
Wacha think?
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-Original Message-
From: Jason Vincent [mailto:jayv@;nortelnetworks.com]
Sent: November 15, 2002 8:51 AM
To: Aaron Wolski; [EMAIL
Doh!
Edit:
if (mysql_num_rows($sql) == 0) {
Aaron
-Original Message-
From: Aaron Wolski [mailto:aaronjw@;martekbiz.com]
Sent: November 15, 2002 8:42 AM
To: 'Snijders, Mark'; 'Jonathan Narong'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking for 0 results?
Or you
Or you can skip a step like:
$sql = "select * from ietsfuckingfriday";
if (mysql_num_rows($result) == 0) {
do_something();
} else {
do_anotherthing();
}
Aaron
-Original Message-
From: Snijders, Mark [mailto:Mark.Snijders@;atosorigin.com]
Sent: November
ws = db_numrows($refQuery);
?>
If this is too messed up let me know and I'll reformat.
Sorry guy the annoying question guys.
Aaron
it that much stronger and a longer lasting business
relationship (more$).
Just my thoughts.
Aaron
-Original Message-
From: John KRewson [mailto:krewsonj@;sworps.utk.edu]
Sent: November 14, 2002 10:47 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Best reporting Tool
I have recently
$date = date("m:d:y", $myrow[datefield]);
Will produce: 11:13:02
http://www.php.net/manual/en/function.date.php
Aaron
-Original Message-
From: Edward Peloke [mailto:epeloke@;echoman.com]
Sent: November 13, 2002 4:27 PM
To: Php-Db
Subject: [PHP-DB] date()
I have a date f
Ok,
Thanks for your input. I know very little about how to manipulate MySQL
so this out to be fun and very slow going :-(
Thanks!
Aaron
-Original Message-
From: Jason Vincent [mailto:jayv@;nortelnetworks.com]
Sent: November 13, 2002 12:34 PM
To: Aaron Wolski; [EMAIL PROTECTED
Hi There,
Well the first and last record of the results.
So if 1000 records were found... then record #1 and then record #1000 -
perform data calculation between those 2 records (how many days does
this query span).
Know what I am trying to say?
Sorry if its not clear.
Aaron
-Original
to get the number
of days the record spans?
Haven't done something like this before and don't have a clue where to
start. Date sorting,etc I can do just don't know about this one.
Thanks for your help!
Aaron
e%22>
&ie=UTF-8&oe=UTF-8&q=%22help+me%22
If would be entered into the Db because the keyword "identifier" is the
& sign.
How would I alter the above explode() code to include a bunch of
"identifiers".. for example:
?
K
R
Etc.
Any thoughts?
Thanks a bunch!
Aaron
ONLY be on the
delete[] checkbox.
I know.. waaay off topic but I don't know how to reference the names
that are arrays in javascript :(
Sorry again all.
Aaron
Hi All,
In a form I have checkboxes associated with order records. The
checkboxes are for deleting order records (should a client choose to do
so).
It looks like this:
Now.. when the process button is pressed the information is carried off
to the
Ok...
This is the code I have setup:
for ($i=0;$i -Original Message-
> From: Rasmus Lerdorf [mailto:rasmus@;php.net]
> Sent: Wednesday, November 06, 2002 2:16 PM
> To: Aaron Wolski
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Imploding an array?
>
>
> You su
Hey all,
Can't seem to figure out why this won't work:
$test = implode(",", $order_index[$i]);
When I print_r() the variable I have values so I know that works.
Any thoughts on this?
Thanks.
Aaron
Hi there,
This worked perfectly for me!
Thanks for the tip - I shall remember this :)
To all who replied - thanks for your help as well.
Regards,
Aaron
> -Original Message-
> From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr]
> Sent: Tuesday, November 05, 2002 9:1
7;Shipped' OR order_status='Not
Shipped'" part the query works fine and only returns 2 results (as
expected). However, with the inclusion of the previous I get all the
results (currently 8) returned.
It seems to be ignoring everything before "AND order_status='Shipped' OR
order_status='Not Shipped'".
Any clues?
Much thanks!
Aaron
Hi Guys,
I'm begging here.. ANYONE have a clue. I can searchinbg and searching
but I see nothing that's helping me. Anyone had issues like this before?
Thanka!!!
Aaron
-Original Message-----
From: Aaron Wolski [mailto:aaronjw@;martekbiz.com]
Sent: Friday, November 01, 2002 1
Arg.
Thanks.
Aaron
n md5 hash and compare that value against the stored md5
password. If a match - log the user in. If not - kick an error page.
Aaron
> -Original Message-
> From: Seabird [mailto:jacco@;vliegt.nl]
> Sent: Thursday, October 31, 2002 9:49 AM
> To: [EMAIL PROTECTED]
> Subject:
ALTER TABLE TableName ADD COLUMN columnParametersHere
E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255);
Aaron
> -Original Message-
> From: Shaun Thornburgh [mailto:shaun@;mania.plus.com]
> Sent: Thursday, October 31, 2002 7:39 AM
> To: [EMAIL PROTECTED]
> S
do_something_else logic.
How would I approach this?
something like:
for ($first_record) {
do_something;
} else {
do_something_else;
}
Any clues?
Thanks!
Aaron
> -Original Message-
> From: Graeme McLaren [mailto:mickel@;ntlworld.com]
> Sent: Friday, October 25, 2002 2:4
7;t
perfect. I would rather develop a solution like this for them instead of
them going to some hack who could give 2 shits about security.
My clients dictate the development and I provide the expert and
cautionary advive. If they are willing to be obtuse about the process
then who I am to balk?
Just
Well.. Isn't that the ideal.
I agree in theory, however, not all clients are willing to shell for the
Payment Processor Services if they are just starting ou tin e-commerce
and don't know what kind of volume to expect.
Thery is wonderful, however, practicle must preside.
Aaron
---
to provide us with the code (which is quite
small) while working a few site before his departure.
Seems to works like a charm and we've never had any issues with it
(hacking, etc).
Regards,
Aaron
-Original Message-
From: Doaldo Navai Junior [mailto:doaldo@;triunfo-bsb.com.br]
Agreed!
It sure is.
Aaron
-Original Message-
From: John W. Holmes [mailto:holmes072000@;charter.net]
Sent: Monday, October 21, 2002 12:51 PM
To: 'Sparks'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] catalog system
> If someone will point me to the Nubee-forum, I will gla
Build you own.
Does no one want to 'work' for their projects these days?
*shrug*
Aaron
-Original Message-
From: Sparks [mailto:alex@;paychoice.com]
Sent: Monday, October 21, 2002 9:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] catalog system
Greetings,
I'm looking f
If (isset($_COOKIE[cookiename]) {
echo 'Your cookie is: '.$_COOKIE[cookiename].' ';
}
-Original Message-
From: Steve Dodkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 9:22 AM
To: Php-Db (E-mail)
Subject: [PHP-DB] echo printing a cookie
Hi I'm trying to print
Hey all...
Working on a time calculation for a tracking system.. time ON the apge..
time OFF the page type of thing..
Anyway.. everything as far as entering the time values, etc is working
correctly except the calculation is NOT working as it should!!!
here is my code for the calculation
/*
Why don't you just try it and see?
Aaron
-Original Message-
From: Rodrigo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:41 PM
To: PHP
Subject: [PHP-DB] Function help
Hi people, i wanna know from you if this is the way to complete a filed
with zeros "0
t
possible.
Any ideas out there?
Thanks.
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
SELECT * from SomeTable where dateinserted>$start_date AND
dateinserted<$end_date
Dateinserted is the date stamp column in your table.
Aaron
-Original Message-
From: Meltem Demirkus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 8:36 AM
To: [EMAIL PROTECTED];
When the page is loaded only Row 1,2 and 4 are displayed. When someone
else loads the page rows 2,4 and 5 are displayed.
Any clues on how to make this possible??
Thanks in advance for looking.
Peace.
Aaron
hp code into a url (form or link) such as a
$rerturn_url I usual do something like:
This would produce a url like: index.php?type_index=3 (assuming the type
index selected was indeed 3) but you should understand what I mean.
Don't know if this helps you at all but figured I'd take a s
reciated
thanks all.
Aaron
Brad,
Thanks a million! That does the trick.
Aaron
On 9/5/02 3:38 PM, "Brad Bonkoski" <[EMAIL PROTECTED]> wrote:
> $variable_to_be_passed = 'some value';
> echo "I am a
> link";
>
> I think this should do it, not quite sure what you mean by
All,
How can I display the results of a table so that the first field (column) is
a link to another page that shows the details of that row? Issue #1, I have
to wrap the cell contents in an http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Are you able to connect to the MySQL server using a client?
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL Socket error :\
PHP Warning: MySQL Connection Failed: Can
It may prove beneficial to check the event log. More clues may lie in
there. If the webserver has any type of error log check that as well.
Aaron Weiker
> -Original Message-
> From: Marco Lanini [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 22, 2002 1:10 AM
> To: [EMA
lease, if you
can, reply directly to my email address as well as this list.
Thanks,
Aaron.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
I hope you can help.
Thanks
aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
http://www.php.net/manual/en/features.file-upload.php
-aaron
At 3:03 AM +0200 3/9/01, karakedi wrote:
>hi there,
>
>i want my users to upload their image files to a desired directory,
>i can handle that but...
>
>is it possible to make a "upload file" php s
101 - 184 of 184 matches
Mail list logo