RE: [PHP-DB] Update errors

Shouldn't have a comma after cat_name = '$cat_name' unless you are updating multiple fields. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Alawi shekh albaity [mailto

RE: [PHP-DB] Processing Page

to display the page. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Aspire Something [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 1:49 PM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] Newbie Question - PHP and MSACCESS

//Place your request into a variable: $result = odbc_do($connection,select * from events where id=$id); $var = odbc_fetch_row($result); // Now you have an array to work on foreach($var as $line){ //Do your formatting thusly: echo ' trtd' . $line[0] . '?td

RE: [PHP-DB] dump data, and save as a file

Header(Content-type: text/plain); Header(Content-Disposition: attachment; filename=topsellers_dvd.csv); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com Hi everyone, I want to dump some data from mysql

RE: [PHP-DB] MySQL problem -- new to PHP

If you cut and pasted your code, try to put localhost into quotes as well. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] Code for drop down lists

'; ## CAVEATS: The get_rowset is a function we've written for retrieving an array from the DB The if $val == $reptmp is to check for whatshould be selected Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto

RE: [PHP-DB] Getting array values into a query

, but the secret its the $$foo (with two $ signs) If $foo = 'aname' then $$foo = $aname The get_rowset is a function I've written to symplify my code, it returns rows in an array from the DB Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http

RE: [PHP-DB] function needed

Use str_replace $FQDN = www.domain.com $domain_only = str_replace(array('www.','.com','.mil','.edu','.org','.gov'),'',$FQDN); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From

RE: [PHP-DB] denying access to folders/files

Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com This is fine and dandy, but how do I prevent that person from taking the direct link to the file and giving it to someone else? I'm sure there is a much better

RE: [PHP-DB] More linking problems but slightly OT

Be sure to add http:// to the beginning of your URL, or the browser thinks it is a local URL Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: George Pitcher [mailto:[EMAIL

RE: [PHP-DB] real time output

Check out the flush() and ob_flush commands on www.php.net Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Art Chevalier [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17

RE: [PHP-DB] Calendar

Check out http://www.hotscripts.com and click on PHP, then Calendars Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:gary.every;ingramentertainment.com http://accessingram.com -Original Message- From: Joran [mailto:joran.sorbo;teleweb.no

RE: [PHP-DB] securing directory tree and allowing PHP to work

Look into the PHP_AUTH_USER variable. It is assigned through basic authentication. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: bmw [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] fiscal week??

Week (01..53), where Sunday is the first day of the week. Used with '%X' %v Week (01..53), where Monday is the first day of the week. Used with '%x' Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com

RE: [PHP-DB] encode/decode

actually a variable that contains ENCODE($_POST[password], encrypt) When you try to decode that, you'll get gobble-di-gook! Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Lisi

RE: [PHP-DB] header function

You'll have to get rid of ALL html, including the BR in your code below. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Mohammad Forouhar-Fard [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] Select a subset?

I think the paging function is what you want SELECT * from table limit 0,10 for the first ten records SELECT * from table limit 11,20 for the next ten, etc. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com

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

Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT

RE: [PHP-DB] E-mail address verification

I do it like this: if (eregi(^[a-z0-9]+([\.%!][_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$, $email)) { list($user, $host) = explode(, $email); if ( !checkdnsrr($host, MX) ) return TRUE; } else { return FALSE; } } As you can see, the email can

RE: [PHP-DB] date format display

/en/function.date.php You'll really want to read the page about the date function. The options for formatting your date output are just about limitless. Gary Pullis Office Management Technologies http://www.omt.cc -Original Message- From: fabrizio [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] MySQL won't return results to screen.

Do you have SELECT permissions for your httpd user on the DB? Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Blaine Dinsmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07

RE: [PHP-DB] cookies and Global variables

, and make sure that the header info is the first thing sent. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Dib, Walid (MED, Stagiaire GEMS) [mailto:[EMAIL PROTECTED]] Sent: Thursday

RE: [PHP-DB] query

Instead of use != Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:06 AM To: [EMAIL PROTECTED

[PHP-DB] DB Class pointer as var in another class

; $this-db_class = new database_class(DB_NAME); } function get_db_info() { ... use db here via $this-db_class ... } } Thanks, Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DB Class pointer as var in another class

I'll have to re-think extending the class with our database class. In the past they may not have worked well. Admittedly, our classes were written poorly. But, now that we're massively redesigning, that may work very well. Thanks for getting my brain-juices flowing again. Gary Gurhan Ozen

[PHP-DB] Dealing with Quotation marks

quotation marks. Is there a function to handle this? Any help would be appreciated. Thanks, Gary -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Probably an easy question - blank search fields (PHP MySQL)

or just putting % before whatever is sent? (this shouldn't mess up what's being entered, surely?) Thanks for any help. -- Gary Smith E: [EMAIL PROTECTED] W: http://www.l33t-d00d.co.uk Pics: http://photos.l33t-d00d.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] pulling images from a database

If you want to be efficient, store only the image metadata in the database (path, filename, creator, date, dimentions, format, etc) in the database. Keep the actual data as a file. -- Regards, Gary SuperID Huntress === FreeSQL.org offering

RE: [PHP-DB] image upload - mime types??

Don't trust file extensions. Use getimagesize() to examine the file. $imginfo = getimagesize($uploadfile); switch ($imginfo[2]) { case 1: // gif case 2: // jpg case 3: // png case 4: // swf default: // not an image } -Original Message- From: Jens Nedal [mailto:[EMAIL

[PHP-DB] Heterogeneous queries with mssql

from SCOPE() where contains(contents, ''unix'') ' ) as R, CONTSUPP as CS WHERE (CS.Address1=R.Path and CS.RecType='L') order by R.Rank Desc Thanks muchly! Gary Pullis Supporting: Sage MAS90/MAS200 | Linux | Windows NT | Novell Netware Office Management

Re: [PHP-DB] MySQL transactions?

a common question. This might help http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html #Missing_Transactions -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers

Re: [PHP-DB] Query with Access

I'd try adding: $conn = odbc_connect("pruebas_php", "", "") or die("cannot connect to pruebas_php"); $resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM Personas") or die ("cannot

Re: [PHP-DB] select data from a drop down box in a form

There are probably a million ways to do this... here is one :) (note that the file should be named "fieldtest.php" -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to d

Re: [PHP-DB] Yet more strings

o fix the data in the database, but barring that you can probably use the TRIM() function in your where clause. (note: the MySQL docs show using trim in the output, not in the where clause so I won't swear that its possible, but it should be) Regards, Gary ""Mick Lloyd"" [EMAIL

Re: [PHP-DB] problems configuring php and postgres - FIXED

My thanks to everyone who provided me info and other hints/tips. The vast majority of the problem was human error of course, sprinkling in a few bad assumptions and some configuration problems...its amazing I got it working at allbut it is :) Thanks again to everyone. Gary "Rasmus Le

[PHP-DB] Free MySQL Database Hosting (beta! beta! beta!)

Hi, I'm testing out the concept of offering free MySQL database hosting. Feel free to create a database at http://superid.dyndns.org:8080/freesql/index.php There's no catch, or hidden agenda. I thought it might be fun to try and offer this as a service to people who might be learning

[PHP-DB] problems configuring php and postgres - call to undefined function

ned function". Any thoughts? I'm pretty much out of ideas right now. Regards, Gary Huntress -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

<    1   2