I have a table for example: tb1
with data:
cse-12m
cse-343k
cse-mka
cse-ptu
cse-jpy

How can I write a SELECT statement to retrieve data in one of these formats:
1) cse-three digits number

How about "part1", "part3" are retrieved from SELECT statement? to use "select from table where component in (select part1 from....)"?
Also "IN(part1, part3)" is OR , not AND, right? I need "AND".

I have one table in this format:

Product Component
---------------------------
A part1
A part2
B part1
B part4
A part3
C ...

I need to manipulate two tables(in different DB) to print out data, what's the effective way to do that in php code?

$conn = mssql_connect($intraserver, $intrauser, $intrapass);...

I try to generate on-fly pdf files by php code, the pdf file will display the web page exactly the same as on browser, did some research but have no clue how to do that.
The function: PDF_show_xy (...

I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example:

id name age dept
---------------------------
1 ...

I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion:
1) Will MSSQL2008...

I use MSSQL 2000 version.
Thank you tesuji, here is the table I need to remove duplicate records.
Table "addonitems":
partid componentid quantity revision componentrevision note...

I have a MSSQL table that contains lots of duplicate records, is there a simple way to keep only one and remove all other duplicates?

mike M 60
mike M 60
mike M 60


I need only one record
...

I try to copy and paste TAB delimited list into html text area, then save it to database, however when I retrieve it from DB, all TAB space are gone, does anyone can give me advice is there a way to...

Another issue:
getElementById() works only in IE, if I try to use Firefox this will not work, how to solve this issue?

thanks, that help me.

I have a form text field called "field_0", and javascript code:

<script language="javascript">
function test() {
var a=document.form1.field_0.value;
alert (a);
}
</script>
<form name=form1...

how can I replace who string with certain beginning and ending, for example I have string:
abc........xyz

I want to replace this string with "this is a test", no matter what text in between, only...

Is there attachment feature in standard php mail() function? I don't want to install additional application as I have bunch of files use mail(), I don't know if this new application will affect that.

In php mail() function, how can I send attachments? I didn't find parameter to do this. any help will be appreciated.

how can I pass GET url which contains character "?" to php file.
for example I have url:
http://www.mysite.com/file1.php?string=file2.php?a1=1&a2=2&a3=3

I want to pass all string...

How can I get future date by php date() function, for example today is 11/13/2007, I want to get the date after 60 days.

Any advice will be appreciated.

The php page contains table that display dynamic data retrieved from mysql database, I have no problem to display this table on web browser and convert it to excel file, by manually.
Now I need to...

Thanks for reply.
I tried this, it works ok from web browser, but not from command line, it doesn't generate excel file.
Actually this $data is the dynamic php web page I created, I want to save...

I have a simple php file for example:

<?
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=file123.xls");
header("Pragma: no-cache");...

I have a question about how to manipulate php string.
For example, I have a text string:
$text="
---<updated:12/20/06>---
this is 2nd entry
---<updated:12/19/06>---
this is 1st entry
";

Now...

In html page I have two forms:
<form name=fm1 method=post action=aaa.html>
<input type=text name=a1>
<textarea name=a2></textarea>
<input type=submit>
</form>

<form name=fm2 method=post...

I try to download IE7 and install it on my machine, however my pc is running on windows 2000, and there is no download version for win2000, does it mean IE7 cannot run on win2000?

Thanks for any...

I got the answer, thanks.

I have two tables:
tb1:
ID USERNAME
1 u11
2 u12
3 u13

tb2:
ID USERNAME
2 u12

Thank you very much for your response.

By defalult the text in input box is left aligned, is it possble to have it right aligned? The reason to do this is I have a list of input box vertically, to input the price for each item, I want to...

I have php code that retrieve data from mysql DB, and print it in html table.
<?
print "<table>";
$result=mysql_query("select fd1,fd2,fd3 from tbl");
for ($i = 0; $i < mysql_num_rows($result);...

I am wondering how to print the html table background color on printer, for example I have html table:
<table border="2">
<tr>
<td bgcolor="#3333FF">&nbsp;</td>
<td>&nbsp;</td>
...

I want to know is it possible to generate PDF file automatically at the background, I have adobe acrobat installed, usually this application is installed at client side, they can save as pdf file at...

product transaction date
--------------------------------------
1 06/07/2006
2 06/05/2006
2 06/10/2006
3 06/09/2006

I have a table like above, now I want to retrieve the latest transaction...

Thank you very much for pointing it out, I was confused.

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need...

I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write:

SELECT * FROM table WHERE field like '%$val%'

this will list all...

I am planing to write a php script which can display time schedule bar, based on start/end date, and each project(see attached image, start/end date and project name are saved in database), the...

I have the code:
<form method="post" action="abc.php">
<input type="submit" name="sb1" value="sb1"> //<----LINE1
<input type="image" src="sample.jpg" name="sb2" value="sb2"> //<---LINE2
</form>
...

I try to set cookie values from mysql DB, I have the code:

$result = mysql_query("select ID from table");
while ($thisrow=mysql_fetch_row($result))
{
$gname="name_".$i;
setcookie...

thank you very much for the answer!

In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any...