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 how do

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. Try each

[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

[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. ?php

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

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

[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

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] 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

[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 it

[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

[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.

[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.

[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

[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] 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)

[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 would

[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

Re: [PHP-DB] Another Drop down question

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

[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

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