[PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Aaron Wolski
Hi All, I HOPE this is the right place for this.. if not I am sorry!!! I'm hoping someone can put me on a clear path of how to do what I am asking here. I Have a shopping cart... and in this shopping cart I want to feature some items in a pop_up window when the user is ready to check out - if

RE: [PHP-DB] strange behavior

2002-09-12 Thread Aaron Wolski
Hi There, I don't know if this is the actual problem.. But in your form action it looks off. action="index.php? Would produce something that looks like: index.php?123455667784332 What I think you WANT to do is... action="index.php?SID= When I need to put php code into a url (form or

[PHP-DB] randomizing amounts of html displayed

2002-09-12 Thread Aaron Wolski
Hi All.. Quick question and perhaps a suggestion/solution requst to the above topic. My brain is just not working :( I have a HTML table with 5 rows of data. I would like to randomly display 3 of the 5 rows when the page is accessed. For example: Row 1 Row 2 Row 3 Row 4 Row 5 When

RE: [PHP-DB] how can I do?

2002-09-19 Thread Aaron Wolski
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]; [EMAIL PROT

[PHP-DB] how to disable PHPSESSID from posting in URL

2002-10-01 Thread Aaron Wolski
Hey all, I KNOW this is not a Db related question but I really need some ideas here. I don't want the URL to display this info. I never notcied this being displayed before but all of a sudden it seemed to pop-up. I don't host my own server so any access to the php.ini file is not possible. Any

RE: [PHP-DB] Function help....

2002-10-03 Thread Aaron Wolski
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"... if i typ

[PHP-DB] Need help with time calculation for a tracking system - it DOES involve DB work :)

2002-10-04 Thread Aaron Wolski
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 /*

RE: [PHP-DB] echo printing a cookie

2002-10-15 Thread Aaron Wolski
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

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
Well... You can use PGPG/GNPGP for this or you can develop your own RSA encryption - if you understand/have the know how. A former programmer of mine who worked for a Security firm developed the base-line code which was originally written in C then transferred into Perl. He was greatful enough to

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
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 -Original Mes

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
Maybe you do, Bt I run a _client_dictates_the_development_requirments business. It not not be that expensive but to some clients who are trying to give it a go it can mean a lot. Am I to tell them I won't accept their business? No - what I am to do is provide them with the best alternative which

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
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 for a cataloging

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
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 gladly go. http://fo

[PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

2002-10-25 Thread Aaron Wolski
Hey guys, Not really off topic as this involves some Db work as I have to query the DB. Got a logic problem that was jumped dumped on me from UPS (dummys!). Basically I need to pull some records out of a database and for the first record do_this logic and for each record after in the array do_s

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Aaron Wolski
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] > Subject: [PHP-DB] Ad

RE: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Aaron Wolski
You cannot reverse the encryption of an md5 hash. Nor should you want to. You don't want to know their password which is why you encrypt it. When you seyup an account you convert the password to an md5 has(I assume you have done so). When they log back in.. You convert the password to an md5 hash

[PHP-DB] COOKIE problem... URGENTLY NEEDED HELP

2002-11-01 Thread Aaron Wolski
Hi All, Ok.. just went live with a site that 'appeared' to work wonderfuylly. However, now it seems I cannot read a cookie in a secure area (https) when it was set in a non-secure area (http). Any clue on how to get this universally to work? Really really need help with this. Arg. T

FW: [PHP-DB] COOKIE problem... URGENTLY NEEDED HELP - BEGGING

2002-11-01 Thread Aaron Wolski
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

[PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Aaron Wolski
Hi All, I have a query like: select * FROM OrderTable WHERE submitted=1 AND dateinserted>='1036386000' AND dateinserted<='1036502796' AND order_status='Shipped' OR order_status='Not Shipped' Now.. if I omit the "AND order_status='Shipped' OR order_status='Not Shipped'" part the query works

RE: [PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Aaron Wolski
at you want is: > > select * FROM OrderTable WHERE submitted=1 AND > dateinserted>='1036386000' AND dateinserted<='1036502796' AND > ( order_status='Shipped' OR order_status='Not Shipped' ) > > HTH > Ignatius J. Reilly >

[PHP-DB] Imploding an array?

2002-11-06 Thread Aaron Wolski
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

RE: [PHP-DB] Imploding an array?

2002-11-06 Thread Aaron Wolski
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

[PHP-DB] first Array value duplicating..

2002-11-07 Thread Aaron Wolski
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

[PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Aaron Wolski
Sorry for the OT post y'all.. but I can't find this answer - well not without major major code information that I can't figure out! Basic? I have a series of checkbox arrays like: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part

[PHP-DB] How to do this..

2002-11-12 Thread Aaron Wolski
Hi All, Need a little help with something. I've created a Search Engine Tracking tool that allows me to measure ROI from users that comes form search engines using specific keywords.. My problem is I forgot to capture a multiple of different "identifies" that tell me where the keyword is. T

[PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Hi All, First off I have a query like this: SELECT dateinserted FROM SiteTrackingTable; Now. in this query any number of results could be returned 10 or 1000, etc. Is it possible to take the dateinserted value from the first record and then from the last record and perform some calculation

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 13, 2002 12:24 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? You should be able to do this at the database level - of course you never said what database that is

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
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

RE: [PHP-DB] date()

2002-11-13 Thread Aaron Wolski
$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 field in my my

RE: [PHP-DB] Best reporting Tool

2002-11-14 Thread Aaron Wolski
I have to agree on the PDF. Currently my host does not provide for PDF capabilities as of yet but I believe they are going to be compiling with support for PDF soon. When they do, look out. The success of some of our commercial apps will rise for sure as this reporting options becomes available.

[PHP-DB] serious help with linking data together...

2002-11-14 Thread Aaron Wolski
Hey all, Been trying too figure this out all day. First off I'll explain what I am TRYING to do. I am creating a Search Engine Tracking Report that lists keywords and the Search Engines used on that keyword along with the count total for that search Engine - example: Keyword S

RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Aaron Wolski
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 15, 2002 8:26

RE: [PHP-DB] checking for 0 results? edit

2002-11-15 Thread Aaron Wolski
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

RE: [PHP-DB] serious help with linking data together...

2002-11-15 Thread Aaron Wolski
-Original Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 15, 2002 8:51 AM To: Aaron Wolski; [EMAIL

RE: [PHP-DB] serious help with linking data together...

2002-11-15 Thread Aaron Wolski
By George I think I may have got it! Code: Keyword Search Engine Count

[PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
Sorry for the off topic guys.. But I've just been informed that an application we developed for a client whereby they use an Admin tool to setup user accounts into their store needs to have the login (username and password) encrypted. I am thinking PGP for this but to be honest I've never re

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
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

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
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

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Can you explain how e-mail fits into the Admin solution? What is the e-mail used for? Setting up the accounts/passwords or sending the account/password to the user? > -Original Message- > From: Aaron Wolski [mailto:aaronjw@;martekb

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
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

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
() 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'

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
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: '

RE: [PHP-DB] I just wanna say...

2002-11-15 Thread Aaron Wolski
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 :) Aaron -Origin

RE: [PHP-DB] date()

2002-11-18 Thread Aaron Wolski
ubject: RE: [PHP-DB] date() When I use this, I get 12/31/69 as my date. -Original Message----- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 13, 2002 4:04 PM To: 'Edward Peloke'; 'Php-Db' Subject: RE: [PHP-DB] date() $date = date("m:d:y",

RE: [PHP-DB] date()

2002-11-18 Thread Aaron Wolski
Sent: November 18, 2002 2:50 PM To: 'Php-Db' Subject: RE: [PHP-DB] date() it is just a datetime field and the clients use a javascript calander to pick the date, here is the exact date as it appears in the db. 2002-11-08 00:00:00 Eddie -Original Message----- From: Aaron Wolski [mailto:[

RE: [PHP-DB] Email Encryption?

2002-11-19 Thread Aaron Wolski
November 16, 2002 1:08 PM To: 'Aaron Wolski'; 'Jason Vincent'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? $encrypted_string = md5(base64_encode($var.'secret key')); Pass the user name or password to $var and place text in to replace the words &#x

[PHP-DB] multiple foreach loop?

2002-11-20 Thread Aaron Wolski
Hi All, Trying to create a "refer a friend" script. User enters 10 names and email address of a friend to refer to a site. The following code SORT of works in that it will send the email, etc.. but problem is it duplicates - sends the email out twice to the same email address. **CODE*** f

RE: [PHP-DB] INSERT question...

2002-11-20 Thread Aaron Wolski
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 PROTECTED]' Subject: [PHP-DB] INSERT question...

RE: [PHP-DB] INSERT question...

2002-11-20 Thread Aaron Wolski
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 =

RE: [PHP-DB] Help with date

2002-11-28 Thread Aaron Wolski
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??

RE: [PHP-DB] MySQL Array

2002-12-05 Thread Aaron Wolski
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 PROTECTED]

RE: [PHP-DB] Data not entering DB

2002-12-06 Thread Aaron Wolski
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 th

RE: [PHP-DB] Here goes!

2002-12-06 Thread Aaron Wolski
First off, Have you tried echoing the values upon submission to ensure they are being set in the form? Secondly, I would place all "data" code in another file for script processing - processRegistration.php would work well. If all values are being set... maybe look at: $sql="INSERT INTO model

RE: [PHP-DB] Here goes!

2002-12-06 Thread Aaron Wolski
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

RE: [PHP-DB] http/https

2002-12-07 Thread Aaron Wolski
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 Mess

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Aaron Wolski
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 then stopp

[PHP-DB] Dynamic Form?

2004-04-13 Thread Aaron Wolski
Hi All, I've been given the task of developing a dynamic form for a client. When I say dynamic, I mean dynamic in that the client can use an administrative interface (back-end) to create the various form fields (and types) that get displayed on the front-end. Before I start brainstorming the DB

[PHP-DB] PHP based telco billing/accounting software

2004-05-19 Thread Aaron Wolski
[OT] Hi all, I have a client who needs to implement telephone billing/account software for their clients. They're looking to have us develop a customize solution for them. However, I thought I'd check here and see if anyone knows of software (opensource or paid) that they could recommend me chec

[PHP-DB] how to reuse DB results

2004-05-20 Thread Aaron Wolski
Hi All, Got this logic problem I don't know how to solve. Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Right now, I am making two calls to the Db to get th

RE: [PHP-DB] how to reuse DB results

2004-05-20 Thread Aaron Wolski
e thing at the bottom of the > page. > > That's just one way though. There are probably others available with and > without the use of a db abstraction class. > > HTH, > Rich > > > -Original Message- > > From: Aaron Wolski [mailto:[EMAIL PROTECTED

[PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
Hi All, I'm looking for some advise/login on developing an Inventory Management system for an ecommerce store and what pitfalls one needs to be on the lookout for. Anything anyone would like to contribute would be greatly appreciated! Thanks in advance! Aaron

RE: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
isting one rather than reinventing the wheel, so to speak. > > Thanks, > Rich > > > > -Original Message- > > From: Matt [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 21, 2004 11:42 AM > > To: Aaron Wolski; [EMAIL PROTECTED] > > Subject: R

RE: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
> -Original Message- > From: Matt Schroebel [mailto:[EMAIL PROTECTED] > > What if I abandon my cart? Are you using transactions to make sure all > updates are atomic? All cart records are stored to the database with a timestamp. On each call to the cart_script, I check to see if any re

[PHP-DB] How to get 2 columns to display

2004-12-06 Thread Aaron Wolski
Hi guys, I'm trying to get two columns of to display side by side and then go to a new row. I am using this code but nothing I seem to do is working this far. What is happening with this code is I am getting results like: IMAGE HERE IMAGE HERE IMAG

RE: [PHP-DB] Listing A Certain # Range

2002-12-16 Thread Aaron Wolski
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, I

RE: [PHP-DB] Upload Images...

2002-12-27 Thread Aaron Wolski
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 -Original Mes

RE: [PHP-DB] [mysql - php] Newline to BR problem

2003-01-09 Thread Aaron Wolski
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 lik

[PHP-DB] Slashed being added..

2003-01-15 Thread Aaron Wolski
Hi All.. Quick q here as I cannot remember how to prevent this. Customer is entering their name in a form that get submitted. Their name is: Mike O'Neill But their name is being entered like: Mike O\\\'Neill This is causing his info not to be saved. How do I prevent this? Any though

RE: [PHP-DB] SUM(colname)

2003-01-17 Thread Aaron Wolski
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(colname) Hi all, I'm tr

[PHP-DB] matching data from one table with another and displaying results?

2003-02-04 Thread Aaron Wolski
Hi All, Having a problem figuring out the logic of something here and hoping someone can point me in the right direction. I have 2 tables. First table holds a listing of all Provinces and States. Here a brief of what it looks like: value label AB Alberta BC British Col

RE: [PHP-DB] matching data from one table with another and displaying results? SOLVED

2003-02-04 Thread Aaron Wolski
--- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: February 4, 2003 11:59 AM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB] matching data from one table with another and displaying results? Seek out LEFT JOIN on mysql web site, thats what you want. Cheers Jason

[PHP-DB] Help with select box - multiple...

2003-02-05 Thread Aaron Wolski
Hi All, Sorry to be a pain on this one as it is sorta off topic.. but any help would be awesome. I'm creating a report for Product Popularity in which the Admin is present with a form and they have the ability to select A product or multiple products from a drop down combo box. The form is su

[PHP-DB] Argh ! array help required :(

2003-02-05 Thread Aaron Wolski
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

[PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
Argh HOW does one check for an array being empty from a form field?? Tried a billion different things and NOTHING works I've tried: if ($products == "\n") { echo "hello"; } else { echo "bye"; } if ($products == "") { echo "hello"; } else {

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
;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

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
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

[PHP-DB] help with loop and query

2003-02-07 Thread Aaron Wolski
Hi guys, Hopefully last time I need to call of you people for this report I am creating. In this report there is a multiple select box like:   Province/State   Alaska   Alberta   British Columbia   California   Colorado   Connecticut Usi

RE: [PHP-DB] What wrong in this SQL

2003-02-27 Thread Aaron Wolski
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 : $SQLSTATEMENT["DeleteCategory

RE: [PHP-DB] Store

2003-03-06 Thread Aaron Wolski
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://www.p

RE: [PHP-DB] Cropped Text

2003-03-12 Thread Aaron Wolski
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

[PHP-DB] moving though an array..

2003-06-26 Thread Aaron Wolski
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)

RE: [PHP-DB] moving though an array..

2003-06-26 Thread Aaron Wolski
: June 26, 2003 10:26 AM To: Aaron Wolski Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] moving though an array.. One Thing: Change $columns[] to $colums, example: $columns = explode(',',$threadsColumn); On Thu, 2003-06-26 at 10:23, Aaron Wolski wrote: > Hi All, > > Hopefull

RE: [PHP-DB] moving though an array..SOLVED

2003-06-26 Thread Aaron Wolski
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

[PHP-DB] PHP DB Interaction with Javascript?

2003-06-26 Thread Aaron Wolski
Hi All, Trying to get my head around something and want to know if it's possible first. Can PHP and Javascript interact to the point of PHP querying a DB to find out what records are in use as a variable for another record and then using JS to A) prevent the user from clicking a delete button;

[PHP-DB] csv upload script?

2003-07-07 Thread Aaron Wolski
Hey all, Does anyone know a simple.. out of the box ready go csv upload script to import values into a table? I've looked at hotscripts and couldn't find anything. Any help is appreciated. Thanks! Aaron

RE: [PHP-DB] csv upload script?

2003-07-07 Thread Aaron Wolski
July 7, 2003 2:27 PM To: Aaron Wolski Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] csv upload script? if it is truley csv, then use MYSQL's "LOAD DATA INFILE" syntax. granted you've got to have ahold of the text file.its not out of the box, but pretty close. Woudl that w

[PHP-DB] formating results in seperate tables?

2003-07-08 Thread Aaron Wolski
Hi All, Having some issues with the code below: 0) { for ($i=0;$threadResults = db_fetch($threadQuery);$i++) { ?>

[PHP-DB] Logic Advice?

2003-07-14 Thread Aaron Wolski
Hi Guys, Here's the deal: I have a page the lists "patterns". In this page is a link that opens up a window that displays ALL the "threads" available in the database. "Threads" need to be related to "patterns". What I mean by this is that I need the ability to select (with a checkbox) the t

[PHP-DB] how to do this processing....

2003-07-15 Thread Aaron Wolski
Hi all, Would anyone have some logic ideas on how to do this processing given the following HTML? Selected? Manufacturer Colour # Colour Can Order? DMC B5200

[PHP-DB] speeing up query and display...

2003-07-19 Thread Aaron Wolski
Hi Guys, I have the following query which unfortunately has to grab all records in a table (well over 3000) to display in a multiple select box. Code: > Can ANYONE see a way to speed up the query and displaying of the results? Take a while on High Spe

RE: [PHP-DB] speeing up query and display...

2003-07-21 Thread Aaron Wolski
help. I am sure I'll be able to learn from what you've provided to take my developments that much further. Thanks once again. Aaron -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: July 20, 2003 4:48 PM To: Aaron Wolski Cc: [EMAIL PROTECTED] Subject: R

[PHP-DB] getting MySQL column header?

2003-07-21 Thread Aaron Wolski
Hey all, I have a query (thanks John!)... $query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type, p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id = p.thread_index WHERE p.pattern_index = $id OR p.pattern_index IS NULL ORDER BY t.colourID"; $thread_ma

RE: [PHP-DB] getting MySQL column header?

2003-07-21 Thread Aaron Wolski
uery to get this info. *shrugs* Thanks for the info, though! Aaron -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: July 21, 2003 4:24 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] getting MySQL column header? > How would one get the column

[PHP-DB] why script only updating one table?

2003-07-22 Thread Aaron Wolski
Hi All, I have a form that passes to select box array to my script. Select boxes are named: patternThreads[] and patternFabrics[] My Script: //Check to see if Threads were selected for this pattern if ($patternThreads) { if (is_array($patternThreads)) {

RE: [PHP-DB] why script only updating one table? SOLVED

2003-07-22 Thread Aaron Wolski
Hi Guys, No need to think about this. I solved the problem by putting both scripts under one check If ($patternThreads || $patternFabrics) { //DO STUFF HERE } Aaron -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED] Sent: July 22, 2003 10:34 AM To

[PHP-DB] passing array data back to form in header?

2003-07-22 Thread Aaron Wolski
Hi Guys, the topic pretty much covers it. I have a script and if it errors out.. I send a bunch of values back to the form. I'm having difficulity figuring out how to pass array data that is/was selected back to the form. I can send the non array values no problem - eg: header("Location: patt

[PHP-DB] dynamic radio buttons.. checked or not?

2003-07-24 Thread Aaron Wolski
Hi Guys.. hopefully someone can help with this. Code: $query = "select t.id, t.thread_index, t.pattern_index, t.avail, p.id, p.type, p.colour, p.colourID, p.manufacturer FROM kcs_patternthreads t LEFT JOIN kcs_threads p ON t.thread_index = p.id WHERE t.pattern_index = $id";

RE: [PHP-DB] Line of code should work...but doesn't

2003-07-24 Thread Aaron Wolski
if (strftime("%H") == "03") { header( "Location: maintainence.php" ); exit; } Note the exit; line. Aaron -Original Message- From: J. Michael Roberts [mailto:[EMAIL PROTECTED] Sent: July 24, 2003 10:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Line of code should work...

RE: [PHP-DB] Re: dynamic radio buttons.. checked or not? SOLVED

2003-07-24 Thread Aaron Wolski
Well... I actually solved this an hour ago. $query = "select t.id, t.thread_index, t.pattern_index, t.avail, p.id, p.type, p.colour, p.colourID, p.manufacturer FROM kcs_patternthreads t LEFT JOIN kcs_threads p ON t.thread_index = p.id WHERE t.pattern_index = $id"; $thread_manufacturer = '';

RE: [PHP-DB] Line of code should work...but doesn't

2003-07-24 Thread Aaron Wolski
] Sent: July 24, 2003 10:29 AM To: Aaron Wolski Cc: 'J. Michael Roberts'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Line of code should work...but doesn't this may work, but i hesitate, i've _never_ had to use exit to get my code to excecute a redirect. and i'm heavily relia

  1   2   >