[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 -

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??=session_name().'='.session_id()? Would produce something that looks like: index.php?123455667784332 What I think you WANT to do is...

[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

[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.

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 type

[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].' br'; } -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

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

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

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.

[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

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] Add

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

[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.

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 11:55 AM

[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
AND dateinserted='1036386000' AND dateinserted='1036502796' AND ( order_status='Shipped' OR order_status='Not Shipped' ) HTH Ignatius J. Reilly - Original Message - From: Aaron Wolski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday

[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
else. *shrugs* I think I wma way off base here *eyes blurry* heeh Aaron -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 sure you

[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: form name=form action=process_bank.php method=POST input type=hidden name=order_index[0] value=1 td class=cartlink

[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: input type=checkbox name=delete[] value=$row[id] These are for different records in my DB. Now... I want

[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. To

[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

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

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

[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

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 can skip a step like

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

2002-11-15 Thread Aaron Wolski
Message- From: Jason Vincent [mailto:jayv;nortelnetworks.com] Sent: November 15, 2002 8:51 AM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB] serious help with linking data together... you haven't really said what the problem is - but this is what I can see... Functions like COUNT

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: HTML HEAD /HEAD link rel=stylesheet href=styles.css type=text/css BODY table border=0 cellpadding=0 cellspacing=0 width=600 tr valign=top tdimg src=Graphics/spacer.gif width=350 height=1/td

[PHP-DB] Email Encryption?

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

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:aaronjw

RE: [PHP-DB] Email Encryption?

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

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 the login

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' log into a secure

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: 'Jason

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

RE: [PHP-DB] date()

2002-11-18 Thread Aaron Wolski
: [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, $myrow[datefield]); Will produce: 11:13:02

RE: [PHP-DB] date()

2002-11-18 Thread Aaron Wolski
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:[EMAIL PROTECTED

RE: [PHP-DB] Email Encryption?

2002-11-19 Thread Aaron Wolski
: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 'secret key'. -Original Message- From: Aaron Wolski

[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***

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 = INSERT

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

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 models

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

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

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,

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

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: Hellobrbr My name isbrbr Aaronbrbr In your HTML code which then would output in

[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

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

[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

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

2003-02-04 Thread Aaron Wolski
,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 -Original

[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

[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
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 for empty array from a form field? grrr

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

2003-02-05 Thread Aaron Wolski
://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- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 4:53 PM To: 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB

[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: select name=province[] class=selectcontent size=3 multiple   option value=  

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 :

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

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

[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..SOLVED

2003-06-26 Thread Aaron Wolski
[mailto:[EMAIL PROTECTED] Sent: 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

[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
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 work for you? http://www.mysql.com/doc/en

[PHP-DB] formating results in seperate tables?

2003-07-08 Thread Aaron Wolski
Hi All, Having some issues with the code below: ?php } ? tr valign=top ?php $col = explode(,,$threadsColumn); $col_search = (; for

[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 thread

[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? form action=insert_threads_patterns.php method=POST tr td class=adminthreadsDisplayHeader align=centerSelected?/td td class=adminthreadsDisplayHeader

[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: ?php $manufQuery = db_query(SELECT manufacturer FROM kcs_threads); while ($manufResults =

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

2003-07-21 Thread Aaron Wolski
to 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: Re: [PHP-DB

[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;

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

2003-07-21 Thread Aaron Wolski
. *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 name/header out

[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

[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:

[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...but

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

2003-07-24 Thread Aaron Wolski
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 reliant on this function. did aarons fix work

[PHP-DB] query and display acting weird...

2003-07-25 Thread Aaron Wolski
Hi Guys, Code: echo select name=\patternThreads[]\ size=\10\ multiple style=\font-family:monospace;\\n; $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 =

RE: [PHP-DB] how to get records from one table that are not in another table

2003-07-27 Thread Aaron Wolski
I'd suggest you pick up an SQL book or do some more reading if you don't understand that. -- ---John Holmes... John, Do you have a good book recommendation for MySQL.. I'm looking for more knowledge on improving my queries, etc. LEFT JOINS were completely unfamiliar (still are) until you

[PHP-DB] alphabetical sorting... limiting and paginating on next set of letter group

2003-07-29 Thread Aaron Wolski
Hi Guys, Rather long topic I know. Sorry if it annoyed anyone. Hopefully someone can help here with the logic on this. I have a query where I am getting one column (designers) in a Table, ordered alphabetically. Right now.. this query is displaying EVERY distinct result (45 in total). This

RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group

2003-07-30 Thread Aaron Wolski
Message- From: Ramil G. Sagum [mailto:[EMAIL PROTECTED] Sent: July 29, 2003 11:38 PM To: [EMAIL PROTECTED] Cc: Aaron Wolski Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote: Hey, Thanks

RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group

2003-07-30 Thread Aaron Wolski
Sorry all but getting kinda desparate here :( Trying a few different things and still nothing seems to work. Does anyone have a kick in the right direction that I could explore here? Sorry for the repost. Thanks Aaron -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED

RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!

2003-07-31 Thread Aaron Wolski
? http://us4.php.net/manual/en/function.urldecode.php -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 3:14 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] updating a column based on info from another coluimn? Desperate! Hi All

[PHP-DB] Regular Expressions? URGENT

2003-08-01 Thread Aaron Wolski
Hi All, Sorry for OT post but need some info. Does anyone know a good tutorial that explains regular expressions in DUMMY terms? I have a list of characters that I need to check to see if they are in a string. I tried creating an array of the characters but some of them are like ' and `

[PHP-DB] query works fine on console but not with PHP - why?

2003-08-03 Thread Aaron Wolski
Hi guys, I have the following query which returns FINE through the console but not in PHP select t.id, t.colour, t.colourID, t.price, t.type, g.thread_index, g.groupNameUrl FROM kcs_threads t LEFT JOIN kcs_threadgroups g ON t.id = g.thread_index WHERE g.groupNameUrl = '0-500' The error I

RE: [PHP-DB] query works fine on console but not with PHP - why? SOLVED

2003-08-03 Thread Aaron Wolski
-Original Message- From: Matt [mailto:[EMAIL PROTECTED] Sent: August 3, 2003 10:11 AM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] query works fine on console but not with PHP - why? - Original Message - From: Aaron Wolski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday

[PHP-DB] ***SOLVED *** query works fine on console but not with PHP ***SOLVED***

2003-08-03 Thread Aaron Wolski
in future debugging. Thanks again to all. Aaron -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED] Sent: August 3, 2003 10:08 AM To: 'Matt'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] query works fine on console but not with PHP - why? SOLVED Hi and thanks, Actually

[PHP-DB] make 2 queries into one?

2003-08-03 Thread Aaron Wolski
Hi All, Been trying to come up with a way to make the following queries into one which would speed up the processing I think. Code: $mQuery = db_query(SELECT manufacturer FROM kcs_threads GROUP BY manufacturer ORDER BY manufacturer); while ($mResult = db_fetch($mQuery)) {

RE: [PHP-DB] RE: query is returning over 74,000 results and taking 30 seconds - HELP!

2003-08-04 Thread Aaron Wolski
Ok.. I echo'd out the queries AND the num_rows returned for each loop and this is what I got: Manufacturer Query is: SELECT DISTINCT manufacturer FROM kcs_threads ORDER BY manufacturer Manufacturer Rows Returned Are: 5 Left Join Query is: select t.type, t.newUrlType, g.threadType,

  1   2   >