[PHP-DB] mysql --> php

2001-04-08 Thread Adam
o use mysql in a php script: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php3 on line 97 Error I'm sure that mysql server is running. Greets, Adam -- PHP Database Mailing List (http://www.ph

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 P

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Adam Younce
name for the column that the date is stored in. To get more info on the DATE_FORMAT function, check out the MySQL online manual. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat e_and_time_functions Regards, Adam Younce [EMAIL PROTECTED] - Original Message ---

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

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

2004-02-19 Thread Adam Voigt
and doesn't execute my query. > > I'm running php 4.3.3 for Windows; the SQL Server 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 (

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 th

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

2004-02-20 Thread Adam Voigt
16:38, 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? > >

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

2004-02-23 Thread Adam Voigt
27;sa','password') > mssql_connect('namedinstance\coconut','sa','password') > > and those wouldn't work either. The only response I get is "failed to > connect to server ..." > > I'm off to try ODBC. Anyone hav

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

2004-02-23 Thread Adam Voigt
2-23 at 09: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 MySQ

[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

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

Re: [PHP-DB] Uploading files

2004-02-27 Thread Adam Voigt
;server not found" error. > > 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 - >

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Adam Voigt
ody may access 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 suggestions?

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

2004-03-12 Thread Adam Voigt
encing the sql-test.php file: > - > > Connected to server. > Warning: Sybase: Server message: Line 1: Incorrect syntax near 'e'. > (severity 15, procedure N/A) in /home/www/sql-test.php on line 12 > Can't connect to Northwind > > > > Can anyone help me figure this one out?! > > Thanks! > Jason Morrill > IT Manager > 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
> > Connected to server. > Warning: Sybase: Server message: Line 1: Incorrect syntax near 'e'. > (severity 15, procedure N/A) in /home/www/sql-test.php on line 12 Can't > connect to Northwind > > > > 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 [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 card

Re: [PHP-DB] mssql query

2004-03-16 Thread Adam Voigt
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

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

2004-03-17 Thread Adam Voigt
d recipient, > please delete the mail. > Any use not in accord with its purpose, any dissemination or disclosure, 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
t are formatted something 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
ange needed would be quite simple. > > PB -- 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
efresh a web page displaying a png > image? > > Thanks in advance for any thoughts/insights into how I can 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 p

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

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
I see it, the hardest part is > converting 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 >

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 t

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
.eventime, 110) BETWEEN '$startdate' and > 'enddate' > and type = '1' > group 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 th

Re: [PHP-DB] logic problem

2004-04-21 Thread Adam Williams
110) BETWEEN '$startdate' and > > 'enddate' > > and type = '1' > > group 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 &

[PHP-DB] Need some HELP

2004-05-10 Thread Adam Farid
nd file file2.php "; print ""; print ""; ?> Name: User Number: Address: ... .. Kind Regrads Adam I hope someone can help me. Thanks _ Stay in touch with absent friends - get M

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

2004-05-10 Thread Adam Farid
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 MSN Mess

[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

[PHP-DB] SQLite security

2004-08-16 Thread Adam Q
t;; } ?> But updating this on pref changes is no fun compared to SQLite 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 s

[PHP-DB] RE: ensuring unique field value in MySQL using PHP

2002-01-28 Thread Adam Royle
nName" command to make sure there are no duplicates. Look in the mySQL documentation (www.mysql.com) to find the correct command. Adam -Original Message- From: Janet Valade [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:24 PM To: [EMAIL PROTECTED] Subject: ensuring unique fiel

[PHP-DB] RE: FIle Uploading to database

2002-02-03 Thread Adam Royle
You missed the SET parameter in your query... example is below... $query = "INSERT INTO Canidate SET (FirstName, LastName, Indus... Adam -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Re:

[PHP-DB] Re: Counting db generate links

2002-02-06 Thread Adam Royle
were storing addresses (like downloadable things, eg PDFs or scripts, etc) cause then it really is a link MANAGEMENT system, and not just a link stat counter Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: option in forms

2002-02-09 Thread Adam Royle
I think this is what you're getting at: "> or something like that so it would look like (in HTML) Artist's Name First in list Artist's Name second in list Artist's Name third in list if you select the first item in the list, the next page will produce: $artistID = "23" so yah... that

[PHP-DB] RE: Outputing Distinct rows

2002-02-10 Thread Adam Royle
ic_id = posts.topic_id ORDER BY posts.lastUpdated DESC LIMIT 10"; Also, this would allow for extra things in the future, such as a page showing all updates in a certain day, or within last 3 days, or something like that. Hope this helps. Adam -Original Message- From: KingZeus [mai

[PHP-DB] Re: Getting days after last login. Date problem

2002-02-13 Thread Adam Royle
: " . date("j/m/Y",$time); ?> would produce something like: Timestamp: 1013605509 Formatted date: 13/02/2002 and then you can store the value of $timestamp in a database and calculate the formatted string later... Adam > Hi there, > > I would like to find out the changes

Re: [PHP-DB] Session confusion :-(

2002-02-18 Thread Adam Royle
o effect on current session variables with the same name. See if that works, and if it doesn't have a look at this... http://www.php.net/manual/en/language.variables.predefined.php Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Special Insertion Into MySQL - at a loss!

2002-02-21 Thread Adam Royle
w you want it to look, but i think its the data transfer that you were worried about... any questions about the code?? just ask... Adam >I have a special set of information retrieved from a while loop that I would >like a person to be able to edit and send back into a MySQL table. > &

RE: [PHP-DB] "The" Debacle

2002-02-25 Thread Adam Royle
To make sure that other names are not interfered with, I would refine what you're doing. ie. "Theater Nuts" would become "ater Nuts, The" obviously this is not acceptable... so you would do something like this... //does it begin with 'The '? $name_start = substr($band_name, 0, 3) if ($name_st

[PHP-DB] Question about advanced SQL

2002-02-27 Thread Adam Royle
easier way. Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: login

2002-03-10 Thread Adam Royle
I have not tested this but it should work... Adam this goes in the form area on login.php -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: login there is a page that when user go to need to be

[PHP-DB] RE: login

2002-03-10 Thread Adam Royle
If the variable $SCRIPT_NAME does not suit your needs, try the other environment variables here: http://www.php.net/manual/en/language.variables.predefined.php Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Output of curl to an array.

2002-03-21 Thread Adam Royle
: ) Adam You can use it like so... PHP Script (of course, you must either have the function on the same page or include() it like so): Output: Array ( [Name1] => Value1 [Name2] => Value 2 [Name 3] => Value 3 ) //=> extractPairs.php ""); }

[PHP-DB] Re: insert into javascript php

2002-03-22 Thread Adam Royle
PHP cannot recognise javascript variables because javascript is interpreted via the browser, and not the server (which php is). for php to use javascript variables, you must post the variable to another page using either a form or querystring. Adam > > > c=document.forms[0].categor

Re: [PHP-DB] "marking" DB entries...

2002-03-22 Thread Adam Royle
you have the ID number of the person logged in, you can allow/disallow what they can edit depending on the ID. If you need further help, contact me directly. Adam. > Im making an address book using PHP and mySQL. > I want each user to have access only to his/hers adressinputs. Now I

[PHP-DB] Re: urgent guys

2002-03-22 Thread Adam Royle
uot;; javascript -> php: // this is probably wrong javascript syntax, but you get the idea location.href = "thing.php?q=first+one&p=second+one"; Adam > i know it has nothing to do with php but i'm stuck:) > > i have this url: > http://localhost/auction/seller

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Adam Royle
he query is actually working. Adam

[PHP-DB] Re: If else Question

2002-03-26 Thread Adam Royle
;t submitted the form (obvious) and it doesn't insert the record until it checks the data integrity and if they are allowed to insert the record. Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP/Access problem

2002-03-26 Thread Adam Royle
#) Order by Author,Title your table name should not hae single quotes around it... adam

[PHP-DB] Re: Checking for 2 unique row contents

2002-03-27 Thread Adam Royle
Simple do these checks and you'll be sweet as a nut Adam // you might have this at the top of your form to show the error messages \n"; for($i=0;$i\n"; } echo "\n"; } ?> > Hi all > > > > I am trying to create a regis

[PHP-DB] Advice to PHP beginners

2002-03-27 Thread Adam Royle
Hope this helps for someone out there... Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-04-01 Thread Adam Royle
er. Learn to use both (its not that hard) and it will make life a lot easier (and more interesting). Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mail()

2002-04-02 Thread Adam Voigt
entering a hardcoded test without the variables to make sure it works just even with straight static values? Adam Voigt [EMAIL PROTECTED] On Tue, 2 Apr 2002 10:55:20 -0500, James Kupernik <[EMAIL PROTECTED]> wrote: > I'm trying to run a mail function .. the program is running, but I

Re: RE: [PHP-DB] mail()

2002-04-02 Thread Adam Voigt
make the email appear as coming from [EMAIL PROTECTED], while when they clicked the reply button, it would go to [EMAIL PROTECTED], the most useful situation for these is when your server appends a nastry from address like apache@localhost or whatever from the webserver daemon. Adam Voigt [EMAIL

Re: [PHP-DB] Regular Expressions

2002-04-07 Thread Adam Royle
he code for you do figure out your problem. if (strlen($string) > 20){ print "error"; } else { print "OK"; } Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] New PostgreSQL functions

2002-04-08 Thread Adam Voigt
7;s funny PHP has so many ways to do certain things, and so few ways to do other things. =) Just Curious, Adam Voigt [EMAIL PROTECTED] On Mon, 08 Apr 2002 13:41:46 +0900, Yasuo Ohgaki <[EMAIL PROTECTED]> wrote: > Hi, > > I&

Re: Re: [PHP-DB] New PostgreSQL functions

2002-04-08 Thread Adam Voigt
example of all the positives they found to the PHP language, and I certainly don't want you to think me a ASP zealot because I don't program in ASP or iHTML for that matter, I'm a pure PHP evangelist from top to bottom. Adam Voigt [EMAIL PROTECTED] On Mon, 08 Apr 2002 23:04:25

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
SELECT * FROM whatever ORDER BY id DESC; Ofcourse if you want Ascending order, it would be "ASC" instead of "DESC" Adam Voigt [EMAIL PROTECTED] On Tue, 09 Apr 2002 15:48:45 +0200, Lisi <[EMAIL PROTECTED]> wrote: > Each record in my table has a unique ID numbe

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
Oh, forget to include that if you only want that one record, use the "LIMIT 1" keyword as well. Adam Voigt [EMAIL PROTECTED] P.S.: All of this is in the MySQL manual. On Tue, 09 Apr 2002 15:48:45 +0200, Lisi <[EMAIL PROTECTED]> wrote: > Each record in my table has a unique

[PHP-DB] PHP tags in a MySQL echo

2002-04-09 Thread Adam Alkins
igure the PHP server is not treating the text as PHP code but regular text, because its just simple lines which include() other php files. Is there any way to work around this and get it to treat all the echoed rows as PHP not just only text? Adam -- PHP Database Mailing List (http://www.php.net

[PHP-DB] PHP tips to make your life easier

2002-04-24 Thread Adam Royle
url.php"); function go($URL){ header ("Location: $URL"); exit(); } So you see, these functions aren't big, and they don't have to be, but it cleans things up a bit and makes your code more readable... And as a huge bonus, a lot of your syntax errors/sp

[PHP-DB] Re: Upcoming event script

2002-05-12 Thread Adam Royle
Should be something like so... "SELECT text FROM events WHERE date < now() SORT BY date DESC LIMIT 1" That should work. Adam

[PHP-DB] Re: query

2002-05-13 Thread Adam Royle
Not sure if you received this previously. Try this query below. Adam. $query = mysql_query("SELECT * from 150bk where Signature like '%1' and 150bk.ID ='$rec_id' limit 1");

[PHP-DB] Re: Adding totals

2002-05-20 Thread Adam Royle
This should be it (if I am understanding you correctly). Adam $strSQL = "SELECT SUM(columnName) as sum FROM tblName"; $result = mysql_query($strSQL); while ($row = mysql_fetch_array($result)){ $total = $row["sum"]; } Hi all, Is there

[PHP-DB] Re: db sql issue from var

2002-05-26 Thread Adam Royle
Hi Dave, Load the data from the text file into a variable (eg, $fileContents) Then split the file into an array and run every sql statement. The following code should work... Adam $arrSQL = explode(";",$fileContents); for ($i=0;$i

Re: [PHP-DB] new pair of eyes

2002-05-31 Thread Adam Royle
you can just modify the functions to suit your DB, or you can add and delete things inside the functions for your own setup. Adam / DEFINE CONSTANTS / // Connecting to a database define( "DB_SERVER" , "localhost" ); // used for dbCo

[PHP-DB] sql and week starting ending numbers (dates)

2002-06-01 Thread Adam Royle
like it to say "January 12 - 19 2002 $0" or something like that. Below is my table schema for the above query Adam CREATE TABLE tblCashflow ( ID bigint(20) NOT NULL auto_increment, purchaseDate date default NULL, categoryID_FK tinyint(4) default NULL, itemName

[PHP-DB] Re: SQL Troubles with JOIN, GROUP BY and MAX???

2002-06-04 Thread Adam Royle
I think this is something like you would want... Adam SELECT users.id, username, MAX(stamp) as stamp, filename FROM users, files WHERE users.id = userid GROUP BY username -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Having trouble understanding how to manage arrays

2002-06-10 Thread Adam Royle
ation. Adam ">

Re: [PHP-DB] MySQL Clustering, redundancy

2002-06-18 Thread Adam Voigt
e you must take account of this in your code interacting with the server, but the data will be sync'd). Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 08:47, Matt Babineau wrote: > Hi All: > > I quickly skimmed the MySQL manual and didn't see any information on > clus

RE: [PHP-DB] MySQL Clustering, redundancy

2002-06-18 Thread Adam Voigt
fluid" solution I could think of would be an application gateway of some sort which will load balance properly to different IP's while in your code you only point to one. Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 09:12, Matt Babineau wrote: > Thanks for your response Adam!

RE: [PHP-DB] Converting values from text to numerical

2002-06-21 Thread Adam Royle
Hi Matt, I think this might be the answer to your problem. It basically checks if the string is an integer. I generally love the PHP automatic type conversion, but sometimes it can trick ya :) if (intval($val) == $val){ // integer stuff } else { // string stuff } Adam

[PHP-DB] Re: Populating multi-select list from mysql

2002-06-21 Thread Adam Royle
elect("category_list_array[]","categories","","multiple size=10"); And voila... all is done... Need any help... ask Oh yeah, btw everyone else, I have emailed the lib.php file to Bob - if you want a copy, email me. Adam lib.php.zip Description: Zip

[PHP-DB] Re: getting the value of a javascript variable

2002-06-22 Thread Adam Royle
contents of the second drop-down box. There are a few examples around on the net - Google is your friend. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Form not working...

2002-06-26 Thread Adam Royle
What you said (Mike) is mostly correct, although the GetSQLValueString() function in Scott's code automatically puts the quotes around the values if the datatype definition of "text" is passed to the function. Adam -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: remove from db renumbering

2002-06-30 Thread Adam Royle
() LIMIT 1 2. Get all of the ID numbers into an array and pick a random value, then retrieve the rest of the details using the row ID you picked from the array. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: delete multiple records with one query

2002-07-02 Thread Adam Royle
the form field. this will make a comma-delimited string of all your selected ID numbers, and will be available in $name_array your choice adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Refresh after DB Query

2002-07-02 Thread Adam Royle
Sorry if you are a newbie.. but if might help if you delete the records before you select them to display in html ie: put the delete query at the top of the page, just after this line: require ("templates/db_connect.php"); adam

[PHP-DB] Re: Urent please

2002-07-08 Thread Adam Royle
is: window.open("somepage.php?var1=&var2=","theWindow","width=200,height=300"); adam > maybe this is more a javescripy problem...but its related to my php > code: > how can i open a new window with javacript and pass to it php > variables?? > thanks g

Re: [PHP-DB] A Simple Question

2002-07-09 Thread Adam Alkins
graded to that version or greater, but there are always the late ones. Good reading: http://www.php.net/manual/en/language.variables.predefined.php -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] catch warnings?

2002-07-10 Thread Adam Alkins
rity 16) > > How can I catch these warnings in PHP? I believe mssql_get_last_message() is what you want. -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] A Simple Question

2002-07-10 Thread Adam Royle
rst ) $var2 Array ( [2] => second [3] => third ) You can also have multidimensional arrays, but not associative arrays. But you do have the 255 character limitation (can be a bummer). Adam > Also, as far as limitations go, the following are considerations; > > 1. You ca

Re: [PHP-DB] PHP Security and Code Design

2002-07-10 Thread Adam Alkins
> Anybody working with register globals off already that can clear this up? Yes. URL passed variables are access via the GET method. So page.php?foo=bar is accessed by $_GET['foo'] -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: HELP NEEDED!

2002-07-13 Thread Adam Alkins
{ do_user_exists_stuff(); } -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HELP NEEDED

2002-07-13 Thread Adam Royle
parison like so: if ( $_result ) // 0 = false, 1 = true; { echo "Name was found in the database"; } else { echo "Name was NOT found in the database"; } Hope that helps.. Adam > Hi there > I am having a problem querrying to my database. > I

Re: [PHP-DB] extract data from database into an array

2002-07-13 Thread Adam Alkins
ysql_fetch_assoc) or numeric (mysql_fetch_row). And simply if selecting multiple rows, use a loop while($data = mysql_fetch_array())... -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Select a subset?

2002-07-14 Thread Adam Alkins
of rows in a query, so if you only selected 10 rows, it will return 10. If you want to count all the rows in the table, its best to use the COUNT() function SELECT COUNT(*) FROM table -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.p

Re: [PHP-DB] extract data from database into an array

2002-07-15 Thread Adam Voigt
$query = mysql_query("SELECT whatever FROM whatever;"); while($row = mysql_fetch_array($query)) $construct[] = $row[whatever]; That will give you an array (construct) with position 0 being the first row, position 1 being the second row, and so on. Adam Voigt [EMAIL PROTECTE

Re: [PHP-DB] Keeps prompting to download php page???

2002-07-16 Thread Adam Alkins
Wrong list. This is for Databases. Try the php-install list. -- Adam Alkins http://www.rasadam.com -- -- 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-17 Thread Adam Royle
d be happy to help. Adam

[PHP-DB] To Bo

2002-07-21 Thread Adam Royle
Study these two parts in the manual, and you will know how to do everything you've mentioned (and more). http://www.php.net/manual/en/ref.strings.php http://www.php.net/manual/en/ref.array.php Adam

[PHP-DB] Re: php and javascript?

2002-07-22 Thread Adam Royle
ot;/delete.php?id="+recordID; } } //--> HTH, Adam. > Hi, > > Here is what I wanted to achieve, I want to get a confirmation box pop > up > when user click on the delete link of the webpage(displays the contents > got > from mysql database). I know we can do it in javascript e

  1   2   3   4   >