[PHP-DB] Re: Difficult Dilemma Details Dodged

Kevin, simply requery the client data from the database and display it on the next page... Or you could send it via input type=hidden name=varname value=somevalue to the called script. this is faster, as you don't need to requery the database, but not that clean. regards Chris Greetings All;

Re: [PHP-DB] Multiple select box using mysql

But how do I populate the array with (for e.g.) 2 fields from a mysql table. Each line of the select box needs to hold the Name and Version of the piece of software, the results from a: select Name, Version from software -s- --- Corne' Cornelius [EMAIL PROTECTED] wrote: You have to give the

[PHP-DB] Checkboxes to gather rows to delete

I have a mysql database with a table using one column as a primary key. (rowID). On a php page I use a query to list all of the rows of the table and have a checkbox beside each row that should be used to check if you would like to delete this row. Can someone give me an example using post to

[PHP-DB] Re: Checkboxes to gather rows to delete

You best bet is to do this: List all your rows with the ID to delete in the NAME of the checkboxes and at the same time build a list seperated by , with your IDs so you can use that list the EXPLODE function for PHP: Echo input type=\checkbox\ name=\id . $row[id] . \ value=\1\; $idList .= $sep .

Re: [PHP-DB] Checkboxes to gather rows to delete

I have a mysql database with a table using one column as a primary key. (rowID). On a php page I use a query to list all of the rows of the table and have a checkbox beside each row that should be used to check if you would like to delete this row. Can someone give me an example using post

Re: [PHP-DB] Checkboxes to gather rows to delete

It is wrong to use that way of doing it John, cause this will delete ALL lines that where printed with a checkbox And also, if you are using a old version of PHP with register globals OFF, the _POST array will not be available Mathieu Dumoulin 1lt John W. Holmes [EMAIL PROTECTED] a écrit dans le

[PHP-DB] RE: PHP4 on Windows using MSSQL

The MSSQL module for PHP DOES NOT USE ODBC. It uses the C library direct style of connecting to MSSQL. Use your enterprise manager to configure the appropriate users and permissions and you should be fine. Ollie Cronk www.cronky.net -Original Message- From: Kevin Gordon [mailto:[EMAIL

RE: [PHP-DB] Checkboxes to gather rows to delete

Hi all, Can I raise a point of principle here. My databases never have records deleted - instead they are marked as being deleted in a status field. That way, they are always there for reference. Unless you are running a system that needs the space or has extremely high turnover of deleted

Re: [PHP-DB] Checkboxes to gather rows to delete

I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] = 101 [1] = 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I like the way of doing it that Mathieu has shown using the

[PHP-DB] Help for list selection

I am very new to PHP. I have a survey to do and I would like to have most of the questions selected from drop down lists. I have got the part of creating a list made from a table in MySQL. Currently I open the connection and get the table for the question for every question in the survey. This

Re: [PHP-DB] Checkboxes to gather rows to delete

I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] = 101 [1] = 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I like the way of doing it that Mathieu has shown using the

Re: [PHP-DB] Checkboxes to gather rows to delete

Thats just it. I am just not sure what to do with the array before my delete from query now that I have it :-) Thanks... Lewis - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:13 AM

Re: [PHP-DB] Checkboxes to gather rows to delete

Thats just it. I am just not sure what to do with the array before my delete from query now that I have it :-) Thanks... Lewis You don't have to do anything with it, just throw it into the line that I gave you. Show the code you have now and someone can help you put it all together. ---John

Re: [PHP-DB] Checkboxes to gather rows to delete

Thanks. The below code returns each ID in an array like so... Array ( [0] =101 [1] = 201 ). Thanks for the help! Lewis $teacherID = $_POST[teacherID]; $deleteID = $_POST[deleteID]; if(isset($delete_teacher)) { This is where I should loop through checking for the chosen ones to

Re: [PHP-DB] Checkboxes to gather rows to delete

Hi there, I have double checked the column namesIts giving me a Warning: Bad arguments to implode() error Thanks. Lewis - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:36 AM

Re: [PHP-DB] Checkboxes to gather rows to delete

On Monday 24 February 2003 23:57, George Pitcher wrote: Can I raise a point of principle here. My databases never have records deleted - instead they are marked as being deleted in a status field. That way, they are always there for reference. Unless you are running a system that needs the

RE: [PHP-DB] Checkboxes to gather rows to delete

Hi there, I have double checked the column namesIts giving me a Warning: Bad arguments to implode() error Thanks. Lewis What's the code you're using? Are you sure $deleteID is an array at the point you call implode()? Are you sure it's available in the current scope at the point you

Re: [PHP-DB] Multiple select box using mysql

I'm not sure if anyone answered this for you, and perhaps I'm missing something. Are you simply trying to populate a multi-select box with MySQL data? If so, try this: echo form tag here... echo SELECT NAME=\software[]\ MULTIPLE SIZE=5; $query=select ID, Name, Version from software;

[PHP-DB] Using PHP and Oracle with NT / 2000 and IIS.

Well, I promised on making a post on how to get it running, and I've yet to clean up and find the bare minimum on using Oracle + OCI in PHP on windows... 1) PHP under IIS running as a CGI runs as IUSR_machinename where machinename may be some weird set of characters. Try giving IUSR read

Re: [PHP-DB] Checkboxes to gather rows to delete

I think the problem is that I need to put the array into a comma delimited group Lewis - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: 'Lewis Watson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 11:09 AM Subject: RE: [PHP-DB] Checkboxes to

Re: [PHP-DB] Checkboxes to gather rows to delete

I think the problem is that I need to put the array into a comma delimited group Lewis U... that's what IMPLODE does. It will take the array and turn it into a comma separated list. Your having a problem because you're not passing an array when you think you are. ---John Holmes...

[PHP-DB] question

Is this the place to post questions on php db's?

[PHP-DB] Re: question

[EMAIL PROTECTED] (Ali M) writes: Is this the place to post questions on php db's? php.db - yes ;-) -- --Fredrik Whether you can hear it or not The Universe is laughing behind your back -- National Lampoon, Deteriorata -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Calendar Question

HI there everyone, I currently use a Javascript calender but want one that is in PHP so that it is more flexible for people who disable Javascript (Very important). How can I get PHP to print a simple calendar with sun - sat at the top, then some rows under with the correct dates to correspond

[PHP-DB] inserting binary data into a mysql blob field

I want to be able to insert binary data into a blob field but am having all kinds of problems! I've tried everything twice. I can't get anything to work! Could someone please help me or give me some suggestions? Upload Script: $imgSize1 = $_FILES['userfile1']['size']; $imgSize2 =

Re: [PHP-DB] Calendar Question

on 2/24/03 7:03 PM, Chris Payne at [EMAIL PROTECTED] appended the following bits to my mbox: HI there everyone, I currently use a Javascript calender but want one that is in PHP so that it is more flexible for people who disable Javascript (Very important). How can I get PHP to print a

[PHP-DB] Re: inserting binary data into a mysql blob field

[EMAIL PROTECTED] (Craig Kohtz) writes: [ inserting images into a mysql db ] I haven't done it myself, but a search on php.net for blob mysql file gave (among others) http://www.php.net/manual/en/features.file-upload.php (seach the page for 'blob'). On the other hand, it has been said that

Re: [PHP-DB] Calendar Question

Hey there, Thank you !!! That is EXACTLY what I was after, you're the best :-) Regards Chris on 2/24/03 7:03 PM, Chris Payne at [EMAIL PROTECTED] appended the following bits to my mbox: HI there everyone, I currently use a Javascript calender but want one that is in PHP so that

[PHP-DB] What about MySQL

Hey,Everyone! I am a fresh man in MySQL,Can anyone tell me how i begin to learn it? and what are the different between MySQL and other commerce relative database?As what I known,My SQL is free,but other commerce RDB is very expensive! Why MySQL not in the top? Is MySQL not strong

Re: [PHP-DB] What about MySQL

I am a fresh man in MySQL,Can anyone tell me how i begin to learn it? www.mysql.com is a really good place to start. and what are the different between MySQL and other commerce relative database?As what I known,My SQL is free,but other commerce RDB is very expensive! Why MySQL not in

RE: [PHP-DB] Re: inserting binary data into a mysql blob field

Thanks, I've looked at so many suggestions on how to do things, and have done them all it seems, but either PHP or MySQL must be set up wrong, because it doesn't work for me. The files I'm trying to upload aren't close to a meg big, which is what this talks about. I've heard that storing files in

RE: [PHP-DB] What about MySQL

Ok,Thank for your help very much! Maybe I have make my first step in MySQL and PHP trip! -Original Message- From: Larry E. Ullman [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:14 AM To: Jun.Han Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] What about MySQL I am a

RE: [PHP-DB] What about MySQL

If you are looking for books to help get your feet wet, you can try the following: MySQL, by Paul DuBois (there is a new version that just came out), published by New Riders, ISBN: 0-7357-0921-1 Professional PHP Programming, published by Wrox press, ISBN: 1-861002-96-3 -Lisi At 11:30 AM

[PHP-DB] Grabbing emails into MySql

Hi All How would I go about grabbing ALL emails to a SMTP box and placing there contents and heads (individual parts of the message) into a MySql database. I have a feeling its a file to array kind of thing or a fsock thing but not sure. I have never attempted this kind of thing so any

Re: [PHP-DB] Grabbing emails into MySql

Investigate PHP's IMAP functions. Ignatius - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:09 AM Subject: [PHP-DB] Grabbing emails into MySql Hi All How would I go about