I created a PHP based mailing list that sends out a Bible verse and a quotation each day. Today's verses were: Bible verse of the day: Matthew 17:19-21 Then the disciples came to Jesus privately and said, "Why could we not cast it out?" And He said to them, "Because of the littleness of your faith; for truly I say to you, if you have faith as a mustard seed, you shall say to this mountain, 'Move from here to there,' and it shall move; and nothing shall be impossible to you. But this kind does not go out except by prayer and fasting." ( NASB ) Quiet Time Quotation And Reflection Topic of the day: If you hold the gospel up and you become it's shadow do you fit? In both the Bible verse table and the quotation table is a "current verse of the day" column that the UPDATE command is suppose to change from a 0 to a 1 so the associated web page will be able to display and a few other functions will know the current verse of the day. The verses are selected randomly. Both the UPDATE for the Bible verse and the UPDATE for the quotation failed. I know the code works over all. From my estimate the use of " or ' is the reason why the UPDATE didn't work. Let me show you some code: It selects a Bible verse: SELECT * FROM bible ORDER BY RAND() LIMIT 1 Then it puts the text into variables: $bible_verse_ref=mysql_result($result,$i,"bible_verse_ref"); $bible_verse_text=mysql_result($result,$i,"bible_verse_text"); $bible_verse_translation=mysql_result($result,$i,"bible_verse_translation"); Then immediately following this is the UPDATE that didn't work: UPDATE `bible` SET `current_verse_of_the_day` = '1' WHERE `bible_verse_ref` LIKE '$bible_verse_ref' AND `bible_verse_text` LIKE '$bible_verse_text' AND `bible_verse_translation` LIKE '$bible_verse_translation' AND `current_verse_of_the_day` LIKE '0' LIMIT 1 Where there are no ' or " this piece of code works just fine. I am essentially retrieving a Bible verse from the table and then immediately searching for it to change the 'current_verse_of_the_day' to change from 0 to 1. I have manually made the change for today and the current_verse_of_the_day value was 0. Similar code is used for the quotation --- but there is no need for me to repeat it here. Any ideas how I am able to get the use of ' or " to work on this page? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
