Re: [PHP-DB] Error with addition of second

2004-09-18 Thread randy
omic > > > Agriculture > > > > > > Computers > > > > > > > > > > Also, you shouldn't have all of the radio buttons associated with the > > same variable checked. In fact, if this is a quiz, none should be > > checked

Re: [PHP-DB] MySQL: Problem optimizing multi-table row deletion ... errors out :(

2004-09-13 Thread randy
If the threadID column is an int, you don't need to wrap the $threadID variable in quotes. HTH ~randy On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }- <[EMAIL PROTECTED]> wrote: > hi gang > > I'm working on optimizing the SQL for my forum system, but have run i

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread randy
ll it). $sql = "SELECT * FROM $table"; // works $sql = 'SELECT * FROM '.$table; // works $sql = 'SELECT * FROM $table'; // doesn't work randy -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: This is awesome

2004-09-05 Thread randy
I'm confused. How does this pertain to php-db? Let's keep this shit off the list please. Yours Truely, Randy On Sun, 5 Sep 2004 17:47:15 +0200, Torsten Roehr <[EMAIL PROTECTED]> wrote: > "Theeb Basheer" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL

Re: [PHP-DB] PHP working but now Disobedient

2004-09-01 Thread randy
You can get rid of the open paren in the echo statement. randy On Wed, 1 Sep 2004 10:24:07 -0700 (PDT), Judy Picard <[EMAIL PROTECTED]> wrote: > > --- Judy Picard <[EMAIL PROTECTED]> wrote: > > > Date: Wed, 1 Sep 2004 09:25:08 -0700 (PDT) > > Fr

Re: [PHP-DB] mac and mysql

2004-08-31 Thread randy
l/bin/mysql everytime you want to use the command line). > > Again, please excuse my ignorance, but here is an opp to educate those of us stuck > in a MS POV. Thank you in advance. NP. Hope this helps. > > Michael -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DATABASE Error on form submission

2004-08-30 Thread randy
or die(mysql_error()); > > //create nice message for user > $msg = "The $topic_title topic has been created."; > ?> > > > New Topic Added > > > New Topic Added > > > > - > Form code > -- > > include 'menufile.php'; > ?> > > > Add a Topic > > > Add a Topic > > Your E-Mail Address: > > Topic Title: > > Post Text: > > > > > > -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB]different heading

2004-08-19 Thread randy
--- > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-db > -- > /* > Left to themselves, things tend to go from bad to worse. > */ > > > > -- > PHP Database

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread randy
7;t know how to enter in LF or > > CR in a vim search string. > > > > Hope this clarifies. > > > > -- > > Michael Cortes > Fort LeBoeuf School District > 34 East Ninth Street > PO Box 810 > Waterford PA 16441-0810 > 814.796.4795 > >

Re: [PHP-DB] Re: MySQL denying access to everything

2004-08-18 Thread randy
Lgui.exe, it still gives me the same problem... > -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Check Boxes

2004-08-18 Thread randy
yeah yeah...it's damn near 4 in the morning here...my brain isn't exactly on at the moment. :) On Wed, 18 Aug 2004 11:35:59 +0100, Ford, Mike [LSS] <[EMAIL PROTECTED]> wrote: > On 18 August 2004 11:24, randy wrote: > > > $chkboxes = $_POST['ch

Re: [PHP-DB] Check Boxes

2004-08-18 Thread randy
t; > > How about showing us some code kind of hard to help without that... > > -- > > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > php|architect: The Magazine for PHP Professionals â www.phparch.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL to EXCEL?

2004-08-17 Thread randy
ne formed incorrectly for an XLS file, can anyone see if > I need to use any special characters rather than a comma? > > fwrite($filesession,"$id,$new,$recno,$category,$product,$description,$unit,$ > certificate,$instock,$orderpt,$ordernow,$vendor,$unitcost,$unitsell\015\012"

Re: [PHP-DB] MAILING LIST QUESTION

2004-08-16 Thread randy
called if an assertion fails. > ;assert.callback = 0 > > ; Eval the expression with current error_reporting(). Set to true if you want > ; error_reporting(0) around the eval(). > ;assert.quiet_eval = 0 > > [Ingres II] > ; Allow or prevent persistent links. > ingres.al

Re: AW: [PHP-DB] Re: Subject: LOAD DATA LOCAL INFILE

2004-08-16 Thread randy
t find a solution to get it work. > >> > >>Is there way to get it work? > >> > >>Regards > >>Dani > > > CaptionKit http://www.captionkit.com : Production tools > for accessible subtitled in

Re: [PHP-DB] Multiple word queries

2004-06-30 Thread Randy C Boland
By Shiloh's description, I think you want to replace AND with OR - using AND will only return rows that contains every word, while using OR will match any row that has any of them. On Wed, 30 Jun 2004 23:22:04 -0400, John W. Holmes <[EMAIL PROTECTED]> wrote: > For that simple example, you can just

Re: [PHP-DB] Re: MySQL executes several times the same request

2004-06-30 Thread Randy C Boland
I'm not sure where the value of $counter is coming from, but it you're getting it from a SQL SELECT query, it would be more efficient to just use: UPDATE statistics SET VALUE(`counter` = `counter`+1) It's just one less query on the DB, which could make a difference if you're getting heavy traffic.

[PHP-DB] International Addresses and Telephones

2003-12-04 Thread Rankin, Randy
I have a form which captures US addresses ( address, city, state ) and telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I need to expand this to capture non-US info, so I was hoping for some guidance on forms and table structures. I have googled this to death and still have

[PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread Rankin, Randy
'textually', but he is _determined_ that he must have the graphic 'drag and drop' feature. There may be another method ( Javascript ? ) to accomplish the same effect. I am certainly open to any advice and/or opinions. Any pointers would be _greatly_ appreciated. Thanks, Randy Rankin

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-05 Thread Rankin, Randy
ALUES ($tmp, $td )"; Randy -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Datetime help in an INSERT... If you are using MySql with the date field is of type timestamp, you s

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-05 Thread Rankin, Randy
If you are using MySql with the date field is of type timestamp, you should have to insert anything using the query. It will update automatically when the record is inserted and/or updated. ie; $denylog = "INSERT INTO deny (account, td ) VALUES ($tmp, $td )"; Randy -Origin

Re: [PHP-DB] Generating view of tree?

2003-03-27 Thread Randy
t3!=$row['cat3']) { $indent="3-"; $cat3=$row['cat3']; echo "$indent $cat3"; } } Hope that helps. -- Best regards, Randy Wednesday, March 26, 2003, 8:18:50 PM, you wrote: > I have a table with

RE: [PHP-DB] Help with MySQL Logic

2003-03-04 Thread Rankin, Randy
Thanks to everyone for your help. I was able to work out the logic last night based on your fine suggestions and all is well! Thanks again. Randy > -Original Message- > From: "1LT John W. Holmes" <[EMAIL PROTECTED]> > Sent: Monday, March 03, 200

[PHP-DB] Help with MySQL Logic

2003-03-03 Thread Rankin, Randy
remaining cars, originally numbered 1-29 would become 2-30. I hope I explained thourougly. Any suggestions would be appreciated. Randy

Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-29 Thread Randy Phillips
store the first id? When would you want that? ------ Randy Phillips www.phillips-it.com phillipsIT, L.L.C. voice: 636.390.9468 Senior Web Developer

[PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-28 Thread Randy Phillips
a single insert statement, or does it matter? -- Randy Phillips www.phillips-it.com phillipsIT, L.L.C. voice: 636.390.9468 Senio

[PHP-DB] Looking for Beta testers

2003-01-07 Thread Randy Phillips
. Thanks, -- Randy Phillips www.phillips-it.com phillipsIT Voice: 636.390.9468 Senior Web DevelopereFax: 501.423.3817

RE: [PHP-DB] Broken Links 2

2002-10-24 Thread Rankin, Randy
be great to hear from you. Thanks again for all your help! Randy - BEGIN CODE -- image_bin_data; $new_w=75; $new_h=75; Header("Content-type: image/png"); $src_img=@ImageCreateFromString($image); $dst_img=@ImageCreate($new_w, $new_h); ImageCopyResample

RE: [PHP-DB] First record of array not being echoed

2002-10-14 Thread Rankin, Randy
Thanks Marco! It's working now. Based on your suggestion, here is waht I came up with. It's working now. Randy SNIP  Tra

[PHP-DB] First record of array not being echoed

2002-10-14 Thread Rankin, Randy
first record of each array is not being echoed. If I run the query in MySQL, all rows are returned, so it must just be something I am not seeing in the code (which is posted below). Thanks in advance for any help. Randy -- START EXAMPLE

[PHP-DB] Confused

2002-09-23 Thread Rankin, Randy
group based on the group_id? How would I loop through to create a table for each group? Thanks inadvance for any help. Randy Rankin

[PHP-DB] Date Concat?

2002-09-20 Thread Rankin, Randy
te FROM training This produces the following: start_date: September 16, 2002 end_date: Sepetember 20, 2001 Based on the above, I would like to echo out something like this: You will be in training September 16 - 20, 2002. Is this possible? Th

RE: [PHP-DB] redirect a page

2002-04-24 Thread Rankin, Randy
Nato, Try something like this: $num = mysql_numrows($result); if ($num == 0) { echo "There were no records found."; } else while ... -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 11

RE: [PHP-DB] Determine last quarter

2002-03-20 Thread Rankin, Randy
If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) "; echo "End of Period: $period_last_day"; ?> -Original Message----- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:57

[PHP-DB] Determine last quarter

2002-03-19 Thread Rankin, Randy
I am trying to determine these dates for a report that generates previous quarter sales based on today (whatever 'today' might be). Hope that's clear. Thanks in advance, Randy Rankin

RE: [PHP-DB] increase date()

2002-03-18 Thread Rankin, Randy
Try this: $six_months_from_now = date("Y-m-d", mktime(0,0,0, date(m)+6, date(1), date(Y))); echo "Six Months From Now: $six_months_from_now"; -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] increase

RE: [PHP-DB] creating a drop down menu from mysql categories

2002-03-14 Thread Rankin, Randy
]"; } ?> ----- Randy -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 6:47 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] creating a drop down menu from mysql categories Hello everyone, I am a little new to the list. I have been reading a lot of t

[PHP-DB] Dynamic Drop Down Box

2002-03-05 Thread Rankin, Randy
ox. Based on the user selection, the 2nd drop down box would be populated with the distinct 'make' for that model (ie; if the user selects Ford in the first drop down, the 2nd drop down would be populated with Explorer, Expedition, Ranger, etc.). Thanks, Randy Rankin

[PHP-DB] Dynamic Table Columns

2002-02-18 Thread Rankin, Randy
| $100 | $200 | $300 | $300 | $300 | $300 | $300 | Widget 2 | $300 | $200 | $500 | $300 | $300 | $300 | $300 | . . . I have posted order_summary.php below. Any thoughts? Thanks, Randy Rankin order_summary.php

RE: [PHP-DB] First and Last Record Query

2002-02-13 Thread Rankin, Randy
>> Why are you iterating through the array? Inexperience. Thanks for the help guys. I'll give it a try. Randy -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:43 AM To: 'David Fudge'; [EMAIL PROTECTED] Subjec

[PHP-DB] First and Last Record Query

2002-02-13 Thread Rankin, Randy
uld like to grab the first and last record in the array so that the final result would be to echo something like "This report is from $start_period through $end_period". Hope that makes sense ... Thanks in advance for any help. Randy Rankin

RE: [PHP-DB] OCI Query Results

2001-12-12 Thread Rankin, Randy
Nevermind, I figured it out. There was a duplicate OCIfetchinto statement in the script. Randy -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:12 AM To: PHP List Cc: Barker, John Subject: [PHP-DB] OCI Query Results We are using

[PHP-DB] OCI Query Results

2001-12-12 Thread Rankin, Randy
in the result set. Does anyone have any thoughts. I can post code sample if needed. Randy

[PHP-DB] PHP/MySQl Consultation

2001-08-24 Thread Randy Johnson
I am in need of someone that is very good at PHP and MySQL to view my scripts and discuss with me in detail on how to speed up my scripts and how to speed up mysql some. if you are interested please send me credentials and rates ASAP please send them to [EMAIL PROTECTED] Thank you, Randy

RE: [PHP-DB] Connection to Oracle8i

2001-08-16 Thread Rankin, Randy
of a connect script that I run using OCI calls: <% $connection = OCILogon ("user","pass","sid"); if ($connection == false) {echo OCIError($connection).""; exit; } OCILogoff ($connection); %> Hope that helps,

RE: [PHP-DB] OCI support not functioning

2001-08-07 Thread Rankin, Randy
Did you install the Oracle client? -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] OCI support not functioning Hi folks. I posted on the install board but I figured I would run this by the gu

[PHP-DB] Query on Oracle Views

2001-08-06 Thread Rankin, Randy
ecute a query with a table name like v$instance? TIA, Randy Rankin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

php-db@lists.php.net

2001-07-13 Thread Rankin, Randy
again everybody!! Randy Rankin -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 10:27 PM To: Rankin, Randy; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Escaping & Please explain the dynamic link . is that in the documentation somewhere>

php-db@lists.php.net

2001-07-12 Thread Rankin, Randy
und for X" where X is the letter immediately preceding the ampersand. Does anyone know how to get around this? TIA, Randy Rankin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

RE: [PHP-DB] odbc with ms access

2001-05-22 Thread Rankin, Randy
http://www.microsoft.com/KB/Articles/Q128/8/08.HTM -Original Message- From: Dalyyla [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] odbc with ms access hi, Access to data with ms access via odbc is kinda slow . I would like to kn

[PHP-DB] No MySQL-Link resource supplied

2001-05-10 Thread Rankin, Randy
. Thanks in advance, Randy Rankin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Variable Assignment

2001-05-02 Thread Rankin, Randy
to do is assign the results of the field real_name to a variable called $salesperson, but I cannot seem to get it to work. Thanks inadvance for your help, Randy Rankin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mai

RE: [PHP-DB] PHP On Linux

2001-04-20 Thread Rankin, Randy
Try this: http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/ Randy Rankin Ben Cairns wrote: > > I have nearly 18 Months devel on Windows, but we are now moving to Linux, > > I have never installed PHP On Linux before, so could someone pls give me an > 'Installat

[PHP-DB] RE: Doing multiple updates

2001-01-30 Thread Randy Johnson
Does the Connection ID change if I use persistent connection through PHP using mysql_pconnect()? Is it possible to retrieve CONNECTION_ID() this though PHP? -Original Message- From: The Tilghman [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:31 PM To: 'Randy Jo

[PHP-DB] query error

2001-01-25 Thread Randy Johnson
When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

[PHP-DB] Username/Password retrieval

2001-01-12 Thread Randy Johnson
uestion is will result be equal to "" if the query statement doesn't return any data? thanks randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]