Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Stuart Felenstein
--- Jason Wong [EMAIL PROTECTED] wrote: I'm not sure what you mean exactly by intended use checkboxes. Intended use - I generate a list (via a repeat region) of records. Each item on the list has an associated checkbox. If I put a check in the box, do a $_POST I expect on the next page

Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Jason Wong
On Monday 06 December 2004 20:39, Stuart Felenstein wrote: --- Jason Wong [EMAIL PROTECTED] wrote: I'm not sure what you mean exactly by intended use checkboxes. Intended use - I generate a list (via a repeat region) of records. Each item on the list has an associated checkbox. If I put

[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 td/td 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. ?php for ($r=0;$products = db_fetch($productsQuery);$r++) { ? td align=centera href=?php echo $base_url; ?products/?php echo

[PHP-DB] RE: Multi-User Update Problem

2004-12-06 Thread SCALES, Andrew
Thank you everyone who replied to my problem. I have decided now to go with Anna's solution and so far it's working great! So thank you very much for your help Anna. Thanks again, Andy. -Original Message- From: anna w [mailto:[EMAIL PROTECTED] Sent: Wednesday, 01 December 2004 11:17 To:

RE: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-06 Thread Bastien Koert
Post your relevant code and lets have a look. bastien From: Steven \[Offstage\] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Mozilla inserts twice, IE does OK... ? Date: Sun, 5 Dec 2004 23:41:43 +0100 (CET) Hi there, First post to this mailing list, and I have a very strange problem:

RE: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-06 Thread Norland, Martin
Are you using view source a lot? (some of) Mozillas view source commands send the query again, minus the POST vars. This could be the behaviour you're seeing. I say some of because there are multiple ways of viewing the source - web developer toolbar's (extension) doesn't seem to suffer from

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
On Monday 06 December 2004 22:46, Norland, Martin wrote: No, PHP5 does indeed have some new (and different) functions for mysql, but it supports (properly, nothing old about it) the normal mysql functions as well. The change for PHP5 is that it no longer enables mysql functions by default

RE: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Norland, Martin
anyway mysql_connect() won't work in php5 - although I do believe it's possible to compile in the 'old' mysql lib yourself. No, PHP5 does indeed have some new (and different) functions for mysql, but it supports (properly, nothing old about it) the normal mysql functions as well. The change

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

2004-12-06 Thread Bastien Koert
try this ?php for ($r=0;$products = db_fetch($productsQuery);$r++) { if (($r % 2) == 0) { echo /tr tr valign=\top\; } echo td

RE: [PHP-DB] pagination

2004-12-06 Thread Bastien Koert
Newer versions of php user $_POST and $_GET to access form variables...try this if([EMAIL PROTECTED]'start']) $start = 0; bastien From: Valerie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] pagination Date: Sun, 5 Dec 2004 10:19:03 -0500 It shows next and the first 10 records but

RE: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Norland, Martin
AFAIK no version of PHP ever did compile with mysql by default. You *had* to use --with-mysql if you wanted mysql support. The choice was whether to use the bundled library (the default if you didn't specify a directory with --with-mysql) or some other library. snip If this is where you

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
On Monday 06 December 2004 23:54, Norland, Martin wrote: Sorry this got a little toasty, but it sure felt like a blind attack, since the most cursory of checks revealed my statements true. I'm sorry if you felt that that was an attack. Your honour, in my defence, I confess that I haven't

[PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
I'm trying to send mail out based partially on a recordset/binding. The fields are available but I'm not sure if they need to be turned into a variable first or if I can just reference them in the body of the email. Here is what I tried: $to = $rsVendorJobs-Fields('Conmail'); $subject =

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Bastien Koert
I prefer to assign the db values to loca variables to ensure that I am sending out exactly what I need to. Bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] stumped-mail and database Date: Mon, 6 Dec 2004 10:05:57 -0800 (PST) I'm trying to send mail out

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Here is what I tried: $to = $rsVendorJobs-Fields('Conmail'); $subject = $rsVendorJobs-Fields('RefEm'); $body = '$cl'; $headers = From: [EMAIL PROTECTED]; mail($to,$subject,$body,$headers); echo Mail sent to $to;

Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
er, I don't know if it would interest you but here is a class I have been using for ages now (not that I have trouble using mail() for simple jobs) because its simple, packed with functionality and works well: http://phpmailer.sourceforge.net/ the following page hopefully demonstrates how

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Bastien Koert [EMAIL PROTECTED] wrote: I prefer to assign the db values to loca variables to ensure that I am sending out exactly what I need to. Well the binding is one where clause that pulls the correct record for the transaction. Following what you are saying, how does that

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: 1) change $to = $rsVendorJobs-Fields('Conmail'); To $to = {$rsVendorJobs-Fields('Conmail')}; Or just $to = $rsVendorJobs-Fields('Conmail'); 2) change $body = '$cl'; To $body = $cl; Well I'm sure this is not the

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
What is $rsVendorJobs, where is it populated? I assumed, from the way you were using it - that it was a class object with a 'fields' function that returns the value of a column when passed the column name. Which, looking back, seems pretty excessively abstracted :) Is $rsVendorJobs just the

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: What is $rsVendorJobs It's a recordset which for lack of a better definition is a sql query. Is $rsVendorJobs just the result of a mysql_query()? If so, you probably just want to be using: $to = $rsVendorJobs['Conmail']; Nope, though it

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
All I can recommend from here is heavy use of printr() or var_dump() on your variables. $totalRows_rsVendorJobs = $rsVendorJobs-RecordCount(); // end Recordset This clearly means $rsVendorJobs is an object of some sort, probably some custom recordset object as you've said - so your best bet is

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: All I can recommend from here is heavy use of printr() or var_dump() on your variables. They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. Obviously, also, you'll want to print

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. (Bear with me on this, because I've got nothing remaining to go on...) What do you get from:

Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
Stuart Felenstein wrote: --- Norland, Martin [EMAIL PROTECTED] wrote: All I can recommend from here is heavy use of printr() or var_dump() on your variables. They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. be more specific - its

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: (Bear with me on this, because I've got nothing remaining to go on...) What do you get from: var_dump($query_rsVendorJobs); var_dump($totalRows_rsVendorJobs); var_dump($-SelectLimit($query_rsVendorJobs));

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
var_dump($rsVendorJobs); object(kt_adorecordset_mysql)(33) { [dataProvider]= Looks like you're using the ADODB library ( http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or similar. ( That may not be the official site, I just bounced around a bit. ) All your previous code

Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
I just thought, if your query object ($) is returning a resultset object then maybe you have to 'loop' the resultset object in order to retrieve the 'row' object(s) from which you can retrieve the data. your resultset object doesn't have a GetRowAssoc() method? [ defined as