Re: [PHP-DB] mssql insert
$query = INSERT INTO myTable VALUES ('.$myVar.');';
Check the commas?
Miles
At 05:50 PM 3/28/2004 +1200, Martin Ryan wrote:
Got a dumb-ass question for you all. I have got insert queries working with
mssql_query($query); except if any of the variables have two or more words.
For example:
$myVar = Two or more words;
$query = INSERT INTO myTable VALUES ('.$myVar.');';
mssql_query($query,$db);
The query will only insert Two.
I know the query is correct, because I've echoed it, cut it, and pasted it
directly into Query Analyzer and it comes up roses.
Cheers muchly,
Marty
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] $$$wanna make real money$$$..you will no longer need student loans
EXCELLENT CASH INCOME I started out with $6. Now, I am making thousands. I found this on a bulletin board and decided to try it. A little while back, I was browsing through newsgroups, just like you are now, and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of $6.00! So I thought, Yeah right, this must be a scam, but like most of us, I was curious, so I kept reading. Anyway, it said that you send $1.00 to each of the 6 names and addresses stated in the article. You then place your own name and address in the bottom of the list at #6, and post the article in at least 200 newsgroups. (There are thousands) No catch, that was it. So after thinking it over, and talking to a few people first, I thought about trying it. I figured: what have I got to lose except 6 stamps and $6.00, right? Then I invested the measly $6.00. Well GUESS WHAT!?... within 7 days, I started getting money in the mail! I was shocked! I figured it would end soon, but the money just kept coming in. In my first week, I made about $25.00. By the end of the second week I had made a total of over $1,000.00! In the third week I had over $10,000.00 and it's still growing. This is now my fourth week and I have made a total of just over $42,000.00 and it's still coming in rapidly. It's certainly worth $6.00, and 6 stamps, I have spent more than that on the lottery!! Let me tell you how this works and most importantly, WHY it works... Also, make sure you print a copy of this article NOW, so you can get the information off of it as you need it. I promise you that if you follow the directions exactly, that you will start making more money than you thought possible by doing something so easy! Suggestion: Read this entire message carefully! (print it out or download it.) Follow the simple directions and watch the money come in! It's easy. It's legal. And your investment is only $6.00 (Plus postage) IMPORTANT: This is not a rip-off; it is not indecent; it is not illegal; and it is 99% no risk - it really works! If all of the following instructions are adhered to, you will receive extraordinary dividends. PLEASE NOTE: Follow these directions EXACTLY, and $50,000.00 or more can be yours in 20 to 60 days. This program remains successful because of the honesty and integrity of the participants. Please continue its success by carefully adhering to the instructions. You will now become part of the Mail Order business. In this business your product is not solid and tangible, it's a service. You are in the business of developing Mailing Lists. Many large corporations are happy to pay big bucks for quality lists. However, the money made from the mailing lists is secondary to the income which is made from people like you and me asking to be included in that list. Here are the 4 easy steps to success: STEP 1: Get 6 separate pieces of paper and write down your name and address followed by the words PLEASE ADD ME TO YOUR MAILING LIST on each of them. Now get 6 US $1.00 bills and place ONE inside EACH of the 6 pieces of paper so the bill will not be visible through the envelope (to prevent thievery). Next, place one paper in each of the 6 envelopes and seal them. You should now have 6 sealed envelopes, each with a piece of paper stating the above phrase, your name and address, and a $1.00 bill. What you are doing is creating a service. THIS IS ABSOLUTELY LEGAL! You are requesting a legitimate service and you are paying for it! Like most of us I was a little skeptical and a little worried about the legal aspects of it all. So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal. Mail the 6 envelopes to the following addresses: 1) Jay foresman 1925 Elmeda Muskogee Ok, 74403 2) John Visser 11140 Streets Ridge RR#2 Oxford, NS Canada, B0M 1P0 3) C. Warren 721 W. 1500 S. Provo, UT 84601 4) justin s 12 bense ct Washington, NJ 07882 5) Rueben Hernandez 709 3rd ave apt B Bradley Beach, NJ 07720 6)Salameh basheer 9331 Sakhnin, Israel 20173 STEP 2: Now take the #1 name off the list that you see above, move the other names up (6 becomes 5, 5 becomes 4, etc...) and add YOUR Name as number 6 on the list. STEP 3: Change anything you need to, but try to keep this article as close to original as possible. Now, post your amended article to at least 200 newsgroups. (I think there are close to 24,000 groups) All you need is 200, but remember, the more you post, the more money you make! You won't get very much unless you post like crazy. This is perfectly legal! If you have any doubts, refer to Title 18 Sec. 1302 1341 of the Postal lottery laws. Keep a copy of these steps for yourself and, whenever you need money, you can use it again, and again. PLEASE REMEMBER that this program remains successful because of the honesty and integrity of the participants and by their carefully adhering to the directions. Look at it this way. If you are of
[PHP-DB] Upload / Load Image File to MySQL
Need help / example how to upload / load image file to MySQL Thank's Wijaya __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] List Question!
Hi, Just a list question here. Not sure if this question is answered online anywhere but thought I'd post here. - If a user is NOT subscribed to this Mailing List can they still post by emailing [EMAIL PROTECTED] ? I have never emailed [EMAIL PROTECTED] without subscribing before. - If no and they need to subscribe online or whatever, do the moderators of this list ban people for spamming unrelated things to people? I just got an email about making money online and has no relation to db's or php at all. We're subscribed for nothing else than php and mysql stuff and code, not business spam and believe action should be taken against these spammers to eliminate it to a min. If one person can get away with it many more will follow and do the same. Thanks for your time. J Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysqli - using PREPARED STATEMENTS - worth it?
Looking at this page: http://us2.php.net/manual/en/function.mysqli-prepare.php Also the new book ADVANCED PHP PROGRAMMING uses the new MySQLi Prepared Statements for all queries. Wondering if that extra code, trouble, and lack of flexibility is worth it? Will it be a HUGE performance increase that will be worth those added lines of code for every single query? Any insight appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] checkboxes and loops
OK lets see if I can figure out how to ask this:
I am setting up a system for my company to filter through employee
applications. Most of the applications do not fit the criteria and I
want to allow my bosses a checkbox to the right of them which they can
check or uncheck to remove an applicant.
So I run a loop that generates a bunch of check boxes with the name
box1, box2, box3... by running a loop that runs this and increments
counter every time:
{
input type = checkbox name = box?echo $counter;? value = delete
$counter++;
}
But when I try to create my query that updates the table I have a
problem generating these variable again by referring to them indirectly:
*Bad solution 1 (to much work)***
if ($box1 == 'delete') do whatever
if ($box2 == 'delete') do whatever
if ($box3 == 'delete') do whatever
if ($box4 == 'delete') do whatever
if ($box5 == 'delete') do whatever
if ($box6 == 'delete') do whatever
***
*Bad solution 2 (doesn't work)***
$counter = 1;
while (whatever)
{
if ($box . $counter == 'delete') do whatever
$counter++;
}
***
How do I get around this problem?
Hopefully someone understands what I am trying to say.
Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] checkboxes and loops
Hi!
I think you should rename checkboxes to box[1], box[2] etc.
So you will get an array $_POST[box]. I think it will be better.
Best wishes,
Mikhail U. Petrov,
PHP-programmer
Hello matthew,
Monday, March 29, 2004, 9:45:28 AM, you wrote:
mp OK lets see if I can figure out how to ask this:
mp I am setting up a system for my company to filter through employee
mp applications. Most of the applications do not fit the criteria and I
mp want to allow my bosses a checkbox to the right of them which they can
mp check or uncheck to remove an applicant.
mp So I run a loop that generates a bunch of check boxes with the name
mp box1, box2, box3... by running a loop that runs this and increments
mp counter every time:
mp {
mp input type = checkbox name = box?echo $counter;? value = delete
mp $counter++;
mp }
mp But when I try to create my query that updates the table I have a
mp problem generating these variable again by referring to them indirectly:
mp *Bad solution 1 (to much work)***
mp if ($box1 == 'delete') do whatever
mp if ($box2 == 'delete') do whatever
mp if ($box3 == 'delete') do whatever
mp if ($box4 == 'delete') do whatever
mp if ($box5 == 'delete') do whatever
mp if ($box6 == 'delete') do whatever
mp ***
mp *Bad solution 2 (doesn't work)***
mp $counter = 1;
mp while (whatever)
mp {
mp if ($box . $counter == 'delete') do whatever
mp $counter++;
mp }
mp ***
mp How do I get around this problem?
mp Hopefully someone understands what I am trying to say.
mp Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
