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] 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] 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] 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] 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] 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] 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] 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] 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

[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

[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] 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] $_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

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

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

[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

[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] 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

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] 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] 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] 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

[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] 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

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

[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 - 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

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] 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

[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

[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] 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] 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] 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] 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

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] 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] 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

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] 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: 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] 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

[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] 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

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

[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

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

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

<    1   2   3