Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PeterMac
- Order by date
-
Update with Embedded Select not working
Got this off the MySQL web pages... Expanded support for subqueries Subqueries allow you to use the result of one query as a component of a larger query. The MySQL server already supports some forms of this technique, such as INSERT INTO ... SELECT ..., and this support will be expanded in... -
Update with Embedded Select not working
well it supports insert... select so I just assumed... thanks... Peter -
Update with Embedded Select not working
What is wrong with this syntax ? Using MySQL 3.23.51-nt UPDATE products SET manu_release_date = (SELECT dates.reldate FROM dates, products WHERE dates.id = products.stock_code ) I get the error: Error MySQL said: You have an error in your SQL syntax near 'SELECT dates.reldate FROM dates... -
multiple re-directs
I got it figured out in the meantime... thanks for your response though... I used... <script language='JavaScript'> <!-- start script function openWindow(url) { popupWin = window.open(url,'Name', 'top=0,left=0,resizable=yes,width=850,height=550,scrollbars=yes,menubar=yes,toolbar=no')...- PeterMac
- Post #3
- Forum: Javascript
-
multiple re-directs
I have searched and searched... I have to ask... Is there a way to spawn a new page AND re-direct as script at the same time... I am trying something like this... I know this is in PHP ... but it is client side actions that I want to accomplish... <? header(...- PeterMac
- Thread
- Replies: 2
- Forum: Javascript
-
Printing - Supressing the Header & footer
I am wanting to generate custom reports with PHP and then be able to print them. Is there any way - I have even looked at window.print() in Javascript - to get rid of the URL and date thing at the bottom of the page and the Title and Page 1 of 3 thing at the top? Peter- PeterMac
- Thread
- Replies: 1
- Forum: Javascript
-
Printing - Supressing the Header & footer
I know that this may not be a PHP specific question, however I am wanting to generate custom reports with PHP and then be able to print them. Is there any way (I have even looked at window.print() in Javascript) to get rid of the URL and date thing at the bottom of the page and the Title and... -
Hello: I am passing a date from
You are correct in that it should return a month... I was playing with the other letter options... and confused myself !!! It was returning December, not June (or Wednesday)... but I did not use the strtotime() function, so I will try that out and let you know what I come up with... thanks for... -
Hello: I am passing a date from
Hello: I am passing a date from a database to the date function and it returns the wrong month... any ideas why? saledate is currently: 2003-06-21 and date("F", $row["saledate"]) returns Wednesday, but June 21st is a Saturday... can't figure it out... any help... -
forms printing concepts
well looks like I get to answer my own question... I had a friend point me in the PDFlib direction. I am looking into it now... check out their web site at... http://www.pdflib.com/ cheers, Peter -
Do you hand code your pages?
well the "purists" hand code... I hand-code mostly because I like to read my code and get right down into it. Once you get familiar with PHP / MySQL you will only want to hand code (my prediction)... Good luck... Peter -
forms printing concepts
OK... I am about to develop an on-line financial system that generates checks, receipts, and the like. I am planning to do it in PHP / MySQL. Now the thing that I don't know is how do I generate a formatted report (like a check run) that will be printable on stock forms like an accounting... -
Exporting data steructures to SQL text
So I guess the real answer is "no" ???- PeterMac
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Exporting data steructures to SQL text
Hello: Is there a way in Access to export (or just show for cut & paste process) the table structures in the CREATE TABLE style? I have created tables in Access and I want to convert them to MySQL without having to re-create them manually. Any help appreciated. Peter- PeterMac
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
2 questions on Sessions and Cookies
OK... here is the first one... what is the difference between a session and a cookie ? The php documentation states that sessions are managed thru cookies... so why use the $_SESSION as opposed to a cookie? question 2 I have a site that uses cookies... my local environment allows for me to... -
re-positioning the query result
Yes, thanks... I have been looking for this for 2 days ! and as soon as I posted this question, I did one more search thru this site and found the answer. I have tried the code and it runs "as smooth as a trout's ear" ! Thanks for the quick response ! Cheers, Peter -
re-positioning the query result
Hello everyone: I have the following code that works, but the only way it is working is if I hit the database twice to get my $result array back to the top. It is the same query and all I want to do is put the "record pointer" back to the front of the array. I have tried reset()... -
call 2 queries from within a 3rd ?
Thanks... got it figured... it was too simple :) SELECT cardid from [Any 2 Lines] UNION SELECT cardid FROM [Any 1 Line + 4 Corners]; cheers, and thanks for the pointers... PeterMac- PeterMac
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
call 2 queries from within a 3rd ?
Thanks a bunch... so this is what I have now... SELECT [Any 2 Lines].cardid FROM [Any 1 Line + 4 Corners] INNER JOIN [Any 2 Lines] ON [Any 1 Line + 4 Corners].cardid = [Any 2 Lines].cardid; will that joint the two tables and give me all the cardid results from each one ? table 1.cardid...- PeterMac
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
call 2 queries from within a 3rd ?
I have this so far... SELECT [Any 2 Lines].cardid, [Any 1 Line + 4 Corners].cardid FROM [Any 2 Lines], [Any 1 Line + 4 Corners]; but I want to do something like this... SELECT cardid FROM [Any 2 Lines], [Any 1 Line + 4 Corners]; will that combine the 2 queries into one a column result set?- PeterMac
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
