trekerboy Posted September 7, 2007 Share Posted September 7, 2007 I am trying to update some entries in a mysql database that will append the filename to the end of a thumbnail directory entry. So for example /images/thumb/ would become /images/thumb/12345.jpg. I am stumped because the below code gives no php or mysql errors but the entries are not updated in the mysql db! <?php require ''.$_SERVER['DOCUMENT_ROOT'].'/includes/vital.php'; ?> <div id="content"> <?php require ''.$_SERVER['DOCUMENT_ROOT'].'/includes/admin_nav.php'; ?> <?php $client = "14"; $query = "SELECT id, file, thumb_small, thumb_medium, thumb_gallery FROM dsp_images WHERE client=".$client; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { $file = $row['file']; echo $file."<br>"; $thumb_small = $row['thumb_small'].$file; echo $thumb_small."<br>"; $thumb_medium = $row['thumb_medium'].$file; echo $thumb_medium."<br>"; $thumb_gallery = $row['thumb_gallery'].$file; echo $thumb_gallery."<br>"; $image_id = $row['id']; echo $image_id."<br>"; $this_query = "UPDATE dsp_images SET thumb_small='".$thumb_small."',thumb_medium='".$thumb_medium."',thumb_gallery='".$thumb_gallery."' WHERE id='".$image_id."'"; if(mysql_query($query)) { echo "updated info for file: ".$file.".<br>"; } else { echo "There was an error: ".mysql_error(); } } ?> </div> <?php require ''.$_SERVER['DOCUMENT_ROOT'].'/includes/layout/dsp-black/bottom.php'; ?> Can anyone see anything wrong this code that would make it so that, when run, it WOULD NOT update any db entries and WOULD NOT return any errors? Here's the output of the above code: _mg_9875.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9875.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9875.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9875.jpg 121 updated info for file: _mg_9875.jpg. _mg_9879.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9879.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9879.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9879.jpg 122 updated info for file: _mg_9879.jpg. _mg_9881.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9881.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9881.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9881.jpg 123 updated info for file: _mg_9881.jpg. _mg_9883.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9883.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9883.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9883.jpg 124 updated info for file: _mg_9883.jpg. _mg_9884.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9884.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9884.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9884.jpg 125 updated info for file: _mg_9884.jpg. _mg_9886.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9886.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9886.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9886.jpg 126 updated info for file: _mg_9886.jpg. _mg_9887.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9887.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9887.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9887.jpg 127 updated info for file: _mg_9887.jpg. _mg_9888.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9888.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9888.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9888.jpg 128 updated info for file: _mg_9888.jpg. _mg_9891.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9891.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9891.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9891.jpg 129 updated info for file: _mg_9891.jpg. _mg_9892.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9892.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9892.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9892.jpg 130 updated info for file: _mg_9892.jpg. _mg_9896.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9896.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9896.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9896.jpg 131 updated info for file: _mg_9896.jpg. _mg_9897.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9897.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9897.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9897.jpg 132 updated info for file: _mg_9897.jpg. _mg_9899.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9899.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9899.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9899.jpg 133 updated info for file: _mg_9899.jpg. _mg_9904.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9904.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9904.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9904.jpg 134 updated info for file: _mg_9904.jpg. _mg_9908.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9908.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9908.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9908.jpg 135 updated info for file: _mg_9908.jpg. _mg_9912.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9912.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9912.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9912.jpg 136 updated info for file: _mg_9912.jpg. _mg_9915.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9915.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9915.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9915.jpg 137 updated info for file: _mg_9915.jpg. _mg_9918.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9918.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9918.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9918.jpg 138 updated info for file: _mg_9918.jpg. _mg_9921.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9921.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9921.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9921.jpg 139 updated info for file: _mg_9921.jpg. _mg_9923.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9923.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9923.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9923.jpg 140 updated info for file: _mg_9923.jpg. _mg_9926.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9926.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9926.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9926.jpg 141 updated info for file: _mg_9926.jpg. _mg_9927.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9927.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9927.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9927.jpg 142 updated info for file: _mg_9927.jpg. _mg_9931.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9931.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9931.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9931.jpg 143 updated info for file: _mg_9931.jpg. _mg_9932.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9932.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9932.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9932.jpg 144 updated info for file: _mg_9932.jpg. _mg_9934.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9934.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9934.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9934.jpg 145 updated info for file: _mg_9934.jpg. _mg_9935.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9935.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9935.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9935.jpg 146 updated info for file: _mg_9935.jpg. _mg_9937.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9937.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9937.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9937.jpg 147 updated info for file: _mg_9937.jpg. _mg_9939.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9939.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9939.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9939.jpg 148 updated info for file: _mg_9939.jpg. _mg_9943.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9943.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9943.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9943.jpg 149 updated info for file: _mg_9943.jpg. _mg_9944.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9944.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9944.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9944.jpg 150 updated info for file: _mg_9944.jpg. _mg_9952.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9952.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9952.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9952.jpg 151 updated info for file: _mg_9952.jpg. _mg_9953.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9953.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9953.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9953.jpg 152 updated info for file: _mg_9953.jpg. _mg_9954.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9954.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9954.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9954.jpg 153 updated info for file: _mg_9954.jpg. _mg_9956.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9956.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9956.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9956.jpg 154 updated info for file: _mg_9956.jpg. _mg_9957.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9957.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9957.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9957.jpg 155 updated info for file: _mg_9957.jpg. _mg_9958.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9958.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9958.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9958.jpg 156 updated info for file: _mg_9958.jpg. _mg_9959.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9959.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9959.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9959.jpg 157 updated info for file: _mg_9959.jpg. _mg_9960.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9960.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9960.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9960.jpg 158 updated info for file: _mg_9960.jpg. _mg_9966.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9966.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9966.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9966.jpg 159 updated info for file: _mg_9966.jpg. _mg_9967.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9967.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9967.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9967.jpg 160 updated info for file: _mg_9967.jpg. _mg_9968.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9968.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9968.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9968.jpg 161 updated info for file: _mg_9968.jpg. _mg_9970.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9970.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9970.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9970.jpg 162 updated info for file: _mg_9970.jpg. _mg_9976.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9976.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9976.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9976.jpg 163 updated info for file: _mg_9976.jpg. _mg_9981.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9981.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9981.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9981.jpg 164 updated info for file: _mg_9981.jpg. _mg_9982.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9982.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9982.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9982.jpg 165 updated info for file: _mg_9982.jpg. _mg_9984.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9984.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9984.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9984.jpg 166 updated info for file: _mg_9984.jpg. _mg_9985.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9985.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9985.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9985.jpg 167 updated info for file: _mg_9985.jpg. _mg_9989.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9989.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9989.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9989.jpg 168 updated info for file: _mg_9989.jpg. _mg_9993.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_9993.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_9993.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_9993.jpg 169 updated info for file: _mg_9993.jpg. _mg_0002.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0002.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0002.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0002.jpg 170 updated info for file: _mg_0002.jpg. _mg_0005.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0005.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0005.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0005.jpg 171 updated info for file: _mg_0005.jpg. _mg_0008.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0008.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0008.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0008.jpg 172 updated info for file: _mg_0008.jpg. _mg_0011.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0011.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0011.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0011.jpg 173 updated info for file: _mg_0011.jpg. _mg_0017.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0017.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0017.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0017.jpg 174 updated info for file: _mg_0017.jpg. _mg_0019.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0019.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0019.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0019.jpg 175 updated info for file: _mg_0019.jpg. _mg_0022.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0022.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0022.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0022.jpg 176 updated info for file: _mg_0022.jpg. _mg_0023.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0023.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0023.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0023.jpg 177 updated info for file: _mg_0023.jpg. _mg_0026.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0026.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0026.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0026.jpg 178 updated info for file: _mg_0026.jpg. _mg_0029.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0029.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0029.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0029.jpg 179 updated info for file: _mg_0029.jpg. _mg_0030.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0030.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0030.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0030.jpg 180 updated info for file: _mg_0030.jpg. _mg_0031.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0031.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0031.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0031.jpg 181 updated info for file: _mg_0031.jpg. _mg_0037.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0037.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0037.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0037.jpg 182 updated info for file: _mg_0037.jpg. _mg_0038.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0038.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0038.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0038.jpg 183 updated info for file: _mg_0038.jpg. _mg_0039.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0039.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0039.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0039.jpg 184 updated info for file: _mg_0039.jpg. _mg_0042.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0042.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0042.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0042.jpg 185 updated info for file: _mg_0042.jpg. _mg_0050.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0050.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0050.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0050.jpg 186 updated info for file: _mg_0050.jpg. _mg_0055.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0055.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0055.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0055.jpg 187 updated info for file: _mg_0055.jpg. _mg_0056.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0056.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0056.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0056.jpg 188 updated info for file: _mg_0056.jpg. _mg_0058.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0058.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0058.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0058.jpg 189 updated info for file: _mg_0058.jpg. _mg_0067.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0067.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0067.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0067.jpg 190 updated info for file: _mg_0067.jpg. _mg_0071.jpg /images/clients/baumann_luke/portrait_photography/thumb_small/_mg_0071.jpg /images/clients/baumann_luke/portrait_photography/thumb_medium/_mg_0071.jpg /images/clients/baumann_luke/portrait_photography/thumb_gallery/_mg_0071.jpg 191 updated info for file: _mg_0071.jpg. Any help is appreciated! - Jason Quote Link to comment https://forums.phpfreaks.com/topic/68393-solved-mysql-entries-wont-update/ Share on other sites More sharing options...
recklessgeneral Posted September 7, 2007 Share Posted September 7, 2007 Hi trekerboy, You've simply passed the wrong query to mysql_query - the select one instead of the update one. Change to: if(mysql_query($this_query)) { echo "updated info for file: ".$file.".<br>"; } else { echo "There was an error: ".mysql_error(); } Cheers, Darren. Quote Link to comment https://forums.phpfreaks.com/topic/68393-solved-mysql-entries-wont-update/#findComment-343859 Share on other sites More sharing options...
trekerboy Posted September 7, 2007 Author Share Posted September 7, 2007 Hi Darren, Thanks a bunch! Also, I really like your song "Come back to bed". Do you ship to the US, or could I buy a digital copy? Good luck with your music career. - Jason Quote Link to comment https://forums.phpfreaks.com/topic/68393-solved-mysql-entries-wont-update/#findComment-343861 Share on other sites More sharing options...
recklessgeneral Posted September 7, 2007 Share Posted September 7, 2007 Thank you very much, although my brother is the talented one, I just do the web stuff for it. Currently haven't figured out how to sell stuff abroad yet, not that we don't want to, but it's on a list of things to do. We're hoping to get the tunes registered with iTunes and other online stores, but again that'll take time to suss out then another couple of months to go through the process. If you'd like to register with the site, then we can mail you when we have the international option set up. I'll pass your comments on to my brother. Cheers, Darren. Quote Link to comment https://forums.phpfreaks.com/topic/68393-solved-mysql-entries-wont-update/#findComment-343946 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.