[PHP-DB] Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1,1 in FreeBSD ports will Failed!

2009-03-26 Thread James Chang
Dear Sir, I'm running almost 300 boxes of FreeBSD with PHP 5.2.9 as my Web Application front-end. Because my backend DB Server is Sybase ASE 15.0.2, I need to re-build my php5-sybase_ct-5.2.9 with FreeTDS 0.82(or above). Or I will encounter truncated problem when column type is Char(n),

Re: [PHP-DB] MDB2 help needed

2008-06-12 Thread James Lucas
)) { print_r($record_result-getUserInfo()); } returns: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM non_existent_table] [Native code: 1146] [Native message: Table 'database.non_existent_table' doesn't exist] Regards James YVES SUCAET wrote: Thanks

Re: [PHP-DB] Excel to xml

2008-06-12 Thread James Lucas
it from http://www.phpmyadmin.net and upload it your own webspace to use it. Regards James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LIMITiT

2008-05-20 Thread James
Hi all, The following code is created by Dreamweaver 8 , it shows 18 records per page. I want to limit the total number of records to 54 that means it should show only the first 3 pages, but as it is not a simple query I can not use LIMIT , it is already used in sprintf. Could

[PHP-DB] HTML CSS (Off Subject) 911 Help! :-)

2008-03-24 Thread Karl James
complete the UFL Fantasy Rosters Links. Thanks, for your help in advance as well. Karl James HYPERLINK http://www.theufl.comwww.theufl.com HYPERLINK mailto:[EMAIL PROTECTED][EMAIL PROTECTED] No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database

[PHP-DB] Re: [PHP] the opposite of a join?

2007-10-03 Thread James Ausmus
ID is NOT linked to in the contact table? Basically, the opposite of a join? SELECT company.* FROM company LEFT JOIN contacts ON (company.companyID = contacts.companyID) WHERE contacts.companyID IS NULL (Assuming your DB can handle a left join) -James Thanks J

[PHP-DB] Re: [PHP] RE: the opposite of a join?

2007-10-03 Thread James Ausmus
DB) - let the DB do the hard work and use a LEFT JOIN syntax, the database can optimize that much more efficiently. Only if your DB doesn't support the LEFT JOIN syntax would you want to do the above. -James Regards, Lasitha Alawatta Application Developer Destinations

[PHP-DB] Using PDO with APC

2007-09-20 Thread James McLean
no good for me either. Has anyone got APC working with PDOStatement result sets? Cheers, James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Using PDO with APC

2007-09-20 Thread James McLean
On 9/20/07, James McLean [EMAIL PROTECTED] wrote: Howdy, I'm attempting to implement APC into my framework, but running into some issues. I'm using PostgreSQL 8.2 with PDO, on PHP 5.2.2 running on Gentoo Linux. When ever I attempt to save my result set obtained from the database

Re: [PHP-DB] Individual Array Entries

2007-07-13 Thread James Gadrow
Here's how you can fill a multi-dimensional array: $days = array(); //Declare $days to be an array while ($row = mysql_fetch_assoc($result)) //set variable $row to be an associative array containing a row of results from your mysql query

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread James Gadrow
William Curry wrote: $qry1 = SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from PcarsCallComplete where Location_address = .$Location2. order by CALL_NO; This method usually works well for me for debugging purposes: immediately prior to query, echo it to see exactly what you're

Re: [PHP-DB] Mailto and PHP

2007-06-14 Thread James Gadrow
Phil Matt wrote: De-lurking here. I am trying to modify a mailing script that I originally wrote to use a small form to send mail to different people from a MySQL database. I would like to modify it so that instead of using a form, the user's regular default email program opens on

[PHP-DB] mysqli_select_db() expects exactly 2 parameters, 1 given

2007-05-25 Thread James Lockie
I do: $db = mysqli_select_db( $database_name ); I get this error: HP Warning: mysqli_select_db() expects exactly 2 parameters, 1 given I have MySQL server version: 4.1.22 and PHP 5.2.2. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysqli_select_db() expects exactly 2 parameters, 1 given

2007-05-25 Thread James Lockie
David Weitz wrote: mysqli_select_db requires the connection to be in the first argument. So: $link = mysqli_connect('blah','blah','blah'); $db = mysqli_select_db($link,$db_name); James Lockie wrote: I do: $db = mysqli_select_db( $database_name ); I get this error: HP Warning: mysqli_select_db

Re: [PHP-DB] Read more link with HTML code

2007-05-07 Thread James Gadrow
Hmmm... Perhaps you should think about separating the tags from the content? Do something like: //Strip tags from content and add a few char hook to be used for re-insertion //Count 200 chars (ignoring any hooks found while parsing and thereby not adding it to the char count) //Make sure

[PHP-DB] PDOStatement and fetchAll()

2007-05-03 Thread James McLean
($this)); but both still only return the stdClass object.. Can someone explain how to do this with fetchAll() a little more clearly? Cheers, James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] variable with NULL value

2007-05-03 Thread James Gadrow
OKi98 wrote: Hi, one more question. Why the variable, that contains NULL value appears to be not set. When you try to echo it the php does not produce warning about using undefined variable. //$connection contains database connection handler $result=mysql_query(select NULL as

Re: [PHP-DB] PHP and MYSQL

2007-05-02 Thread James Gadrow
Chris wrote: Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command I recieve and error that reads the resource id and a number. What does that mean? Firstly always cc the list - others will be able to provide their input and

[PHP-DB] Re: [css-d] IE5.5 and td[scope]

2007-05-02 Thread James Gadrow
D. D. Brierton wrote: On Wed, 2007-05-02 at 16:24 +0100, Martin Paton wrote: I'm using ... #contactform table td[scope] {width:50%} ... to set the width of the label column of a form. Does IE 5.5 support this because I can't get it to pick up (or is there a workaround?) No,

[PHP-DB] Data types, PDO, PgSQL 8.1 and PHP 5.1

2007-05-01 Thread James McLean
if that will help at all. Cheers, James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Help creating tables and fields

2007-03-28 Thread Karl James
that shows a projected database. If you are interested in seeing it please let me know so I can email you off the list, as I am not able to send out attachments. :-) Your alls help would be greatly appreciated Karl Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL

[PHP-DB] Access denied for user...sometimes???

2007-02-21 Thread James Garfield
, I'm using a host of '%' and my IP isn't changing, does anybody know what the problem is with PHP??? TIA, James -- The sender of this email subscribes to Perimeter Internetworking's email anti-virus service. This email has been scanned for malicious code and is believed to be virus free

[PHP-DB] pdo_odbc and odbc

2006-12-29 Thread james tanhs
Hi, I m running on : client: XP + Apache2.2+Php5.2 ( enabled pdo, pdo_odbc, Merant) server: oracle8i Are there anyone having the same problem ? Thanks. ?php // option 1 $db = new PDO('odbc:his', 'his', 'passwd'); $db-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt =

Re: [PHP-DB] Apache 2.2 + PHP5.2 + php_oci8.dll

2006-12-28 Thread james tanhs
page. Follow the Oracle9i link beneath Previous database releases on http://www.oracle.com/technology/software/products/database/oracle10g/index.html Chris james tanhs wrote: Sorry, I posted into the php-general newsgroup earlier. Hi, I saw numerous posting on this type of posting and no one

[PHP-DB] Apache 2.2 + PHP5.2 + php_oci8.dll

2006-12-22 Thread james tanhs
Sorry, I posted into the php-general newsgroup earlier. Hi, I saw numerous posting on this type of posting and no one seems to have a consistent solution to it. Lately, I am quite disapointed with the pain of going thru this configuration and testing. I need to access the oracle 8i server db

[PHP-DB] stable versions of AMP components

2006-09-20 Thread James Tu
Hi: The production environment will most likely live on a Linux machine. My dev environment will be on OS X. What is the most stable versions of the AMP components should I can install? Any advice would be great. Thanks. -James -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Database project

2006-08-23 Thread Karl James
a few questions. You guys would be my hero if I can get this started up so I can do all the data entry. I want to do all the work, just Need help with design of table structure. Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED

[PHP-DB] Problem with list#2

2006-07-07 Thread Karl James
to resolve this. I would send a screen shot but its not advise to In forums. Off list I can for sure if any one wants To see what's going on. Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] www.theufl.com

[PHP-DB] need help on setting up tables for db (NFL Football)

2006-07-05 Thread Karl James
://www.theufl.com/ufl_project.htm Your help would be greatly appreciated. I would be using phpmyadim for this. Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] www.theufl.com

[PHP-DB] problem with list

2006-07-05 Thread Karl James
Team, When I receive an email from this list and only this list, I receive 6 copies. Can any one suggest any ideas why this is happening. I didn't sign up 6 times. Thanks, for your advise. Its becoming annoying, obviously! Karl Karl James (TheSaint) mailto:[EMAIL PROTECTED

[PHP-DB] Question about clients

2005-04-07 Thread karl james
know. Yes I do realize I am talking to the competition... :-) But any advise for a newbie would be greatly appreciated. If you want you can email me directly at the url donw below. Thank you very much in advance. Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/ -- PHP Database Mailing

[PHP-DB] mysql, php error

2005-03-07 Thread James
: Deprecated. Please use the public/private/protected modifiers [PHP Error 20050307145950] HTTP_SESSION_VARS is NULL [PHP Error 20050307145950] _SESSION is NULL [PHP Error 20050307145950] template is Object id #1 -James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Intermittent odbc_connect() problem with iodbc/openlink

2005-02-16 Thread Crone, James
I'm having intermittent problems with odbc_connect(). Here's the situation I'm trying to connect to a Sybase Adaptive Server Anywhere database running on Win2K from my web server using Solaris, Apache, PHP, iODBC, and OpenLink's ODBC universal data access driver for MSSQL/Sybase. About

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread James Pancoast
In my (very) limited experience with PEAR::DB, I've found that getMessage() doesn't give very verbose error messages :). So if I'm really having a problem, I do all 4 of these: echo 'Standard Message: ' . $db-getMessage() . br\n; echo 'Standard Code: ' . $db-getCode() . br\n; echo 'DBMS/User

Re: [PHP-DB] Parse errors ,,, can you. impart me about it.

2005-01-03 Thread James Ferrara
Quite so, you're my new hero. -James Ferrara Jochem Maas wrote: Norland, Martin wrote: ... 4) you thought this was [EMAIL PROTECTED] that's simply hilarious! :-) thanks Martin for making me laugh! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] neeld voluntary help regarding project!

2004-09-23 Thread karl james
/ufl_project.htm Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: LOAD DATA LOCAL INFILE

2004-08-16 Thread James Hatridge
Hi Dani et al.. The guys at MySQL turned this off for security reasons. :( They and SuSE say that you can turn it back on, but I've never been able to get it to work. There are two ways to handle this, first you have to use LOAD DATA INFILE. The file then needs to be either in /tmp and

[PHP-DB] Stopped working?

2004-06-21 Thread James Hatridge
HI all... I just upgraded my SuSE system from 8.2 to 9.1 now the counters on my web sites are not working right. I tracked it down to this line: $cur_ip = $REMOTE_ADDR; I believe that this has stopped working. The idea was my counter kept your number so that you were only counted once. But

RE: [PHP-DB] HTTP header information

2004-06-10 Thread James Harrell
is there in the event you add features later on that require sessions throughout the application. A possible alternative is to use output buffering, which allows you to start a session even after output has been sent. Though this is more likely a kludge rather than a good solution to the problem. James

RE: [PHP-DB] Re: HTTP header information

2004-06-10 Thread James Harrell
the closing php tag. Any output- even a space or extra CR/LF will cause PHP to send the headers. James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] When did mysql_query quit allowing multiple queries separated by a semicolon

2004-06-02 Thread James Harrell
it will not be added back in? Thanks, James Harrell http://www.copernicusllc.com http://celestia.cbstech.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] help with check boxes (php)!

2004-02-20 Thread karl james
names and passwords so far! For the login if you want to look at the team page. And please advise on any other, always looking to improve the site. Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://theufl.com/ http://theufl.com/

[PHP-DB] Noobie on list (Test)

2004-02-15 Thread karl james
This is a test to make sure the email works! Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] drop down changed out for check boxes

2004-02-15 Thread karl james
me how to do this within my code and show me the code on This site http://nopaste.php-q.net/ at the bottom I will have submit buttons that say trade player or release player, and a reset button of course! Please edcucate I am a noobie in php so please bare with me on code! Karl James (TheSaint

[PHP-DB] substr() problems

2004-02-06 Thread James Meers
anyone help? PHP Version 4.3.3 Apache/2.0.47 (Fedora) Many thanks in advance, James.

RE: [PHP-DB] substr() problems

2004-02-06 Thread James Meers
Apologies, the script was right - but the data was wrong - I had lots of white space at the end of each string, i have used rtrim to solve this: $DB_ref = rtrim($DB_ref, ); $DB_temp_ref = $DB_ref; J. -Original Message- From: James Meers Sent: Fri 06/02/2004

[PHP-DB] Re: Results with ledger stripes?

2004-01-27 Thread James Hatridge
On Tuesday 27 January 2004 17:13, Ricardo Lopes wrote: It isnt pretty, efficient or small, but it works... :) Try this: $c= (++$ZZ%2? 'yellow':'white'); printf(tr bgcolor=\$c\); - Original Message - From: Gary Every [EMAIL PROTECTED] To: Ryan Jameson (USA) [EMAIL PROTECTED];

[PHP-DB] What am I doing wrong with pg_copy_from ?

2004-01-20 Thread James Long
point my web browser at this .php script: ?php $database = pg_connect( dbname=james user=james ); $row_id = field 1; $query_string = select * from test where (field1 = '$row_id'); echo $query_string . br; $result = pg_query( $database, $query_string ); if ($result) { // How many fields

[PHP-DB] Web counter question..

2003-12-05 Thread James Hatridge
Hi all.. I just put up my stamp bulletin on line (issue #100!!). I have a problem with it. The counter that I use counts everyone every time they look at the site. I want a better counter, can you all suggest one? It's got to work with html and php only. Thanks, JIM PS Check out my stamp

[PHP-DB] Re: DB update problem...

2003-09-14 Thread James Hatridge
Hi Simon, On Saturday 13 September 2003 19:01, Simon Stiefel wrote: On 13 Sep 2003 at 17:26, James Hatridge wrote: HI gang! Hi! I am trying to do a mysql update. I wrote a small bash file that works fine at the command line. But I would like to have it ran by PHP whenever I start

[PHP-DB] DB update problem...

2003-09-13 Thread James Hatridge
HI gang! I am trying to do a mysql update. I wrote a small bash file that works fine at the command line. But I would like to have it ran by PHP whenever I start the DB. What I am trying to do is have PHP check if a new update file is there (AUD.txt) if it is run the euro-update.program. But

Re: [PHP-DB] PHP connection to remote Access database on NT

2003-09-10 Thread James Hughbanks
Yes, it is possible, but you will have to use an odbc connection on the linux box. I have heard of this being done, but never attempted to mysql, go to www.iodbc.org, that is the odbc software for linux, lots of articles on php+apache+odbc there. --James On Wednesday, Sep 10, 2003, at 21:55

[PHP-DB] PHP Safe Mode ...

2003-09-07 Thread James Hatridge
Hi all,,, I'm having hell with this !ยง$ PHP safe mode. It seems that SuSE complies PHP with safe mode = on. THEREFORE the config file php.ini can not turn it off. Can someone who is using PHP exec in SuSE 8.2 give me an idea how they are doing it? OR how to work around this. Here is my

Re: [PHP-DB] Transferring MySQL data.

2003-08-15 Thread James Hughbanks
the backup file to your production box. If you need anything else, let me know --James Hughbanks Mikro-Data Engineering Dept. [EMAIL PROTECTED] 1-866-457-6287 http://www.mikro-data.net On Friday, Aug 15, 2003, at 17:28 America/New_York, Hugh Dickinson wrote: This is probably a stupid question

[PHP-DB] Playing mp3s using flash and php

2003-03-06 Thread James Riley
which can pull in the sound link and play the file. This same movie would be used throughout the site. Any help would be brilliant Thanks a lot James Riley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: mysql_errno() list?

2003-01-12 Thread James Booker
versions of all the errors in. It turnsa out the text file I talked about in my original poost actually has what I need, but thanks anyway Kind regards James -Original Message- From: Adam Royle To: James Booker; [EMAIL PROTECTED] Sent: 10/01/03 22:30 Subject: Re: mysql_errno() list? Just

[PHP-DB] Oracle via PHP on OS X

2002-11-04 Thread James Stepanek
I need to make connections of this sort but cannot find the needed extensions. Could someone point me in the right direction? I'm using 10.1.5. James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Quarter question..

2002-11-01 Thread James Hatridge
HI all, In the code below I'm trying to get the last column to show 1, 2, 3, or 4 according to which quarter of the year it is. But all it shows in that column is Resource ID # X. The X starts with #3 and goes to 18. There are (at the moment) 15 items in the table. Any ideas what's wrong?

[PHP-DB] Forms question..

2002-10-20 Thread James Hatridge
Hi all... When I have an input form I must click on the first input field. Is there anyway to have it active when the form loads? #2 When I tab down to the next input field, is there anyway to have it highlight what is in the field (ie the default data) so that it will overwrite it? #3 How

[PHP-DB] This is driving me insane!

2002-08-29 Thread James Hatridge
HI all... I'm at my end, would some kind soul please help? I'm working on a database using SuSE 8.0, mysql, and PHP. All the standard installs. I need to use exec, unlink, etc. BUT the durn PHP is stuck in safe_mode and I can't get it out. I've looked in /etc/php.ini and it shows safe_mode

[PHP-DB] Printing?

2002-08-21 Thread James Hatridge
Hi all... I'm useing SuSE 8.0, mysql, and PHP with a HP L5 printer. Could someone give me a hint on how to print a form to my HP? What I want to do is print (on paper G) monthly customer statements. Thanks JIM -- Jim Hatridge Linux User #88484

[PHP-DB] Charts...

2002-08-21 Thread James Hatridge
Hi all.. I'm using SuSE 8.0, mysql, and PHP4. Is it possible to make charts with a database? If so, how about a hint on it? Thanks JIM -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656

[PHP-DB] case

2002-06-11 Thread James Kupernik
I want to test a value that was typed into a form, but I don't want the case to be a problem, how can I get around this?? This is what I have now: function calculate_tax($OrderedByState,$ShipState) { global $totalPrice; //tax calculation $taxRate = 0.05; if ($OrderedByState==MA

[PHP-DB] Re: case

2002-06-11 Thread James Kupernik
PLEASE IGNORE! Thanks! James Kupernik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I want to test a value that was typed into a form, but I don't want the case to be a problem, how can I get around this?? This is what I have now: function calcu

[PHP-DB] values across functions

2002-06-05 Thread James Kupernik
I have a file, it's a shopping cart. Currently is contains all the fuctions required in the cart, including the shipping and billing form. It won't take the values from the shipping form and use them in the functions that calculate the tax and S H. Why would this be? I've gotten other variables

Re: [PHP-DB] foreach

2002-06-04 Thread James Kupernik
found my problem .. thank you for your help! You guy put me in the right direction to solve this problem. Thanks!! Jason Wong [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Tuesday 04 June 2002 00:52, James Kupernik wrote: yes because I

[PHP-DB] foreach

2002-06-03 Thread James Kupernik
I'm using this: if($save) { foreach ($cart as $record = $qty) { if($$record==0) unset($cart[$record]); else $cart[$record] = $$record; } $totalPrice = calculate_price($cart); $items = calculate_items($cart); } and I'm getting this: Warning: Invalid argument

Re: [PHP-DB] foreach

2002-06-03 Thread James Kupernik
yes because I'm using it in another foreach, but this one doesn't want to work. Pierre-Alain Joye [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Mon, 3 Jun 2002 12:48:47 -0400 James Kupernik [EMAIL PROTECTED] wrote: and I'm getting this:

Re: [PHP-DB] sessions

2002-05-23 Thread James Kupernik
devshed, or webmonkey, or phpwizard if not, there's plenty of source code for existing shopping cart systems around these sites, so you can take them and rewrite it to your liking and design! the wonders of open source! -Original Message- From: James Kupernik [mailto:[EMAIL PROTECTED

[PHP-DB] Re: tables/columns with spaces

2002-05-13 Thread James Chin
Jeffrey, Try using quotation marks: select * from REQ where BUSINESS AREA = '$var' Keep in mind that using quotation marks means that the field name is now case sensitive. Regards, James OpenLink Software Inc. http://www.openlinksw.com On Fri, 10 May 2002 08:41:11 -0400, [EMAIL PROTECTED

Re: [PHP-DB] Form Submittion

2002-05-02 Thread James Treworgy
workaround. PN Thanks. PN -- PN Cameron Cooke PN Software Engineer PN Toucan Resolve Ltd PN Registered No 3900680 PN Tel: 01273 422288 PN Fax: 01273 272227 PN Email: [EMAIL PROTECTED] -- Best regards, Jamesmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http

Re: [PHP-DB] Using functions in SELECT statements

2002-05-02 Thread Tony James
Hi Robin Instead of using sql to change the case of the search criteria try using php as in the statement below $query= SELECT * FROM [Organisation Membership] WHERE lower(organisation) LIKE '%. strtolower($SearchBox) .%'); Hope this is of some help to you Tony James

Re: [PHP-DB] Count and group ?

2002-05-01 Thread Tony James
Hi Dave Assuming you are using mysql try the following query select count(Admin_id) as admin1, Admin_id as admin2 from TABLE_NAME group by admin2 substituting TABLE_NAME for whatever you have called your table. Hope this helps Cheers Tony James - Original Message - From: Dave

[PHP-DB] results on multiple pages

2002-04-16 Thread James Kupernik
I am retrieve records from my MySQL table and I want to display the results 12 per page along with allow for a sort. I was just send a query to the table with a limit each time, but it didn't sort all the records, so I need to load all the results into a table to sort then display. Here is what I

[PHP-DB] mail()

2002-04-02 Thread James Kupernik
I'm trying to run a mail function .. the program is running, but I'm not getting the email. Here is the code .. any one have any ideas? $toaddress = $friendemail; $subject = A message from .$fromname..; $mailcontent = Here's a special message from a friend .Your friend,

[PHP-DB] phpMyAdmin

2002-03-21 Thread James Kupernik
I'm trying to load phpMyAdmin on, and it seems to work fine, but when I browse a table and run my mouse over the contents of that table I get a jazascript error. Does anyone know a solution for this problem? I doesn't happen in the earlier version of phpMyAdmin .. just this later version. Any

[PHP-DB] Re: phpMyAdmin

2002-03-21 Thread James Kupernik
Nevermind ... I found the problem! (slamming head against desk) James Kupernik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm trying to load phpMyAdmin on, and it seems to work fine, but when I browse a table and run my mouse over the

RE: [PHP-DB] need help guys

2002-03-14 Thread Tony James
hi Rehab Because your submitted text on the url contains an '' anthing after this character will be parsed as a new variable. Instead of location.href=additems.php?category=+c try location.href=additems.php?category=+escape(c) this will encode the '' aswell as spaces to preserve

FW: [PHP-DB] Username

2002-02-05 Thread Tony James
Hi Jennifer The table defines the uid field as not null. CREATE TABLE users ( uid int(10) unsigned NOT NULL auto_increment, name varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', .. However you are trying to insert null

FW: [PHP-DB] Username

2002-02-05 Thread Tony James
Hi again The insert statement is incorrectly positioned within the if statement. ? if(!IsSet($stage)) { ? Please fill out the form below to get an account. FORM METHOD=POST ACTION=te.php Username:BRINPUT TYPE=TEXT NAME=name SIZE=15BR input type=hidden

[PHP-DB] fwrite()

2002-01-25 Thread James Kupernik
I'm trying to take the contents of a table and write them to a file on my server. Everything seems to function ok (AKA no errors) but no file gets written ... I can't figure out why. Can anyone shine some light on this dark problem? $db = mysql_connect(localhost,cloft,spring);

Re: [PHP-DB] fwrite()

2002-01-25 Thread James Kupernik
Still when I make the changes suggested the file will not be created, yet I get no form of an error message. Is there something else I'm missing? I'm trying to take the contents of a table and write them to a file on my server. Everything seems to function ok (AKA no errors) but no file gets

[PHP-DB] select and update together

2002-01-21 Thread James Kupernik
it's possible. Thanks for any advice you can provide. James -- 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] limit sytax error

2002-01-21 Thread James Kupernik
when I try to do the update with a limit on which records, it gives me a sytax error on the limit, is there anyway to get around this? UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i,10 thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] Resource id #2 ?

2002-01-18 Thread James Kupernik
I run this query $countreq = mysql_query(SELECT COUNT(*) FROM catalogs WHERE PROCESSED IS NULL); then try to echo $countreq but end up getting Resource id #2 instead of the count total. What would cause this? Thanks for any advise! James -- PHP Database Mailing List (http://www.php.net

[PHP-DB] password problem

2002-01-17 Thread James Kupernik
I'm creating this form where the person needs to enter a password to move on. When they enter the password it just loops back to enter the password and doesn't move on. But then I remove the requirement for a password the page moves on and loads the information from the DB. Why is this? --

[PHP-DB] enter key?

2002-01-17 Thread James Kupernik
I found the problem in the form and fixed that, but now anytime I want to submit the form by hitting enter, it acts like it's reloading the page. What would be the cause of that? When I click on the submit button the verification and program function correctly, but when I hit enter, they do not.

Re: [PHP-DB] enter key?

2002-01-17 Thread James Kupernik
tdPassword:/tdtdinput type=password name=magicword size=10/td /tr /table pinput type=Submit name=submit value=Get Catalog Requests/p /form ?php } //endif ? Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Friday 18 January 2002 00:25, James Kupernik wrote

RE: [PHP-DB] How can recommend a book for SQL and DB design

2002-01-15 Thread Montz, James C. (James Tower)
I found Sams teach yourself MySQL in 21 days to be very helpful. It provides some general db practices such as structure and normalization. And it covers MySQL pretty well, with examples for mutiple languages. -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

[PHP-DB] permissions for writing file

2002-01-14 Thread James Kupernik
I'm trying to use PHP and MySQL to query a table and write the contents to a new file. When run the command to outfile it tells me I don't have permissions. This is on a Unix machine. mysql select * into outfile /home/u1/funfun/www.somewebsite.com/catalogreq/ catalog.txt mysql fields terminated

[PHP-DB] Re: permissions for writing file

2002-01-14 Thread James Kupernik
My problem is that I'm trying to run the query via a telnet sessions before I code through PHP. Is there a solution that anyone knows for this? James Kupernik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm trying to use PHP and MySQL to query

[PHP-DB] outfile permission error

2002-01-14 Thread James Kupernik
I'm trying to create a new file on my server from the data in a table. When I do the query it returns a permission error. I'm logged into my server through a telnet sessions and the permissions on the dir allow me to write to it. Here is the query below. mysql select * into outfile

[PHP-DB] Input to DB from form

2002-01-03 Thread James Kupernik
','$BLNAME','$BADD1','$BADD2','$BCITY','$BZIPA','$BSTATE','$BCTRY', '$BTELO','$TODAY'); This is embedded in an HTML document and loads the entire document, but doesn't add the information to the table. Any help would be wonderful! James -- PHP Database Mailing List (http://www.php.net

[PHP-DB] searching for zipcode: where to start?

2001-11-10 Thread dean james
hello, I want to create a database search with php/mysql that searches for zipcodes in a database. of course, there will be other columns/tables and such to be printed, but I only want to search for the zipcodes and have the other cells printed if the following criteria are found: lets say I

[PHP-DB] Re: [PHP-DEV] Re: [PHP-WIN] call a function from a DLL?

2001-11-09 Thread James Moore
of hours), implement a com interface to your dll or wait for the w32api extension to become more stable. Cheers, - James -- 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

[PHP-DB] Re: very strange problem for mysql query

2001-10-31 Thread James Chin
there are three arguments. Since there are only two conversion specifiers in the format string, only the first two arguments will be processed and printed. The '$s' is an undefined variable so nothing gets outputted for that. Regards, James Chin OpenLink Software Inc. On Wed, 31 Oct 2001 14:42:36

[PHP-DB] Problems with MSSQL

2001-09-24 Thread James Cornman
Hello. I'm have PHP 4.0.6 compiled as a DSO module for Apache. From the command line (with the same ./configure line, with out the --with-apxs paramater) it runs fine, but from the web, it is unable to connect to my MSSQL server. I've configured php --with-sybase=/usr/local/freetds. I've tried

[PHP-DB] Warning: 0 is not a Sybase link index in

2001-08-15 Thread James Reategui
i am running apapche 1.3.20 on a UNiX box with php compiled with freetds support fro mssql server. I have a MSSQL 7 server I need it to connect to using the php commands. When I run an sql script with the mssql_connect function I get the following error: Warning: 0 is not a Sybase link index

[PHP-DB] Retrieving a PDF file from a MySQL Database

2001-07-21 Thread James Willard
error has occurred. The file datatype in the table is MEDIUMBLOB and the filesize data seems to be accurate. Could someone please offer any assistance? Thanks, James Willard [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Submiting forms to mySQL

2001-07-09 Thread James Wharton
I would like to have a three frame webpage. The data entry would be in the main frame while the edit delete and submit buttons would be in another frame. Is this possible? I thought that you could only submit things between the form/form tags. (not things in different html or php files) --

  1   2   >