Re: [PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Max Schwanekamp
Bruce Gilbert wrote: //build and issue query $sql = "INSERT INTO $table_name values ('', '$_POST[f_name]', '$_POST[l_name]', '$_POST[address1]', '$_POST[address2]', '$_POST[address3]', '$_POST[postcode]', '$_POST[country]', '$_POST[prim_tel]', '$_POST[sec_tel]', '$_POST[email]', '$_POST[birthday]

Re: [PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Stephen Leaf
I believe it's proper SQL syntax to use a double quote " tho for column names. I've heard of backtick working.. but in any example I've ever seen both in classes and on mysql and postgresql sites they always use "" I don't use `` so I'm not sure how widely they are accepted. Just ran a test in s

[PHP] Savant question

2005-11-13 Thread Ligaya Turmelle
I am trying to use savant and having a few odd problems. I plan on making a simple DB driven site where the majority of the content is held in the DB. I have created a basic template (header, footer, nav and content) to just echo out the content (the content will have a html to format it the

[PHP] Good user comment system?

2005-11-13 Thread Guy Brom
Hi all, Anyone familiar with a good user-comment system for PHP, preferably one that works with adodb and has thread-like design (where users can answer each other). Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Page Update Script

2005-11-13 Thread Wolf
Anyone know of a script out there already which will read directories on a site and display a list of files updated within the last month? Just thought I would ask before I invented the wheel! R -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

Re: [PHP] Zend + Eclipse + Standized Framework

2005-11-13 Thread Marco Kaiser
Hi Dan, there are no details right now. Check frequently zend.com for updates about the framework and upcomming zend eclipse stuff. -- Marco -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Jasper Bryant-Greene
Bruce Gilbert wrote: for the table name you mean like this? $table_name =" 'Contact List' "; No, backticks. I gave an example of the backtick in my email (in brackets). It is on the same key as the tilde, and looks like this: ` Also, I would probably left $table_name as it was and put the b

[PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Bruce Gilbert
for the table name you mean like this? $table_name =" 'Contact List' "; On 11/13/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > Bruce Gilbert wrote: > >> You would need to show us the SQL that was causing that error. Otherwise > >> it is fairly meaningless. > > > > hope this helps... > > >

[PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Jasper Bryant-Greene
Bruce Gilbert wrote: You would need to show us the SQL that was causing that error. Otherwise it is fairly meaningless. hope this helps... Unrelated, but you should have quotes here. Like $_POST['f_name'] header("Location:http://www.inspired-evolution.com/show_addcontact.php";);

[PHP] Re: please shed some light on SQLsyntax error

2005-11-13 Thread Bruce Gilbert
>You would need to show us the SQL that was causing that error. Otherwise >it is fairly meaningless. hope this helps... http://www.inspired-evolution.com/show_addcontact.php";); exit; }else { //if form variables are present,start a session session_start(); } //check for v

Re: [PHP] please shed some light on SQLsyntax error

2005-11-13 Thread Jasper Bryant-Greene
Bruce Gilbert wrote: I am trying to set up a contact list database using guidance from a PHP/MySQL book I recenty purchased, and not aving done this before I am not sure what the following error means or where I shoudl look for this kind of error. I have a table set up in MySQL using PHPMyadmin,

[PHP] Zend + Eclipse + Standized Framework

2005-11-13 Thread Dan Rossi
Just found this article via phpeclipse.de stating Zend will be including Eclipse framework in their development schedules :) http://www.zend.com/news/zendpr.php?id=109 Id like to know more about this standardized application framework. I wonder if it includes the pear framework, or compiled OO

[PHP] please shed some light on SQLsyntax error

2005-11-13 Thread Bruce Gilbert
I am trying to set up a contact list database using guidance from a PHP/MySQL book I recenty purchased, and not aving done this before I am not sure what the following error means or where I shoudl look for this kind of error. I have a table set up in MySQL using PHPMyadmin, and I am thinking it ma

Re: [PHP] mod_rewrite and include paths

2005-11-13 Thread Marcus Bointon
On 13 Nov 2005, at 22:15, Marco Kaiser wrote: try to use realpath, dirname and other related funktion to resolv the real path. dirname(__FILE__) ? Good point (you can tell I've been up too long). I've just had a play with that - I appended the current path to my include_path, but it see

Re: [PHP] Printing to a buffer

2005-11-13 Thread Todd Cary
Because this was just a test of what will be many "print" lines. The original application used a file to hold the data and upon request by the user, it was emailed. But with my client's shared server, files cannot be opened...a pain. If you have a better solution, I am open to other ideas.

Re: [PHP] Output_Buffer problem

2005-11-13 Thread David Tulloh
The documentation[1] lists output_buffering as changeable PERDIR. This means you can't set it in the file. Instead you should look into setting it in the apache .htaccess file. 1: http://php.net/manual/en/ref.outcontrol.php Todd Cary wrote: > My client has switched to a shared server, so direc

Re: [PHP] Printing to a buffer

2005-11-13 Thread M. Sokolewicz
call me stupid, but why don't you do it like this: $buf = "This is a test"; header("Content-type: text/plain"); header("Content-Length: ".strlen($buf)); header("Content-Disposition: attachment; filename=sfyc.html"); echo $buf; ?? looks easier to me... no output buffering required... Todd Cary w

[PHP] Output_Buffer problem

2005-11-13 Thread Todd Cary
My client has switched to a shared server, so direct access to the php.ini is not availble. Our calendar program expects to have output_buffering set to On ("1"). Currently, I get the expected error of Warning: Cannot modify header information - headers already sent by (output started at /h

Re: [PHP] Printing to a buffer

2005-11-13 Thread Todd Cary
Just before the police knocked at my door, I made a few changes! "; $buf = ob_get_contents(); $len = strlen($buf); ob_end_clean(); header("Content-type: text/plain"); header("Content-Length: $len"); header("Content-Disposition: attachment; filename=sfyc.html"); print($buf); ?> Tod

Re: [PHP] mod_rewrite and include paths

2005-11-13 Thread Marco Kaiser
Hi Marcus, try to use realpath, dirname and other related funktion to resolv the real path. dirname(__FILE__) ? -- Marco -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mod_rewrite and include paths

2005-11-13 Thread Marcus Bointon
This seems like a simple problem... I have a rewrite like this: RewriteRule ^x/([0-9]+) x.php?x=$1 [PT,L] This maps a url like http://www.example.com/x/123 to http:// www.example.com/x.php?x=123 x.php contains a line to include some class like: require_once 'x.class.php'; My include path c

Re: [PHP] Printing to a buffer

2005-11-13 Thread Marcus Bointon
On 13 Nov 2005, at 19:27, Jasper Bryant-Greene wrote: Many thanks! I did not know that MIME-Type. Change duly made! You're not suggesting that you actually set the MIME-Type to application/force-download, are you? I think he is. I've called the MIME-type police and they'll be round lat

Re: [PHP] Printing to a buffer

2005-11-13 Thread Jasper Bryant-Greene
Todd Cary wrote: Marcus - Many thanks! I did not know that MIME-Type. Change duly made! You're not suggesting that you actually set the MIME-Type to application/force-download, are you? Todd Marcus Bointon wrote: On 13 Nov 2005, at 00:17, Jasper Bryant-Greene wrote: seem to do that

Re: [PHP] Printing to a buffer

2005-11-13 Thread Todd Cary
Marcus - Many thanks! I did not know that MIME-Type. Change duly made! Todd Marcus Bointon wrote: On 13 Nov 2005, at 00:17, Jasper Bryant-Greene wrote: seem to do that. I just tried "application/text" since I use "application/pdf" for other applications. Whatever it's giving the user

Re: [PHP] Recommendations for the Zend PHP Certification

2005-11-13 Thread Gustavo Narea
Hello. Alright, I get it. Thanks! Marco Kaiser wrote: Hi, i mean http://www.phparch.com/cert/ :) -- Marco Aren't they the same books? I mean, I see the same authors, the same titles and the same pictures. -- Gustavo Narea. PHP Documentation - Spanish Translation Team. Valencia, Venezu

Re: [PHP] Printing to a buffer

2005-11-13 Thread Marcus Bointon
On 13 Nov 2005, at 00:17, Jasper Bryant-Greene wrote: seem to do that. I just tried "application/text" since I use "application/pdf" for other applications. Whatever it's giving the user the ability to do, it's probably because the browser doesn't recognise the (invalid) MIME-Type. Quit

Re: [PHP] Recommendations for the Zend PHP Certification

2005-11-13 Thread Marcus Bointon
On 12 Nov 2005, at 16:29, Gustavo Narea wrote: - Zend PHP Certification Study Guide. This book would be good if it were not so full of errors. With a bit of luck it's been revised since my edition (July 2004 printing); I noticed quite a few problems and then found a huge errata list on

Re: [PHP] Recommendations for the Zend PHP Certification

2005-11-13 Thread Marco Kaiser
Hi, i mean http://www.phparch.com/cert/ :) -- Marco > Aren't they the same books? > > I mean, I see the same authors, the same titles and the same pictures. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] performance suggestions

2005-11-13 Thread Joe Belmaati
$sql = "SELECT u.*, s.*, p.* FROM URL u, session s, page p WHERE u.url_id = s.url_id AND s.section_id = p.section"; if (!$result = mysql_query($sql)) { die('Could not obtain results'); } while ($row = mysql_fetch_array($result)) { $url = $row['url_name']; .. .. and what ever e