Re: [PHP-DB] ER diagram class

2004-10-12 Thread Ignatius Reilly
Dezign / MySQL Importer www.datanamic.com HTH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Form action

2004-10-12 Thread Ng Hwee Hwee
hi, i can use Method (1) and include the validation file instead of prepending it to the whole form. then it would centralise my form submission and also does not make my debugging process too messy, right? - Original Message - From: Shahmat Dahlan [EMAIL PROTECTED] To: Ng Hwee Hwee

[PHP-DB] mysql_query

2004-10-12 Thread ballo1
hello, I have a begining question. I've got simple html form and php script, but insert doesn' t work. What is wrong in my insert mysql_query? mysql_query( insert into obiskovalci (ime, priimek, ulica, hstevilka, pstevilka, posta) values('$ime', '$priimek', '$ulica', '$hstevilka',

Re: [PHP-DB] mysql_query

2004-10-12 Thread bbonkosk
1. place your query string into a variable for easy dumping... i.e. $query = insert into obiskovalci (ime, priimek, ulica, hstevilka, pstevilka, posta) values('$ime', '$priimek', '$ulica', '$hstevilka', '$pstevilka', '$posta'); echo $query; (See if there are problems

FW: [PHP-DB] mysql_query

2004-10-12 Thread Darryl
You may have to use $_POST. Like - $ime = $_POST[ime]; Just put the form component name inside the square brackets of the post function to get it to work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 3:44 PM To: [EMAIL PROTECTED]

RE: [PHP-DB] mysql_query

2004-10-12 Thread Murray @ PlanetThoughtful
Hi, Unless you have 'register globals' on, are you retrieving the value of the variables passed by your form from the $_GET or $_POST super variables (whichever is appropriate)? In other words, at the top of the page that is performing your insert query, do you have lines such as: $ime =

Re: [PHP-DB] mysql_query

2004-10-12 Thread Philip Thompson
On Oct 12, 2004, at 7:15 AM, [EMAIL PROTECTED] wrote: hello, I have a begining question. I've got simple html form and php script, but insert doesn' t work. What is wrong in my insert mysql_query? mysql_query( insert into obiskovalci (ime, priimek, ulica, hstevilka, pstevilka, posta)

RE: [PHP-DB] ER diagram class

2004-10-12 Thread Bastien Koert
www.fabforce.net - dbdesigner...great tool and free bastien From: Matthew Perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] ER diagram class Date: Mon, 11 Oct 2004 18:03:11 -0500 Does anyone know a good class or program that automatically generates an ER diagram from all tables in

RE: [PHP-DB] autoresponder

2004-10-12 Thread Bastien Koert
You'd need to parse out the email (or at least the subject of that email) then find a file based on that subject, then email the file...it is possible. I wrote a script to parse out emails, you can find it at weberdev.com in the php examples area (look for my name). hth Bastien From: Kenny

[PHP-DB] folder creation in php

2004-10-12 Thread Adil
Here's what i'm trying to do in php and a mySQL database: I want a button on a page that if clicked it launches the browser's or OS's Save As window, allowing me to specify where to save my file and/or create a new folder thx in advance Adil.. -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Matthew Kiehne
forgive the poor structure of my code, im pretty new at this and havent figured out exactly what it should be formed like to look its best, anyway whenever i run this code it works on inserting new information into the database, however when i want to update the SQL query returns an output like

RE: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Graham Cossey
I'm no 'expert' (opening myself up for much criticism here) but try the following: (I'm assuming you are setting $fid somewhere) if (empty($form_status)) { $staff = $_POST[staff]; $ttlpst = $_POST[ttlpst]; $mnthpst = $_POST[mnthpst]; $ttlicon = $_POST[ttlicon]; $mnthicon =

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Jason Wong
On Wednesday 13 October 2004 04:08, Matthew Kiehne wrote: database, however when i want to update the SQL query returns an output like this 'SQL statement = UPDATE badges (staff,ttlpst,mnthpst,ttlicon,mnthicon) VALUES ('1','1','1','/ribbons','/ribbons') WHERE fid=2' but when i try to pull the

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Matthew Kiehne
sorry this is the output i meant to post SQL statement = UPDATE badges SET staff = '1' ttlpst = '1' mnthpst = '1' ttlicon = '/trophies' mnthicon = '/ribbons' WHERE fid = 61 and this is the error i getyet i still cant for the life of me find a problem Update query = UPDATE badges SET staff =

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Jason Wong
Please do not top-post. On Wednesday 13 October 2004 10:26, Matthew Kiehne wrote: sorry this is the output i meant to post SQL statement = UPDATE badges SET staff = '1' ttlpst = '1' mnthpst = '1' ttlicon = '/trophies' mnthicon = '/ribbons' WHERE fid = 61 and this is the error i getyet i

RE: [PHP-DB] folder creation in php

2004-10-12 Thread Bastien Koert
use the headers header(Content-Length: .filesize($filepath)); header(Content-type: application/octet-stream); header(Content-disposition: $attachment filename={$newfile}); header(Content-Transfer-Encoding: binary); readfile($filepath); bastien From: Adil [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Matthew Kiehne
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] If you look up the manual entry for UPDATE, you'll find that you're missing the commas separating the columns. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

RE: [PHP-DB] folder creation in php

2004-10-12 Thread Gryffyn, Trevor
It's worth noting that if you're just generating HTML that creates just a regular old HREF pointing to a regular old file, that the web server will handle sending out the proper headers. For example: a href=filename.zipYour Download/a You don't need to do anything special with PHP to make this