[PHP-DB] php and oracle

2001-10-23 Thread Marco Orsuni
Hallo, I have problems installing php in Linux Mandrake 7.2. Php work, but I can't see the oracle funcions. I guessed I had to recompile the source. I have downloaded the latest version of php from php.net. I unzipped the file in /tmp but when I write "./configure" the program go in abend with

[PHP-DB] How can I insert a binary-file into sybase dbsystem??

2001-10-23 Thread Benjamin
I'd finished install sysbase,but could not insert binary-file (pic or mp3) into it ,why?? Thanks:) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

[PHP-DB] Category search w/o specified categories

2001-10-23 Thread olinux
Hi all, I would like to know if anyone has any ideas on how a script behind a search such as www.smartpages.com would work. i.e a search for doctors returns "similar categories" that do not even include the word "doctor" So how is this possible, is there a cross reference of synonyms ? Thanks

[PHP-DB] Html email

2001-10-23 Thread Benny
Please help me. I have problem with html email. I send email to 3 email address : [EMAIL PROTECTED], [EMAIL PROTECTED] and [EMAIL PROTECTED] The email client for yahoo & eudoramail is their web. And for the last destination, the email client is ms outlook. The html email for yahoo & eudoramail

[PHP-DB] Newbie in Need of Assistance

2001-10-23 Thread JMack
Greetings. I have been playing around with PHP this week, programming a football pool. I have hit a small snag that I would like some assistance with, if anyone knows the answer -- it's probably very simple, but my Intro to PHP book does not tell me how to do it. I have an HTML form in a PHP pa

RE: [PHP-DB] PHP form to search MySQL DB

2001-10-23 Thread Rick Emery
The error messages have NOTHING to do with the date format. See my previous email to determine how to determine where error is. rick -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 4:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP form to searc

RE: [PHP-DB] PHP form to search MySQL DB

2001-10-23 Thread Peter Lovatt
Hi echo $query; echo mysql_error( $mysql_db_link); is useful for finding query errors (it echos the query itself, and any error message) but the problem here I think is that you are using 'date' as a field name and/or variable name. Try using a name which is not a reserved word. HTH Peter

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-23 Thread Peter Lovatt
Hi while(...) { do whatever } mysql_data_seek ($mysqlresultid, 0) while(...) { do whatever } mysql_data_seek ($mysqlresultid, 0) etc will set the pointer back to the beginning of the result set, so you can scan through it as many times as you need to, without needing to repeat the query. HT

[PHP-DB] PHP form to search MySQL DB

2001-10-23 Thread Jason
Ok here is my problem... I have a form on a page named index.php and the code for the form is as follows: *I.E. - Format is 04/01/2001* Search for Ads by date: This form is used to supply the variable that we would like to seach the da

[PHP-DB] Re: Warning: MySQL: Unable to save result set

2001-10-23 Thread Leobarod Cortes
HI there.. I ahve the following issue Error MySQL said: Host 'bbtest' is not allowed to connect to this MySQL server Do you have any idea what could go wrong??? Leo Doug Schasteen wrote: > Warning: MySQL: Unable to save result set in on > line *** > > I recently upgraded to php 4 fro

Re: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason
Ok I made the changes and now I am getting these 2 errors... Warning: 0 is not a MySQL result index in search01.php on line 141 and this one... Warning: 0 is not a MySQL result index in search01.php on line 143 No rows found On line 141 - $count = mysql_num_rows($results); On line 143 - if (mysq

Re: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason Wood
Let me guess, the parse error is on the last line of the file? I get that all the time, its usually caused by a loop thats still open... and, in your case, your "do" and "if" statements arent closed try this. mysql_connect ("db_hostname", "db_username", "db_password"); mysql_select_db ("

RE: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Rick Emery
OK. Ya followed me just a little too literally. We needed you to restructure. So you're part way there. i've made some changes below. I don't have access to PHP here at work, otherwise I'd test the changes I made below. So you'll have to test them. You'll note that I placed the while(){} loo

Re: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason
Ok here is the script after changes... Name: ".$row['fname, lname']."\n"; if (mysql_num_rows($results) ) { while( $row = mysql_fetch_array($result) ) { } } else { print "No rows found"; } ?> And now I get a parse error on line 201 which is below the html and php code, so there isn't anything to

Re: [PHP-DB] keys in mysql

2001-10-23 Thread Jason G.
You read the mysql manual. www.mysql.com Look up alter table. ALTER TABLE mytable ADD KEY keyname (keyfield1, keyfield2); -Jason Garber At 08:33 PM 10/23/2001 -0700, søren eriksen wrote: >How do I set up secondary keys in mysql? -- PHP Database Mailing List (http://www.php.net/) To unsubscr

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-23 Thread Rick Emery
You're on the right track. Did you try?: while( $row[] = mysql_fetch_array($result) ); This should load each result row into a row of a multi-dimensional array. You would then access it with: $row[0]['colname'] -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Tu

[PHP-DB] Using A Query Results Multiple Times

2001-10-23 Thread Adam Douglas
I have an instance where I have to query my MySQL database and then use the multiple row results to create multiple pull down menus on a web page. My problem is how can I take the results of the query and use them more the once to create pull down menus? I've always used a while look to fe

RE: [PHP-DB] Cant connect to a remote mySQL database

2001-10-23 Thread Matt Williams
> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using > password: > NO) in /usr/local/apache/htdocs/pruebamysql.php on line 5 > > Warning: MySQL Connection Failed: Access denied for user: > '[EMAIL PROTECTED]' (Using password: NO) in > /usr/local/apache/htdocs/pruebamysql.php on line 5 > 1

[PHP-DB] keys in mysql

2001-10-23 Thread søren eriksen
How do I set up secondary keys in mysql?

[PHP-DB] Cant connect to a remote mySQL database

2001-10-23 Thread Leobarod Cortes
Hi John: Im trying to connect to a remote mysql database but it seems that this thing is not working This is the information that thw browser sent to me: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /usr/local/apache/htdocs/pruebamysql.php on line 5 Warning: MyS

RE: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Rick Emery
First o all, GET RID of the 19 constructs using mysql_result(). You've already captured the row with the $row=mysql_fetch_array(). mysql_result() cannot be mixed with mysql_fetch_arry(). So instead of: echo "Address: "; printf(mysql_result($result,$count,"address")); echo "\n"; use: print "Addr

Re: [PHP-DB] ADORecordset Equivalent in PHP?

2001-10-23 Thread Richard Chauvaux
I would suggest checking out the classes at http://phpclasses.upperdesign.com/browse.html I've used the mysql_recordset class that is part of the mysql_db package. It has the basic methods similar to ADO. I found it to be very functional if you're using mysql. There are other classes there as w

[PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason
As of yet I have tried all sorts for date formating for the search field to work. I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc. The date field in the database is stored as 10/23/2001 and yet when a user enters the date and clicks the search button it does not display the results. I am

Re: [PHP-DB] datetime in MSSQL7

2001-10-23 Thread Frank M. Kromann
This problem has just been fixed in CVS. - Frank > Hello! > > How can I force PHP to fetch datetime field i 'mmdd hh:mm:ss' WITHOUT > using MSSQL query like *SELECT convert(varchar,dtfield,20) as 'dtfield'* and > so on? > I have a few tables on MSSQL with the different structures and som

[PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason Wood
I'm not positive, but try switching the day and month fields. ie: 28/04/1981 for April 28th, 1981 instead of 04/28/1981 Could work... I know alot of programs, etc, use this format, and I cant remember offhand right now. Let me know if it works for you!! -- Jason Wood Chief Technology Office

[PHP-DB] PHP and MySQL queries...

2001-10-23 Thread Jason
I am having a hard time setting up a form for users to enter a date in the format of 00/00/ (of course they would use an actual date). My form is as follows... *I.E. - Format is 04/01/2001* Search for Ads by date:

RE: [PHP-DB] Informix + PHP any gotcha's to watch out for?

2001-10-23 Thread Mark Roedel
> -Original Message- > From: davemacgb [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 12:12 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Informix + PHP any gotcha's to watch out for? > > > I've only used MySQL via PHP until now, does anyone know of > any gotchas that I s

[PHP-DB] Re: looped insert

2001-10-23 Thread Russ Michell
Relax! $email comes from a text input, and the categories come from checkboxes dynamically displayed from table column names: //Get all table column names, dynamically display, and use to accept subscriptions to category updates: $fields = mysql_list_fields("$dbName", "myanet_categories", $co

[PHP-DB] Re: looped insert

2001-10-23 Thread bill
Hi Russ, It's not clear that you're keeping track of which categories are being checked. You name them category[$names] but you refer to them as $category[$i] where $i is a number. How will you know what $category[1] refers to? Other issues: It's also not clear where the value of $email come

[PHP-DB] ADORecordset Equivalent in PHP?

2001-10-23 Thread MrBaseball34
I know about mysql_fetch_array but how would I do it for each row into a "recordset" that I can use instead? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail:

[PHP-DB] Flatrate - Request 559

2001-10-23 Thread
Below is the result of your feedback form. It was submitted by ([EMAIL PROTECTED]) on Tuesday, October 23, 2001 at 09:06:48 --- message: Introducing The Newest Flatrate LongDistance Plan Along With A System To Make $580

[PHP-DB] PHP/IIF/INFORMIX

2001-10-23 Thread Andreas Schmitz
Hi, I have some problems with the interface between windows PHP and informix. the following constellation is on the windows box: Windows2000 Microsoft-IIS/5.0 PHP 4.0.6 php_ifx.dll aus PHP 4.0.6 ist installiert IFX-ClientSDK 2.70 TC1.1 the windows box is used to generate templates for the webse

Re: RE: [PHP-DB] looped insert

2001-10-23 Thread Russ Michell
Gottit at last!: //If submit button selected, process those ticked checkbox categories: if(isset($submit)) { //Start off sql $sql = "INSERT INTO $myanet02 ("; //loop while categories have been ticked while(list($key,$val) = each($category)) {

Re: RE: [PHP-DB] looped insert

2001-10-23 Thread Russ Michell
Hi all + Rick: Since the last email I have got even closer, here is the code: //If submit button selected, process those ticked checkbox categories: if(isset($submit)) { //Start off sql $sql = "INSERT INTO $myanet02 ("; //loop while categories have been ticked whi

[PHP-DB] Re: ifx_connect error

2001-10-23 Thread Andreas Schmitz
Muciño Zúñiga Marco Antonio wrote: > > I'm trying to connect to a Informix database but I get the error : > > Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829] in > /usr/local/apache/htdocs/php/connect.php on line 2 > Imposible conectarse a la base de datos. > > My script is : > >$c

Re: RE: [PHP-DB] looped insert

2001-10-23 Thread Russ Michell
Hi Rick: Cheers for the info. Thwe following code almost does it, however, the NULL value isn't inserted, if checkboxes are != to 'yes': //If submit button selected, process those ticked checkbox categories: if(isset($submit)) { //Start off sql $sql = "INSERT INTO $myanet02 (staffdev,strategie

Re: [PHP-DB] Creating a file using php

2001-10-23 Thread Jon Farmer
- Original Message - > > Polite: Well its easier to post and get a reply rather then me going and > serching fo it.;) Easier for who? Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to [EMAIL PR