Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread dpgirago
Martin Alterisio wrote: 2006/4/26, [EMAIL PROTECTED] [EMAIL PROTECTED]: Skip Evans wrote: Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread dpgirago
Adrian Bruce wrote: [snip] No, not Obviously, PHP is not well suited for many tasks (or has a high cost to get the suit tailored) :) [/snip] Obviously because i am posting to a PHP list, numpty! but thank you for the recommendation anyway. Obvious in that sense sure ,but just

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread dpgirago
I think you're confusing php (the language) with bad programming practices (the developers). They aren't the same. A true enough statement, except what i am referring to is that PHP (the language) lends itself to bad practice and has extremely bad security issues (example: your config info

[PHP-DB] MySQL: Load Data Infile

2006-05-16 Thread dpgirago
Greets, I'm trying to use the load data infile syntax within a php script. The data is in csv format. I was under the impression that I could reorder the fields during the insert, such as: load data infile 'currentData.txt' into table(fieldName2, fieldName1) fields terminated by ','; The stuff

Re: [PHP-DB] MySQL: Load Data Infile

2006-05-16 Thread dpgirago
Am Dienstag, 16. Mai 2006 17:40 schrieb [EMAIL PROTECTED]: I'm trying to use the load data infile syntax within a php script. The data is in csv format. I was under the impression that I could reorder the fields during the insert, such as: load data infile 'currentData.txt' into

Re: [PHP-DB] MySQL: Load Data Infile

2006-05-17 Thread dpgirago
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...); Syntax isn't quite correct with field and line terminators specified. You must also specify a column list if the order of the fields in the input file differs from the order of the columns in the table. Otherwise, MySQL

Re: [PHP-DB] how to get the referrer page details

2006-06-15 Thread dpgirago
Hello all, I am developing a site in which user comes from different site to my site. Now i want to maintain that user comes from which site. I am using $_SERVER['HTTP_REFERER'] for that. Now i came to know that this variable is not supported by some servers or it can be set off in php.ini

Re: [PHP-DB] Inserting Data into MySQL database

2006-06-15 Thread dpgirago
Hi All, I have a table in MySQL database 5.0 the structure of which is as follows ssno INT 9, lname VARCHAR(15) NOT NULL, fname VARCHAR(15) NOT NULL, I am inserting the values using $query = insert into student (ssno,lname,fname) VALUES

Re: [PHP-DB] Inserting Data into MySQL database

2006-06-15 Thread dpgirago
Hi All, I have a table in MySQL database 5.0 the structure of which is as follows ssno INT 9, lname VARCHAR(15) NOT NULL, fname VARCHAR(15) NOT NULL, I am inserting the values using $query = insert into student (ssno,lname,fname) VALUES

Re: [PHP-DB] Generating forms and form elements

2006-06-20 Thread dpgirago
Mark Fellows previously described: Hi, Hitting up the list for maybe a decent link(s) or pointers. I need to figure out how to generate forms and form elements from php code inside database tables. Hope this makes sense. It's not a complete picture of what I need to do but the first step

Re: [PHP-DB] Generating forms and form elements

2006-06-20 Thread dpgirago
Mark Fellows previously described: Hi, Hitting up the list for maybe a decent link(s) or pointers. I need to figure out how to generate forms and form elements from php code inside database tables. Hope this makes sense. It's not a complete picture of what I need to do but the first step

Re: [PHP-DB] Count Many Records

2006-06-28 Thread dpgirago
Kevin Murphy asks: The following code works and accomplishes what I need it to do, but I am wondering if there is a better way to accomplish the same task. I have several tables of records and I need to count and then display. Even if I could just combine the first three queries (below) into

Re: [PHP-DB] Only a section from the database result

2006-07-18 Thread dpgirago
I have articles in a MySQL database and I want creating a fast brows where people can read the beginning of the articles and select the ones they want to read. How do I only display the first say 50 chars of a 5000 char article? $count = 1; while(($row = mysql_fetch_array($News)) or

<    1   2