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

[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

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

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

[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

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

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

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

[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

[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

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

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

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

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

[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

[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

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

[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

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

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

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

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

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

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

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

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

Re: [PHP-DB] Script to control mysql users?

2002-08-29 Thread Adam Williams
read mysql.com's documentation on the GRANT command. Or install phpmyadmin and use that. Adam On Thu, 29 Aug 2002, Leif K-Brooks wrote: I need to add mysql users to some databases, but my dumb control panel (ensim) doesn't seem to have a feature to do that, and I'm

Re: [PHP-DB] This is driving me insane!

2002-08-29 Thread Adam Williams
restart apache Adam On Thu, 29 Aug 2002, James Hatridge wrote: HI all... I'm at my end, would some kind soul please help? I'm working on a database using SuSE 8.0, mysql, and PHP. All the standard installs. I need to use exec, unlink, etc. BUT the durn PHP

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

2002-08-29 Thread Adam Williams
set you to owner of the script and then chmod 700 it Adam On Thu, 29 Aug 2002, Smita Manohar wrote: hii im using php script with mysql. i want to hide the script from the admin or from the person who has privileges to access all the data. bcos i use ftp to upload

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

2002-08-29 Thread Adam Williams
oh yeah duh me, set it 701 Adam On Thu, 29 Aug 2002, Ryan Jameson (USA) wrote: Wouldn't that make php unable to read it as well? Then it is useless as well. Ryan -Original Message- From: Adam Williams [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29

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

Re: [PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread Adam Williams
Thats how its supposed to work. It won't reuse old numbers even after you delete the entire row. Adam On Tue, 27 Aug 2002, simon wrote: Hi Wondering if anybody can help with this: My table has an INT column named 'member_id' which is set to AUTO_INCREMENT

Re: [PHP-DB] Create database

2002-08-27 Thread Adam Williams
the same error, try connecting to mysql from the console with mysql -u user -ppasswd Adam On Tue, 5 Aug 2003, Russell Griechen wrote: Newbie here, With PhpMyAdmin, What is the syntax for create database? I have: $link = mysql_pconnect(hostname, username, password

Re: [PHP-DB] login won't work for Internet Explorer

2002-08-27 Thread Adam Williams
View the source in mozilla, it might just be suppressing the output for whatever reason. Adam On Wed, 28 Aug 2002 [EMAIL PROTECTED] wrote: Hi there, I am experiencing a peculiar problem. I have recently moved a PHP / MySQL driven website I have been developing

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
look at http://www.php.net/manual/en/function.pg-connect.php do you have postgresql starting with the -i paramater so that it is listening on a TCP port? PHP needs this to be able to connect to postgresql. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: Hey everyone

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
In your connect statement, you aren't selecting a password and TCP port to connect to. You made need to specify those. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: Hey everyone, got a problem here. I'm using php4.2.1, postgres 7.2. I'm trying to do a simple

[PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
and insert the array $statement[$counter]? I am at a loss as to what is happening, because if I change the form to submit one variable instead of an array, it works fine. Any idea as to what is happening? Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
I got it to work. I have to put the statement in ifx_prepare right before I call it in the loop. I think its because when I define the statement at the start of the code, $statement[$counter] has not been asigned yet so it sets its value to nothing. Adam -- PHP

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread Adam Williams
use an HTML form. Adam On Mon, 26 Aug 2002, Gerd Ulrich wrote: Hello, I want to build a questionaire where the user is guided through five pages of questions. How can I program PHP that the user gets to the second page after pushing the Submit-Button? My solution

Re: [PHP-DB] full text search and how to underline keyword in results

2002-08-25 Thread Adam Royle
$keywords[$i], although you could figure out a proper regex if you don't want partial words higlighted. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Date Subtraction

2002-08-21 Thread Adam Royle
Use getdate() with mktime() and this is your solution. http://www.php.net/manual/en/function.getdate.php http://www.php.net/manual/en/function.mktime.php Adam

Re: [PHP-DB] default value for date.

2002-08-19 Thread Adam Williams
set a default value that isn't possible (like -99-99 99:99:99) and then have an if statement saying if ( $row[date] == '-99-99 99:99:99' ) { $row[date] = '';} Adam On Mon, 19 Aug 2002, Smita Manohar wrote: i'm using php with mysql. some tables in database have

Re: [PHP-DB] Return Results in Categories - like CNET

2002-08-16 Thread Adam Williams
If your articles are in an SQL database uses the LIMIT clause on your SQL statement. Adam On Fri, 16 Aug 2002, olinux wrote: I would like to allow articles to be searched and returned in grouped categories - similar to cnet.com See example here: http

Re: [PHP-DB] PHP File for adding to database

2002-08-15 Thread Adam Williams
what is the structure of the table that this info will be going into? Paste me the CREATE TABLE command you used to create it. Adam On Thu, 15 Aug 2002, Shoulder to Shoulder Farm wrote: Hi all, How can I make a PHP4 page that will add information to a MySQL database

Re: [PHP-DB] Connecting Linux (PHP) to MS Access database

2002-08-15 Thread Adam Williams
See if this message posted earlier helps you out: http://marc.theaimsgroup.com/?l=php-dbm=102938139730405w=2 Adam On 16 Aug 2002, Osman Omar wrote: Hi, Can I connect/access MS access database from linux ? if can, what software/driver that I need? Now I'm using

<    1   2   3   >