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
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
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
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
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
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
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
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
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
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
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
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 ("
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
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
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
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
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
> 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
How do I set up secondary keys in mysql?
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
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
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
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
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
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
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:
> -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
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
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
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:
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
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
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)) {
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
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
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
- 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
37 matches
Mail list logo