RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Adam Williams
Apache can execute a file without reading it. Don't believe me? Make a file 701 and then open it in apache. Adam On 29 Aug 2002, Mateus Cordeiro Inssa wrote: Em Qui, 2002-08-29 às 16:05, Adam Williams escreveu: oh yeah duh me, set it 701

RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Adam Williams
I encourage you to create a file whatever.html and set it 701 and then look at it with a browsing by connecting to your webserver. http://server.com/~user/whatever.html will be displayed even though it is 701. I've done it many times. Adam On 29 Aug 2002, Mateus

[PHP-DB] Re: [mysql] freeing resources

2002-09-02 Thread Adam Royle
access from the command line). Adam

Re: [PHP-DB] PHP Editor?

2002-09-06 Thread Adam Williams
1: http://quanta.sourceforge.net/ 2: yes Adam On Fri, 6 Sep 2002, Bryan McLemore wrote: First off, What html/php editor do you guys think is better? Secondly, perhaps a little more relevant to the database part of this. I just want to clarify

Re: [PHP-DB] SQL Query

2002-09-06 Thread Adam Williams
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY Adam On Sat, 7 Sep 2002, Bryan McLemore wrote: Hi Guys I have written this SQL Query : CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address VARCHAR(50), startDate DATE, lastWork DATE, progress INT

Re: [PHP-DB] Apache 2.X and PHP

2002-09-07 Thread Adam Williams
Yes but support is experimental so you may notice strange behavior. Adam On Sat, 7 Sep 2002 [EMAIL PROTECTED] wrote: Is it possible to run Apache 2.X with PHP? Julio Cuz, Jr. [EMAIL PROTECTED] Information Services Riverside Community College mailto:[EMAIL

[PHP-DB] Re: assist with SORT array

2002-09-10 Thread Adam Royle
)) { $rest_array[] = ucwords(stripslashes($row-name)); } And its sorted!!! If you want to check what values an array holds, use a combination of header(Content-Type: text/plain); and print_r($rest_array); Have fun! Adam I have a head scratcher.. prob just a glitch on my side

Re: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Adam Voigt
Umm, the body tag in HTML has an onLoad parameter. So: body bgcolor=black onload=javascript:window.new('url'); That code for the window.new is probably wrong, but that will do it. Adam Voigt [EMAIL PROTECTED] On Tue, 2002-09-10 at 11:20, Aaron Wolski wrote: Hi All, I HOPE

Re: [PHP-DB] php start-stop howto?

2002-09-12 Thread Adam Williams
look in /etc/httpd/conf/httpd.conf when you restart apache (/etc/rc.d/init.d/httpd restart) it restarts php because php is called by apache. Adam On Thu, 12 Sep 2002, Warren Massengill wrote: RedHat Linux 7.2 RPM installation included: PostgreSQL 7.1.3 PHP 4.0.6

Re: [PHP-DB] to determine how much server space left on the webserver?

2002-09-17 Thread Adam Williams
?php exec(df -h); ? On Tue, 17 Sep 2002, Bo wrote: Any ideas of how to write a php script to determine the disk space left in my account at my web server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] to determine how much server space left on the webserver?

2002-09-17 Thread Adam Williams
actually make that system(df -h); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: onnecting to MSSQL database from Linux?

2002-09-17 Thread Adam Williams
He's using microsoft sql server, not mysql. try --with-mssql maybe? Adam On Wed, 18 Sep 2002, Jason Morehouse wrote: It means you haven't compiled mysql support into php. Recompile it using --with-mysql -- Jason Morehouse (jm[@]netconcepts[.]com) Auckland, New

[PHP-DB] Re: password function

2002-09-24 Thread Adam Royle
()); } Then to call it, simply $sql = select password(.$_POST['password'].) AS pword; $result = query($sql); Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mysql vs postgresql

2002-09-24 Thread Adam Alkins
/tim2705.php3 -- Adam Alkins http://www.rasadam.com --

Re: [PHP-DB] Current row of query

2002-09-26 Thread Adam Williams
why not if (!($1%2)) { echo even!; } else { echo odd!; } Adam On Thu, 26 Sep 2002, Brad Bonkoski wrote: oops... I meant: (if $i is odd) ... because $i would be the current index in the array. Brad Bonkoski wrote: why not this? $result = mysql_query(Select

Re: [PHP-DB] Noob questions...

2002-10-02 Thread Adam Williams
search around for phpmyadmin on google Adam On Wed, 2 Oct 2002, Brett Lathrope wrote: Ok, here's my scenario... My Web Host has all Root Admin control over MySQL and PHP configs (but they are setup well no complaints there)...I simply have access to 1 DB (already

Re: [PHP-DB] I need Microsoft SQL Library: mssql70.so

2002-10-02 Thread Adam Voigt
. Adam Voigt [EMAIL PROTECTED] On Wed, 2002-10-02 at 12:48, Leo Hotmail wrote: I've installed Linux Red Hat 7.1 with php 4 and have the this libraries in /usr/lib/php4 pgsql.so ldap.so imap.so but I need Microsoft SQL Library: mssql70.so how can I install it? Leo

[PHP-DB] Advanced search scripts

2002-10-08 Thread Adam Royle
or anything, and this is just for my own research (at this time), but I eventually would like to be able to create a smarter site searching engine. Can anyone give suggestions? or any links to tutorials (or books) I have used regex a little bit before, but not in PHP (only ASP and JavaScript). Adam

Re: [PHP-DB] Advanced search scripts

2002-10-09 Thread Adam Royle
Well, for this example, you could use mySQL, but really, I would be looking to utilise this on any database. Personally, I don't think this would be database dependent (unless you have other ideas). Adam On Wednesday, October 9, 2002, at 08:46 PM, John W. Holmes wrote: What database

[PHP-DB] Re: Accessing data from next row? (mysql)

2002-10-14 Thread Adam Royle
($result)){ use this: for ($i=0;$icount($arrData);$i++){ $arrThisRow = $arrData[$i]; $arrNextRow = $arrData[$i+1]; } obviously, if you are trying to access a variable which index does not exist, you will need to implement some sort of error checking, etc adam Using mysql, how do I

[PHP-DB] Re: Accessing data from next row? (mysql)

2002-10-14 Thread Adam Royle
Also, if you're not sure how to get the values from $arrThisRow / $arrNextRow: echo $arrThisRow['columnName']; or $arrData[$i]['columnName'] if you want to access it manually without the other two arrays adam On Monday, October 14, 2002, at 06:05 PM, Adam Royle wrote: Create an array

[PHP-DB] .htaccess and db authentication

2002-10-14 Thread Adam Royle
of system before? are there any good resources people know of for this type of thing? Thanks, Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] problem with informix

2002-10-21 Thread Adam Williams
I'd go back to apache 1.3.27 and php-4.2.3 if I were you and see if that fixes your problem. I run Informix, PHP, and Apache on a server and have had no problems. Adam On Mon, 21 Oct 2002, Erwin Speybroeck wrote: Hi, I'm struggling with a problem for quite some time

Re: [PHP-DB] MySQL password protection?

2002-11-07 Thread Adam Voigt
Make the include file (or wherever your page with the pass is) encrypted, see ioncube.com they charge by the amount of code you incrypt, for a simple database include file, I think it would be $1 or less. On Wed, 2002-11-06 at 16:04, William Trappeniers wrote: Hi all I was wondering if it is

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread Adam Voigt
Ok, here's how I do it: =) Delete checkbox's (assuming this is being called recursively, once for each row in the db): input type=checkbox name=delete[] value=$row[id] And on submition: foreach($_POST[delete] AS $row) mysql_query(DELETE FROM tablename WHERE id = '$row';); Adam Voigt

[PHP-DB] Re: Having more than one id in the same field

2002-11-10 Thread Adam Atlas
. Maybe 2 hotels are used instead of one). If I solve my problem this way, do you think that it will be too difficult or 'heavy' to have more than one condition like this in my queries? Do you think of any other way? Thanx in advance Achilles -- Adam Atlas Your mouse has moved. Windows has

Re: [PHP-DB] sql select

2002-11-12 Thread Adam Williams
Have you ran it by hand in MySQL from the command prompt with some test data and gotten an error? Adam On Tue, 12 Nov 2002, Steve Dodkins wrote: if i have a statement $result = mysql_query(SELECT labor_id,labor_ord_no,labor_wkyr,works_orders_part_no,works_orders_qty

Re: [PHP-DB] MySql Update.

2002-11-12 Thread Adam Voigt
with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080

[PHP-DB] Re: Displaying a single picture...

2002-11-12 Thread Adam Royle
?br ?= $title % -- Hope this helps Adam --- Original Message --- I have several thumbnail images spread out in my website. I thought it would be cool to write a single PHP script so that when they click on the thumbnail, the name of the larger pic

[PHP-DB] Re: how to put all rows into an array

2002-11-13 Thread Adam Royle
No built-in function, but this can be handy (i have it inside a getData() function, which also lets me output data in a number of ways) HTH, Adam $sql = SELECT * FROM .; $DB_RESULT = mysql_query($sql); $arrData = array(); $rowCount = 0; while ($r = mysql_fetch_array($DB_RESULT,MYSQL_ASSOC

Re: [PHP-DB] Multiple Inserts with mySQL

2002-11-14 Thread Adam Voigt
/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description

[PHP-DB] php sessions using mysql (or any db)

2002-11-15 Thread Adam Nelson
Cannot get code to work for session management on a database. Does anyone have tips. It appears that the data goes into the table, but I can't get it out. session_start just initializes the data in the value column.: SessionsTable definition ---

Re: [PHP-DB] Fastest, easiest Flatfile DB with PHP

2002-11-18 Thread Adam Voigt
. Anyone ? thanks Teemu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Nelson
Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Friday, November 15, 2002 4:59 PM To: Adam Nelson Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php sessions using mysql (or any db) CREATE TABLE `SessionsTable` ( `SID` varchar(32) NOT NULL default '', This doesn't need to be a varchar

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Nelson
Message- From: Peter Beckman [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 12:01 PM To: Adam Nelson Cc: [EMAIL PROTECTED]; 'Rasmus Lerdorf' Subject: RE: [PHP-DB] php sessions using mysql (or any db) ?php // I got this somewhere. It works. // This code is released

RE: [PHP-DB] php sessions using mysql (or any db)

2002-11-18 Thread Adam Royle
Hi, Just wondering, which is the better method: 1. Using PHP sessions ($_SESSION['var'] = val;) 2. Using mySQL-based sessions (as described in this thread) I know if you're using multiple servers, a DB-based session would be handy. Any comments, anyone? Adam

[PHP-DB] Get Last ID Inserted

2002-11-21 Thread Adam Voigt
Using Microsoft SQL does anyone know how to get the id of the row that you just inserted without clumsily trying to select the id back based on the same criteria of your insert (which might be overlapping)? -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49

Re: [PHP-DB] inserting html into mysql tables

2002-11-21 Thread Adam Voigt
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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

Re: [PHP-DB] Re: Get Last ID Inserted

2002-11-21 Thread Adam Voigt
PGP SIGNED MESSAGE- Hash: SHA1 Hello Adam On 21 November 2002 at 10:47:15 -0500 (which was 15:47 where I live) Adam Voigt wrote Using Microsoft SQL does anyone know how to get the id of the row that you just inserted without clumsily trying to select the id back based on the same

Re: [PHP-DB] Re: Get Last ID Inserted

2002-11-21 Thread Adam Voigt
Ahh, thanks very much. On Thu, 2002-11-21 at 12:08, David Elliott wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Adam On 21 November 2002 at 11:12:46 -0500 (which was 16:12 where I live) Adam Voigt rearranged electrons to get But if there are heavy operations on the site

RE: [PHP-DB] Check data exists in MySQL

2002-11-21 Thread Adam Royle
Sorry about previous post (some stupid shortcut key made it send) Your row: $sql = INSERT INTO count VALUES('$dept', '$deptsub', '0'); should be: $sql = INSERT INTO count VALUES('$dept', '$deptsub', '0'); You missed the double quotes. Adam --- Original Message --- Hi, for some reason

[PHP-DB] MySQL/PHP Iterative Tree

2002-11-26 Thread Adam Voigt
sublevel's as there might be (infinite). Am I missing something, is there a simple logical way to do this recursively? Or if there's a semi-complex way, anyone got a script example? I'd very much appreciate it. -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080

Re: [PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-26 Thread Adam Voigt
/unsub.php -- 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

Re: [PHP-DB] Resource id #2

2002-11-26 Thread Adam Voigt
_ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http

Re: [PHP-DB] Connecting to MS SQL 7

2002-11-27 Thread Adam Voigt
Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Adam Voigt
: http://www.php.net/unsub.php -- 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

Re: [PHP-DB] PHP4, Apache 1.3.x, and mod ssl install document?

2002-11-27 Thread Adam Voigt
/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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

Re: [PHP-DB] Resource id #2

2002-11-27 Thread Adam Voigt
), but a statement that simply has a variable name doesn't DO anything. Should these have echos in front of them? --- Adam Voigt [EMAIL PROTECTED] wrote: Umm, he is putting them into an array, I quote: while ($row = mysql_fetch_array($result)) { $row['Books.Title']; $row

Re: [PHP-DB] Refining my search app..

2002-12-02 Thread Adam Voigt
A little cleaner: switch($_POST[column]) { case(foo):$query = mysql_query(WHATVER);break; case(too):$query = mysql_query(BLAH);break; default:$query = mysql_query(DOH);break; } while($row = mysql_fetch_array($query)) { // DO SOMETHING } -- Adam Voigt ([EMAIL PROTECTED

Re: [PHP-DB] Return 1 instance of each unique record?

2002-12-06 Thread Adam Williams
use GROUP BY field Adam On Fri, 6 Dec 2002, Doug Coning wrote: Hi everyone: How do I get MySQL to summarize a query so that I receive only 1 instance per similar record. I.E. if you have 10 records with name Smith and 5 records with Barney, etc, that it would

[PHP-DB] Re: Check Automaticaly

2002-12-08 Thread Adam Royle
of #2 (i would image), is the explorer icon will be constantly loading a page, so if you click stop, the game will cease hope that helps adam

Re: [PHP-DB] passing variables

2002-12-09 Thread Adam Williams
www.php.net/isset if !isset($var) { echo var is not set to anything; } else { echo var is set to $var; } On Mon, 9 Dec 2002, Edward Peloke wrote: Hello all, I have a login/register screen for my php/mysql db. When the page opens, the user sees the log in screen but I have a button and

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
can your main workstation ping 192.168.1.1 On Mon, 9 Dec 2002, Alex Francis wrote: At last I have Apache and PHP running on my server. My server IP is 192.168.1.1 and I have set ServerName 192.168.1.1 in my httpd.conf file. I can access my test files from the server using either

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
can you ping your router? is it filtering ICMP? can you ping anything? is your cat 5 cable crimped properly and you have link lights on your switch/hub/router and network card? Adam On Mon, 9 Dec 2002, Alex Francis wrote: It seems like a network problem. I can access

RE: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
:) Adam On Mon, 9 Dec 2002, Gene Dymarskiy wrote: I am a bit confused. Your WS is connected to cable modem and gets public IP assigned by your ISP. Your WS is also connected to a hub shared with your web server. does it mean you have two network cards, one connected

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
what you need to do is have 1 nic going directly to your cable modem using a cross over cable, and then with the 2nd NIC in your WS plug it into the hub along with the web server box, or ditch the hub and connect the WS to the web server with a cross over cable. Adam

[PHP-DB] Re: Delay Confirmation....

2002-12-09 Thread Adam Royle
Use: set_time_limit(0); // let script run forever Have a look at output control functions, particularly: ob_start(); ob_flush(); They might help you Adam --- Original Message --- Hi, I'm still new in PHP..., I have some problem in using sleep() function. Actually, I want to make a script

[PHP-DB] MSSQL Text Length Restriction

2002-12-10 Thread Adam Voigt
I can't seem to get more then 255 characters to be sent back from a field in our MSSQL database, unless the fields is a TEXT type, which is very inefficient. Anyone know a fix? (I've already tried modifying the max size variables in the php.ini under the MSSQL section.) -- Adam Voigt

RE: [PHP-DB] MSSQL Text Length Restriction

2002-12-10 Thread Adam Voigt
Adam Voigt adam@cryptoco To: Hutchins, Richard [EMAIL PROTECTED

RE: [PHP-DB] MSSQL Text Length Restriction

2002-12-10 Thread Adam Voigt
Uncommented, and set to the max value (2147483647). No effect. On Tue, 2002-12-10 at 10:57, [EMAIL PROTECTED] wrote: Adam. are these lines uncommented in your php.ini? They are under [MSSQL] ; Valid range 0 - 2147483647. Default = 4096

Re: [PHP-DB] bulk miorting rows into mysql db

2002-12-13 Thread Adam Williams
use mysqlimport, its a program that comes with MySQL. go to www.mysql.com and click on documentation to learn more about it. Adam On Fri, 13 Dec 2002, mikek wrote: I have a few hundred rows of data to import into a mysql db. Its currently tab separated. What's

Re: [PHP-DB] Get error message, need help

2002-12-16 Thread Adam Voigt
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080

Re: [PHP-DB] keyword search a mysql database.

2002-12-18 Thread Adam Voigt
/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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: Finding zipcode within radius of another zipcode.

2002-12-25 Thread Adam Royle
There are databases / packages you can buy which already have this information in them. A simple search for 'purchase postcode database' on Google gave me a few leads. Adam Hi folks, I'm building a PHP/MySQL database for a customer. It's an advanced mailing list for a band. They want

Re: [PHP-DB] Help with FTP

2002-12-27 Thread Adam Williams
use system() to run /bin/df depending on the OS you might need to add a flag to it like -h (linux) or -k (solaris). www.php.net/system Adam On Fri, 27 Dec 2002, Dankshit wrote: Is there a way to see how much space is left in a ftp server? thanks in advance

[PHP-DB] Re: File Upload ---Thanks!

2003-01-07 Thread Adam Royle
Yep. Been using Mac OS X (10.1 - 10.2.3) with mySQL no problems. I built it from source first time, but now I just use Mac OS X packages from Mark Liyanage. You can find them here. Also he has a good pre-compiled PHP4 you can download and use. http://www.entropy.ch/software/MacOSx/mysql/ Adam

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

2003-01-10 Thread Adam Royle
Just use a combination of mysql_errno() and mysql_error(): echo mysql_errno() . : . mysql_error(). \n; Adam PS. Documentation always rocks! Hi guys, I've been playing with PHP for a while now, and love the mysql functions, but there's one thing I'd like to know... I want to check

Re: [PHP-DB] data move

2003-01-13 Thread Adam Voigt
://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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

Re: [PHP-DB] javascript and submitting forms

2003-01-14 Thread Adam Royle
Hi Mignon, This should work, never closing the window without submitting (foolproof). Just add some error checking, and you'll be sweet as a nut! All I did was add the echo statement underneath the data insert. Adam ? include ('dbconn.php'); if(isset($submit)) { $query = INSERT

RE: [PHP-DB] Send mail with a file

2003-01-16 Thread Adam Voigt
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc

[PHP-DB] Re: Email to a list of address in your database.

2003-01-19 Thread Adam Royle
This should work. You were on the right track, although you might want to use better var names so you don't get confused. You can see I have changed them to what I would normally use. Adam ?php $sql = select * from users; $result = mysql_query($sql, $connection) or die(Couldn't execute

[PHP-DB] Re: Using strlen and substr to Shorten DB Results

2003-01-26 Thread Adam Royle
Try this. PHP arrays are cool! Of course there are tidier ways to implement this, but this is just an example. Adam -- Code -- $getscname = mysql_query(SELECT * FROM subcat WHERE subcatid = '$subcatid') or die (Couldn't get the info.br.mysql_error()); while($sub_cat = mysql_fetch_array

[PHP-DB] Re: Images-weird!!

2003-02-02 Thread Adam Royle
Hi Mihai, Didn't try your code, but noticed your comment on colours. RBG values go from 0 - 255, not 1 - 256, so this may be your problem. Adam

Re: [PHP-DB] Date format in MySQL

2003-02-03 Thread Adam Voigt
Lisa Rubanowicz CNH Ireland Tel: +353 46 77663 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc

Re: [PHP-DB] Storing iterated results into various variables

2003-02-04 Thread Adam Voigt
://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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

RE: [PHP-DB] A little JOIN help please...

2003-02-04 Thread Adam Royle
and characters. Adam

RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Adam Voigt
, visit: http://www.php.net/unsub.php -- 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

RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Adam Voigt
are used. But in the WWW arena, you just don't know what clients are going to be used. -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:25 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

Re: [PHP-DB]

2003-02-12 Thread Adam Voigt
tel.: 2108256721 - 2108256722 fax: 2108256712 email: [EMAIL PROTECTED] http://www.qbit.gr -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description

[PHP-DB] Re: Web Page Caching

2003-02-16 Thread Adam Royle
to people out there who may not have much programming experience - try doing all of your server-side processing (or at least db and filesystem calls, etc) before you output any data, this way you can implement error checking etc and still use the header() function, etc. Adam --- Original Message

[PHP-DB] Re: Recordsets and associative arrays

2003-02-17 Thread Adam Royle
]['Name'] = 'Name 1'; $data[0]['Address'] = 'Address1'; $data[0]['City'] = 'City1'; $data[1]['Name'] = 'Name 2'; $data[1]['Address'] = 'Address2'; $data[1]['City'] = 'City2'; $data[2]['Name'] = 'Name 3'; $data[2]['Address'] = 'Address3'; $data[2]['City'] = 'City3'; etc etc HTH Adam - Original

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

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Adam Voigt
Well if you do, (sort by id) this will work. On Wed, 2003-02-19 at 11:14, Noam Giladi wrote: i'm not using a fixed sort tnx noam Adam Voigt [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Assuming your sorting by id, just do

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

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

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

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

<    1   2   3   >