Re: [PHP-DB] broken PHP

G'day John > I installed Panther on "delivery day". It has broken PHP. MySQL still > works. Everytime I try a test to local it tells me, "You are not > authorized ...on this server" I see I now have apache1.3.8 (I believe > I had 1.3.6 before) and Perl 5.8. Where did things get changed, and

Re: [PHP-DB] Load MySQL from a variable

G'day CPT John W. Holmes and Rory >> AFAIK, LOAD DATA INFILE will only work off a file. So you would have to >> create a temp file. Another option is to create a multiple value insert >> query e.g. > Agree that LOAD DATA INFILE will probably still be faster overall, even with > the file write. Tr

[PHP-DB] Load MySQL from a variable

G'day all, I have some data from Filemaker Pro which needs to have a lot of search/replacing done before importing into MySQL. I have used ereg_replace in PHP and end up with a variable holding the correct data. (there are several hundred rows of data in the variable) Is it possible to use Load d

Re: [PHP-DB] Popup menu problem

G'day all > I've struck a problem with an existing piece of code which I want to move > to a new one. Apologies in advance. The page in question was an HTML page rather than a PHP page and I hadn't added .html to the AddType bit of the httpd.conf file. Thanks to those who replied - it's wo

[PHP-DB] Popup menu problem

G'day all, I've struck a problem with an existing piece of code which I want to move to a new one. I'm aware of the issues with register global being off as far as forms are concerned, but I can't figure out why this snippet doesn't work. It displays the code rather than the popups. \n"; echo "

Re: [PHP-DB] Insert problem

G'day All, Duh! Sorry, I had deleted the line that calls the query. I need to get home... cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Insert problem

G'day all, I have a problem with an insert which is proving infuriating. When I run the following code everything seems to work (no errors) except the database remains empty. When I echo $query and run it from a command line it inserts fine. I don't get any connection errors - in fact when I ech

Re: [PHP-DB] Newbie file reading into MySQL

G'day Jason > Just one question: why are you storing text files containing DATA into a DB? > Why not just store the data in the DB and do away with the text files? Thanks for the reply. I can see now my original wording was a bit unclear. I am, in fact, storing the data only - the text file

[PHP-DB] Newbie file reading into MySQL

G'day all This is probably a really basic question but I'm asking advice because I'm a real newbie and want to start off on the right foot. I'm trying to build a PHP/MySQL workflow tracking system in which each movement of an InDesign file generates a text file which contains the tracking data I

[PHP-DB] Odd characters

G'day all, I have a folder with an "Ÿ" (Option-F) in the name which PHP processes as "Ä". Is there some sort of encoding/unencoding which will handle this character correctly? I've tried URLencoding and htmlspecialchars but I don't really know what to search for in the docs. cheers kim -- PHP

[PHP-DB] Web image database questions

Hi folks, A friend of mine would like to use PHP/MySQL to host a web based photo archive. I believe it will hold around 20,000 to 30,000 photos at a reasonable size for web display - perhaps 100 k or so each. I expect he'd have a small preview 'clickable' to a larger version. I searched the list

[PHP-DB] Word Count, rounding and missing zeros

G'day All, I'm using php to query a mysql db and I need to display a word count from one of the columns and multiply it to get a quote. So far I have this: $thewords = count(split (" ","$adtext")); $thequote = round(($thewords * .78),2); In an example with 35 words it returns 27.3 but I'd like

[PHP-DB] Structure questions/advice (newbie)

Hello all, I'm setting up a mysql/php system where people will be able to enter articles. Obviously I'll have a writer table and an article table but I want a way for the IDs to be passed seamlessly from one table to the other. IOW, when they login, I want to pass the writer_ID returned from th

[PHP-DB] Getting data from a page which isn't a form

Hi all, I'm using PHP to retrieve data from a form and pass it to a 'confirm' page. Here the data is echoed and the user presses a 'confirm' button to finally mail the information to us. This page is a basic html page (confirm.html) with some inline php which displays the relevant information. A

[PHP-DB] Getting data from a page which isn't a form

Hi all, I'm using PHP to retrieve data from a form and pass it to a 'confirm' page. Here the data is echoed and the user presses a 'confirm' button to finally mail the information to us. This page is a basic html page (confirm.html) with some inline php which displays the relevant information. A

[PHP-DB] Re: Grouping menu items

Hello All Forget my previous post - I will simply run an update on the table to alter all the various News variations back to 'News' cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Grouping menu items

Hello All, I have a MySql database which has a 'sections' column which includes values such as Real Estate, Sport, Letters etc. The 'News' section is divided into 4 parts to indicate a priority for any given story; News, News2, News3 and News4. We are using: $getlist1 = mysql_query("SELECT dis

[PHP-DB] Re: thanks

G'day Matthew > i think i got this solved; sorry about the non-php question but there > isn't a mysql newsgroup that i know of. You can find a list at www.mysql.com = Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

[PHP-DB] Re: Database search question

G'day Chris > I have 3 fields, city, country, type > I also have an imput box where you can type in a search word. What I need is, > say you type in hotels germany, I need the search to break up the sentence and > then search each 3 fields in the DB looking for a match. > So, for example: it wou

Re: [PHP-DB] Another Drop down question

G'day szii, > The easiest way... >> $getlist = mysql_query("SELECT distinct Writer FROM stories"); >> echo " \n"; > echo "Search All"; I love simple solutions:) Cheers and many thanks kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub

[PHP-DB] Another Drop down question

Hello all, I'm trying for the first time to use a dynamically created popup menu from a mysql database. The menu is of (article) writers' names and will be used in a select query. Using snippets of code I've gleaned from here and the mysql list, I've the popup working fine but I'd like to inclu

Re: [PHP-DB] Using a Left() result in PHP

G'day all, The answer was nice and simple - assign an alias to the select statement - thanks all for the quick responses. Cheers, kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Using a Left() result in PHP

Hi there I'm just scraping the surface of MySQL and PHP and there's something I can't work out. I want to get the first 64 characters from a database row result and display only those 64 characters using PHP. The snipped code is here - I've deleted all the error trapping and comments: $result