Re: [PHP-DB] PHP/Mysql Script help.

2003-06-05 Thread Jason Wong
formatted code that php doesn't even attempt to run. Check that each open , ', [, (, { has a corresponding closing counterpart and each of your php statements (~lines) are terminated with a semi-colon (;). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Offering alternatives in typing mistakes

2003-04-04 Thread Jason Wong
solution, like taking the middle? I've already put some thought in it, but I see no reason to reinvent the wheel again. Has anybody any better ideas? I'm open to solutions. If you're going to be running on some *nix platform then have a look at the chapter on pspell. -- Jason Wong - Gremlins

Re: [PHP-DB] Re-ordering items

2003-04-03 Thread Jason Wong
to create a linked list. The fields will hold the previous and next records in the list I'll leave you to work out the implementation details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Php Thumbnail Gallery

2003-03-31 Thread Jason Wong
a bundled GD library there may not be much incentive for people write one. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-30 Thread Jason Wong
On Sunday 30 March 2003 11:11, Bruce Feist wrote: I wonder why the PHP/MySql interface doesn't simply return dates as dates instead of strings. *frowns* How do you mean? PHP doesn't have a date type. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] PHP and MySQL 4

2003-03-30 Thread Jason Wong
On Monday 31 March 2003 04:46, Benjamin Higgins wrote: Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP with --with-mysql, is that sufficient to get MySQL 4 support? Yes. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] An interesting Apache Log to MySql ?

2003-03-29 Thread Jason Wong
On Saturday 29 March 2003 22:25, Dave Carrera wrote: I have been trying to find a way to write Apache Log data to a MySql db via a pipe log directive. Search the archives, a solution was presented in the past few days. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] Setting up arrays from queries

2003-03-24 Thread Jason Wong
, UPDATE, DELETE queries 3) If you want an associated array use mysql_fetch_assoc() -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] mail() function

2003-03-24 Thread Jason Wong
webserver) then leave it as 'localhost'. Otherwise do what I originally suggested and use an upstream SMTP server (probably provided by your ISP). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] mail() function

2003-03-21 Thread Jason Wong
sadflkjaflkasdj; } 1) Check that php.ini is correctly configured 2) Check the php error log 3) Check your mailserver log -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] mail() function

2003-03-21 Thread Jason Wong
in sending mail :) If you're running on some Windows system you can try specifying the SMTP server provided by your ISP. Otherwise google is your friend. If you're running some *nix system then they usually come with the ubiquitous sendmail. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] transfer files that doesent exists

2003-03-16 Thread Jason Wong
know how to do that ?? If i did'nt explain right please let me know You can have tar _extract_ an archive onto stdout. But I don't think you can _create_ an archive and have it go to stdout. So you would _have_ to create a temporary file and delete it when you're finished with it. -- Jason

Re: [PHP-DB] newsletter optimization help needed

2003-03-12 Thread Jason Wong
. but for the life of me I can't think straight right now :-( The easiest method is to stick them all into an array then implode them using a comma as the delimiter. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: Fwd: Re: [PHP-DB] need help with foreach()

2003-03-10 Thread Jason Wong
. } $query = SELECT * FROM Rota WHERE date = $start and date = ($start + INTERVAL 6 DAY) ; $result = mysql_query($query); while ($row = mysql_fetch_array($result)){ $date = $row[Date]; Again, see above comments. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] PHP to mysql to email

2003-03-09 Thread Jason Wong
that the email bounced email matches? Search archives (php-general) for mail bounce or mailing list bounce or similar. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] need help with foreach()

2003-03-09 Thread Jason Wong
you're at it do a var_dump($tips) as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] data insert in textfile

2003-03-06 Thread Jason Wong
On Friday 07 March 2003 13:59, Ramesh PAtel wrote: I am working on PHP and PostgreSQL. I want to insert output of my Query in textfile. so how to open file and insert data one by one in textfile. fwrite(), see manual for details and example. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] php and local printing

2003-03-05 Thread Jason Wong
file which on server I can print using lp filename. Similar thing but without any print dialogue box at the client end. Exactly, this is a client-side problem (Javascript, ActiveX/script, etc). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] A-Z Listings

2003-03-02 Thread Jason Wong
On Tuesday 18 February 2003 05:46, Andy wrote: Hi There., I have a script that lists directorys then how many files are in each. although it won't list in an A-Z format, would anyone know how i would do this? Read all the filenames into an array then use asort(). -- Jason Wong - Gremlins

Re: [PHP-DB] Update errors

2003-02-27 Thread Jason Wong
near 'WHERE cat_id = 2 ' at line 4 Db : mysql -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] Array key problem

2003-02-25 Thread Jason Wong
in the array named something the code will print the key 0 PHP is doing automatic type conversion for you. Use: if ($key === something { ... } instead. See manual for details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Jason Wong
the space or has extremely high turnover of deleted records, this makes sesne. Better still, setup parallel tables and move deleted records over. That way you'll save cluttering up the main tables. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] problem in PHP with ADODB connection, Microsoft JET Database

2003-02-19 Thread Jason Wong
. - The error is quite explicit: Syntax error in FROM clause So unless the Jet Engine is lying or is buggy then you have an incorrectly formed query. can anyone help me? Nobody can help you unless you post your query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software

Re: [PHP-DB] Submitted information not being displayed

2003-02-19 Thread Jason Wong
]); $Array[id_num] = trim ($Array[id_num]); $Array[Email] = trim ($Array[Email]); Use print_r($_POST) to show all the values POSTed from your form. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Auto Generation of HTML Forms + SQL Code to update My/Postgre SQL Database

2003-02-19 Thread Jason Wong
products etc... I'm trying to quicken my development cycle. freshmeat.net and search for mysql forms -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] [Import text file]

2003-02-13 Thread Jason Wong
the question. Real email clients gives you multiple response methods -- reply to sender; reply to list; reply to all; bounce; redirect etc -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] crypt help

2003-02-12 Thread Jason Wong
On Thursday 13 February 2003 04:33, Zach Davis wrote: However, I've noticed that if anything past the 8th character in the password is irrelevant. That is clearly explained in the manual. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] Using CURDATE, DATE_SUB and DATE_ADD

2003-02-10 Thread Jason Wong
you expect them to contain. And also you could consider using BETWEEN instead of the less-than and greater-than comparisons. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Is my Hosting service full of it?

2003-02-10 Thread Jason Wong
run a monitor while testing your code locally, you'll be able to pinpoint precisely what causes the recources to be chewed up. There is something called mysqltop. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] access mysql db with DW

2003-02-08 Thread Jason Wong
hp?email=.HTTP_POST_VARS[email].; should be $insertGoTo = booking_details.php?email=$HTTP_POST_VARS[email].; For people wondering _why_ it works like a charm the correct statement should in fact be: $insertGoTo = booking_details.php?email=.$HTTP_POST_VARS[email].; -- Jason Wong - Gremlins As

Re: [PHP-DB] foreach problem

2003-02-07 Thread Jason Wong
foreach database query.); } $event_date is an array with several dates separated by commas. (2003-10-02, 2003-10-03). The code above successfuly inserts the first dae in the array, but none of the others... am I missing something? Any error messages? If so what does mysql_error() say? -- Jason

Re: [PHP-DB] foreach problem

2003-02-07 Thread Jason Wong
is an array with several dates separated by commas. (2003-10-02, 2003-10-03). The code above successfuly inserts the first Could you explain what exactly $event_date contains? The output of print_r($event_date) would suffice. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

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

2003-02-07 Thread Jason Wong
the values I want in the session through a query on the previous script and call it directly to the function I want to use? Please post your code. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] vaiable from one page to another

2003-02-05 Thread Jason Wong
of the variable in another php program. butit is not getting. one our friend told to put like echo $_post(fname) but it is also not working. now getting the error about post array. so what to do. manual A simple tutorial manual Variables Variables from outside PHP -- Jason Wong - Gremlins

Re: [PHP-DB] Argh ! array help required :(

2003-02-05 Thread Jason Wong
)) { $prod_search .= ,; } } $prod_search .= ); Can anyone see where I am going wrong? $doo = array('dah', 'dee', 'dib'); $doo = in (' . implode(', ', $doo) . '); echo $doo; -- Jason Wong - Gremlins Associates - www.gremlins.biz

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

2003-02-04 Thread Jason Wong
with HTMLs (kind of template) and by means of Php tags I can echo these variables where needed. What exactly are you having problems with? What is your code so far? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] How activate the support for MySQL?

2003-02-04 Thread Jason Wong
for Call to undefined function mysql_connect will probably cover all the common cases. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] UPDATE doesn't work

2003-02-04 Thread Jason Wong
-- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] inserting datas through table

2003-02-04 Thread Jason Wong
On Wednesday 05 February 2003 15:03, kumar wrote: (B (B I have created reservation table i need to store all the values in (B database when i click the submit button (B but it couldn`t working. (B (BCould you give a detailed description of HOW it isn't working? (B (BWhat did you

Re: [PHP-DB] Help!

2003-02-03 Thread Jason Wong
for the function in question to see which configure option/switch you need to compile that function into PHP. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] variable conversion

2003-01-31 Thread Jason Wong
that value i did like: ?php echo($fname); ? where fname is the text box name of the previos page. but it is not coming. what should i do. help me.. Have you tried reading the manual? The chapter A simple tutorial? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] - Update help

2003-01-31 Thread Jason Wong
with 4.0.6 you really should be using a newer version. If you really do need 4.0.6 then check the archives on how to use the patch. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Is there a Php MySql Scripting Tool or Gui ??

2003-01-31 Thread Jason Wong
on this project. http://freshmeat.net search for mysql forms -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you

Re: [PHP-DB] check box help

2003-01-31 Thread Jason Wong
trying for hours. You mentioned printing out Globals or something. I am relatively new to this, so I don't really know how to do that. I would really appreciate more help. Thanks. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

Re: [PHP-DB] check box help

2003-01-30 Thread Jason Wong
That should be: ... name='CheckBox[$counter]' ... -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* 1 1 was a race-horse, 2 2 was 1 2. When 1 1 1 1 race, 2 2 1 1 2. */ -- PHP

Re: [PHP-DB] upload time out

2003-01-29 Thread Jason Wong
files then things will fly Remember HTTP uploads doesn't allow you to resume transfer. Thus if a file was 99% uploaded and an error occurs you have a very unhappy user ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] really stumped!

2003-01-28 Thread Jason Wong
someone else's code. There are plenty of classes at www.phpclasses.org which builds and verifies forms for you. Also searching freshmeat.net for mysql forms should be rewarding. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-28 Thread Jason Wong
inspection so that whatever port was used to initiate the connection with mysql should be allowed through. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We're all

Re: [PHP-DB] empty query

2003-01-26 Thread Jason Wong
of a button and Submit Your Ad is it's value? As it is part of the form and you're programmatically (or indiscriminately) extracting everything from $_POST (or equivalent) then that is why you end up with it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] dates and updates recommendation?

2003-01-26 Thread Jason Wong
date functions). If your date stuff will mostly be done in PHP then use unix timestamps. On the whole I would stick to a DBMS native date format because: - it's human readable - built-in date functions - not limited to post epoch dates -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] empty query

2003-01-26 Thread Jason Wong
the contents of $formdata into your database. If that code is properly written then the presence (or otherwise) of next_ should not affect its operation. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] empty query

2003-01-25 Thread Jason Wong
$formdata is empty?? If it is, where are you getting $formdata from? [snip] $result = mysql_query($query) or die (Couldn't execute query.); Don't use die(), use: $result = mysql_query($query) or echo Couldn't execute query. . mysql_error(); -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Array trouble

2003-01-24 Thread Jason Wong
. Considering all of the columns exist, I think the problem just has to do with how I am pulling the array values out and placing them into their column. Any help would be appreciated. Thanks in advance, Please post your code and DB schema. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] While + Function

2003-01-23 Thread Jason Wong
) { do_insert_row; } while ($row = mysql_fetch_array($result)) { insert_results($row); } -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Joe's sister puts spaghetti

Re: [PHP-DB] posting field_DATE variables

2003-01-22 Thread Jason Wong
to do this. One is: $date = explode('-', '10-01-2003'); $newdate = $date[2] . $date[0] . $date[1]; -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* To err is humor

Re: [PHP-DB] Array Issue help please

2003-01-20 Thread Jason Wong
describe in more detail how your code doesn't behave the way you expected it to behave? So do you see anything at all? What exactly does it do? Error messages? Have you checked the logs? Have you tried echo() on the important variables to see what they contain? -- Jason Wong - Gremlins

Re: [PHP-DB] Getting all rows of a certain column when grouping?

2003-01-18 Thread Jason Wong
that smileys associated with the same image are displayed on the same row. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I'm not the person your mother warned you about... her

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Jason Wong
); if ($result) echo mail sent; } It always print mail sent, but I never got the email. So I was wondering if Mail() request any send mail program to work. Is it a windows server that you're using? SMTP only works for windows. Anything else uses sendmail or equivalent. -- Jason Wong

Re: [PHP-DB] Date math functions...

2003-01-15 Thread Jason Wong
. Any more ideas? Which probably means your $StopDate is 0. What does it actually contain? You really should assign your query to some variable ($query) THEN plug it into your query function. If and you have any problems you can echo $query to see what you're passing to mysql. -- Jason Wong

Re: [PHP-DB] Slashed being added..

2003-01-15 Thread Jason Wong
options in php.ini. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Don't SANFORIZE me!! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] HTML + PHP

2003-01-15 Thread Jason Wong
-- unclosed/unbalanced tags (/td, /tr, /table). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When the going gets tough, the tough go grab a beer. */ -- PHP Database Mailing

Re: [PHP-DB] Arrays and forms

2003-01-14 Thread Jason Wong
do the same for prob[] as well. Having done that then in your example you should get something like: $prob[0]: Problem one $prob[1]: Problem two $level[1]: High $prob[2]: Problem three$level[2]: Low NB that $level[0] is undefined. -- Jason Wong - Gremlins

Re: [PHP-DB] php - mysql connection via Apache

2003-01-13 Thread Jason Wong
a page. Has anyone seen this behavier before ? Yes. I've seen it before. Loads of times. It means your version of php was not compiled with mysql support, or the mysql module was not found. Try searching in the archives for an answer. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Insertion upon upload

2003-01-12 Thread Jason Wong
new to databases then check out some php/database tutorials (there are _plenty_ out there). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Our business is run on trust. We

Re: [PHP-DB] two inserts at once?

2003-01-09 Thread Jason Wong
is a auto increment field, as is id... but it seems I need to know the value of faqid to relate it correctly to the fgNumber... The retrieve faqid use mysql_insert_id(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] which DBMS... MySQL or PostgreSQL

2003-01-09 Thread Jason Wong
). Also google MySQL vs PostgreSQL should be helpful. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It is better to wear out than to rust out. */ -- PHP Database Mailing

Re: [PHP-DB] OR on multiple columns

2003-01-09 Thread Jason Wong
the archives, check the usual script sites (www.hotscripts.com, www.zend.com, www.phpclasses.org etc) for timing classes/functions/etc. Everything runs on my ISP's server. That's not an issue. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] OR on multiple columns

2003-01-08 Thread Jason Wong
a syntax error. Is it not legal to do this? The php-mysql interface does not support multiple queries. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* A handful of friends

Re: [PHP-DB] RE: passing array values in forms

2003-01-06 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Catch a wave and you're sitting on top of the world. -- The Beach Boys */ -- PHP Database Mailing List (http

Re: [PHP-DB] Storing Radio Buttons Checkboxes in MySQL

2003-01-05 Thread Jason Wong
and values have to be different? When it is inserted into the DB it shouldn't matter since the record would not be a duplicate. manual FAQ PHP and HTML -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Progress output

2003-01-04 Thread Jason Wong
-general php-db), it's been covered many times before. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* static buildup */ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] How to seperate the web server and MySQL database server?

2003-01-04 Thread Jason Wong
mysql to allow remote connections (checkout the GRANT command). Also if you have a firewall between the two machines you would naturally have to take that into account. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] more values in a array

2003-01-04 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Life is like a tin of sardines. We're, all of us, looking for the key. -- Beyond the Fringe */ -- PHP

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Jason Wong
writing file './nrlug/home.frm' (Errcode: 28) This is obviously a mysql question. Go to their website and search on the error message. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Jason Wong
On Friday 03 January 2003 17:11, conbud wrote: Jason Wong wrote: On Friday 03 January 2003 17:00, conbud wrote: Hello can someone give me some possible reasons this error happens when I use the mysql client to add a tabe to a database. mysql create table home (id int not null, heading blob

Re: [PHP-DB] Formgenerator?

2003-01-02 Thread Jason Wong
is cool, but doesn´t support a fieldcheck or events after an insert. There is also ImpAkt which supports all the features but it´s nich OpenSource. www.phpclasses.org -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Renaming a file uploaded by a form.

2003-01-01 Thread Jason Wong
to be created by the PHP machine (wild guess) but it looks like this: /var/tmp//phptkYxkV Any ideas on how to get it to look like: filename.doc would be greatly appreciated. RTFM section on Handling file uploads, in your code print_r($_FILES). -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Drawing chart

2003-01-01 Thread Jason Wong
jpgraph -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The longest part of the journey is said to be the passing of the gate. -- Marcus Terentius Varro

Re: [PHP-DB] PHP files and special characters language

2002-12-31 Thread Jason Wong
lang=whatever -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When you die, you lose a very important part of your life. -- Brooke Shields */ -- PHP

Re: [PHP-DB] Serve images from files, or db?

2002-12-31 Thread Jason Wong
the archives. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Life is a concentration camp. You're stuck here and there's no way out and you can only rage impotently against your

Re: [PHP-DB] How to solve T_STRING error?

2002-12-25 Thread Jason Wong
that you have closing braces on the last two IF statements. Are you sure you're looking at the right file? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Promise her anything

Re: [PHP-DB] Select a table inside a db

2002-12-24 Thread Jason Wong
On Wednesday 25 December 2002 00:10, zeroked wrote: Hi I am a newbie to PHP so please help How do I add information into my mysql db? I have a db called sitedb and I want to insert datat into my news table inside my sitedb. Merry Christmas. You forgot to say what the problem is. -- Jason

Re: [PHP-DB] Questions regarding primary keys, updates, and autoincrement

2002-12-22 Thread Jason Wong
application to link tables together. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* This ASEXUAL PIG really BOILS my BLOOD ... He's so ... so ... URGENT!! */ -- PHP Database

Re: [PHP-DB] file upload array problem

2002-12-21 Thread Jason Wong
INTO inventory (registration,type,total_time,price,description,picture_name) VALUES ('{$_POST['registration']}','{$_POST['type']}',...); -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] form validation

2002-12-20 Thread Jason Wong
and validate forms for you. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Qvid me anxivs svm? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Next/Prev 10 lines

2002-12-20 Thread Jason Wong
other day (or so it seems). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Nihilism should commence with oneself. */ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Newbie PHP/MySQL question

2002-12-20 Thread Jason Wong
4.2.3 MySql 3.23 IIS 5.0 My mind reading skills aren't very good, but I think there's something wrong with line 13 of your program. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] PHP/MySQL Problem....

2002-12-19 Thread Jason Wong
If this is an all Redhat RPM installation then install the mysql-php*.rpm as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* If you suspect a man, don't employ him. */ -- PHP

Re: [PHP-DB] pictures into MySQL

2002-12-17 Thread Jason Wong
insert picture into mysql -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It's not an optical illusion, it just looks like one. -- Phil White */ -- PHP

Re: [PHP-DB] login won't log in, HELP

2002-12-17 Thread Jason Wong
, here are a couple of pointers: 1) Bypass the login page, hardcode the login details and see whether that gets you logged in. 2) Use print_r() on your major variables in strategic places in your code to see what's happening to them as they pass through your code. -- Jason Wong - Gremlins

Re: [PHP-DB] random select

2002-12-17 Thread Jason Wong
. I am working off localhost on a WINXP machine. PHP 4.2.2. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Ain't that something what happened today. One of us got traded

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Jason Wong
the random table working. [snip] Anybody see the solution?? First we need to know _what_ the problem is. I think we can assume your code doesn't work the way you expected. Can you tell us _how_ it doesn't work? Error messages? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] random rows...what about tables

2002-12-17 Thread Jason Wong
. There's an example in the manual which shows you how to use mysql_list_tables(). Get that working, _then_ adapt it to return random tables. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] UPDATE tbl problem...

2002-12-14 Thread Jason Wong
you're not testing for it? You should _always_ use something like: mysql_query('...') or die(mysql_error()); Second, the reason why it fails is because you need commas between the items in your SET clause: UPDATE table SET col1 = 'val1', col2 = 'val2' ... -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Typical login script... user problem... :)

2002-12-10 Thread Jason Wong
, $db_pass to see whether they contain what you think they contain. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Persistence in one opinion has never been considered a merit

Re: [PHP-DB] passing variables

2002-12-09 Thread Jason Wong
with the other code but it still loads the form under if (!$login_clients and !$register_clients){ If I use isset it does the same thing. Quickest solution, stick a phpinfo() in the first line your code to see exactly what is and isn't being set. -- Jason Wong - Gremlins Associates

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

2002-12-06 Thread Jason Wong
the choices provided in the while loop from the database. Please let me know what you think. Your table doesn't seem to be closed. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

2002-12-06 Thread Jason Wong
using PHPMyAdmin, minus the var of course, the table is created. When I run it in my code, nothing happens. I do a die($SQL) to see the final outcome of the query and it's correct and is what I am using to run the query in PHPMyAdmin. mysql_error() to see what the problem is. -- Jason Wong

Re: [PHP-DB] php and mysql

2002-12-06 Thread Jason Wong
on the form before they edit it) *change the prices after submission of the form into the mysql database THANKS A LOT, it will really help I bet it will ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Parserproblem by cascading outputscript

2002-12-05 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* FORTUNE PROVIDES QUESTIONS FOR THE GREAT ANSWERS: #15 A: The Royal Canadian Mounted Police. Q: What was the greatest

<    1   2   3   4   5   6   7   >