RE: [PHP-DB] File Downloads

2010-05-28 Thread Adam Schroeder
to adjust the mime type accordingly. http://stackoverflow.com/questions/258365/php-link-to-image-file-outside-default-web-directory/258380#258380 Good luck. Adam -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 1:39 PM To: php-db@lists.php.net

RE: [PHP-DB] File Downloads

2010-05-28 Thread Adam Schroeder
... but depending on the importance of the content -- it should be good. Adam -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 2:36 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4:33 PM, Karl DeSaulniers

[PHP-DB] Help for a beginner

2009-12-23 Thread Adam Sonzogni
. I have tried enabling: only mysql, mysql AND mysqli, and only mysqli. None of this seems to have done anything to change my situation. Again, I apologize for the lengthy message, I hope I have accurately described my issue in the right amount of detail. Thank You! Adam Sonzogni -- PHP

[PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
Mr. Brookhouse, Thanks for the quick reply. I am guessing it is not relevant to my case because I am not using PERL. I cannot find anything that says PHP requires PERL so I suspect Iam ok in this regard. Thank You, Adam -Original Message- From: Edward Brookhouse [mailto:eb

RE: [PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
Chaitanya, Apache is not an option for us, and IIS is serving PHP without issue, so I would prefer to resolve my connectivity issue. Thanks, Adam From: Chaitanya Yanamadala [mailto:dr.virus.in...@gmail.com] Sent: Wednesday, December 23, 2009 10:17 AM To: Adam Sonzogni Cc: Edward Brookhouse

RE: [PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
and the root password for mysql Thanks, Adam -Original Message- From: Giff Hammar [mailto:gham...@sv-phoenix.com] Sent: Wednesday, December 23, 2009 10:41 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] RE: Help for a beginner It looks like you are not connecting because of a user name/password

RE: [PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
) conn.close % So line 4 is: conn.open Thanks, Adam -Original Message- From: Barry Stear [mailto:bst...@gmail.com] Sent: Wednesday, December 23, 2009 11:28 AM To: PHP DB Posts Subject: Re: [PHP-DB] RE: Help for a beginner Adam, What is at Line 4 in your test.asp? The error you

RE: [PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
...@gmail.com] Sent: Wednesday, December 23, 2009 12:04 PM To: Adam Sonzogni Cc: PHP DB Posts Subject: Re: [PHP-DB] RE: Help for a beginner Well I am not familiar with ASP. You might want to check to make sure that you didn't make any typos in your mysql_test.php page. I would suggest seeing if you can

RE: [PHP-DB] RE: Help for a beginner

2009-12-23 Thread Adam Sonzogni
: Wednesday, December 23, 2009 1:54 PM To: Adam Sonzogni; PHP DB Posts Subject: Re: [PHP-DB] RE: Help for a beginner I apologize I do see that you tried using phpmyadmin and received the FastCGI error. This might help you : http://www.php.net/manual/en/install.windows.iis7.php . Let me know what

RE: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Fortuno, Adam
Sashi, This (likely) means you have a some generic page (i.e., picture.php) that displays some picture. The picture it displays depends on the parameter passed when the page is called (i.e., 123). html head titleSashi's Test Page/title /head body

RE: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Fortuno, Adam
Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image WHERE ID = %s; mysql_real_escape_string($value); Sorry, but this won't work, since you don't map the value of the escaped $value to the %s, lets say

RE: [PHP-DB] Re: session variable in select query showing picture from database

2009-02-12 Thread Fortuno, Adam
Mika, Put the dollar sign (i.e., $) outside the curly brace. $query=SELECT * FROM pic_upload WHERE band_id='${band_id}'; A- -Original Message- From: Mika Jaaksi [mailto:mika.jaa...@gmail.com] Sent: Thursday, February 12, 2009 12:27 PM To: php-db@lists.php.net Subject: [PHP-DB] Re:

RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

2008-12-08 Thread Fortuno, Adam
Fred, If you're using integrated security (e.g., a domain account such as domain\bob), you won't supply a password. However, the sa account is a SQL login (v.s. a domain login). In that case, it would make sense that you supply a password. See the following page for some code to connect using

RE: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Fortuno, Adam
Dee, If all you're trying to code is that a value of NULL equates to FALSE and a date value (whatever date value) equates to true, you can use something like this: If ($MyVariable) { //... true path blah... } else { //... false path blah... } You can use this because NULL

RE: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Fortuno, Adam
All, Chris makes a good point i.e., unknown compared to anything is unknown. His comment made me want to clarify my earlier note. In my earlier example, I wasn't suggesting that-that logic be coded in the database. I was assuming it would be in the page: ?php $TestNullValue = NULL; If

RE: [PHP-DB] re:database tables relations advice

2008-11-27 Thread Fortuno, Adam
a look. Good luck, and welcome to the DB development club. Cheers, Adam -Original Message- From: mrfroasty [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2008 5:19 AM To: php-db@lists.php.net Subject: [PHP-DB] re:database tables relations advice I am quite new to database

RE: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-26 Thread Fortuno, Adam
] Sent: Monday, November 24, 2008 5:54 PM To: Fortuno, Adam Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5 Rick, when I delve into the php_info() shmaz, I see this snipet - see below. I'm not sure if I should be looking for something else

[PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Fortuno, Adam
be appreciated. Cheers, Adam

RE: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Fortuno, Adam
To: Fortuno, Adam Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5 //Return the database connection OCILogon($username, $passwd, $db); I receive an error stating, Fatal error: Call to undefined function OCILogon() in C:\Documents

Re: [PHP-DB] SQLite security

2004-08-20 Thread Adam Q
You can use Mcrypt, OpenSSL or any other crypographic provider to encrypt the information however for your application to be able to access the information you would also have to store the encryption key, reducing the protection offered. Any PHP MySQL connection script has the DB password in it

[PHP-DB] SQLite security

2004-08-16 Thread Adam Q
shrug Please somebody tell me I'm wrong, Cheers, Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] oracle error ORA-12154

2004-07-16 Thread Adam Williams
Hi, I'm trying to connect to an oracle 9.20 database using: $conn = OCILOGON(dah50,dah50,zed2.aleph0); but I get the error ORA-12154 Searching on google says my listener.ora or tnsnames.ora may have problems, but I think mine are correct. Can someone take a look and see if they are ok?

Re: [PHP-DB] oracle error ORA-12154

2004-07-16 Thread Adam Williams
$TNS_ADMIN=/home/beckman/oracle/network/admin If those aren't set, then things won't work. Please confirm that those environment variables are set in Apache or whatever web server you are using. If they aren't, oci8 won't work. Beckman On Fri, 16 Jul 2004, Adam Williams wrote: Hi, I'm trying to connect

[PHP-DB] Need some HELP

2004-05-10 Thread Adam Farid
; ?/td/tr trth align=left Address:/th td ? print$User_Addres; ?/td/tr ... input type=submit value='submit' /table /FORM .. Kind Regrads Adam I hope someone can help me. Thanks _ Stay in touch with absent friends - get MSN

[PHP-DB] Need some HELP (not works)

2004-05-10 Thread Adam Farid
]'; but nothing a new. I have checked register_globals is on. in my first page I used session_start(); and global $HTTP_SESSION_VARS; I dont know if this cause the problem that I had. Thanks again and more help please. Adam _ Use

[PHP-DB] Need some HELP (not works)

2004-05-10 Thread Adam Farid
Thanks. I tried your suggestion, but the values still did not displayed in second page. nothing printed out. I put my files in db-list (Need some HELP). regards Adam _ Stay in touch with absent friends - get MSN Messenger http

[PHP-DB] logic problem

2004-04-21 Thread Adam Williams
I'm using some proprietary software/hardware where when a visitor swipes their entry card, it is recorded in a mssql 2000 server. My boss wants a count of unique vistors for a range of dates. So, I need to have it give a count of unique vistors, meaning that I need to count all vists for a

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
the eventime to a date or some unique string to represent the date. On Apr 21, 2004, at 1:13 PM, Adam Williams wrote: I'm using some proprietary software/hardware where when a visitor swipes their entry card, it is recorded in a mssql 2000 server. My boss wants a count

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
Yeah I basically had that with my previous SQL statement, I was grouping by event.cardnum instead of counting the cardnums by date. I think what I'm trying to do is beyond the scope of SQL and I'll have to write some PHP to take the SQL statement results and feed them into an array and count

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
by date In MySQL you don't need to specify a field for count(). And you should have to convert the eventime field twice, you should be able to reference the calc field in the group by. On Apr 21, 2004, at 2:19 PM, Adam Williams wrote: Yeah I basically had that with my previous SQL

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
for count(). And you should have to convert the eventime field twice, you should be able to reference the calc field in the group by. On Apr 21, 2004, at 2:19 PM, Adam Williams wrote: Yeah I basically had that with my previous SQL statement, I was grouping by event.cardnum instead

[PHP-DB] postgresql

2004-04-14 Thread Adam Williams
Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I am moving a postgresql database from one server to another. As the user that owns the database, lculber, I ran

[PHP-DB] ocilogon error

2004-03-31 Thread Adam Williams
Hi, I have oracle and PHP working together on a remote server called zed that runs redhat linux. I have another computer called accessserver that runs win2k pro with PHP that I am trying to connect to oracle on zed. Both computers have the oracle client libraries installed. On accessserver I

Re: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread Adam Voigt
solve this problem. dave -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Adam Voigt
-- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP - MSSQL - LINUX

2004-03-17 Thread Adam Voigt
, either whole or partial, is prohibited. Please inform us in case of erroneous delivery, thanks for your cooperation. -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySql query

2004-03-17 Thread Adam Voigt
like this: SELECT * FROM sometable WHERE 1 does WHERE 1 just return every row? thanks in advance. -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mssql query

2004-03-16 Thread Adam Williams
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000 database. We have a proprietary application/hardware setup where when a person enters the building, the time they enter the building is automatically put into the database in a field called eventtime, and their access

Re: [PHP-DB] mssql query

2004-03-16 Thread Adam Voigt
in there for the date functions as a whole. On Tue, 2004-03-16 at 10:32, Adam Williams wrote: I've used mysql a little, but now I'm working with a MS SQL SERVER 2000 database. We have a proprietary application/hardware setup where when a person enters the building, the time they enter the building

RE: [PHP-DB] PHP - MSSQL connects, but can't query

2004-03-15 Thread Adam Voigt
Can anyone help me figure this one out?! Thanks! Jason Morrill IT Manager Child Family Agency SE Connecticut -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt

Re: [PHP-DB] PHP - MSSQL connects, but can't query

2004-03-12 Thread Adam Voigt
Child Family Agency SE Connecticut -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] working with ' in SQL

2004-03-04 Thread Adam Williams
Hi, I have an SQL statement that is ran when data is submitted through a form. When someone types in a word with an ' such as farmer's the SQL statement fails. I tried $_POST[data] = addslashes($_POST[data]); before executing the SQL statement, but the statement still fails. any

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Adam Voigt
the database via phpadmin or anything else Appreciate your input on this one. -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Uploading files

2004-02-27 Thread Adam Voigt
. Does anybody know anything about that? Thank you -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Uploading files

2004-02-27 Thread Adam Voigt
If your on a slow connection, it might be timing out. Try putting: set_time_limit(0); At the top of the page where the file is being uploaded to (not from), and see if that helps. On Fri, 2004-02-27 at 10:29, nikos wrote: It is allready 8M - Original Message - From: Adam Voigt

Re: [PHP-DB] Connect to MSDE using PHP

2004-02-23 Thread Adam Voigt
to try ODBC. Anyone have any suggestions? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Voigt
:53, [EMAIL PROTECTED] wrote: Howdy -- Would someone point or provide me with an example of PHP + libMysqld (Embedded MySQL server)? My problem is my churchs web site doesn't provide a MySQL database as a default package (add $15.95/mo)for a MySQL Db. TIA, David -- Adam Voigt [EMAIL

[PHP-DB] Re: [PHP] Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Voigt
-02-23 at 11:53, [EMAIL PROTECTED] wrote: Adam Voigt wrote: Check these guys out: http://spenix.com/WebHostingPlans.aspx Very cheap, very reliable, great features, and support is second to none I've ever experienced, and before you ask, no I'm not now nor have I ever been an employee

[PHP-DB] Re: [PHP] Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Bregenzer
On Mon, 2004-02-23 at 23:02, [EMAIL PROTECTED] wrote: Adam, Thanks for your repsone(s) now back the root of the problem. As stated above I need to be able to run the database from with the home direcory/document root? I hesitate to answer this so as to not create a naming confusion but I can

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-20 Thread Adam Voigt
, Michael Flanagan wrote: Adam, Thanks for the suggestions. I don't want to ignore all error handling. Later, I might get an error that I really don't want php to swallow due to either of your suggestions. Has anyone else run into this and solved it? Any idea why the following lines

Re: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Adam Voigt
and web server are on the same machine. I'm using PEAR:DB for the database access. Thanks. Michael Flanagan voice: (1) 303-674-2691 fax: (1) 603-963-0704 (note '603' area code) mailto:[EMAIL PROTECTED] -- Adam Voigt [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Adam Voigt
Try putting the error suppressor (@) before the query, eg: @mssql_query Or, try setting the error reporting: error_reporting(0); On Thu, 2004-02-19 at 14:38, Michael Flanagan wrote: Thanks, Adam. I don't get the error in Enterprise manager. MS has a KB article out that says

[PHP-DB] compiling oracle support

2004-02-12 Thread Adam Williams
How do I compile PHP on Unix to have oracle 9 support. Looking at ./configure --help and PHP's website, I see no option for oracle 9 support. I see --with-oci8 but that appears to only work for Oracle 8. Any help? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-04 Thread Adam i Agnieszka Gasiorowski FNORD
Jeremy Peterson wrote: I haven't tested this code, but it should get you started. I imagine that you have a lot of different days that you are trying to restrict in your query (This could be costing you a lot of time), so the first query removes all articles you don't want up front before

[PHP-DB] [Fwd: Catalog listing]

2004-01-04 Thread Adam i Agnieszka Gasiorowski FNORD
LOL, look what I've got after posting to one of the groups about my problem with multiple JOIN query...Some kind of robot reads one of them? Original Message From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Precedence: bulk Subject: Catalog listing To: [EMAIL

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Adam i Agnieszka Gasiorowski FNORD
Jeremy Peterson wrote: If you are concerned with speed, consider multiple queries. Joins cause most delays. Give that a shot. What do you mean? Sorry, please explain futher, I don't know what you have in mind... I have to do some of those joins, because of the relationships

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Adam i Agnieszka Gasiorowski FNORD
Jeremy Peterson wrote: Could you repost your original message (I deleted it already, sorry.) and more details about your database tables even some sample data. I'll try to make more sense of the query you are performing and help you along. In general it would be better to eliminate the

[PHP-DB] CREATE TABLE LIKE, error

2003-12-15 Thread Adam i Agnieszka Gasiorowski FNORD
I cannot use this query CREATE TABLE table LIKE other_table; , which is supposed to create an empty clone of the other_table named table. Was it added in some later MySQL version? It's in the manual on mysql.com, bo no version info available. -- Seks,

Re: [PHP-DB] CREATE TABLE LIKE, error

2003-12-15 Thread Adam i Agnieszka Gasiorowski FNORD
CPT John W. Holmes wrote: From: Adam i Agnieszka Gasiorowski FNORD [EMAIL PROTECTED] I cannot use this query CREATE TABLE table LIKE other_table; , which is supposed to create an empty clone of the other_table named table. Was it added in some later MySQL version? It's

[PHP-DB] informix error

2003-11-19 Thread Adam Williams
Hi, I was wondering if anyone has seen this informix error before. It has me stumped. Searching on google didn't reveal anything. Running my query in informix returns the proper results, so I'm not sure what the problem is. Warning: ifx_fetch_row(): 4 is not a valid Informix Result resource

Re: [PHP-DB] Optimal mySQL query for next prev page system

2003-11-18 Thread Adam i Agnieszka Gasiorowski FNORD
Kim Steinhaug wrote: Then I query the mySQL database again to get the final result set, which I return together with the buildt prev/next htmlkode Instead of querying twice, use the SQL_CALC_FOUND_ROWS parameter of SELECT statement and then do a quick SELECT HIGH_PRIORITY

Re: [PHP-DB] keyword searching

2003-11-12 Thread Adam Williams
the db is looking for all the fields that contain holmes, north, and carolina. CPT John W. Holmes wrote: From: Adam Williams [EMAIL PROTECTED] CPT John W. Holmes wrote: From: Adam Williams [EMAIL PROTECTED] I am selecting a field in a database called description for keyword searching

[PHP-DB] keyword searching

2003-11-12 Thread Adam Williams
Hello, I am selecting a field in a database called description for keyword searching. The field contains names of people, states, years, etc. When someone searches for say holmes north carolina the query searches for exactly that, fields which have holmes north carolina, and not fields that

Re: [PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread Adam Reiswig
question now is regarding the curly brackets in the 2nd example. Can anyone describe why using the curly brackets works and/or how php processes them. I have read quite a bit about php and never come accross thier use in this way. Thanks again. -Adam Reiswig -- PHP Database Mailing List (http

[PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread Adam Reiswig
question now is regarding the curly brackets in the 2nd example. Can anyone describe why using the curly brackets works and/or how php processes them. I have read quite a bit about php and never come accross thier use in this way. Thanks again. -Adam Reiswig -- PHP Database Mailing List (http

[PHP-DB] $_POST in MySQL query issue...

2003-10-16 Thread Adam Reiswig
= .$_POST['elementName']; and several other variations. Can anyone give me some pointers to inserting $_POST[] statements inside of query statements? I am sure there must be a way but I have spent a lot of time on this and am really stumped here. Thanks for any help. -Adam Reiswig PS if anything

[PHP-DB] Variables not working within Functions

2003-10-15 Thread Adam Symonds
Hi, I am starting to us functions with my work but I am having troubles With the variables in the functions.. If I have the following function called from my page it will work but the variable won’t ($username) but if I put this code straight on the page then it works fine.. Any reason for the

[PHP-DB] Photo Gallery Comments.. NOT WORKING

2003-09-25 Thread Adam Symonds
am doing wrong with the in_array.. Thanx In advance Adam == ?PHP //start of comments selection... $mysql_access = mysql_connect(localhost, username, password) or DIE(mysql_error()); mysql_select_db(database, $mysql_access) or DIE(mysql_error

[PHP-DB] Re: PHP MSSQL

2003-08-14 Thread Adam Presley
Ok. Special thanks to Robert Twitty for the answer. I started using the TEXT datatype to achieve long texts of data. However, PHP.INI is configured by default to limit TEXT datatype retrievals to 4K. Change the mssql.textlimit in the INI file to suit your purposes, and use the TEXT datatype.

[PHP-DB] Re: PHP MSSQL

2003-08-14 Thread Adam Presley
I know what you're going through here. In MS SQL you can define a VARCHAR up to about 8000 characters, but your PHP mssql_query command only returns 255 (0 - 254) characters. I then tried using the TEXT datatype. TEXT datatype in MS SQL allows somewhere around 2 billion characters. However, the

RE: [PHP-DB] Don't know why query works this way

2003-08-11 Thread Adam Alkins
); or if (db_numrows($someQuery) ...) These are just some thing I use to make my life easier. Hope it helps Not to be rude... but what does that have to do with his question? -- Adam Alkins http://www.rasadam.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

RE: [PHP-DB] determining if a query returns no value

2003-08-08 Thread Adam Alkins
Quoting [EMAIL PROTECTED]: Youy could use: if(!$result) { // Don't display } else { echo Title; } You fill in the blanks That only checks to see the query failed. A query returning no rows doesn't fail... -- Adam Alkins http://www.rasadam.com -- PHP Database Mailing List (http

Re: [PHP-DB] Limit

2003-08-04 Thread Adam Alkins
If it is a unix timestamp, why not just select rows where the date is = 7776000 (which is 90 days) or if you want to be specific about the months, use mktime() to generate the timestamp for the date 3 months ago. -- Adam Alkins http://www.rasadam.com Quoting Marie Osypian [EMAIL PROTECTED

Re: [PHP-DB] Regular Expressions? URGENT

2003-08-02 Thread Adam Royle
Hi Aaron, I found this on a little useful when I started learning regex. Good luck 2 ya! adam http://www.devshed.com/Server_Side/Administration/RegExp/ Hi All, Sorry for OT post but need some info. Does anyone know a good tutorial that explains regular expressions in DUMMY terms? I have

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-07 Thread Adam Voigt
only $29.95 per month! http://sbc.yahoo.com -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL Extention in PHP5.0.0b2-dev

2003-07-07 Thread Adam Lundrigan
still get the error for the mysql extension Any Ideas? Thanks. Adam Lundrigan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-04 Thread Adam Lundrigan
that doesn't seem to workit tells me that the libmysql.dll file is not a PHP module. Where can I track down the PHP module for MySQL? Its not in my /extensions directory -Adam Lester Caine [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Exactly how would one go about installing

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-04 Thread Adam Lundrigan
Thanks. I'll try that -Adam Marco Tabini [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try in the current snapshot at http://snaps.php.net (also, more info on my blog). Cheers, Marco Tabini http://blogs.phparch.com On Fri, 2003-07-04 at 13:01, Adam Lundrigan wrote

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-03 Thread Adam Lundrigan
Exactly how would one go about installing the MySQL extension, as a workaround to the removal of the builtin MySQL library? Thanks, -Adam Lundrigan Rasmus Lerdorf [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Sun, 29 Jun 2003, Ben Lake wrote: Anyone have an input

Re: [PHP-DB] Reading from a file

2003-07-01 Thread Adam Voigt
. Also, how do I get rid of any white space at the end of a variable if there is some once it is read in? - Rick -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] moving though an array..

2003-06-26 Thread Adam Voigt
to be written in such a manner that it scales up or down in options.. depending on what was selected in the form. ANYONE have some thoughts? Oh.. when I echo the above code I get this: (Array %h%) Thanks! Aaron -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator

Re: [PHP-DB] Related Tables - Capture ID

2003-06-26 Thread Adam Voigt
record insertion to insert into a field into a related table in the third. What would the easiest way to go about this in php? Thanks, MAO -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Accessing MySql using Flash while using PHP as themiddleware

2003-06-25 Thread Adam Voigt
info, but with Flash I am struggling. -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

2003-06-03 Thread Adam Voigt
(http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with php/mysql and ISS on windowsXPprofeesional

2003-06-03 Thread Adam Voigt
description.) humbly, =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Adam Voigt [EMAIL

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

2003-06-03 Thread Adam Voigt
-- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Total Values with MySQL

2003-06-03 Thread Adam Voigt
of '1' then can I get MySQL to return 3? Thanks for your help -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connect Microsoft SQL database with php on unix

2003-04-01 Thread Adam Voigt
/mssql_connect ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED

[PHP-DB] RE: MySql Help needed

2003-03-31 Thread Adam Douglas
Are you sure you give access to this user from the machine to the database server? Check IP address permissions and if the user has access to the specific table and/or database in MySQL. Also check to make sure the database server is setup to allow you access from your machine.. check the MySQL

Re: [PHP-DB] Gathering data from a database

2003-03-22 Thread Adam -
Hi, $select = mysql_select_db ($database); like Mike said you don't need to have this in and no need for a var to be assigned... Then when you want to print out the data print_r( $row ); you can use $row['table_row_name']; :) Adam At 08:26 PM 3/22/2003 -0500, you wrote: I have been

RE: [PHP-DB] Addslashes (MSSQL)

2003-03-20 Thread Adam Voigt
Holmes... -- 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 -- Adam Voigt ([EMAIL PROTECTED

[PHP-DB] Including Details in MySQL longer than 255 characters

2003-03-20 Thread Adam Venturella
data where comments =$input Anyway if someone could point me in the right direction I would be very appreciative. Adam [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Including Details in MySQL longer than 255 characters

2003-03-20 Thread Adam Venturella
Thanks, I totally forgot about that type... And thanks to everyone else who replied! -a Mike Karthauser [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] on 20/3/03 6:11 pm, Adam Venturella at [EMAIL PROTECTED] wrote: Anyway if someone could point me in the right direction I would

[PHP-DB] Re: PHP script execution - display issue

2003-03-13 Thread Adam Royle
is causing your problems. Unfortunately, sometimes this unavoidable. To make it run sequentially, you could do this, or use divs with absolute positioning. just a thought. Adam Hello, I have a display problem with one of my sites. Because there is an big amount of information in the pages, which

[PHP-DB] Re: adding to an array variable using a loop...?

2003-03-10 Thread Adam Royle
functions (or string functions) to work out how to do this. Depending on how your date is setup you would use strtotime() or mktime() (or both). Adam --- Original Message --- I want to create an array from results returned from a mysql query. I want it to go through each row in the returned result

[PHP-DB] Re: Dynamic Variable names

2003-03-09 Thread Adam Royle
arrays - they are much more flexible (and PHP arrays are especially cool). http://www.php.net/manual/en/ref.array.php adam Just a quick question about dynamic variables would like to end up with a variable called $tips_1 $tips_2 ... $tips_n where n is the value of the variable $sid i have tried

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread Adam Voigt
be appreciated. Randy -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description: This is a digitally signed message part

[PHP-DB] Re: Using results from one mysql query to make another

2003-02-27 Thread Adam Royle
SELECT b.name FROM apliexperts a LEFT JOIN experts b ON a.expid = b.id WHERE softid = 2 I have a table that includes the ids of software aplications and experts (apliexperts). My page is loaded with the variable of the software id (softid), which it uses to match the experts for that software.

Re: [PHP-DB] Processing Page

2003-02-27 Thread Adam Royle
you can gauge percentages of things done. Alternatively, you could simply use same method (without image), and after db stuff is done, output a javascript redirect. The above is probably confusing, but ask me if you need more explanation. Adam -Original Message- From: Aspire Something

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Adam Voigt
-- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description: This is a digitally signed message part

  1   2   3   >