Hi,
unfortunately i can't help you much, but listen
you can make your pattern more readable if you
delete [] there's no need for classes in your pattern
SELECT * FROM ospd WHERE word REGEXP
'^a?p?e?$|^a?e?p?$|^p?e?a?$|^p?a?e?$|^e?a?p?$|^e?p?a?$';
? = one or none but if you need each letter
would be nice if you would tell which line is 140
-Original Message-
From: Burgess [mailto:[EMAIL PROTECTED]]
Sent: donderdag 10 oktober 2002 11:14
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error query : mysql_result
Hi
I have used the mysql_result function to return some specific
Burgess [mailto:[EMAIL PROTECTED]] wrote:
Hi
I have used the mysql_result function to return some specific
information
from database. The information is returned as it should but
I keep getting
this error message:
Warning: Unable to jump to row 0 on MySQL result index 4 in
I have table A with an auto increment coloumn called tid. during the same
query I need to get that value and stick it in a related record in anouther
table.
I have two doubts.
A: What is the way to do a multitable insert? guess is: INSERT INTO
table(fields) VALUES (fields), table1(fields)
I can get the previous insert auto-increment id via mysql_insert_id(). it
will solve my problem. but if you know a soloution that will work in one
query please share it with me/everyone!
--
JJ Harrison
[EMAIL PROTECTED]
Noodle Snacks [EMAIL PROTECTED] wrote in message
[EMAIL
This usually means your query failed. Check for errors using
mysql_error().
---John Holmes...
-Original Message-
From: Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:14 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error query : mysql_result
Hi
I have used
No, you have to use two queries to do two inserts into different
tables...
---John Holmes...
-Original Message-
From: Noodle Snacks [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 7:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Multi-Table Insert and gettin' data
I realize this is off topic, not php db interfacing. However, it is php and I am
hoping someone
can point me to a mailing list that would cover this question. So here goes
I am working on a simple inventory program and am running into the following
messageMethod
Not Allowed
That would be an Apache configuration issue. Somewhere in http.conf, I
think, you can choose whether or not to allow GET/POST operations.
---John Holmes...
-Original Message-
From: Michael Cortes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 10:25 AM
To: [EMAIL
I recently upgrade to PHP 4.2.3 and started having problems with one of my
applications. I have a PHP application that interfaces to a MySQL DB
(version 3.23) all running on an Apache web server (1.3) under Linux 7. Up
until doing the upgrade, everything had been working fine. Now on a daily
I just checked and register_globals are on in php.ini. I have also previously been in
the
httpd.conf in my previous attempts to fix this problem. I have googled my fingers
off and all
fixes have mentioned the conf file for apache. I have played with options ExecCGI
as well as
other
Have you checked apache's config file for:
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php4
AddType application/x-httpd-php-source .phps
?
IIRC Apache denies POST to file types not registered for... Also it may be
possible that your OS upgrade has overwritten your
This is what I have in my config file:
# The following is for PHP4 (conficts with PHP/FI, below):
#IfModule mod_php4.c
AddType application/x-httpd-php .php4 .php3 .phtml .php
AddType application/x-httpd-php-source .phps
#/IfModule
# The following is for PHP3:
#IfModule mod_php3.c
AddType
Sorry, Michael, I meant to send this to the list, not just to you. I
apologize.
Hello all,
I am a php newbie and am currently developing my first php page. My page
will allow several people to log in at the same time sharing access to the
mysql db. SO, I need to use sessions. Does anyone
I'm new at using PHP and mySQL, so please forgive my potentially naive question.
I have a series of checkboxes with different values. The user can select any number
of checkboxes, and I need to store this information in a mySQL table.
2 questions:
Should I have a unique form name for each
Hello,
I'm trying to retrieve data from a MySQL table which contains data encrypted with the
MySQL PASSWORD() function from a PHP script but I can't seem to get it to work.
Below is the query I'm trying:
SELECT * FROM user_data WHERE username = 'thaak' AND password = PASSWORD('thaak');
I
Hello to all!
Quick questionis it possible to do an update query w/ a join yet? If not, what is
your preferred method? Would you take care of it on the PHP side?
I need to update a table w/ data from another table if certain conditions are true,
i.e the fields in the table to be joined
forgive the basic question but how do I add a space in my query
$result=mysql_query(SELECT * from .$dbname..grades WHERE user_id=.$uid.
and subject=.$subject,$db);
I need to force a space between $uid and 'and' and I don't think simply
pressing the space bar does it.
Thanks,
Eddie
--
nevermind, stupid me, I got it working...
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] space in query
forgive the basic question but how do I add a space in my query
Cory Hicks [mailto:[EMAIL PROTECTED]] wrote:
Hello to all!
Quick questionis it possible to do an update query w/ a
join yet? If not, what is your preferred method? Would you
take care of it on the PHP side?
No, it's not possible, at least not with MySQL 3.x. MySQL 4.1, currently in
Quick questionis it possible to do an update query w/ a join yet?
If
not, what is your preferred method? Would you take care of it on the
PHP
side?
Probably depends on your database, but MySQL doesn't support it. I think
MySQL 4.0 might.
I need to update a table w/ data from another
I'm trying to retrieve data from a MySQL table which contains data
encrypted with the MySQL PASSWORD() function from a PHP script but I
can't seem to get it to work. Below is the query I'm trying:
SELECT * FROM user_data WHERE username = 'thaak' AND password =
PASSWORD('thaak');
I then
Perfect, thank you very much Owen!!
Owen Prime [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Sounds like what your trying to do is:
$cartArray[] = array(ItemNumber = $itemnumber,
Brand = $brand,
Quantity =
This is a very good tutorial about authentication using PHP and MySQL. If
you don't use database, you may still learn some thing about sessions from
there:
http://phpcomplete.com/content.php?id=72
Ruth
- Original Message -
From: Edward Peloke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hello,
Curious if there is an easier way to do this (using just SQL and not PHP).
SQL seems powerful enough to do this but can't think of the synatx. Note, I
am using MySQL so no sub-selects (or other useful items). Basically trying
to pull all records for a 24 hour period but instead of
In article
[EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Hello,
Curious if there is an easier way to do this (using just SQL and not PHP).
SQL seems powerful enough to do this but can't think of the synatx. Note, I
am using MySQL so no sub-selects (or other useful items). Basically
Hello, John.
You wrote 10 îêòÿáðÿ 2002 ã., 23:40:10:
J 2 questions:
J Should I have a unique form name for each checkbox, and store it's
J boolean value in the database, OR (is it more streamlined) ..
J To create an array input type=checkbox name=apps value
J =myarray[$i] with
27 matches
Mail list logo