Re: [PHP-DB] A real question this time...

2002-07-05 Thread John Coder
On Fri, 2002-07-05 at 14:43, NIPP, SCOTT V (SBCSI) wrote: > > mysql_select_db($database, $Test); > $query_SA = "SELECT sbcuid FROM contacts_sa"; > $SA = mysql_query($query_SA, $Test) or die(mysql_error()); > $PASS = $SA; I think here is your problem you have the select element name pass just

[Fwd: Re: [PHP-DB] Having more problems]

2002-07-07 Thread John Coder
--- Begin Message --- On Sun, 2002-07-07 at 01:07, Shiloh Madsen wrote: > The newbie is still having troubles heh. Maybe some kind soul can tell > me what im doing wrong this time. This is the code for a page I am > working on. When I try to bring up the page in a browser, I just get a white

Re: [PHP-DB] PHP4/mssql_query INSERT problems

2002-07-15 Thread John Coder
On Mon, 2002-07-15 at 21:01, Salve Tinkerworth wrote: > Why do I keep getting messages like: > > INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory) > VALUES (463,'In and Out','','') > Warning: MS SQL message: Line 1: Incorrect syntax near '463'. (severity 15) > in c:\inetpub\w

Re: [PHP-DB] oddity with insert multiple input fields to multipletables

2002-08-17 Thread John Coder
On Sat, 2002-08-17 at 17:08, Chip Wiegand wrote: > I have a web page interface to a mysql database. In this web page I have > about a dozen form input fields. On submit these are submitted to > multiple tables, a differant table for each input field. If I leave any > fields blank, and insert only

Re: [PHP-DB] oddity with insert multiple input fields tomultipletables

2002-08-18 Thread John Coder
On Sun, 2002-08-18 at 21:21, Chip Wiegand wrote: > On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote: > > > if (!isnull($date_am || $exercise_am || $reps_am)) then > > > mysql_query($sql_am) or die > > > ("Error in this query >>$sql<< : " .mysql_error()); > > > > Try: > > > > if(!isnull($date_am)

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread John Coder
On Mon, 2002-08-26 at 13:25, Gerd Ulrich wrote: > Hello, I want to build a questionaire where the user is guided through five > pages of questions. How can I program PHP that the user gets to the second > page after pushing the "Submit"-Button? > My solution printed here doesn't work. > Any hints

[PHP-DB] Re: {PHP-DB] how to display tree structure from database

2002-08-28 Thread John Coder
>> Original Message << On 8/28/2002, 9:04:27 PM, Pierre-Alain Joye <[EMAIL PROTECTED]> wrote regarding Re: [PHP-DB] how to display tree structure from database???: > On Wed, 28 Aug 2002 18:02:09 -0700 > "leo g. divinagracia iii" <[EMAIL PROTECTED]> wrote: > > a

RE: [PHP-DB] how to display tree structure from database

2002-08-28 Thread John Coder
>> Original Message << On 8/28/2002, 9:04:27 PM, Pierre-Alain Joye <[EMAIL PROTECTED]> wrote regarding Re: [PHP-DB] how to display tree structure from database???: > On Wed, 28 Aug 2002 18:02:09 -0700 > "leo g. divinagracia iii" <[EMAIL PROTECTED]> wrote: > > a

[PHP-DB] incrememnting an array

2002-09-19 Thread John Coder
are for the values of the angles for the pie chart on imagefilledarc(). And for the life of me I can't figure out how to do it. any help would be greatly appreciated John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] incrememnting an array

2002-09-20 Thread John Coder
20) think of angle and ) being the beginning 23 being the end then 23 being the begging of an angle haveing 2 degress so I need it to go to 25 and so forth. hope this explains it better. > - Original Message - > From: "John Coder" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTE

Re: [PHP-DB] SQL file,

2002-09-21 Thread John Coder
from the mysql invoked by ? while in the mysql client the command \. is what you use. the blurb after is "Execute a SQL script file. Takes a file name as an argument. Dump a file with phpMyAdmin you get a sql file. at least in Windows you do so I assume you do in non windows OS'es also. John On

Re: [PHP-DB] incrememnting an array

2002-09-24 Thread John Coder
On Fri, 2002-09-20 at 16:49, John Coder wrote: > On Fri, 2002-09-20 at 05:41, Martin Adler wrote: > > > > I hope the little script bellow helps you > > > > greet > > Martin > > > > > $arr = array('a','b','c',&#x

Re: [PHP-DB] export to csv file

2002-09-28 Thread John Coder
you have to watch the permissions on the file it sounds like that is the problem . perhaps add yourself to the mysql group if the file has group permissions. the last is just a thought. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pedigree question

2002-10-06 Thread John Coder
at his site which is www.Koffler.cc I beleive. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] string

2002-10-31 Thread John Coder
x27;t work. I'm at a loss here I can't find the correct string function for this. help would be greatly appreciated. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] string

2002-10-31 Thread John Coder
gt; > SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename > > from memory > > HTH > > beau > > // -Original Message- > // From: John Coder [mailto:jcoder@;insightbb.com] > // Sent: Friday, 1 November 2002 9:47 AM > // To: [EMAIL PROTECTE

Re: [PHP-DB] mysql_connect problem rh7.3

2002-11-02 Thread John Coder
While Micah is correct, you do have mysql support on php but as a dbs not the built in php fuctions. Therefore you must use the dbx functions instead. John Coder On Sat, 2002-11-02 at 14:35, Micah Stevens wrote: > > It doesn't appear you have the PHP MySQL functions installed. W

[PHP-DB] boolean instead of array

2002-11-02 Thread John Coder
| name| +-+ | BodyWatch | | BreakThroughGallery | | TempGallery | | KidZone | | Lobby | +-+ 5 rows in set (0.01 sec) here's the output from the browser: Resource id #3 boolean array array array array array Any

[PHP-DB] boolean instead of array update

2002-11-02 Thread John Coder
the deptid in both Tmp and picdata are the same so it nakes no diff which I use the output is the same Boolean each time I just noticed that the tables were diff names but data and structure is the same. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.

Re: [PHP-DB] boolean instead of array

2002-11-03 Thread John Coder
On Sun, 2002-11-03 at 01:44, Jason Wong wrote: > On Sunday 03 November 2002 10:23, John Coder wrote: > > I seem to somehow get an boolean instead of an array from a > > mysql_fetch_row function and I have no idea how. > > Here's the code; > > Try adding some er

Re: [PHP-DB] boolean instead of array

2002-11-03 Thread John Coder
On Sun, 2002-11-03 at 15:01, Jason Wong wrote: > On Sunday 03 November 2002 20:58, John Coder wrote: > > > Try adding some error checking into your code (see manual examples) and > > > using mysql_error() to find out what's going. > > > > What error checking

Re: [PHP-DB] foreach loop from MySQL select query to HTML selectlist

2002-11-27 Thread John Coder
h_array($result); > foreach ($row as $value) {echo " value=\"$value\">$value\n";} > ?> > Put your mysql_close here if you want to close it. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] a newbie in deep need for help

2002-12-27 Thread John Coder
On Fri, 2002-12-27 at 04:19, Ehab El Maraghy wrote: > Hi everybody > I have installed php4 and mysql on IIs winxp > I am trying to retrieve a password and print it using a query which is > written as followos > > $query2 = "select passwd from user where username = '$username'"; > $result = mysql_r

RE: [PHP-DB] image size

2002-12-27 Thread John Coder
manual/en/function.getimagesize.php John Coder Thanks, Petre NICOARA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Drawing chart

2003-01-01 Thread John Coder
in a database? I've already reinvented the wheel and it's at http://www.php.net/manual/en/function.imagefilledarc.php in the user comment section. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Drawing chart

2003-01-01 Thread John Coder
On Wed, 2003-01-01 at 21:37, John Coder wrote: > On Wed, 2003-01-01 at 18:27, Matthias Steiner wrote: > > I'd like to have PHP drawing a chart based on temperature data in a mySQL > > database. > > > > Before I start inventing the wheel: does anybody know about fi

[PHP-DB] array question

2003-06-02 Thread John Coder
) [3] => Array ( [0] => Completed [1] => In Progress [2] => Deferred ) Hope this makes sense John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Clueless abt Error with MySql

2003-09-08 Thread John Coder
t should take care of that prob. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php