[PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Dan Rowe
of 'PHP 5'. https://bugs.php.net/bug.php?id=60124 Please let me know if you have any problems applying the patch or comments on how we can make it better/get it added to the main codebase. Thanks, -Dan

Re: [PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Dan Rowe
and now that we have had it in production for a while. One of those things where the time invested in trying to get it integrated/accepted is more then the actual development time for such a small patch :) Thanks again, -Dan On Dec 13, 2011 1:34 PM, Matijn Woudt tijn...@gmail.com wrote: On Tue, Dec

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Dan Rowe
Try running this : http://mysqltuner.pl/mysqltuner.pl If the server has been up for over 24hrs it gives a lot of good insight and things to try tuning wise as a starting point. It'll uncover a lot of common configuration issues or MySQL server level bottlenecks. -Dan (apologizes for the top

Re: [PHP-DB] DATETIME

2009-10-08 Thread Dan Shirah
Hi All, I have a DB that is storing the date/time an event happens in DATETIME format, i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC I am trying to write a query in PHP that will look for any row that falls within a range of dates, i.e. between Sep 1 and Oct 1, but

Re: [PHP-DB] finder

2009-07-15 Thread Dan Shirah
Hello… I must to do a finder with 10 posibilities. This 10 can be full or empty. (sorry... I just ask this but I’m not understand yet) I know how to do a finder about any field, but this is my first time with one like this where the user can find a “house” in a “zone” or find anything

Re: [PHP-DB] finder

2009-07-15 Thread Dan Shirah
But with that it doesnt difference between full and empty field… If the user want search on two posibilities on ten... Maybe I'm not understanding what you're asking... Or maybe you don't understand the query... Say your form has 10 checkboxes. If the users picks 3 out of ten boxes and

[PHP-DB] Re: [PHP] CREATE question

2008-10-30 Thread Dan Shirah
On 10/30/08, Daniel Brown [EMAIL PROTECTED] wrote: On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah [EMAIL PROTECTED] wrote: Is it possible for us to use PHP to create temp tables in our database? [snip!] But all that does is give me an ifx_prepare fails message. (Forwarded to PHP-DB

Re: [PHP-DB] from a table, I have to pick only those rows which have two specified fields

2008-09-18 Thread Dan Shirah
On 9/18/08, Vaibhav Informatics [EMAIL PROTECTED] wrote: Any simple command like distinct? -- Vaibhav Informatics, 304 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED] could you provide a little more detail, please? Are you saying that you

Re: [PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Dan Shirah
Hi Everyone, I am attempting to wrap my head around an issue and wanted to see if I was thinking right. I am attempting to setup a pURL site, one where they go to something like: example.com/purl.php?purl=jason1234 and the site says Welcome Jason. I have that part of it working, and it's

Re: [PHP-DB] Pull Down Menu with ODBC query

2008-08-11 Thread Dan Shirah
Try something like this: tddiv align=right SELECT name=menu ?php $conn = odbc_connect(HOMES, , ); $billdate = $_POST[ 'billdate' ]; $q_menu = SELECT DISTINCT sls_his_cust_id FROM sls_his where sls_his_prchdat_alt = $billdate; $r_menu = odbc_exec($conn, $q_menu); while

Re: [PHP-DB] Question on PHP connect MS SQL 2005

2008-06-11 Thread Dan Shirah
Alice, In regards to: Call to undefined function mssql_connect() in /home/TDC/Desktop/create_new_entry_master.php on line 20 Do you have the MSSQL extension uncommented in your PHP.ini? Dan

[PHP-DB] PHP + MySQL

2007-07-18 Thread Dan Maret
( copyright = Copyright 2007 yada yada version = 2.15.1 ) That way I can do ?= $settings['version'] ? Can you help point me in the right direction? Any help would be greatly appreciated!! :-D -- -Dan

Re: [PHP-DB] record pointer

2007-07-05 Thread Dan Shirah
If I understand what you're asking, just write a simple query. $picked = your_selection; $sql = SELECT * FROM your_table WHERE cat = '$picked'; $result = mssql_query($sql) or die (My_Error_Message); $row = mssql_fetch_assoc($result); $id = $row['id']; $name = $row['name']; $cat = $row['cat'];

Re: [PHP-DB] Re: record pointer

2007-07-05 Thread Dan Shirah
Okay, in your first post you said you were selecting by category, now you're saying you are selecting by ID and want all corresponding records that have the same category as the selected ID. Which way are you trying to do this?? On 7/5/07, elk dolk [EMAIL PROTECTED] wrote: O.K. the id column

Re: [PHP-DB] mssql connecting

2007-05-23 Thread Dan Shirah
Did you already try these steps? http://us2.php.net/manual/en/function.mssql-connect.php#70918 On 5/23/07, Bryan [EMAIL PROTECTED] wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any

Re: [PHP-DB] DB Design Concepts

2007-05-02 Thread Dan Shirah
, at application run time if certain conditions were met, the column takes on the characteristic NOT NULL attribute. -Original Message- From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 3:50 PM To: Max Thayer Cc: php-db@lists.php.net Subject: Re: [PHP-DB] DB Design Concepts

[PHP-DB] Re: mysql question.

2007-04-03 Thread Dan Luevano
EMail, COUNT(*) FROM mena_guests WHERE Voted = 'yes' GROUP BY EMail LIMIT $startingID, $items_numbers_list The group by will cause the DISTINCT effect AND you'll be able to see how many duplicates there were for each distinct EMail. Hope this helps, Dan Luevano [EMAIL PROTECTED] wrote

Re: [PHP-DB] widthheigh

2007-03-30 Thread Dan Shirah
I believe what he is saying that since you wrap your echo in double quotes, that you should not use duoble quotes again inside the same echo. Therefore your code should like like this: td width=90 height=70 ?php echo img src='/album/img/'.$photoFileName[2].' width='90' height='70 ' border='0' /

Re: [PHP-DB] Using multiple submits on a page and retaining $POST data

2007-03-16 Thread Dan Shirah
! Thank you. Onochie -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ.. -- akan ada dimana mulut terkunci dan suara tak

[PHP-DB] MSSQL Server

2006-12-21 Thread Dan Shirah
I cannot connect to my MSSQL server. I use the following connection string: php: -- $connection = mssql_connect http://php.net/mssql_connect('server','user', 'password') or die ('server connection failed'); $database = mssql_select_db

Re: [PHP-DB] Special Character

2006-11-16 Thread Dan Shirah
dash) it also does the same thing for a single hyphen depending on the sentance structure. Hope this helps! Dan On 11/16/06, Niel Archer [EMAIL PROTECTED] wrote: Hi David What you describe sounds like Word is auto replacing hyphens with either en- or em-dashes. This is a configurable option

[PHP-DB] Re: generating random id's

2006-02-09 Thread Dan Baker
JeRRy [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Just to let you all know I used PHP's unique ID generator to generate a unique id for tracking purposes. I than md5 it hide the format a bit, would this be enough? Or can be easily worked out also? Need it pretty tight and

[PHP-DB] Re: Re: Storing Credit Cards, Passwords, Securely, two-wayencryption

2006-01-09 Thread Dan Baker
Peter Beckman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Fri, 6 Jan 2006, Dan Baker wrote: Peter Beckman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new

[PHP-DB] Re: Re: Storing Credit Cards, Passwords, Securely, two-wayencryption

2006-01-09 Thread Dan Baker
On 1/9/06, Dan Baker [EMAIL PROTECTED] wrote: And last of all, I know of a pretty large company that uses a service similar to VeriSign. This other service (can't remember the name) didn't provide the PNRef scenario, so the company stores credit card numbers in their database (encrypted

[PHP-DB] Re: Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-09 Thread Dan Baker
Neil made a great post about storing credit card data at your own site securely. I thought I'd add a note: If you do implement his suggestion, I'd suggest adding a Reference type situation: (1) When you add credit card data to the system, have it return a valid Reference to that credit card.

[PHP-DB] Re: Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-06 Thread Dan Baker
Peter Beckman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. I'm also thinking about how to save passwords in the DB, not plaintext, but not one-way

RE: [PHP-DB] Re: Problem with mysql_connect(...)

2005-09-20 Thread Dan
. -Original Message- From: viraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 12:14 AM To: Dan Cc: Michael Louie Loria; php-db@lists.php.net Subject: Re: [PHP-DB] Re: Problem with mysql_connect(...) this is a dll issue; if you are running php5 on windows! read this.. http

RE: [PHP-DB] Re: Problem with mysql_connect(...)

2005-09-19 Thread Dan
If this is a windows computer, you might want to try adding C:\PHP (or whatever directory your PHP resides) into the path. I read somewhere that this needs to be done for PHP5 and MySQL. Not sure if it was true but seemed to clear up the problems I was having getting the 2 to talk to either

[PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Dan Baker
Jordan Miller [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and

[PHP-DB] Re: load data infile -- problem

2005-08-18 Thread Dan Baker
select.now [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] So, in command line, all works fine, all records are correctly imported. command line code - mysql load data infile 'c:\\datastream\\import\import -into table iport - fields

Re: [PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)

2005-06-22 Thread Dan Fulbright
I have no problem creating a table, using a query from my dbase table news: SELECT * FROM table where column = VALUE. However, now that most of our articles have more than one column type (i.e. instead of just technology, the column can now contain technology, politics, local. You need

[PHP-DB] selective query?

2004-10-31 Thread Dan Bowkley
$mongorow[2]/t dtd$mongorow[3]/td/tr\n; } echo /table; Any ideas? TIA, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] IBM DB2

2004-09-08 Thread Dan Scott
.software.ibm.com/webapp/download/search.jsp?rs=db2pde if you want to test it out. Registration is required, but there's no license fee involved as long as you're not using the database in a production environment. Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: RE :I thought 4 didn't equal 456456456%20%20OR%2012

2004-05-10 Thread Dan Bowkley
DING! That's the sound of a little lightbulb turning on... Thanks so much for that tidbit...I could certainly see myself getting screwed by not using such a thing. Dan - Original Message - From: Neil Smith [MVP, Digital media] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Dan Bowkley
-dibcomputers/index.php?id=456456456%20%20OR%2012 Dan Bowkley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] got it...rather than return false, mysql_result throws an error if the query returns nothing. What a pain. Finished product at http://www.dibcomputers.com/new

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Dan Bowkley
The 404 page is also inserted into the template, or at least that's the idea...index.html?id=404 is the error page. ?id=1 is the main page, other pages are numbered accordingly. - Original Message - From: Justin Gruenberg [EMAIL PROTECTED] To: Dan Bowkley [EMAIL PROTECTED] Cc: [EMAIL

[PHP-DB] narrowing it down...

2004-05-09 Thread Dan Bowkley
I've come up with this: if (mysql_result ( mysql_query (SELECT id FROM dibcomp_site WHERE id = $page_req),0)) {$thisid = 404;} else {$thisid = $page_req;} and, well, it doesn't work. I think it really ought to...

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Dan Bowkley
got it...rather than return false, mysql_result throws an error if the query returns nothing. What a pain. Finished product at http://www.dibcomputers.com/new-dibcomputers/index.php.txt if anyone wants to steal it... D - Original Message - From: Dan Bowkley [EMAIL PROTECTED] To: [EMAIL

[PHP-DB] supernoob strikes again

2004-05-08 Thread Dan Bowkley
-dibcomputers/index.php and I've got it also retrievable as a text file at the above url with .txt appended. I know there's an easy way to do this...I'm just braindead at the moment. Staring at this thing for too long I guess. :) Thanks in advance, Dan the Noob

Re: [PHP-DB] lamer noob with repeat question

2004-05-04 Thread Dan Bowkley
Anyone? - Original Message - From: Dan Bowkley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 02, 2004 1:21 AM Subject: [PHP-DB] lamer noob with repeat question Hello everyone, I've been working on (read:tearing my hair out over) my mom's website for some time now

[PHP-DB] stuck on stupid...can't find the bloody error...

2004-04-25 Thread Dan Bowkley
a work order number that already exists. Help this feeble-minded programmer wannabe? Oh, as to the \' madness down yonder: should I or shouldn't I backslash the single quotes? TIA Dan html headtitleThe Board Lady - Work Order Database 0.1a/title/head body ?php define ('DB_USER

[PHP-DB] lamer noob question

2004-04-15 Thread Dan Bowkley
design by Dan at a href=http://www.dibcomputers.com; style=color:#2f2f2f; font-size:xx-small;text-decoration:none;font-weight:bold; target=newDIB Computers./a/div/center/td/tr/table /td/tr/table /body /html First off, I need to know how to fetch variables out of the URL. I know this is /supposed

Re: [PHP-DB] Where's the error?

2004-04-08 Thread Dan Brunner
Not even the title?!?! Dan On Apr 8, 2004, at 2:55 PM, [EMAIL PROTECTED] wrote: It is not displaying anything at all. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:52 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB

Re: [PHP-DB] multi-language site

2004-01-16 Thread Dan Hewins
different sites (English, Spanish, Admin-Eng, Admin-Esp). A separate question is this: where are the good resources for XML on the web? Thanks. Dan On Jan 16, 2004, at 4:18 AM, [EMAIL PROTECTED] wrote: The advantage of doing it the way Dan describes is that it is very easy to set up an admin tool

[PHP-DB] multi-language site

2004-01-15 Thread Dan Hewins
. Does this sound like a good approach? Is PHP capable of something like this? Thanks for any help or suggestions you can give. Dan Hewins -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: send email

2003-11-26 Thread Dan Brunner
of feedback to the user, so they now it worked as well. I hope this helps. I know there are better ways of doing this, functions or classes. But this is quick. Good luck! Dan Brunner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003

Re: [PHP-DB] removing space ?

2003-10-28 Thread Dan Brunner
Hello. Use ltrim(). $image = ltrim($data-JPG_Name); echo $image; Or use trim() Or http://www.php.net/manual/en/ref.strings.php Dan On Oct 28, 2003, at 4:11 PM, [EMAIL PROTECTED] wrote: When I select data from my data base I have spaces on the lead side for example the data

[PHP-DB] redirect

2003-10-27 Thread Dan Liu
Hi all, Has anyone used 'Module mod_rewrite URL Rewriting Engine'? I need to do a redirect from http://url1/cgi-bin/mapserv?map=/dir1/county.map to http://url2/cgi-bin/mapserv?map=/dir2/county.map But it is not working. Does somebody know why? Thanks in Advance. Dan -- PHP Database Mailing

Re: [PHP-DB] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Dan Brunner
Hello!! Yes check to make sure mysqld is running. ps -aux|grep mysql If you don't see mysql, then start mysql. service mysql start If your running red hat. Dan On Oct 14, 2003, at 4:52 PM, [EMAIL PROTECTED] wrote: phpinfo() says: MySQL Support enabled

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-10 Thread Dan Brunner
What is your field length??? Varchar(10)?? You should set the column type to text. Dan On Oct 10, 2003, at 10:27 AM, [EMAIL PROTECTED] wrote: I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while

[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem

2003-09-15 Thread Dan Anderson
null if $link didn't work and we didn't die */ $result = mysql_query(SELECT * FROM table); ? -Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP, LDAP and the root DSE

2003-07-14 Thread Dan Evans
to read the root DSE from PHP and if so how?! (We're running PHP 4.3.2, Apache 1.3.20 and OpenLDAP 2.0.11 libraries on a Red Hat 7.2 i386 box). Dan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] address info, forms, maintanance

2003-06-05 Thread Dan Brunner
Hello!! Are talking about the same Post Question??? On another words, what is being duplicated?? If not, you can use auto_increment. Dan On Wednesday, June 4, 2003, at 03:13 PM, [EMAIL PROTECTED] wrote: I need to modify some company web pages that include a form for asking the company

Re: [PHP-DB] Email an attached file

2003-05-29 Thread Dan Brunner
Good luck!! Dan Brunner On Wednesday, May 28, 2003, at 01:12 PM, [EMAIL PROTECTED] wrote: www.phpclasses.org is your best bet. there are plenty. personally i use this one..http://phpclasses.com/browse.html/package/32.html check out his site for examples. hth jd

Re: [PHP-DB] Email an attached file

2003-05-29 Thread Dan Brunner
Then you should be able to use that function... So are you storing the Path of the file in MYSQL or any other database?!?!!? If not then replace /- $file2 = (./images/$data-name); //-- to reflect your path... Dan On Wednesday, May 28, 2003, at 02:34 PM, [EMAIL PROTECTED

[PHP-DB] print table truncated

2003-03-31 Thread Dan Liu
Hi, I havea question about printing.When the table in HTML page is too big and I print the page,part of the table got truncated.Is there a way to print the web page without truncation? Thanks in advance. Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Customer id

2003-02-28 Thread Dan Kelly
('$fname','$lname') ; mysql_query($query) or die (mysql_error()); } ? Any Ideas? Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] worked

2003-02-28 Thread Dan Kelly
Hey that worked guys.. Thanks..Dan You need to create a column in the target table similar to: custID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT When you run your INSERT query, you pass NULL to that column and the ID will be created/auto incremented for you. Is that what you mean? Rich

[PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Dan Martin
and the PHP Manual, but can't seem to figure this out. I'd be grateful for a reference or guidance. Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] uploading

2002-11-05 Thread Dan Brunner
it belongs... The actual file is uploaded into a temp directory..you have to copy or move the file from that spot to where you want it...At least with Linux... Dan On Tuesday, November 5, 2002, at 04:03 PM, [EMAIL PROTECTED] wrote: I have been trying to get this to work as well, where I am

[PHP-DB] Re: Print data

2002-10-25 Thread Dan Koken
by using the print button. HTH... Have a great day... Dan José Moreira wrote: hello, at my company we have several network printers and i was was wondering if it's possible to print directly to them using PHP, instead of showing on the screen or both ... to gain more control on what is printed

[PHP-DB] Help Help

2002-10-09 Thread dan
. Help please. Dan J. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Mysql vs postgresql

2002-10-01 Thread Dan Koken
are needed. Maybe the new release of mySQL with sub-selects and transaction processing will compare favorably??? Donno?? Anyway that was my experience.. hope it helps. Have a great day... Dan Gabi Munteanu wrote: I would go for postgresql. Reasons? triggers,procedures,a speed almost equal

[PHP-DB] with-oci8 and RedHat distribution

2002-09-28 Thread Dan Trottier
in order to configure php with the same options as in the default distribution. Any help or pointers would be appreciated. Thanks, dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Dan Brunner
Check your register_globals value in your PHP.INI!! Dan On Thursday, September 26, 2002, at 11:48 AM, [EMAIL PROTECTED] wrote: I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from 1 php to the other how i fix it? Thanks -- PHP Database Mailing List (http

Re: [PHP-DB] Getting a list of MSSQL databases

2002-09-17 Thread Dan Healy
Thanks That will work for me Dan Ryan Jameson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I believe you'll have to do this: select * from master.sysdatabases :-) Ryan -Original Message- From: Dan Healy [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 15, 2002 9

[PHP-DB] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
back commentary back on any suggested recourse from those who've done this already. Hopefully this will prove to be a useful change, and people will be happy :) As always send your comments to me. --- Dan KalowskyI'll

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
it in a different release schedule (as ODBC standards don't change that rapidly). But I've heard some complaints against such ideas, so I haven't pushed it (yet). Anyways naming convention can be changed very easily. --- Dan Kalowsky

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
. --- Dan KalowskyI'll walk a thousand miles just http://www.deadmime.org/~dankto slip this skin. [EMAIL PROTECTED]- Streets of Philadelphia, [EMAIL PROTECTED]Bruce Springsteen

[PHP-DB] Query display question

2002-08-26 Thread Dan J.
Hello, I am some what new to php. I have an odbc query written and it displays like I want it to but... I want to be able to setup a next / prev button when say records = 10. How would I go about this? Thanks Dan J. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: New to PHP mySQL

2002-08-25 Thread Dan Koken
Ray, Why not just simply give them a list of available times that meet their number of days requested starting with the day they ask for. Would look something like this. HTH. Dan. Have a great day. -- ? $req_start_date = '2002-04-01'; $req_end_date = '2002-04-20

[PHP-DB] gd Library config problem.......

2002-08-21 Thread Dan Kelly
/builder/psa-patch/psa/apache/../release/lib/imap-cclient' Notice that it says Without GD I want it to say With gd .. where di I go to fix this problem? Thanks, Dan -- PHP Database Mailing List (http

[PHP-DB] Re: Charts...

2002-08-21 Thread Dan Koken
by placing the variable in the height or width and display the one pixel image as such: echo img SRC='images/blue.gif' WIDTH=$percent HEIGHT='18' ALIGN='BOTTOM' BORDER='0'; You can stack different colors. But you only get bar graphs. HTH. Dan. James Hatridge wrote: Hi all.. I'm using SuSE 8.0

[PHP-DB] Re: select distinct with all columns

2002-08-12 Thread Dan Koken
SELECT * FROM equipement WHERE class = microphones GROUP BY type; Russ Arbuthnot wrote: I have a mysql table named equipment with 11 columns named: id, staff_member, class, type, manufacturer, model, description, picture, created, modified, and published. I'm trying to write a select

[PHP-DB] Re: Select * from t1.id where not equal to t2.id ???

2002-08-03 Thread Dan Koken
Dave, Try something like this: SELECT * FROM t1 LEFT JOIN t2 ON t2.id = t1.id WHERE t2.id is NULL HTH. Dan. Dave Carrera wrote: High all I cant seem to get this sql working. I am trying to pull everything from table 1 (t1) where t1.id is not equal to table 2 (t2) id I cant

[PHP-DB] Re: adding a space in mysql

2002-07-31 Thread Dan Koken
Ron I do believe that placing a space in '%$var %' will do the same as a varchar and sprip it off the end. Not positive. However I believe something like this will do the trick: SELECT something FROM a_file WHERE replace(CONCAT_WS('','.',a_file.field,'.'),' ','.') LIKE '%.$var.%' HTH... Dan

[PHP-DB] Re: adding a space in mysql

2002-07-31 Thread Dan Koken
Ron Wallace wrote: thanks, helpers, but I think I have a simple solution: I will insert a space at the front of the string, where the db must accept and retain it. BTW, here is the SQL I am working with: // elseif ($desc==desc) { $sql=SELECT

[PHP-DB] Re: n00b deleting entries from db.

2002-07-28 Thread Dan Koken
and the other to substitute the variable $num_records into the DELETE as DELETE from file file limit $num_records - 75, $num_records HTH Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Construct, Q+E, QBE

2002-07-18 Thread Dan Koken
such as '=' and use a single input field for price, but I found I had more problems trying to explain that to users. That's your choice. However this seemed to be the easiest for them to use. HTH. Have a great day... Dan = Fernando Ortiz wrote: I'm

[PHP-DB] Re: PDF

2002-07-08 Thread Dan Koken
... and hope this helps in some way. Have a great day... Dan Natividad Castro wrote: Hi to all, How can I display info in a PDF? All I need is to be able to read from a table and display fields into a PDF. Before, I had my DB in Microsoft Access, so I bounded all the fields in a report and then I

[PHP-DB] Re: resizing images comming out of blobs

2002-07-05 Thread Dan Koken
/jpeg); print(mysql_result($result, 0, photo_image)); photo_image is name of blob field from the DB - HTH.. Good luck.. Dan. === Andy wrote: Hi there, I am wondering how to resize an image which

[PHP-DB] Re: subtracting one query from the other

2002-06-27 Thread Dan Koken
= second_record.id ORDER BY something HAVING first_id = NULL Here only the second_records will be selected if there is no matching first_record. HTH.. Good luck .. Dan - Harpreet Kaur wrote: Please help, I am stuck and my mind is frozen. I want to subtrack one query

RE: [PHP-DB] MYSQL Socket error :\

2002-06-21 Thread Dan Harrington
I'm no expert on XP, but you may want to check the firewall settings, to make sure that windows XP isn't preventing the connection. For the $host, you may want to either use 'localhost' or 127.0.0.1 Cheers, Dan -Original Message- From: Marco Lanini [mailto:[EMAIL PROTECTED]] Sent

[PHP-DB] RE: [PHP] date problem

2002-06-06 Thread Dan Hardiker
like your fastest option, but your not providing enough information. -- Dan Hardiker [[EMAIL PROTECTED]] ADAM Software Systems Engineer First Creative Ltd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: multiple queries

2002-05-29 Thread Dan Koken
= mysql_query($sql); $record_count = mysql_num_rows($result); HTH Good luck Dan.. === Natividad Castro wrote: Hi to all, I have a search form where users can search project by 'Project Name' after they type in the project name, they will select which project

[PHP-DB] Uploadin file

2002-05-17 Thread ababei dan george
can someone help me with uploading a file into a table (MSSQL),,, or where can i find a good sample or information about this -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Search Script

2002-04-25 Thread Dan Brunner
FROM Table1 WHERE Print_Name LIKE '%$Print_Name%' ORDER BY $or $place; $result = $nav-execute($sql, $db, mysql); $rows = mysql_num_rows($result); for ($y = 0; $y $rows; $y++){ $data = mysql_fetch_object($result); That should do it!! Dan On Thursday, April 25

Re: [PHP-DB] Search tutroial

2002-04-24 Thread Dan Swensen
Getting a search function running perplexed me, too, until I looked at the MySQL docs. With the Full-Text Search function I got a search function working in minutes. http://www.mysql.com/doc/F/u/Fulltext_Search.html Watch out for the weird bug that ignores duplicate rows, though. It can make

Re: [PHP-DB] Search tutroial

2002-04-24 Thread Dan Brunner
)=mysql_fetch_row($ret)) Dan On Wednesday, April 24, 2002, at 01:47 PM, [EMAIL PROTECTED] wrote: By the way SELECT uid, id, image, iname, quantity, type, user where it shows below that user isn't in the query- it is there in my editor. I just forgot to put it in before sending. Jennifer

[PHP-DB] auto-increment question

2002-04-23 Thread Dan Swensen
need to auto- increment. Can this be done, or do I need to find a workaround (and if so, can anyone suggest anything?) Thanks in advance, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] auto-increment question

2002-04-23 Thread Dan Brunner
Hello!! ALTER TABLE table1 AUTO_INCREMENT = 1000; That should do it... You can use that anytime.. Dan On Tuesday, April 23, 2002, at 12:21 AM, [EMAIL PROTECTED] wrote: Hi all, I'm wondering if there is a way to start an auto-increment field at a number other than 1. I'm working

[PHP-DB] Selecting random record from a database?

2002-04-02 Thread Dan Swensen
Hi all, Does anyone know a quick and easy way to select a random record from a database? I'm looking to put together a simple random quote generator, a la linux's fortune. Any help would be much appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Dan Brunner
); ? It will popup a messages about not checking that checkboxAnd tell you have an error... I too messed around trying to just using PHP, but I gave up using just PHP, Javascript plays nice with PHP anyway!! Dan On Monday, April 1, 2002, at 12:57 PM, [EMAIL PROTECTED] wrote

Re: [PHP-DB] Selecting Drop Down Value From DB to Edit

2002-03-27 Thread Dan Harrelson
If I understand your question, when editing an existing record where StateID = CA, you want the drop-down to show California as selected. You need to add a little code into your while loop to echo SELECTED into the appropriate option tag. -Dan --- Steve Fitzgerald [EMAIL PROTECTED] wrote: I

RE: [PHP-DB] include() statement hell!

2002-03-27 Thread Dan Brunner
Has anybody told him to check his PHP.INI??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] include() statement hell! #1. You may want to double-check the path

Re: [PHP-DB] records into an editable box

2002-03-06 Thread Dan Brunner
Hello!! Do you mean a textarea?? And you want to populate the textarea with the data, right? Dan On Wednesday, March 6, 2002, at 01:34 AM, [EMAIL PROTECTED] wrote: How would I change this sql statement to pull the db table and display it within an editable box within a form? Any help

Re: [PHP-DB] easy date format question

2002-03-04 Thread Dan Brunner
Hello!! it should be $today = Date(Y-m-d); Dan On Friday, March 1, 2002, at 04:50 PM, [EMAIL PROTECTED] wrote: should be simple as pie, of course, but i can't find a straightforward syntax example in the documentation. i'm trying to change the PHP date format to mysql's. my code

RE: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Dan Brunner
Hello!! First uninstall your old version of php(php-4.0.6-9.7.0) Then install the new RPM If you're using the Red Hat update thingy... Or download the source and recompile it!! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04

Re: [PHP-DB] Re: forced page links...

2002-02-27 Thread Dan Brunner
, or with cookies. And check for that variable every page with an If...else..statement. like If (empty($CheckPLEASE){ echo Sorry You are out of order; exit(); }else{ echo hey your good to go!!; } And so on and so on... Dan On Wednesday, February 27, 2002, at 02:03 AM

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Dan Brunner
Hello... Try exec() I know it works moving files. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] accessing system cmds w/ PHP Can anyone tell me how to access linux

  1   2   >