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

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

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

[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] 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] Receiving a warning... no clue how to resolve it and need help badly :(

2003-11-27 Thread Aaron Wolski
Hi Guys, I need help with this code I am about to paste. It works on a testing server running PHP 4.2.2 but not 4.3.2 Here is the error: Warning: array_merge_recursive(): recursion detected in /services2/webpages/r/i/rinkrake.com/public/test.php on line 26 Here is the code: "; // Allow th

RE: [PHP-DB] Unsure of how to perform query and results..

2003-11-21 Thread Aaron Wolski
n W. Holmes [mailto:[EMAIL PROTECTED] > Sent: November 20, 2003 4:34 PM > To: Aaron Wolski; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Unsure of how to perform query and results.. > > From: "Aaron Wolski" <[EMAIL PROTECTED]> > > > I have data in a Db that looks some

[PHP-DB] Unsure of how to perform query and results..

2003-11-20 Thread Aaron Wolski
Hi Guys, I have data in a Db that looks something like: 14,[EMAIL PROTECTED],Andrew,Smith 1,[EMAIL PROTECTED],Andrew,Smith 14,[EMAIL PROTECTED],Barbara,Richardson 1,[EMAIL PROTECTED],Barbara,Richardson The number represents a product_id that was purchased by the customer in question. As you c

RE: [PHP-DB] Current page url

2003-11-19 Thread Aaron Wolski
$_SERVER['PHP_SELF'] http://ca.php.net/reserved.variables There are many others you could use as well. HTH Aaron > -Original Message- > From: Hugh Dickinson [mailto:[EMAIL PROTECTED] > Sent: November 19, 2003 7:34 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Current page url > > is

RE: [PHP-DB] Upload multiple files?

2003-08-29 Thread Aaron Wolski
The other option is... You create a pop-up menu system. That have the file form field to select from a location. When you upload the image it populates a HTML display table so you can see it and also allows you to select another image. When you are done.. you close the pop-up menu and that's th

RE: [PHP-DB] Upload multiple files?

2003-08-29 Thread Aaron Wolski
Well... Having never done this I would assume it's the same with and form field you want to use as an array (multiple selections). Create a few different fileselect fields all with the same name but adding in [] to make it an array. Then just loop through the array.. copying the file to the serv

[PHP-DB] Heop someone can help with this.. involves sessions.

2003-08-28 Thread Aaron Wolski
Hi Guys, I really hope you don't mind the OT post but I've looked everywhere and can't seem to find a solution to my problem. I am passing a var in a session (not in the URL) to my secure checkout area and it's not capturing the variable. I know there is a problem with using sessions across n

[PHP-DB] timestamp formatting on display?

2003-08-26 Thread Aaron Wolski
Hi All, Having a brain laps and not sure where in the manual to look and sadly I need a QUICK solution. I have a date formatted in a table like: 20030826132457 Now.. I went to MySQL timestamp from UNIX timestamps because I like the readability of them when just looking at the Tables. How woul

RE: [PHP-DB] Returning Results

2003-08-19 Thread Aaron Wolski
Hi Richard, When you submit the form, why not have a hidden field in the form like: Then use that 'backtopage' variable in your script where you direct the results to. Or.. if you don't want to use a hidden field.. parse the URL to get the referrer? HTH Aaron > -Original Message- >

RE: [PHP-DB] array issue

2003-08-17 Thread Aaron Wolski
tion system not seen by many users. Aaron > -Original Message- > From: OpenSource [mailto:[EMAIL PROTECTED] > Sent: August 17, 2003 12:28 PM > To: Aaron Wolski > Cc: PHP-DB; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] array issue > Importance: High > > Hey guys

RE: [PHP-DB] array issue

2003-08-17 Thread Aaron Wolski
y too? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: August 17, 2003 11:48 AM > To: Aaron Wolski > Cc: 'PHP-DB'; 'OpenSource' > Subject: RE: [PHP-DB] array issue > > > This may or may not make sense for your iss

RE: [PHP-DB] array issue

2003-08-17 Thread Aaron Wolski
First, are you sure there is data in $my_array? Add this after you set the array: echo """.print_r($my_array).""; You'll need to loop through the array , writing each line in the file at a time. Something like: //open the file stuff here foreach ($my_array AS $values) { fputs($fp, $va

[PHP-DB] incrementor in loop is not incrementing.. any thoughts?

2003-08-14 Thread Aaron Wolski
301 0 304 0 326 0 333 0 211 0 223 0 224 0 225 0 356 0 95 0 100HL 0 102 0 Obviously $z is not incrementing. ANY clue why? Thanks! Aaron Aaron Wolski, Project Manager Martek Business Solutions Inc. www.martekbiz.com <http://www.martekbiz.com/> 905-780-9574 [EMAIL PROTECTED]

RE: [PHP-DB] Don't know why query works this way

2003-08-14 Thread Aaron Wolski
--Original Message- From: Adam Alkins [mailto:[EMAIL PROTECTED] Sent: August 6, 2003 8:16 AM To: Aaron Wolski Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Don't know why query works this way Quoting Aaron Wolski <[EMAIL PROTECTED]>: > Here's some functions I use in my devel

RE: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-14 Thread Aaron Wolski
tand it as much as possible *shrugs* Aaron -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: August 5, 2003 9:08 AM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] displaying result across 3 cells - where did I go wrong? From: "Aaron Wolski&quo

RE: [PHP-DB] incrementor in loop is not incrementing.. any thoughts?

2003-08-14 Thread Aaron Wolski
Sent: August 5, 2003 10:02 AM To: Aaron Wolski Subject: RE: [PHP-DB] incrementor in loop is not incrementing.. any thoughts? Is that a copy/paste? You're showing newlines which I don't see in the pasted code ... > -----Original Message- > From: Aaron Wolski [mailto:[EMAIL PR

RE: [PHP-DB] Don't know why query works this way

2003-08-14 Thread Aaron Wolski
Here's some functions I use in my development which save on connect and query calls for me. //General Purpose Utilities. //db_connect connects to the database server and selects the proper database. //Arguments: None //Returns: Nothing function db_connect() { mysql_pconnect("localhost",

RE: [PHP-DB] Sorting issue

2003-08-09 Thread Aaron Wolski
Seeing code might help us. Aaron > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: August 8, 2003 10:44 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Sorting issue > > Why would a mysql db think that 55 was greater than 14000. > > I have several headings that display

RE: [PHP-DB] looping code

2003-08-06 Thread Aaron Wolski
>From what I can see is that you're not actually looping anything? while( !$done ) { $row = mysql_fetch_row( $result ); if( !$row ) { $done = 1; } This doesn't loop through your query, least not in my eyes it doesn't. Why not: while ($rows = mysql_fetch_array

RE: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Aaron Wolski
UNIQUE gradient (gradient) This is causing your issue. You have stated that new records cannot match an already established record with the same name under gradient. HTH Aaron -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: August 5, 2003 1:44 PM To: [EMAIL PROTECTED] Sub

[PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread Aaron Wolski
Hi All, I'm trying to display results across 3 cells - for example: #5 Perle Cotton 223 | 225 | 301 304 | 326 | 333 #12 Perle Cotton 211 | 223 | 224 225 | 356 | #4 Braid 95 | 100HL | 102 Right NOW it is displaying like: #5 Perle Cotton 223 | 225 301 | 304| 326 #12 Perl

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, g.groupNam

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

2003-08-04 Thread Aaron Wolski
Hi Guys, I've tried several different things with the following 2 queries but nothing seem to help. I've stared at the code and reworked it for hours on end and frankly I am getting frustrated. I'm only posting the queries themselves without the PHP code as the entire section is quite long. If

RE: [PHP-DB] Renaming .htm pages to .php

2003-08-03 Thread Aaron Wolski
Same here. I get it all the time. Aaron -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: August 3, 2003 10:53 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Renaming .htm pages to .php Thanks for all the tips. Incidentally, I just noticed that I'm getting e-mai

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

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

2003-08-03 Thread Aaron Wolski
help me 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

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

2003-08-03 Thread Aaron Wolski
ts! Aaron -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

[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

[PHP-DB] problems getting results displaying correctly

2003-08-01 Thread Aaron Wolski
Hi All, I'm trying to get some code to display like: Manufacturer 1 Type 1 Type 2 Type 3 Manufacturer 2 Type 1 Type 2 Type 3 Manufacter 3 Type 1 Type 2 Type 3 My code is: {$manufResult ['manufacturer']}";

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

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

2003-07-31 Thread Aaron Wolski
hing in the database? 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 > anothe

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

2003-07-31 Thread Aaron Wolski
Hi All, This is OT but I am in need of serious help. I am rewriting URL's for a site and came across an issue with spaces in URLS having %20 applied to them. I can't seem to find a solution with mod_rewrite to get rid of the %20 and replace with - (hyphen) so I am hoping someone can help me her

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] alphabetical sorting... limiting and paginating onnext set of letter group

2003-07-30 Thread Aaron Wolski
s Family Tree The Fanci That Full Circle Designs G-J J-M M-P P-S S-V V-Y Y-Z I've tried a few placements of the foreach loop but nothing seems to work. Any ideas? Thanks! -Original Message- From: Ramil G. Sagum [mailto:[EMAIL PROTECTED] Sent: July 29, 2003 11:38 PM To: [EMAIL PR

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

[PHP-DB] query, display and grouping.. one way works but not another

2003-07-26 Thread Aaron Wolski
Hi Guys, Have a multiple select box. I'm trying to group columns and display records under their paired groupings. Code: echo "\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

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

2003-07-25 Thread Aaron Wolski
As usual. John knows best. Thanks! Aaron -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: July 25, 2003 3:05 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] query and display acting weird... Probably need: ORDER BY t.manufacturer, t.colourID

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

2003-07-25 Thread Aaron Wolski
Hi Guys, Code: echo "\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 = '$id' OR p.pattern_index IS NULL ORDER BY t.colourID"; $thread_manufacturer

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

2003-07-24 Thread Aaron Wolski
EMAIL PROTECTED] > Sent: Thursday, 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

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

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

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

[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

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

[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] 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] 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++) { ?>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  1   2   >