- 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
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
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 :
?
$conn_id
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
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
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
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:
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
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,
-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 should
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 some of
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
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
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 BAddress: /B;
printf(mysql_result($result,$count,address));
echo BR\n;
use:
print
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:
How do I set up secondary keys in mysql?
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
1045:
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:
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
Ok here is the script after changes...
?php
mysql_connect (db_hostname, db_username, db_password);
mysql_select_db (db_name);
if ($date == )
{$date = '%';}
$result = mysql_query (SELECT
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
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(){}
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 (db_name);
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 location of script on
line ***
I recently
Ok here is my problem... I have a form on a page named index.php and the
code for the form is as follows:
form name=auth method=post action=search01.php
p*I.E. - Format is 04/01/2001*/p
pSearch for Ads by date:
input type=text name=date
/p
p
input
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
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
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
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
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
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:
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
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
32 matches
Mail list logo