Re: [PHP-DB] converting from form - dropdown box

2003-01-14 Thread xxx xxxx
hi, all you have to do is to extract values from the database with a query. i suppose you know... after that you have to do all you have done till now except the dropdown toolbox(that is called actually a listbox). for the list box you have to write like this: select name=select ?php

Re: [PHP-DB] browsing sorted resultsets from an oracle db

2003-01-14 Thread xxx xxxx
try steping like this: 1. select all you have to find; like dates[][] ..the result is a matrix if you have more then one field 2. register that values with session_register(dates) 3. in every page you have to put a starting counter with it you have to display the values starting with... like

Re: [PHP-DB] Oracle and CLOBs

2003-01-14 Thread xxx xxxx
try SELECT Title, NewsDate, Content FROM inf_news WHERE ID_News = 5 Where Title is VarChar, NewsDate is Date and Content is CLOB ! not Content is a CLOB ! - simple is CLOB because i guess it interprets you say is a not is a CLOB..it thinks the datatype you are searching is a cybercop78

Re: [PHP-DB] javascript and submitting forms

2003-01-14 Thread Adam Royle
Hi Mignon, This should work, never closing the window without submitting (foolproof). Just add some error checking, and you'll be sweet as a nut! All I did was add the echo statement underneath the data insert. Adam ? include ('dbconn.php'); if(isset($submit)) { $query = INSERT INTO

[PHP-DB] Getting data from SQLBase on W2k

2003-01-14 Thread Antti Ijäs
Hi I'm having big problems getting data from a SQLBase database located on a win 2000 server. There doesn't seem to be any ODBC-drivers to that particular database? Do you guys have any idea how I should solve the problem? I'm quite new to windows ODBC- connections and unfortunately I have to

Re: [PHP-DB] how made php on FreeBSD connect to Oracle 8.1.5 on Windows 2000 server

2003-01-14 Thread Jadiel Flores
You have to install the Oracle Client in your FreeBSD server in order to compile php with the -with-oci8=[ORA_PATH] that's why it didn't work At 09:24 PM 1/14/2003 +0800, Cedar John wrote: Hi!I am a newbie. I've got a system with FreeBSD_4.7_release+apache_1.3.27+php_4.2.3. I want access oracle

Re: [PHP-DB] javascript and submitting forms

2003-01-14 Thread Mignon Hunter
Thanks again for the advice. This approach wont work in this case because I'm launching the window from an app, then I need to close to return to the app. If I submit back to my app, it brings a new app into the addl window. And no, you're definetly not stupid ! Thanks for the help. Mignon

Re: [PHP-DB] javascript and submitting forms

2003-01-14 Thread Mignon Hunter
This works! Thanks Adam On Tue, 2003-01-14 at 03:11, Adam Royle wrote: Hi Mignon, This should work, never closing the window without submitting (foolproof). Just add some error checking, and you'll be sweet as a nut! All I did was add the echo statement underneath the data insert.

Re: [PHP-DB] LEFT JOIN not working

2003-01-14 Thread Lisi
Still not working. I made the change, and I'm still getting all results. I even tried it without the leading '0' in front of the 1, no good. Here's my current query, with suggested changes: SELECT ads_displayrate.name, SUM(ads_displayrate.count) as display, SUM( IF( ads_clickrate.date IS NULL,

Re: [PHP-DB] LEFT JOIN not working

2003-01-14 Thread Miles Thompson
For a start simplify the query, so that you are returning only one field until you get it right, say ads_displayrate.name. Second, echo the SQL statement so you can see what has been generated. Third, check the datatypes returned for YEAR(), MOTN() and DAYOFMONTH() functions in MySQL. As part

[PHP-DB] MySQL problem with RedHat 8

2003-01-14 Thread Daniel Elenius
Hi! I'm trying to connect to my mysql database using something like mysql_connect( 'localhost', 'root', 'thepassword' ) or die ( 'Unable to connect to server.' ); But I get the error message: Fatal error: Call to undefined function: mysql_connect() in

Re: [PHP-DB] Arrays and forms

2003-01-14 Thread Mignon Hunter
Hello list, I submitted this problem earlier but got no response so I thought I'd elaborate. The code below successfully displays all of the problems from the db. Based on what is chosen here, needs to go into another table in the db along with a customer tracking id. for($knt = 0;$row =

Re: [PHP-DB] Arrays and forms

2003-01-14 Thread Jason Wong
On Wednesday 15 January 2003 03:23, Mignon Hunter wrote: Hello list, I submitted this problem earlier but got no response so I thought I'd elaborate. The code below successfully displays all of the problems from the db. Based on what is chosen here, needs to go into another table in the db

[PHP-DB] ldap_search in 4.3

2003-01-14 Thread Ryan Jameson (USA)
Weirdness I just started using PHP 4.3 and something strange is happening with my ldap_search calls. It isn't working like it used to. Anyone have any ideas? When I revert to 4.2.3 it works fine. Ryan Ryan Jameson Software Development Services Manager International Bible Society W

RE: [PHP-DB] ldap_search in 4.3

2003-01-14 Thread Ryan Jameson (USA)
Well, I discovered that the php_ldap extension released with 4.2.3 works fine with php 4.3 ... so I'm mostly upgraded. :-) however, I'd still like to have the new extension work. Let me know if anyone finds anything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Tuesday,

[PHP-DB] error message print

2003-01-14 Thread Addison Ellis
hello, how can i get an error message to print in the color red as in the code below? thank you for your time, addison $message_new = $zip is not a valid zip code. Please try again.; -- Addison Ellis small independent publishing co. 114 B 29th Avenue North

Re: [PHP-DB] error message print

2003-01-14 Thread Kent Roper
echo font color=red$message_new/font; Is that what you wanted? - Original Message - From: Addison Ellis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 5:01 PM Subject: [PHP-DB] error message print hello, how can i get an error message to print in the

[PHP-DB] db connect probs

2003-01-14 Thread Addison Ellis
hello, do you have any idea why the following(line 106)would return the following error message ? the login.php has an included form to create an account and that is what will not connect. $connection = mysql_connect($host, $user,$password) //this is line 106 Warning: Access denied for user:

Re: [PHP-DB] db connect probs

2003-01-14 Thread Larry E. Ullman
do you have any idea why the following(line 106)would return the following error message ? the login.php has an included form to create an account and that is what will not connect. $connection = mysql_connect($host, $user,$password) //this is line 106 Warning: Access denied for user:

[PHP-DB] Informix

2003-01-14 Thread Foong
Hello, Does any one know how to connect to Informix database on a Different server?? I have searched on google, php.net but couldn't get a details guide on what to set. the ifx_connect() does not give me an option to pass in the database server ip. Do I need to set it somewhere else?? Foong