RE: [PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL 4.1.7

2004-12-27 Thread Denis Gerasimov
Hello Piotr, > -Original Message- > From: Piotr Wilkin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 5:46 AM > To: php-db@lists.php.net > Subject: [PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL > 4.1.7 > > I have noticed a very peculiar behavior when I upgr

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 8:48 PM, S Kumar <[EMAIL PROTECTED]> said: > Hello Pete: > > However, in the case of checkboxes, I do not know how > to make variables out of them depensing on what user > selects. Say whatever user cheks in the checkbox, > that variable has to be searched in TABLE-C and > vari

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread S Kumar
Hello Pete: It is a cancer patients for whom i have data on preoperative and postoperative procedures and drugs administered for that condition. my table looks like this: S. No Pat_age_group type_of cancer size_of_tumor 1 Old Prostate 5 cm 2 Young bre

[PHP-DB] Re: How to build a dinamic link...

2004-12-27 Thread Frank M Flynn
Hola, I think what you want would be like this: Let's say your table has these fields: id, title, authorID, category and article (which is the text). so the first query might be - SELECT id, title, category FROM myTable WHERE authorID = $myID and you want to know how to present a list of h

[PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL 4.1.7

2004-12-27 Thread Piotr Wilkin
I have noticed a very peculiar behavior when I upgraded my PHP revision from 4.3.9 to 4.3.10 (I use Debian Linux). Suddenly, the PHP MySQL client stopped accepting the default encoding / collation when connecting to the server. When issuing any query containing text field comparisons, I get the fol

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 9:22 PM, p said: > > > > Select age_group from patient_data where age_group = > > young and old ; > > > > > > I am truly stuck here. Can any one please help me out > > to pass this situation. > > > > Thank you in advance. > > > > Kumar. > > PS- How can a single patient

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread Peter Jay Salzman
On Mon 27 Dec 04, 5:22 PM, S Kumar <[EMAIL PROTECTED]> said: > Dear group, > I am a novice programmer started doing php to process > a query form of my patients. > > I have a database and one table in it deals with my > patient information. Depending on their condition I > divided their age

[PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread S Kumar
Dear group, I am a novice programmer started doing php to process a query form of my patients. I have a database and one table in it deals with my patient information. Depending on their condition I divided their age groups into 3 categories. In my database a table patient_data has a column a

Re: [PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread John Holmes
amol patil wrote: entered information still not shown in table of database is below code is right ? form name and type values are 'submit' . then what is wrong with this code, if(isset($_POST['submit'])) { $dbh=mysql_connect ("localhost", "root") or die ('I cannot connect to the da

Re: [PHP-DB] to many addresses

2004-12-27 Thread tg-php
Sounds like pre-loading the addresses into javascript or something is also going to be just as cumbersome and that's the only other method I can think of to have the addresses auto-complete realtime. Yahoo has a little helper app that works with Yahoo mail to auto-complete names from your emai

Re: [PHP-DB] to many addresses

2004-12-27 Thread Joseph Crawford
one thought might be to check thier data for Str, St etc... and have it automatically replace with Street. Another would be to reload the page and give them suggestions on what to use, if they do Rd, have a drop down with Road, Street, Avenue etc.. so they can choose the correct one. -- Joseph

[PHP-DB] Update keeps failing with php/sqlite

2004-12-27 Thread Peter Jay Salzman
Hi all, I made a toy database. Two tables are "students" (a collection of student info) and "message" (private messages I want individual students to read). The "message" table is indexed by a student's social security number. student last, first, ssn, address, city, state, zip, email messag

Re: [PHP-DB] to many addresses

2004-12-27 Thread Bastien Koert
aother option here might be to build a set of associative arrays together that cover all the possibilities of the address endings ie $addresses = array('Road' =>'Road','Rd', 'Street' =>"Street','Str','St'); etc and run thru a little checking code to convert those possbibities into one defined f

[PHP-DB] How to build a dinamic link...

2004-12-27 Thread Daniel A. Betancourt
Hi there!!! This is one of my first postings to this list. I spend most of the time reading the postings, but now I need to ask: How to build a link dinamicly from an output of a query to a web page? Much clearly. I need that certain user can upload a text content into the web site. It doesn´t h

[PHP-DB] to many addresses

2004-12-27 Thread Perry, Matthew (Fire Marshal's Office)
We have about 20,000 addresses in our database. If my users are filling out a form that requires an address already in our database I have to make sure they enter it in a format already in the db (such as "West Road" not "West Rd."). I have to also allow for new addresses. Obviously having a d

FW: [PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread Darryl
>From what I see, the code is fine, you just haven't finished it. mysql_query("INSERT INTO totalinfo (Username,Password) VALUES ('$loginusername','$loginpassword'),$dbh")or die (mysql_error()); } Give that a bash -Original Message- From: John Hicks [mailto:[EMAIL PROTECTED] Sent: Monda

Re: [PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread John Hicks
amol patil wrote: hallo , entered information still not shown in table of database is below code is right ? form name and type values are 'submit' . then what is wrong with this code, if(isset($_POST['submit'])) { $dbh=mysql_connect ("localhost", "root") or die ('I cannot connect to the dat

[PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread amol patil
hallo , entered information still not shown in table of database is below code is right ? form name and type values are 'submit' . then what is wrong with this code, - Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile ph

[PHP-DB] how to set submit.

2004-12-27 Thread amol patil
hallo, clicking on submit entered info. is not entering in database. how to set submit , so that query wll execute correctly. ?php if($submit) { $dbh=mysql_connect ("localhost", "root") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("