Re: [PHP-DB] Inserting a date in to DATE field

2004-04-22 Thread George Patterson
queries to insert into table set date_field=now() George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Hi I am new to PHP

2004-04-15 Thread George Patterson
On Thu, 15 Apr 2004 14:58:09 -0700 (PDT) andy amol [EMAIL PROTECTED] wrote: Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the

Re: [PHP-DB] Missing Data in Columns

2003-12-10 Thread George Patterson
, medicarerollcall669, hr2passage, estatetaxrepeal, headstartvote444, hudappropsvote453, energyrollcall630 Regards George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Buy beer and smoke at ANY age

2003-11-28 Thread George Patterson
On Fri, 28 Nov 2003 07:28:36 -0800 [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: This is not Spam. You signed up with partner site asking for fake license info. If it is not Spam, it is a good imitation. Can someone un-subscribe this email. Ban godaddy.com could be a good idea as well, as I

Re: [PHP-DB] strings of variables,php, sql

2003-11-24 Thread George Patterson
); therefore the value of shed column will be contained within $row. It can be accessed by either of the two lines below. echo $row[0]; #by numeric index.. echo $row[shed]; #or by column name.. If you wish to find out all the column names and values, try print_r($row); George

Re: [PHP-DB] BBEdit

2003-11-06 Thread George Patterson
=right... George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem

2003-11-05 Thread George Patterson
need the error message... George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Out OF OFFICE...

2003-10-23 Thread George Patterson
the list should err on the side of caution and notify them anyway. I shrug sholdersOh well... George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sessions and MySQL?

2003-10-16 Thread George Patterson
, paste the query text into the mysql command line client. See my alterations to you code below.. Regards George Patterson = ? session_start(); header(Cache-control: private); $_SESSION['salutation'] = $_POST['salutation']; //MySQL connection stuff mysql_query

Re: [PHP-DB] Help with file upload

2003-10-15 Thread George Patterson
or copy the temporary file before the php script ends as the temporary file will not exist afterwards. George Patterson On Thu, 16 Oct 2003 05:20:38 +0100 Bunmi Akinmboni [EMAIL PROTECTED] wrote: Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-13 Thread George Patterson
is that you have carriage returns comming back from the form that you need to parse out. George Patterson --- Dan Brunner [EMAIL PROTECTED] wrote: What is your field length??? Varchar(10)?? You should set the column type to text. Dan On Oct 10, 2003, at 10:27 AM

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Patterson
I haven't used Interbase but could it be show tables;. Just a thought... On Fri, 10 Oct 2003 09:34:49 +0100 (BST) George Georgeus [EMAIL PROTECTED] wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php

Re: [PHP-DB] Problem with uploadscript

2003-10-08 Thread George Patterson
the version of php that you are using as this has changed. Example 18.2 is pretty good for the type of code you need. George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] support to palm db

2003-10-07 Thread George Patterson
the file of a certain extension. There is nothing stopping you from using a file extension of you choice an associating it with php, either in the web server config or the os if you are using the stand alone binary under windows. George Patterson -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] MySQL Very Slow Work.

2003-09-25 Thread George Patterson
that is in the machine that you have install that software. How many records have you got in the database?? We have implemented a project in which queries take 20-30 seconds.. about 1 million records, I think.. George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread George Patterson
meant the PHP manual... It is rather terse, but the functions have been categorised to make it easier to find. See code alteration below. George Patterson Ignatius Hi gang -snipped-- I tried this: $num2edit = $_POST['edit']; $link = mysql_connect($host,$username

Re: [PHP-DB] Search problems... :(

2003-07-13 Thread George Patterson
Marco you have made a typing mistake in $key or $Keys... :-D Remoevd all non essential lines... On Sun, 13 Jul 2003 17:13:03 +0200 Marco Mastrorilli [EMAIL PROTECTED] wrote: $keys = explode ( , $_POST [chiave]); foreach ($Keys as $single_word)

Re: [PHP-DB] MySQL CONNECTION PROblem

2003-06-10 Thread George Patterson
to the mysql server. George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem

2003-06-04 Thread George Patterson
); Change the rest of the code to suit. You could also try adding phpinfo(INFO_VARIABLES); to see what you are really getting from the form. George Patterson On Mon, 5 May 2003 03:06:05 +0300 (Egypt Daylight Time) Ahmed Abdel-Aliem [EMAIL PROTECTED] wrote: hi again, i use php/mysql and i

Re: [PHP-DB] Member login

2003-05-27 Thread George Patterson
, my dear Holmes... :-) Regards George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Modify php.ini setting in code

2003-05-27 Thread George Patterson
, A better solution is to use to relative paths.. :-) eg include(incl/config.php); where incl is the directory that contains the file that you wish to utilise. Regards George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] dynamic forms

2003-04-01 Thread George Patterson
On Tue, 1 Apr 2003 20:21:57 -0600 massimo [EMAIL PROTECTED] wrote: hey everyone, I have this select form which get filled dynamically with all my tables in my database. It depends on which one I choose from the drop down menu, that clicking submit it displays the right table.. now, I need