Mike U. Petrov wrote:
Hi every1!
Excuse me for maybe offtopic but I need help on mysql database.
I have 4 tables, and here are some important extractions from 'em:
objects{
object_id;
name;
}
users{
user_id;
nick;
date;
}
notes{
user_id;
First, sorry my starnge way to post new thread.
Second:
I want to specify some features:
in my table notes I've a lot of user_id's for each object_id and I don't
want to find unique user_id, I only want to find one user_id for each
object_id, so unique(user_id) doesn't match. Do u have any other
You can also DISTINCT command instead.
UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
using)
Hope this helps,
M.Mamedov
- Original Message -
From: Justin Patrin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 9:52 AM
Subject: [PHP-DB]
No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
need ONE user_id per one object_id.
Mike U. Petrov
-Original Message-
From: Muhammed Mamedov [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re:
Give me exactly the sample table with data and show what you want there.
I will try to help you.
M.Mamedov
- Original Message -
From: Mike U. Petrov [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 10:17 AM
Subject: RE:
Mike U. Petrov wrote:
First, sorry my starnge way to post new thread.
Second:
I want to specify some features:
in my table notes I've a lot of user_id's for each object_id and I don't
want to find unique user_id, I only want to find one user_id for each
object_id, so unique(user_id) doesn't
Hi,
can I know when does the magic_quotes_gpc start adding slashes and stripping slashes?
I removed my EscapeShellCmd and my data is inserted and retrieved from the database
just as i wanted. The problem now comes when I retrieve that data and immediately
inserted them into another table..
Thanx you all guys, great tools indeed!
- Original Message -
From: Roger Spears [EMAIL PROTECTED]
To: php database [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 6:33 PM
Subject: Re: [PHP-DB] password generator
Here's one I've used recently with success
On Thursday 11 December 2003 17:27, Ng Hwee Hwee wrote:
can I know when does the magic_quotes_gpc start adding slashes and
stripping slashes?
magic_quotes_gpc is for incoming GET/POST/Cookie data (NB it does not strip
slashes) ...
I removed my EscapeShellCmd and my data is inserted and
I know it is possible to search a database like this:
SELECT * FROM x_table WHERE name=%part_of_name%
but I don't know for sure the correct command.
Could you tell me the right syntax?
TIA
Aurel.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
It should be as follows:
SELECT * FROM x_table WHERE name Like = %part_of_name%
Hope this helps,
M.Mamedov
- Original Message -
From: Constantin Brinzoi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:51 PM
Subject: [PHP-DB] SQL question
I know it is
try
SELECT * FROM x_table WHERE name LIKE %part_of_name%
-Original Message-
From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 11:52
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL question
I know it is possible to search a database like this:
SELECT *
I am sorry without equal = sign
SELECT * FROM x_table WHERE name Like %part_of_name%
there are actually three ways to do this:
%part_of_name% part_of_name appears anywhere
%part_of_namepart_of_name appears at the end
art_of_name% part_of_name appears at the begining
$query = SELECT * FROM x_table WHERE name like '%part_of_name%' ;
Constantin Brinzoi wrote:
I know it is possible to search a database like this:
SELECT * FROM x_table WHERE name=%part_of_name%
but I don't know for sure the correct command.
Could you tell me the right syntax?
TIA
Aurel.
--
Hello,
I have a root-server (Suse 8.1, PHP 4.2.2) and i will use
firebird (1.5) with php.
I have install firebird and create my database
with tables and data. It works (isql).
In the first step i will use firebird with the interbase.so.
I do this:
../configure
Hi
I have a variable cold $access and there are values 1,2,3,4,5
How can I check for example
If ($access =='2'){
echo go further;
}
How can I make this work
Thanx in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
if($access ==2)
{
echo do something;
}
Peppe wrote:
Hi
I have a variable cold $access and there are values 1,2,3,4,5
How can I check for example
If ($access =='2'){
echo go further;
}
How can I make this work
Thanx in advance
--
PHP Database Mailing List (http://www.php.net/)
To
Hi
From what I can work out you need to use a function called
in_array(value,array);
http://www.php.net/manual/en/function.in-array.php here is the php manual
link
Hope this is what you want
Brett
-Original Message-
From: peppe [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 16:07
To:
Hi
Pete I forgot to write that $acces is a field from Db and there are values
1,2,3,4
a need to split those values to make that IF
Brettking thanx mate I think that is a solution
Brettking [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
From what I can work out you need to use a
Hi
Pete I forgot to write that $acces is a field from Db and there are values
1,2,3,4
a need to split those values to make that IF
Brettking I think that is solution
Peppe [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
I have a variable cold $access and there are values 1,2,3,4,5
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió:
You can also DISTINCT command instead.
UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
using)
UNIQUE is for table creation or index creation. It is relevent for insertion,
not selects.
DISTINCT and DISTINCT ON() are
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió:
No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
need ONE user_id per one object_id.
GROUP BY is your answer.
--
15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61
El Jue 11 Dic 2003 05:30, Mike U. Petrov escribió:
I tried to use GROUP BY and it worked almost right but i need to return
user_id and mysql generated an error that notes.user_id isn't used in GROUP
BY...
Add it to the GROUP BY.
--
16:33:02 up 15 days, 22:49, 4 users, load average: 0.03,
Hi All - I have a query as below, which builds individual records from a
series of 4 tables
SELECT menuitems.tour_code, image_caption, image_code,
region, country, product_type
FROM tourcountries, tour_product, countries, menuitems
LEFT OUTER JOIN
My own install worked OK with RC4, but it may be worth a
look through the firebird-php list as there are a few other
'fixes' listed.
http://groups.yahoo.com/group/firebird-php
I've pressure to complete a W2k based job before Xmas
otherwise I would be having another look myself. I'm sure we
Does anyone know how to make this work???
$sql = select TEAM_SEQ.NEXTVAL as \nextval\ from sys.dual;
I get the following error in PHP:
ociexecute(): OCIStmtExecute: ORA-00903: invalid table name
But when I use my SQL tool to hit the DB will all the same parameters, it
works just fine.
I have
Hello all,
I have a cronjob that runs a PHP script against MySQL. The script takes 5
minutes to process 4000 records (approximately 12 records per second). Here
are the top two entries from top:
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
8671 mysql 25 0
What good is this function?
A quick example of the wall Im running into -
$sql = 'INSERT INTO .';
$result = pg_query($conn_id, $sql);
if ($result === false)
{
var_dump( pg_result_error( $result ) );
}
According to the manual, pg_result_error takes the result resource.
If that resource is
Hi all,
Right now I'm trying to do a UPDATE and DELETE queries using the following
code below: But i kept getting error
Undefined variable: tutor_id in /usr/local/apache/htdocs/tutor/edit.php on
line .
Didn't I defined my variable $tutor_idI thought I have...
Anyone can help???
Hi,
i've read the following comment on PHP.net and found it very troubling because my
database has Shift_JIS japanese words and my forms allow japanese input as well, so,
does anyone know how can I stripslashes correctly when it comes to Japanese text?
thanx thanx!
hash at samurai dot fm
On Friday 12 December 2003 13:47, Ng Hwee Hwee wrote:
i've read the following comment on PHP.net and found it very troubling
because my database has Shift_JIS japanese words and my forms allow
japanese input as well, so, does anyone know how can I stripslashes
correctly when it comes to
thanks for your reply..
i'm doing a form (form.php)
1) user comes to form.php
2) user enters details and press submit
3) details get passed to form action verify.php
4) verify.php puts all the $_POST into an array $formVars
5) verify.php session_register(formVars)
6) if there is an error,
32 matches
Mail list logo
