[PHP-DB] TDS odbc driver tar file corrupted?
Good morning, I tried to download and test TDS ODBC linux/unix driver from (file tds-1.6- glibc2-i386.tar.gz) from http://library.freeodbc.org/ website. The file seems to be corrupted. Has anybody tried to download and test it? If anybody has a correct version, please, could you send it to me as soon as possible? We are testing a new functionality and we are stuck on the MsSQL connection. Thank you very much for your courtesy. Andrea ___ Andrea Taglioni KeyG Consulting S.p.A. Tel. +39-3351336633 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mousyu
skyward quash obsolescent menopause capacious bum ringside stripy ministry deleterious prepare chou buttress truism coronate summate dominion absorptive bookshelves humidify spew dogma bob cufflink cosmology guthrie sainthood emily dynamism heat levin sleepy yon addison bijection cognizant redemptive piracy macroscopic insulin breech upland kiowa ostentatious pershing hillel ripple custer cyclic impetuous diem white preparatory consecrate ran indiscretion cavalier dee bullfrog position bacillus discomfit sorenson wilsonian volatile chiton mcintosh snappy chamfer stegosaurus anchorage diminish cohen meliorate salesian wave executor pupate idiomatic stung conrail effusion pull makeup philharmonic conclude pewter infer orgasm float cady comic seduce bowie glacier bituminous postoperative du consist do kelsey postprocess mud infancy maltreat multiplicity quotation bury infertile polynomial seed win adrienne skopje hiroshima diabase gore oceanography ana epistemology blockage czar acquire traumatic stigma maladaptive electrode bacterium silo thicket memorable auberge baseplate colossus eukaryote electrolyte shovel akin black giblet bowditch slug cowpea furthermost wronskian haley dungeon captaincy cool blackjack fitzroy sequoia fibrosis horology amphibious gold mispronunciation irishman puffed tiger combination agnes venom amicable approximable starve carney cornerstone callous betrothal lucas valentine cafeteria itself elicit irrational shirt buckaroo low subtrahend conner dieldrin thank bronchitis moluccas rutherford biconnected sandpaper shaft wayne puke selenate rim sombre lim childish benedict author transmitting collocation diamagnetism franz curdle classic damsel infrared lisp pythagorean friedrich nanking chordate durward towel salesmen ewe dolores blackout bleak arrowhead strabismic aurochs brunhilde contradictory broach coherent hap impedance bittern enormity sorenson amend credulous elegiac document cantilever steppe morphine plebian ruthless expressway corpulent metabole reversion aiken brookline deform cashew embedder paz waddle brickbat ann conrad retch shrinkage streetcar inside hemorrhage shoot fauna controvertible polariton wood splotchy exaggerate downs brownian trudge loincloth embargo hate halsey abe eben diagrammatic aida whereby penny hogging turban vigilante wheat sinewy howsomever drub muzo potts apothecary joss liquid antares bite loaves manhole truancy rattlesnake evaporate nineteen dubious greenware ferromagnetism gabardine sash gee precipitable nonchalant eject caution chlorine doll look de edt mudsling bryn arrack infamy seedy holocene gimpy goodrich benchmark emerald spongy inbred inadequate jonquil knives jog dense registrable raft calfskin claude daffodil talc petite syllabus sworn stall beadle ampere automotive normative nodal predilect shoot ti threw precipitous way cyril holocaust perturb contravention buttonhole lyricism saxon altitude nostrand asymmetry french pad ghetto ankle chipboard emanate buzzword budgetary teflon sisal sterno hater abbreviate oxonian corpse endogamy dignify implement incontrollable clan fraud obstacle electrophorus cuisine honk incombustible padre murk barstow constant screwball youthful anvil consanguineous entice emory bolivar proprioception venerate giggle bellhop eastwood hydrophobia sundial diffractometer hypocritic kalmia loop rue psychoanalytic patchy sloe inoperable alison flowerpot mailman paymaster bella sawfish estimate euler calligraphy quandary friction schubert blew ignore annunciate redmond ullman izvestia lithe vendible spearmint teeter protestation lydia sarasota coward bialystok filibuster soften conch budgetary clank dixie lowe pacifism bam inverse celebrant nyc codpiece spat vortices hoot whit habeas fusty magnesite burly thunderclap blanche adduce butadiene curtsey nouveau bluebill bud buckwheat autotransformer pugnacious cathedral bedim stifle contiguous psychotic culpable hot mixup groundsel berea committeeman paragraph spherule triplex fortunate colonel acclimate blandish calculable basil cryptanalyze main eject willful flew anamorphic purgative rectangular spicy biotic wretch chlorine ideate christendom someone bookish flinty cluster servo advisable dinghy diagnoses bamberger burma buteo architectonic copernican davy disburse pluggable quote whale enrico decomposition rip garland resistible len luminescent equestrian askew commonwealth entire workforce digest emotion owens throw hangmen hoosier herald venereal affluence banks dine tachinid canton natalie chelate foxtail hairy preservation pulse whirligig cindy sieve swigging craftsmen awaken mrs digitate headstrong congressional candidacy cushing shop alternate raster liverpudlian bruit oracle tint bogus sixteenth vitreous alphabet night indecent indubitable calcium breathtaking certitude circlet daredevil deathward accredit braille dod orkney rheumatic pore pabst keys sire flowerpot genie stretch
[PHP-DB] Printer functions under linux
Hello, I have worked with the printer class functions under win and they are ok Can I use similar functions under linux? Thanks Antonio Bernabei -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Multi search function (help)
hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form... I need a way to select my records even one or more field were null (searching only on of the above) because the following SQL will generate null result $name=$_POST['naame']; $lastname=$_POST['lastname']; $nickname=$_POST['nickname']; $m_date=$_POST['m_dateY']; echo $name.$lastname.$nickname.$m_date; $sql = mysql_query(SELECT id, name , lastname , m_date from users where name like binary '%$name%' and lastname like binary '%$lastname%' and nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by id ASC ) or die(mysql_error()); Thanks in advanced -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multi search function (help)
Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form... I need a way to select my records even one or more field were null (searching only on of the above) because the following SQL will generate null result $name=$_POST['naame']; $lastname=$_POST['lastname']; $nickname=$_POST['nickname']; $m_date=$_POST['m_dateY']; echo $name.$lastname.$nickname.$m_date; $sql = mysql_query(SELECT id, name , lastname , m_date from users where name like binary '%$name%' and lastname like binary '%$lastname%' and nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by id ASC ) or die(mysql_error()); Thanks in advanced Use isset to test whether the POST values are set and only include in the query if there is a value. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multi search function (help)
thanks .. but my question is not for isset... i m thinking consider that i have 10 search fields... if i have to do a combination then i need a day to right the various SQL statements David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form... I need a way to select my records even one or more field were null (searching only on of the above) because the following SQL will generate null result $name=$_POST['naame']; $lastname=$_POST['lastname']; $nickname=$_POST['nickname']; $m_date=$_POST['m_dateY']; echo $name.$lastname.$nickname.$m_date; $sql = mysql_query(SELECT id, name , lastname , m_date from users where name like binary '%$name%' and lastname like binary '%$lastname%' and nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by id ASC ) or die(mysql_error()); Thanks in advanced Use isset to test whether the POST values are set and only include in the query if there is a value. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Drawing table by while
Hiya, How can i draw a new tr AFTER FIVE td in the following loop (i want to echo the records in 5 columns width tables whatever the number of records will be fetched) .. echo 'table'; while ($myrow = mysql_fetch_array($sql)) { echo $myrow[0]; } echo '/table'; -- | x | y |z | o | -- |f|q| h| hj | -- . . . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
SV: [PHP-DB] Drawing table by while
Something like this: echo 'table'; $count=1; while ($myrow = mysql_fetch_array($sql)) { If ($count==5) { echo /tr; $count=1; } If ($count==1) echo tr; $count++; echo $myrow[0]; } echo '/table'; Hth Henrik Hornemann -Oprindelig meddelelse- Fra: nabil [mailto:[EMAIL PROTECTED] Sendt: 26. maj 2004 14:28 Til: [EMAIL PROTECTED] Emne: [PHP-DB] Drawing table by while Hiya, How can i draw a new tr AFTER FIVE td in the following loop (i want to echo the records in 5 columns width tables whatever the number of records will be fetched) .. echo 'table'; while ($myrow = mysql_fetch_array($sql)) { echo $myrow[0]; } echo '/table'; -- | x | y |z | o | -- |f|q| h| hj | -- . . . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Multi search function (help)
Nabil wrote: David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form... I need a way to select my records even one or more field were null (searching only on of the above) because the following SQL will generate null result $name=$_POST['naame']; $lastname=$_POST['lastname']; $nickname=$_POST['nickname']; $m_date=$_POST['m_dateY']; echo $name.$lastname.$nickname.$m_date; SELECT id, name , lastname , m_date from users where name like binary '%$name%' and lastname like binary '%$lastname%' and nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by id ASC ) or die(mysql_error()); Thanks in advanced Use isset to test whether the POST values are set and only include in the query if there is a value. thanks .. but my question is not for isset... i m thinking consider that i have 10 search fields... if i have to do a combination then i need a day to right the various SQL statements So do something like: $query = SELECT id, name , lastname , m_date from users where 1 ; if (isset($_POST['name'])) { $query .= AND name like binary '%{$-POST['name']}%' ; } if (isset($_POST['lastname'])) { $query .= AND name like binary '%{$_post['lastname']}%' ; } //etc etc $query .= order by id ASC ; $sql = mysql_query($query) or die(mysql_error()); -- David Robley Only cosmetologists give make-up exams. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Passing an ADO Recordset by Reference
Does anyone know how to pass an ADO Recordset by reference to a COM object member function in PHP v4.3.6? eg. This is my best guess... dies horribly :( $AComObject = new COM(AServer.AObject); $AADORecordSet = new COM(ADODB.Recordset); // I wrap the ADO Recordset as a Variant... read on Zend that I have to do this, syntax is probably wrong $rAADORecordSet = new VARIANT($AADORecordSet, VT_DISPATCH | VT_BYREF); // The following function takes a reference to an ADO Recordset object as a parameter $AComObject-AFunction($rAADORecordSet); while (!$AADORecordSet-EOF) { echo $AADORecordSet-Fields[Field1]-value . br; $AADORecordSet-MoveNext(); } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Undefined variable
Hi!! I have a very simple and smail script with just one input text box and a submit button. After that, I have an echo function in the same code page that just displays the data entered in the text box. But I'm receiving an undefinied variable error when I execute it!! Echo ($Name); I'm using Windows 2000 Server and PHP for Windows. Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx
Re: [PHP-DB] Undefined variable
echo $_REQUEST['Name']; - Original Message - From: Miguel Guirao To: PHP DB List Sent: Wednesday, May 26, 2004 17:47 Subject: [PHP-DB] Undefined variable Hi!! I have a very simple and smail script with just one input text box and a submit button. After that, I have an echo function in the same code page that just displays the data entered in the text box. But I'm receiving an undefinied variable error when I execute it!! Echo ($Name); I'm using Windows 2000 Server and PHP for Windows. Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx
RE: [PHP-DB] Undefined variable
Thanks so much!!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Viorel Dragomir [mailto:[EMAIL PROTECTED] Enviado el: MiƩrcoles, 26 de Mayo de 2004 09:55 a.m. Para: Miguel Guirao; PHP DB List Asunto: Re: [PHP-DB] Undefined variable echo $_REQUEST['Name']; - Original Message - From: Miguel Guirao To: PHP DB List Sent: Wednesday, May 26, 2004 17:47 Subject: [PHP-DB] Undefined variable Hi!! I have a very simple and smail script with just one input text box and a submit button. After that, I have an echo function in the same code page that just displays the data entered in the text box. But I'm receiving an undefinied variable error when I execute it!! Echo ($Name); I'm using Windows 2000 Server and PHP for Windows. Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem in passing the necessary variable.
Hi, I have developed a news system .. I can select to insert an image into the articles. The function to extract the image calling them by the imgid of images table is the following: function getImm() { ? select name=image ? connect(); $sql = select * from images; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { printf(option value=\%s\%s/option, $row[id_img], $row[imgid]); } ? /select ? I'd like to be able to see the image before to publish the piece of news. I think about a window pop up with java in order to create a preview of the image. The code follows: a href=../images/image.php?img=XX target=_blank onClick=window.open(this.href, this.target, 'width=200,height=250'); return false;img SRC=../preview.jpg ALT=Click to look at the picture you are charging border=0/a The problem is that I can't pass the imgid to the href inspite of the May someone tell me how to pass the id number in order to show me the image or how may I solve the trouble? I hope someone will help me ... Sincerely, Alexander -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Undefined variable
Are you using a FORM Post or Get ? Perhaps $_POST['Name'] or $_GET['Name'] Hi!! I have a very simple and smail script with just one input text box and a submit button. After that, I have an echo function in the same code page that just displays the data entered in the text box. But I'm receiving an undefinied variable error when I execute it!! Echo ($Name); I'm using Windows 2000 Server and PHP for Windows. Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx
Re: SV: [PHP-DB] Drawing table by while
Or like this (to be a little more complete, with comments): // initialize counter $count=0; // start the table and the first row echo tabletr; // loop through fetch results while ($myrow = mysql_fetch_array($sql)) { // if we've output 5 columns... if ($count==5) { // end the current row, start another echo /trtr; // and reset our counter $count=0; } // output the next cell in this row echo td.$myrow[0]./td; // and increment the counter $count++; } // end the row and the table echo '/tr/table'; I've used this type of code before, but have not checked the specific code above for spelling or other typographic errors. The example code posted earlier (see below) had a small error in that the counter was incremented twice if it was the first column, therefore only printing 4 columns. :Mike S. :Austin TX USA Something like this: echo 'table'; $count=1; while ($myrow = mysql_fetch_array($sql)) { If ($count==5) { echo /tr; $count=1; } If ($count==1) echo tr; $count++; echo $myrow[0]; } echo '/table'; Hth Henrik Hornemann -Oprindelig meddelelse- Fra: nabil [mailto:[EMAIL PROTECTED] Sendt: 26. maj 2004 14:28 Til: [EMAIL PROTECTED] Emne: [PHP-DB] Drawing table by while Hiya, How can i draw a new tr AFTER FIVE td in the following loop (i want to echo the records in 5 columns width tables whatever the number of records will be fetched) .. echo 'table'; while ($myrow = mysql_fetch_array($sql)) { echo $myrow[0]; } echo '/table'; -- | x | y |z | o | -- |f|q| h| hj | -- . . . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Multi search function (help)
I'm not 100% sure, but you may want to also check if the field is empty (using empty() function) before including in your search. (in addition to isset) Also, just a caution, you will need to take some care in figuring when and where to place your 'and' statements linking the various parts of the query. At 08:01 AM 27/05/2004, you wrote: Nabil wrote: David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname , nickname and phone form... I need a way to select my records even one or more field were null (searching only on of the above) because the following SQL will generate null result $name=$_POST['naame']; $lastname=$_POST['lastname']; $nickname=$_POST['nickname']; $m_date=$_POST['m_dateY']; echo $name.$lastname.$nickname.$m_date; SELECT id, name , lastname , m_date from users where name like binary '%$name%' and lastname like binary '%$lastname%' and nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by id ASC ) or die(mysql_error()); Thanks in advanced Use isset to test whether the POST values are set and only include in the query if there is a value. thanks .. but my question is not for isset... i m thinking consider that i have 10 search fields... if i have to do a combination then i need a day to right the various SQL statements So do something like: $query = SELECT id, name , lastname , m_date from users where 1 ; if (isset($_POST['name'])) { $query .= AND name like binary '%{$-POST['name']}%' ; } if (isset($_POST['lastname'])) { $query .= AND name like binary '%{$_post['lastname']}%' ; } //etc etc $query .= order by id ASC ; $sql = mysql_query($query) or die(mysql_error()); -- David Robley Only cosmetologists give make-up exams. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php . . Ross Honniball. JCU Bookshop Cairns, Qld, Australia. . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php