Search results for query: *

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...

well it supports insert... select so I just assumed... thanks... Peter

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...

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')...

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(...

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

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...

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 a database to the date function and it returns the wrong month... any ideas why? saledate is currently: 2003-06-21 and date(&quot;F&quot;, $row[&quot;saledate&quot;]) returns Wednesday, but June 21st is a Saturday... can't figure it out... any help...

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

well the &quot;purists&quot; 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

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...

So I guess the real answer is &quot;no&quot; ???

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

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...

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 &quot;as smooth as a trout's ear&quot; ! Thanks for the quick response ! Cheers, Peter

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 &quot;record pointer&quot; back to the front of the array. I have tried reset()...

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

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...

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?