[PHP-DB] Splitting a CSV file

Hi there everyone, I'm writing an automation system to automatically insert data into a mysql database from a CSV file, and it works great - until I try to insert a large file, then it just doesn't do anything. I've set my PHP filesize to 10 Megs so that's not the issue, and a server timeout i

Re: [PHP-DB] Splitting a CSV file

could try running a CLI command on > this. > > Try looking up the 'split' command, it may solve your problem if you > combine it with some PHP. > > -Matt > > On Mon, 2003-11-24 at 19:14, Chris Payne wrote: > > Hi there everyone, > > > > I'm wri

Re: [PHP-DB] Splitting a CSV file

w about others). > > To prevent this, arrange for the script send regularly some invisible > content to the browser > (eg send a HTML comment line every 100 lines of your CSV file) > > HTH > Ignatius > _____ > - Original Message - > From:

[PHP-DB] LIKE % command

Hi there everyone, I'm doing a search in my DB using LIKE '%$word%' which works great, but it's not case sensitive, so if I search for bike it WON'T find BIKE, i'm using PHP and MySQL. Probably something very obvious LOL it's just a basic select using LIKE. Chris

[PHP-DB] a LITTLE bug with my CSV importer :-)

Hi there everyone, OK So I kind of have my CSV utility working nicely, except for one thing - if I import the file with PHPMyADMIN it imports over 1000 rows (Which is correct) but with the below code on the same file, it's only importing 92 rows, can anyone see anything obvious that's wrong? I

Re: [PHP-DB] a LITTLE bug with my CSV importer :-)

rds Chris may want to try this also (instead of stating a size)... filesize($filename) This: while ($data = fgetcsv ($fp, 1, $d)) {Would be this: while ($data = fgetcsv ($fp, filesize($userfile), $d)) { Let me know... Roger Chris Payne wrote: Hi there everyone, OK So I kind

[PHP-DB] Fixed CSV import problem

Hi there everyone, Just a note to say i've fixed the CSV import problem, I had to excape the ' character that was in the array and now it imports all 1081 rows properly. Now I can relax and pass out LOL :-) Thanks for all the help, very appreciated. Chris

[PHP-DB] Empty Table command?

Hi there everyone, Just a quick question which I can't for the life of me find the answer for on MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to empty a table, is there an empty command or should I just tell it to delete everything? Chris

[PHP-DB] Great PHP Book i've come across

Hey there everyone, Just found a great PHP/MySQL/Apache book, it's not as comprehensive as some books, but the topics it covers it covers VERY well, and i'm learning alot from it. It's called: Sams: Teach Yourself PHP, MySQL and Apache in 24 hours and it's by SAMS PUBLISHING. While it's not t

[PHP-DB] Function Problem

Hi there everyone, This code works fine until I put it into my function, then it still works BUT however many lines are in the file are multiplied. For example, if I have 3 lines with the following: [EMAIL PROTECTED], myname [EMAIL PROTECTED], yourname [EMAIL PROTECTED], ourname In THEORY thi

[PHP-DB] Splitting a string by a ,

Hi there everyone, I'm trying to split a string into an Array by a , but I kepe getting errors. Looking at the PHP manual, I thought it would be this way: $keywords = preg_split(",", $email); But it keeps saying that the , isn't an ending delimiter? Any help would be appreciated, i'm trying t

[PHP-DB] Reading emails with PHP

Hi there everyone, A quick question, is it possible to read a failed mail email and pick out the failed email address? I have around 900 failed emails (Don't ask, long story) from a client and what I want to do is just put the emails in a folder and cycle through the folder and pickout the ema

[PHP-DB] PHP Error or installation problem?

Hi there everyone, I just upgraded my Linux installation of MySQL from 3.23 to 4.0 (Well, the latest production build). In Webmin everything is fine, I can login etc . BUT with PHP 4, the version I used for 3.23 with no modifications (Which may be the problem?) I am having problems connect

[PHP-DB] PHP with Sendmail

HI there everyone, Is it possible to use PHP to check an email on the same server? I have a system setup for my newsletters which I want to expand, and basically when mails bounce back to a certain email address on the server as failed it would then read the email and remove the address from t

[PHP-DB] retrieving email address from array

Hi there everyone, I'm connecting to my mailserver and getting my messagebody, however what I need to do it take everything away but leave the email address that is in the array for processing. How can I take out JUST the email address from the Array? I really need to do this urgently as I ne

[PHP-DB] Can anyone see what's wrong with this code?

HI there Everyone, Finally found the list address again, my computer crashed and I lost everything, sigh. Anyway, i'm zipping a file and it's zipping the filename ok but not the file and I have a feeling it's something wrong with the below, as I get an error on the filesize parameter saying no

[PHP-DB] Functions

Hi there everyone, I need to write a function (New to them but starting to get the hang of it) that will take the field from a form and then do operations on it (To remove bad characters, any entered mysql commands etc ) now that's not a problem, what I want to do though is write a generic

[PHP-DB] PHP Standalone?

Hi there everyone, I need to produce a system which uses databases but NOT on a webserver, I heard something about a PHP distro that is being developed which acts like an executable, does anyone know anything of this? Any help would really be appreciated :-) Chris Payne

RE: [PHP-DB] PHP Standalone? (fwd)

00/XP that can control and receive results from PHP. If you have any tips I would be really appreciative :-) I just download PHP-GTK. Chris Payne -- [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, F

[PHP-DB] URL Problem

Hi there everyone, I have a problem. Basically this is what I need to do: Request behind the scenes (PHP) an ASP Url on a different website with the value pid=1 (Where 1 is an identifying number). Then I need PHP to listen to the response from that request as ASP will then return

RE: [PHP-DB] URL Problem

Hi there, Thanks for the below, but I'll try to explain it a bit better. I don't have access to the ASP server, it's a general server setup for companies, to query their server you must use the ?pid=uniquecompanynumber as it tracks your IP to make sure the correct server is connecting. Anyway, w

RE: [PHP-DB] URL Problem

Hi there, >Just to help clarify, is this what you're saying? If you were to go to the page via a web browser, and put in something like: http://www.someserver.com/somepage.asp?pid=11101 it would get changed (in the browser address bar) to something like http://www.someserver.com/somepath/someo

[PHP-DB] Date help needed

Hi there everyone, I have a problem, I currently have some code which populates a dropdown box - this code gives me every day for the next x amount of days (EG: a years worth of days), however what I really need to be able to do, is to find a way to display this data in the dropdown box but ONL

RE: [PHP-DB] Date help needed

cho date('Y-m-d', $day).''; } (This is not tested, but it *should* work,) On Thu, 24 Jun 2004 17:07:12 -0400, Chris Payne <[EMAIL PROTECTED]> wrote: > > Hi there everyone, > > I have a problem, I currently have some code which populates a dropdown box > - t

RE: [PHP-DB] Date help needed

Hi there, >A drop down with 365 days !?!? Isn't that a "little" big? Actually it's Fridays, Sundays and Tuesdays for 2 years (365 was an example) it's for an Admin for a client, and he asked that it be in a dropdown box and he's the boss, so he gets what he wants :-) One thing he wanted which

[PHP-DB] PHP with Javascript tutorials?

Hi there everyone, I've been looking on Google for PHP Javascript tutorials but I can't find any. I'm new to Javascript but can use PHP for what I need. I was hoping someone would know of a tutorial that would show how to use PHP to get 2-3 datasets which javascript can then use in forms. Fo

[PHP-DB] Load Data infile help needed

Hi there everyone, I'm having a problem loading in a text file, each column is enclosed with a " and separated by a , but when I try the below, it loads in the data BUT it puts a " to the left of each character. Any help would be really appreciated. Thank you Chris mysql_query("

[PHP-DB] SELECT problem between MySQL 3.23 and MySQL 4

Hi there everyone, I'm using Booleans in my searches (New to it) but it works perfectly on my local 3.23 version of MySQL, but on the main server which uses version 4 of MySQL I get an error so there's an error in my Syntax. Here's what I currently use: SELECT id, def, word, 0.2*( LENGTH

[PHP-DB] MySQL variable question

Hi there everyone, I'm using MySQL 4's built-in Boolean handling abilities with PHP 4 which works wonderfully, but I need to change: ft_min_word_len to be 3 characters instead of 4 for fulltext indexing, how can I change this as words such as cat etc ... are not showing up in my PHP sea

[PHP-DB] Column help needed (Table)

Hi there everyone, I need my MySQL query to be displayed in a table, which is no problem, but I only want 2 results per row to be displayed - so if I had 10 returned results from my Database, it would display 2 per column on 5 rows. How can I do this dynamically? Any help would be really a

[PHP-DB] JOIN question

Hi there everyone, I'm transferring a client's product from a Visual Basic .NET ACCESS 2000 application to run on a custom install of Apache/MySQL/PHP which I created (With a custom installer which sets everything up for them). My question though, is on looking through their ACCESS database

[PHP-DB] Urgent JOIN help needed

Hi there everyone, I'm new to JOINS and have followed some info in the MySQL manual but I'm at a loss, using the code I'll paste below, I get each result 4 times and I am confused as to why? Basically I'm trying to display ALL fields from the vendorprices table, and grab just the Description c

[PHP-DB] MAIL() help needed :-(

Hi there everyone, I'm having a major problem. I'm trying to send a message FROM Windows XP Pro, now this is where it get weird - in some mail packages it WORKS, and in some it doesn't. Basically it's an HTML email which is sent when a form is completed, the results are stored in a DB and the

RE: [PHP-DB] MAIL() help needed :-(

Hi there, Thanks for the help, I've sorted it out now - stupid me :-) You know what it's like sometimes, you work that hard on different things that something which should be really simple just goes over your head - well, it does mine anyway :-) Very much appreciated. Chris Hey Chris, Probab

[PHP-DB] MySQL to EXCEL?

Hi there everyone, I'm having a dilemma (Now that I have power back after the hurricane hit us directly in Orlando). Anyway, I need to export a database table to Excel, I can do it as a .txt file without a problem, but I can't seem to get it to put each column into a separate cell when I try t

[PHP-DB] PHP Array to Javascript?

Hi there everyone, I set an array using the following in PHP: $ringb[$i]="$complex_area"; $i++; It cycles through my DB and stores the info, my question is, how can I convert it to a value that can be read in Javascript? I'm stumped. Chris

[PHP-DB] Updating a table when using LEFT JOIN

Hi there everyone, I am using the following to grab the data I need from several tables: $sql = "SELECT * FROM vendorprices LEFT JOIN fooditems on (vendorprices.FoodItemNumber = fooditems.FoodItemID) WHERE vendorprices.VendorNumber='$VendorID' ORDER BY vendorprices.VendorItemNumber"; Th

[PHP-DB] Lotus Notes DB to MySQL?

Hi there everyone, I have a client who uses Lotus Notes for her database, now she wants it converted to MySQL, is that possible? What format is notes DB in? Basically I will write a new front-end and back-end for her so she doesn't need notes anymore (Nasty, nasty software) but I need to impor

[PHP-DB] Finding the highest number in a column?

Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 …… etc …… so there could be a row with the number 1 and then the next row could be 40 and so on …… Is there a way with PHP and MySQL to find out what the highest number is in a particular c

[PHP-DB] I can't seem to get Max() to work

Hi there everyone, I can’t seem to get the below to work with PHP and MySQL: $sql = "SELECT MAX(FoodItemNumber) FROM menuitemsubs"; What am I doing wrong? I need the highest number from the column FoodItemNumber, but it doesn’t return anything unless I change the MAX() to a * and I don

[PHP-DB] How to get unique entries?

Hi there everyone, I’m listing entries by date in a dropdown box, but on some days there are 7-8+ dates the same, but I just need it to display each date ONCE in the dropdown, but for the life of me I can’t remember the command to use to do this, can anyone please remind me? I know it was dead

[PHP-DB] session_destroy();

Hi there everyone, I need to destroy a session in the browser so when they log out it clears all the session data from the browser, I have tried: session_destroy(); But it doesn’t seem to do it as the browser keeps the same PHPSessionID. What is the best way to destroy a session and

[PHP-DB] PHP / Javascript question

Hi there everyone, I have a form with check boxes and with PHP I use the array feature for the form name. Now I need to check if the tickboxes are ticked and if not return an error, normally with javascript I would use: function validate_form ( ) { valid = true; if ( docume

[PHP-DB] Numeric question

Hi there everyone, Just a quick question, I’m having to calculate some values from an existing database, but on some of the results I get (For example) 0.5907 How can I limit the result to only 2 digits after the decimal point with PHP? Thanks Chris --- Outgoing mail i

[PHP-DB] Connecting to a remote server?

Hi there everyone, I have written a program in PHP with MySQL as the DB backend, It works great but I need to be able to connect to a remote MySQL DB server for an Updates system I’ve written, how do I connect to a remote MySQL server with PHP? I’ve only ever done it with localhost. Thanks

[PHP-DB] Error Help

Hi there everyone, Thanks to everyone helping with connecting to a remote server, works wonderfully now :-) I do have a final question, had a look online but couldn’t find what I needed. It’s hard to explain why, but basically individuals have my program on their HD, the DB is on their HD

[PHP-DB] Looping within a string?

Hi there everyone, I’m having to send an email with looped results, but I’m having problems. I can send an email no problem, and this code works OUTSIDE of the string, but not inside, can anyone see what is going wrong? ’; --- Outgoing mail is certified Virus Free. Checked by AVG an

RE: [PHP-DB] Looping within a string?

PLUS the table data into a string? It has to be an HTML email and I'm stumped. I can send an email no problem, but not with all the data, just the last row in the data. Chris On Friday 17 December 2004 10:33, Chris Payne wrote: > I’m having to send an email with looped results, but I’

[PHP-DB] String question

Hi there everyone, I am having to read a string with text in, but the way the DB is written in the same string you have the price, for example” CASARON 4G 50lb Sacks in Ton Lots $88.00 How can I strip out the 88.00 (Baring in mind it could be any number) into it’s own string? Tha

[PHP-DB] Removing first word from a string?

Hi there everyone, I am building a dynamic MySQL query for a project I am working on, but there are instances where it products WHERE AND instead of WHERE city etc ….. due to the nature of the system I am developing. My question is, how can I remove the FIRST “ AND” from a string if it is pres

[PHP-DB] str_replace question

Sorry if this already went through, my SMTP server was having problems. Hi there everyone, I’m having a weird problem and I’m not sure why, if I try to replace WHERE AND with just WHERE it won’t do it, but if I try to replace WHERE or AND by themselves it WILL do it, but I cannot replace BO

[PHP-DB] str_replace question

Hi there everyone, I’m having a weird problem and I’m not sure why, if I try to replace WHERE AND with just WHERE it won’t do it, but if I try to replace WHERE or AND by themselves it WILL do it, but I cannot replace BOTH of them from a single string, is something wrong below? $additionalsq

[PHP-DB] Security Question

Hi everyone, I have a security question, I want to see if I am right or wrong. I have programmed a system with PHP and MySQL, the main system resides on a secure server, but the client wants the login page on a NON-Secure server for marketing purposes. Am I the only one who thinks this is a m

[PHP-DB] What is wrong with this query?

Hi there everyone, I’m trying to select data from 3 tables, I’m using the following code: SELECT * FROM MLS, Cond, Comm ORDER BY Price DESC LIMIT 0, 50 But it’s not working, I thought this is how it worked but I guess I’m wrong. It’s just a basic query, but needs to pull all the info fr

RE: [PHP-DB] What is wrong with this query?

stien >From: "Chris Payne" <[EMAIL PROTECTED]> >To: >Subject: [PHP-DB] What is wrong with this query? >Date: Sat, 22 Jan 2005 23:44:29 -0500 > >Hi there everyone, > > > >I’m trying to select data from 3 tables, I’m using the following code: > > >

[PHP-DB] GROUP BY? Urgent help needed with selection list

Hi there everyone, I’m using the following code to populate cities from a huge database: Show All This works great, no problems BUT the client now needs is so the cities are grouped

RE: [PHP-DB] GROUP BY? Urgent help needed with selection list

x27;t think multiple queries would work, hence why I'm trying to do it all in a single query. Chris if you have kind of geo id number you could use that, failing to have that info, you could re-arrange the data to have Akron - Central, Akron - SE (so that all is in a standard format) Bas

[PHP-DB] Best way to remove slashes?

Hi there everyone, What’s the best way to remove slashes to stop the following from being output from a string: City = HYPERLINK "file:///\\'Alliance\\"\\\'Alliance\\\' Say the string is called $city, I tried the following: Stripslashes($city); but it didn’t seem to work? C

[PHP-DB] Table from an array?

Hi there everyone Is it possible to create a database table from the first line of a CSV file? What I mean is, how would you create the table columns based on the CSV file’s columns? This would really help me out, as some times the table column counts change on data I have to import, so it wou

[PHP-DB] How to upload image?

Hi there everyone, I'm writing an update utility for a database system, but I need to give the user the option to select a file from their machine to upload to the server (Not to the DB itself, but an images dir), what is the best way of doing this in PHP so that it brings up a file requestor

[PHP-DB] Image resize from DB?

Hi there everyone, Once i've gotten an image from my DB, is it possible to resize it proportionatly? Currently all images are resized to 160x120 but for some images this is really bad as it stretches them, is there a way for example where I can go through the loop of images and then resize th

[PHP-DB] Random numbers?

Hi there everyone, I need to generate a random number between 1 and 15 for insertion into a DB, I can easily do the DB side of it but what is the best method for quickly generating a random number between 1 and 15 (including 1 and 15 in the equation)? Thanks for all your help. Regards Chris

Re: [PHP-DB] Random numbers?

Hi there, That is absolutely PERFECT, thank you so much for that you are a lifesaver :-) Regards Chris Payne www.planetoxygene.com > On sön, 03 feb 2002, Chris Payne wrote: > > > Hi there everyone, > > > > I need to generate a random number between 1 and 15 for in

[PHP-DB] ORDER BY question

with Munich Hotels to appear first before the rest, any ideas? Thanks everyone. Chris Payne http://www.planetoxygene.com

[PHP-DB] MySQL Result

Hi there everyone, I have delete working perfectly by doing the following: include("connectionstart.php"); mysql_query ("DELETE FROM emaillist WHERE EMail = '$email' "); However, how do I return a true or false flag whether the row was deleted or not? I basically need to know how to do a 0 or

[PHP-DB] Searching results of results

Hi there everyone, Say I do a simple search as follows: $query = "SELECT * FROM search WHERE (description LIKE '%$test%' OR state LIKE '%$test%' OR city LIKE '%$test%' OR fname LIKE '%$test%') AND (category = '$category' AND country = '$country' AND type = '$type') ORDER BY city ASC LIMIT $of

Re: [PHP-DB] Searching results of results

"fname = '$fname' AND "; } > > $query .= "(category = '$category' AND country = > '$country' AND type = '$type') ORDER BY city ASC LIMIT > $offset, $item_perpage"; > > have fun, > olinux > > > --- Chris Payne <[EMA

[PHP-DB] Copy distinct results to new table

Hi there everyone, How can I copy distinct results of a query to a table in a DB? I have 3 pulldowns, the first one selects the category, then the second one gets the holiday type based on the category, and the third one gets from countries where category = category AND holiday type = holiday

[PHP-DB] Copy distinct results to new table solved

Hi there everyone, Just to let you all know I solved the problem I was having earlier - it's probably not the most elegant solution but hey, it works and it's very fast so I can't complain :-) Thanks to everyone in this group for your help on everything i've asked in the past (And will probabl

[PHP-DB] & update

Hi there, I have a system for updating whereby you select the country/continent from a db then edit the record and update it and it works perfectly - that is until there is a & in the update $country set - so if it says Africa it updates fine, but if $country = Asia & The Orient it doesn't upd

Re: [PHP-DB] & update

Looking at the below, I think it might be spaces in the query - how can I rectify this? Thanks :-) Chris Hi there, I have a system for updating whereby you select the country/continent from a db then edit the record and update it and it works perfectly - that is until there is a & in the updat

[PHP-DB] procedures?

Hi there, Where can I find information in PLAIN terms about how to use procedures in MySQL? More importantly I want to be able to write my own so I don't have to keep re-using the same code in the way that I do now to access, delete etc from db's. Thank you :-) Chris

[PHP-DB] Database search question

Hi there everyone, How can I accomplish the following? I have a table called search, 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

[PHP-DB] Probably a stupid Array question

Hi there everyone, I do this to explode my input line which consists of however many words: $words = explode(" ", $testb); Now i've done this and I presume that $words holds all the info as an Array (new to arrays, sorry if i'm wrong) however, how can I put each item of the array from $words

[PHP-DB] Saving DB Resuts to a file

Hi there everyone, I have a newsletter which works wonderfully, sends to everyone in the DB fine with error checking etc .. My problem is my client now wants to be able to easily save the email addresses from the DB into a text file - so my question is, how can this be done? Connecting t

Re: [PHP-DB] Saving DB Resuts to a file

Hi there, I entered the code in as you described below, and it LOOKS on the screen as thought it is doing it, but when I look at the server there is no output file, can you see anything obvious that I am doing wrong? Thanks for your help. Chris $connection = mysql_connect("localhost","xx",

[PHP-DB] Operations on a string?

Hi there everyone, Say I have a string which reads "12345", how can I search that string and do an operation on each word? What I would like to do is check code before it is inserted into a db, and have a pre-defined list of HTML/PHP syntax already written, it would look at and compare it t

[PHP-DB] Selecy Distinct problem

ITHOUT it being a DISTINCT value, how can I do this?  All the others need to be DISTINCT apart from ID, i'm very confused. Thanks for everything. Regards Chris Payne www.planetoxygene.com

[PHP-DB] PHP Mysql Select Distinct problem

but WITHOUT it being a DISTINCT value, how can I do this?  All the others need to be DISTINCT apart from ID, i'm very confused. Thanks for everything. Regards Chris Payne www.planetoxygene.com

[PHP-DB] Weird Distinct bug?

Hi there everyone, On my linux server I am using: MySQL 3.22.32 Whereas on my Local server I am using MySQL 3.23.42 (Or 43.don't remember). Anyway, I am having a wierd but major problem, if I do the code like the following locally it WORKS, if I do it on the server with the slightly old MySQL

[PHP-DB] mysql exclusion in php

Hi there everyone, How can I do a search which excludes certain words if they put a - in the search string? I can do a search easily, but if they put a - infront of a word in the string, how can I then get MySQL to search all entries EXCEPT where the word with a - next to it appears? Thanks

[PHP-DB] Pulldown selection speeds

Hi there Everyone, I’m having an issue with pulldown selection speeds, is there a way to grab all the data from the DB and store it in jscript or something which isn’t serverside? I mean, say it grabs everything, and in the first menu they select England, it then populates the second menu with

[PHP-DB] how to create a graph from a db?

banners on the screen, that I can do, but how do I display the numbers as images in a chart? Any help would REALLY be appreciated. Thanks Chris Payne --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.368 / Virus Database: 204

[PHP-DB] Splitting a string and placing the contents into a form pulldown

Hi there everyone, I have this pattern in a mysql db: Deluxe double £165.00 prpnSingle £128.00 prpnTriple £229.00 prpn What I need to do is to remove the but where there 's are should be the end of a string, so in this case I should have an Array (?) of 3 items. My question is, how, from thi

[PHP-DB] Splitting a string and placing the contents into a form pulldown Solved

reference for the new Array item. This removed the prpn from the dropdown but I solved that by simply hardcoding that to the right of the dropdown box :-) Regards Chris Payne --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Vir

[PHP-DB] connecting to a remote db?

Hi there everyone, I have a secure server and another separate servr, both use PHP and MySQL – however, I need to connect to a db off of the secure server, how can I do this? I normally use localhost if it’s on the same machine, but how can I connect the DB to a DB on my other machine as I can

[PHP-DB] Last ID from database?

Hi there everyone, How Can I grab just the LAST ID from a database in MySQL with PHP easily? Thanks you :-) Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002

[PHP-DB] remove from db renumbering

Hi there everyone, I have my id field auto incrementing (Of course) and I have a utility that allows me to remove items from it, the problem is when I remove something the items after it keep their ID’s leaving a gap in the ID. For example, say I have 1-10 in the ID field and I remove number 8,

[PHP-DB] PHP . Mysql form problem

Hi there Everyone I have a major problem. I have a new website for a client which works great, but when the person selects their holiday it goes to my secure SSL server. No problem, all pages and images are located on there so it’s fully secure. The thing is I’m using Javascript validation a

[PHP-DB] PHP and Mail under Apache Windows?

, but from what I understand I have to do something to get it to send mail from Apache/PHP now? As a note, under linux I used sendmail. Please help, I am so confused I don't know where to start to get the mail working. Thanks for everything Regards Chris Payne

[PHP-DB] ODBC?

databases for users accounts and I figure this way I could write a PHP script to control users email accounts. Thanks everyone, sorry if this sounds like a stupid question, not used ODBC before so even though I know quite abit about PHP/MySQL, I know diddly about ODBC :-) Chris Payne

[PHP-DB] How to read an image file into a string/array/etc ....???

Hi there everyone, I use the following to read in a text/php etc . file into a string so I can zip it, works no problem: $filename2 = "/home/domain/domain33/web/zip/whois.php"; $fd = fopen ($filename2, "r"); $filedata = fread ($fd, filesize ($filename2)); fclose ($fd); However, how can I r

[PHP-DB] binary data?

Hi there everyone, How can I import binary data - say from a gif file, into a string or array in PHP? I can do text files/csv etc . but using the same method it won't do binary (I'm sure for some obvious reason). Thanks for your help Chris

[PHP-DB] Binary Data problem solved :-)

Hi there everyone, Just wanted to let you know i've solved the binary data problem I was having, I can now zip both text and gif/jpeg files etc . on the fly, in the fopen command I missed out the rb at the end, I put in the r but NOT the b - doh, knew it would be something simple in the en

[PHP-DB] Array help needed :-(

Hi there everyone, I have a problem i'm trying to figure out but i'm not too good with arrays, just know the basics, if anyone could help me out on this it would be wonderful :-) I have two sets of data in columns of a MySQL DB, these items are size and price. Size is seperate by comma's in th

[PHP-DB] Echo Command Thanks

ted to make sure I wasn't putting unecessary strain on my server :-) Thanks again everyone, this is the best PHP / Programming mailinglist out there. Regards Chris Payne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Question

Hi there everyone, Why are so many attachments coming in to the list? Hopefully it's not because somebody has a virus and is infecting people who open them. So don't open attachments unless you are expecting something. Are there any plans to make PHP for windows a full blown programming languag

[PHP-DB] RE: Question - thanks

Hi there everyone, Thanks for the response to my question - both the attachments and PHP as a full blown dev language. I know the latter isn't really for this group, but this is the best PHP group I have found and the only one I write in regularly. Thanks again Chris -- PHP Database Mailing

[PHP-DB] Optimizing

Hi there everyone, How does indexing work, and does it speed up small / average size DB's of around 20,000 records, with 12 columns per record? (Some columns being paragraphs of text). Also, do you create an index on everything or just 1 item or or or :-) I've not looked at indexing but think i

Re: [PHP-DB] I just wanna say...

Here here, couldn't agree more. Sometimes I get the answers I need but am too tired to reply then the next day I get so caught up in everyday life sometimes forget to say thanks myself but this list is a lifesaver and is a godsend to many of us either just learning PHP/MySQL or who want to get int

  1   2   3   >