riginal Message-
From: John W. Long [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 5:00 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL newbie
Hi,
I'm using the following statements to insert a record into a table:
$SQL_Exec_String = "Insert Into Messages
(ReplyID,Sub
Hi,
I'm using the following statements to insert a record into a table:
$SQL_Exec_String = "Insert Into Messages
(ReplyID,Subject,Sender,Email,Message,Reviewed)
Values ($ReplyID,'$Subject','$Sender','$Email','$Message',$Reviewed)";
$cur = odbc_exec( $cnx, $SQL_Exec_String );
This works grea
for the second one you can do a subquery:
select specific_p from where specific_p like '%68030% and
specific_p in (select distinct specific_p from );
this finds all the distinct specific_p fields and then does a query on
them -- that table (remember SQL ONLY returns tables) -- for the like
'%68
add DISTINCT to your query
select distinct specific_p, qty from database where specific_p = 68030 and
qty > 0
For you second requirement, get them all, and just use the first one ...
can't remember exact syntax but something like
select specific_p from database where specific_p like %6803
I meant to say:
There may be other parts that are close too I want to search for %68030% to
get all of them but show only one of each different specific_p.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PRO
I have a database with several fields...
I only want certain fields to show in my results
Some of the searched fields have the same value
example: searched field is specific_p
specific_p comment qty
68030 9845 0
68030 9844 100
68030 9
