schilly

I'm trying to create this procedure: CREATE PROCEDURE make_intervals(startdate Date, enddate Date, intval integer, unitval varchar(10)) BEGIN -- ************************************************************************* -- Procedure: make_intervals() -- Author: Ron Savage -- Date: 02/03/2009 -- -- Description: -- This procedure creates a temporary table named time_intervals with the -- interval_start and interval_end fields specifed from the startdate and -- enddate arguments, at intervals of intval (unitval) size. -- ************************************************************************* declare thisDate Date; declare nextDate Date; set thisDate = startdate; -- ************************************************************************* -- Drop / create the temp table -- ************************************************************************* drop temporary table if exists time_intervals; create temporary table if not exists time_intervals ( interval_start Date, interval_end Date ); -- ************************************************************************* -- Loop through the startdate adding each intval interval until enddate -- ************************************************************************* repeat select case unitval when 'MICROSECOND' then timestampadd(MICROSECOND, intval, thisDate) when 'SECOND' then timestampadd(SECOND, intval, thisDate) when 'MINUTE' then timestampadd(MINUTE, intval, thisDate) when 'HOUR' then timestampadd(HOUR, intval, thisDate) when 'DAY' then timestampadd(DAY, intval, thisDate) when 'WEEK' then timestampadd(WEEK, intval, thisDate) when 'MONTH' then timestampadd(MONTH, intval, thisDate) when 'QUARTER' then timestampadd(QUARTER, intval, thisDate) when 'YEAR' then timestampadd(YEAR, intval, thisDate) end into nextDate; insert into time_intervals select thisDate, timestampadd(MICROSECOND, -1, nextDate); set thisDate = nextDate; until thisDate >= enddate end repeat; END which I got from http://stackoverflow.com/questions/510012/get-a-list-of-dates-between-two-dates When I run this however, I receive "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE make_intervals(startdate Date, enddate Date, intval integer, unitval v' at line 1" Any ideas? I thought it might be a delimiter issue but doing this: delimiter // CREATE PROCEDURE make_intervals(startdate Date, enddate Date, intval integer, unitval varchar(10)) BEGIN -- ************************************************************************* -- Procedure: make_intervals() -- Author: Ron Savage -- Date: 02/03/2009 -- -- Description: -- This procedure creates a temporary table named time_intervals with the -- interval_start and interval_end fields specifed from the startdate and -- enddate arguments, at intervals of intval (unitval) size. -- ************************************************************************* declare thisDate Date; declare nextDate Date; set thisDate = startdate; -- ************************************************************************* -- Drop / create the temp table -- ************************************************************************* drop temporary table if exists time_intervals; create temporary table if not exists time_intervals ( interval_start Date, interval_end Date ); -- ************************************************************************* -- Loop through the startdate adding each intval interval until enddate -- ************************************************************************* repeat select case unitval when 'MICROSECOND' then timestampadd(MICROSECOND, intval, thisDate) when 'SECOND' then timestampadd(SECOND, intval, thisDate) when 'MINUTE' then timestampadd(MINUTE, intval, thisDate) when 'HOUR' then timestampadd(HOUR, intval, thisDate) when 'DAY' then timestampadd(DAY, intval, thisDate) when 'WEEK' then timestampadd(WEEK, intval, thisDate) when 'MONTH' then timestampadd(MONTH, intval, thisDate) when 'QUARTER' then timestampadd(QUARTER, intval, thisDate) when 'YEAR' then timestampadd(YEAR, intval, thisDate) end into nextDate; insert into time_intervals select thisDate, timestampadd(MICROSECOND, -1, nextDate); set thisDate = nextDate; until thisDate >= enddate end repeat; END// I receive the same error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE make_intervals(startdate Date, enddate Date, intval integer, unitval v' at line 1" Thanks.

well i got my query working and i'm guessing it would be faster than running n+1 queries.

So I need to display a list of applications and then tally total downloads for each application. Normally I would do something like: select all the applications, loop through the results then perform another query to get the total downloads for each application. basically n+1 queries. ie. SELECT * FROM applications loop through and for each iteration do SELECT sum(download) FROM app_downloads WHERE app_id = x Can I add a sub query into my original select query to create a column for a total downloads? 1 query vs n+1 queries. And is it faster than doing the method above? Let me know if you need any further info. Thanks.

what's that suppose to do? turn an mp3 into a movie?

I've been using this cmd to generate thumbnails automatically for videos my employer uploads. $ffmpeg -i $movie1 -deinterlace -an -ss $second -t 00:00:01 -r 1 -y -vcodec mjpeg -s $size -f mjpeg $thumb 2>&1 It has been working great until we recently switched all our videos over the H264 at which point it now fails. I've tried switching the -vcodec and -f flags to libx264 and various combinations with mjpeg with no luck. Here is one cmd: $ffmpeg -i $video -deinterlace -an -ss 5 -t 00:00:01 -r 1 -y -vcodec libx264 -vpre default -f mjpeg -s $size $thumb 2>&1 Debug: Can anyone help me out? let me know if you need any additional info. thanks.

awesome. just what i needed. thanks so much.

Thanks for the reply. It's not user inputted. well say you have a primary and secondary categories. one product will want to be listed in cat A as their primary but another product will want to be listed in cat A as their secondary giving you the same category value in both columns.

If I have a table of items with two columns set for categories, say cat1 and cat2 so I can list an item in multiple categories. What's the best way to get a list of all the unique categories? Some categories may only be listed in cat1 and some only in cat2 and some in both. ex. cat1 | cat2 cat | dog house | apartment dog | cat What query would I use to return: cat house apartment dog (no particular order) I'm trying to use combinations of DISTINCT but it doesn't seem to work.

thanks andrew. looking at this one right now: http://www.zurb.com/playground/ajax_upload

I was hoping to find a jquery ajax uploader that doesn't use flash. Seems like all the ones I've found are flash dependent. Is this because javascript can't post files? only form data? Any recommendations and helps is much appreciated. Thanks.

hmmmm not sure.

ya both are the same.

I'm trying to figure out why two sites on the same server both loading the same php.ini file have safe_mode on and the other off. The master value is set to off in both phpinfo() displays which I assume is reflecting to php.ini file. php.ini has safe_mode off. Is there another area where config info is loaded from? Is the path displayed somewhere in the phpinfo()? The main reason I'm looking into this now is because I need to run an exec cmd on the site with safe_mode on which supposedly you can't do. Is there another way around this other than turning safe_mode off? Thanks.

awesome. thanks.

also, would this way be faster than doing it via strpos?

I'm working on bounce processing and I need some trying to get the bounce error message. My pattern matching is terrible so I need some help with what should be a simple pattern. Here is an example bounce message body: I basically need everything in between "<email_address>:" and "--- Below this line is a copy of the message." I tried: eregi("^<email_address>*.)--- Below this line is a copy of the message.$",$body,$matches); But I was keep getting this error: Warning: eregi() [function.eregi]: REG_BADRPT I assuming because my pattern is bad. Any help is appreciated. Thanks.

Not the whole page. Just the form vars. <HTML> <head> ... <link href="../css/webform.css" type="text/css" rel="stylesheet" media="screen"> <script type="text/javascript" language="javascript" ...</script> </head> <body>... <form enctype="multipart/form-data" method="post" name="webform" onsubmit="return validate(this)" action="<?php echo $_SERVER['PHP_SELF'];?>"> ... <input type="text" tabindex="0" name="request_title" maxlength="255" size="62" value='<?php echo $_POST['request_title'];?>' ><br><br> ... <textarea tabindex="1" name="request_description" cols="87" rows="10"><?php echo $_POST['request_description']; ?></textarea> ... <br>... <input type="submit" id="sd" tabindex="23" value="submit" name="submit"> <input type="reset" id="rs" tabindex="24" name="reset" value="reset"> </form> </body> </HTML>

post the query giving the error.

That's correct. Post the code in question.

Yup. Just echo the POST values back into their respective form fields.

Thanks guys. Yea I understand that. I just wanted to make a small change on how it returned the data. What it does is pretty easy and I could easily write a class for it which I might end up doing because trying to decode this may take too long.

So how would I go about making the code readable?

Can anyone tell me how this is done? This is a 3rd party Google Visualization Data Source plugin. You can use the file but you can't mod it or know how it works. <?php /* GVStreamer v1.2 2008 - All rights reserved */$OOO000000=urldecode('%66%67%36%73%62%65%68%70%72%61%34%63%6f%5f%74%6e%64');$OOO0000O0=$OOO000000{4}.$OOO000000{9}.$OOO000000{3}.$OOO000000{5};$OOO0000O0.=$OOO000000{2}.$OOO000000{10}.$OOO000000{13}.$OOO000000{16};$OOO0000O0.=$OOO0000O0{3}.$OOO000000{11}.$OOO000000{12}.$OOO0000O0{7}.$OOO000000{5};$OOO000O00=$OOO000000{0}.$OOO000000{12}.$OOO000000{7}.$OOO000000{5}.$OOO000000{15};$O0O000O00=$OOO000000{0}.$OOO000000{1}.$OOO000000{5}.$OOO000000{14}.$OOO000000{3};$O0O00OO00=$OOO000000{0}.$OOO000000{8}.$OOO000000{5}.$OOO000000{9}.$OOO000000{16};$OOO00000O=$OOO000000{3}.$OOO000000{14}.$OOO000000{8}.$OOO000000{14}.$OOO000000{8};$OOO0O0O00=__FILE__;$OO00O0000=10652;eval($OOO0000O0('aWYoITApJE8wMDBPME8wMD0kT09PMDAwTzAwKCRPT08wTzBPMDAsJ3JiJyk7JE8wTzAwME8wMCgkTzAwME8wTzAwLDEwMjQpOyRPME8wMDBPMDAoJE8wMDBPME8wMCw0MDk2KTskT08wME8wME8wPSRPT08wMDAwTzAoJE9PTzAwMDAwTygkTzBPMDBPTzAwKCRPMDAwTzBPMDAsMzgwKSwnTnJoc1g1MG8yQUczSGdLdThEdjRNYnRtUTFDVjdjUnpCZUlkRU9uV0ppeHdrTFlhOXlwcWYvRlBUbCtqVVo2Uz0nLCdBQkNERUZHSElKS0xNTk9QUVJTVFVWV1hZWmFiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6MDEyMzQ1Njc4OSsvJykpO2V2YWwoJE9PMDBPMDBPMCk7'));return;?> AXZuHsruHsruHs/O7nbWmPAO70yeQFMJA/ZzDEOHDbZzAp9IAp2YAXZu4qruHXU9HhTIAp2kAXZu4qN9HsruHhBE4fZuHsN9HsruGhDuHXU9HXZuHsNJAXU9HsruHXU9Hh9E4fU9HXU9HsN9Gv9W4WAJ7/B/H0Up8M7qv0c3c4eXcdDgQWDLM45sbdcdMWih1MOEDMZYbfiiRocw45OeKmO97tQaDOrMVhLxbbJFMqfW3hcr8EgXDM1ovXOGvfyg4EZ8MbA4b5btb/e1tn5IQFDO1ncJCtiwV0/YVPry7Wgfcm1PRoO+HsXpHq8/gd7TKvkaApEiG4LnQFya7FMJAXU9HsruHXU9HhEj1m1eVhBE4fU9HXU9HXU9G4k=s8iJ1t5E1m2JAfgaVWDOVW8LboO914JBc0bTchZJc0/kKprdC05p7Fbfumbf1IfTApEjs8idV05q7prWcEgaVXgOV09ghWkghWrpVPDOQPDO1hNECt8js8i97nZf1tgf1t8BA0yeQnbkK9fG7oAac0bdc0bE2hDfRmrOK9fG7oAac0bdc0bE2hD9QmDf1mAYK9fG7obIV0Od201/VngfCtZY25ZzQFZY7PDpctgfGhDi1h9EV05I1t9kAoDl70MkAorecoDO7nTZ2I2is8ijs8JEc0ei7pf6vMOAvMOAvMOAvMEyGhDi1hEjs8JEc0ei7pf6vMOAvMOAvMOAv45kGhDkQtAOVhEjs8JEc0ei7pf6vMOAvMOAvMOAv4XyGhDfRmrOG4kghIDfC0Oq34lAvMOAvMOAvMOkvMEJAorecoDO7nTiK9fGz8fG7obIV0Od201/VngfCtZY2XOAvMOAvMOAvMOAHvBECt8is8ijs8JEvMOAvMOAvMOAvtyA2sfBcoA/14kghIDAvMOAvMOAvMOAV09Buvre7WAeRvBIQtlE2I9IQmgd2I9IQm1W2I9IQWEI3hAdVPbYch2k2nDec0MI3hAEQmDOc0OL1v2k2nDO7FHI3hAnQtyq1v2k2n1a7n/ech2k2n1pVFfI3hAW7nZ/7h2k2nOq2I9IV05I1t9I3hAkCt/ich2k2n/eRh2k2n/iVI2k2nlach2k2nl/V09I3hAa1n1q1m8I3hAa7oDiVFlq2I9IVP2I3hAa7nDO7I2k2WricnZf2I9I7Fbk1tgf2I9I7PbL2I9Ic0OL1tZn105l2I9Ic0OL1mgfQt/92I9IcoA/1v2k2WcJ1mAO2IEjs8JEvMOAvMOAvMOAvt9y2sfBQmApQmEJ2n5Y15Zi1h2k2n5qQ/Zi1h2k2n5F1/Zi1h2k2nAlmFOE2I9IQFZ/VWDzCt8I3hAEQmDOmFOE2I9I105f1mDiVtbzCt8I3hAE1mgdmFOE2I9I1n5k7FbzCt8I3hAnVPALQmDzCt8I3hAn7nZLmFOE2I9I1PAacmrzCt8I3hAi7/Zi1h2k2nyeQnbkmFOE2I9IV0OLCmDzCt8I3hALQmezCt8I3hALCtlzCt8I3hAYVPDzCt8I3hAYctykmFOE2I9IVF1n7FbfmFOE2I9IVPrfCtZY7/Zi1h2k2nZpmFOE2I9IVPAE1mAzCt8I3hA9Cm1ac5Zi1h2k2WgOV0bdc5Zi1h2k2Wg/VbZi1h2k2WDiVtba1nDeRbZi1h2k2WDiVtbqc05L75Zi1h2k2WDpctbzCt8I3hAPC0bp1bZi1h2iK9fGCtQJG0Oq7FbfGhDi1hEi2hQnGh5i7/ZYctykGhDi1hEiG8fGAoDJCmHLunOE2sfB7PDpmPAO70yeQFMJAXOAvMOAvMOAvMOkVh9EvMOAvMOAvMOAvt9y3hDi1hEjs8iOVogOs8JEvMOAvMOAvMOAvtyA2sfB1n5k7FMjs8ip1mD/7nTBAXOAvMOAvMOAvMOkv4kghWfghWr/QnyiQprnctldc0OaVIrAvMOAvMOAvMOAHt9JA0yeQnbkG8fGR9fGAXOAvMOAvMOAvMOkvvNZ2oDpctMjs8ii1IBJCmgq1m8JA0yeQnbkGvEBAIQJ2tOqmFl/V09JA0yeQnbkGvEis8JEc0ei7pf6V05I1t9BuvNEV05I1t9js8iOVogOs8JEvMOAvMOAvMOAvtyA2sfB1n5k7FMjs8ip1mD/7nTBAXOAvMOAvMOAvMOkv4kghWfghWr/QnyiQprnctldc0OaVIrAvMOAvMOAvMOAH4XJAoDl70Mis8ijs8JEvMOAvMOAvMOAvtyA2sfBcoA/14kghnOnGhei7PgOchBEcoO91vEi2hQnGh5i7/ZYctykGhDfRmrOGvEis8ijs8iqcFOfQFBBGhDfRmrOG8fGR9fGQF5q1vNI7PDpCtlW2dJAs8JEc0ei7pf6coO91vNZ2hcqcoAiVn7WK9fGQWAOQtkjs8idQmgO2hAYct/I1m2IKBEghIDfC0Oq34lfRmrO2sfBAFl/VtAO7I7js8iI7nbeCqkghnge7FMB2nDec0MIKBEghIDfC0Oq34lfRmrO2sfBAFDec0MWK9fGQWAOQtkjs8idQmgO2hAfCt/O2dJAs8JEc0ei7pf6coO91vNZ2hcfCt/OAqkghnAp1t5wK9fGQF5q1vNI105f1mDiVtMIKBEghIDfC0Oq34lfRmrO2sfBAFDec0bfCt/OAqkghnAp1t5wK9fGQF5q1vNIQnZaVh2+h8fGAoDJCmHLuWDl70MBuvNWQnZaV0beVI7js8iI7nbeCqkghnDO1n5/Vo8+s8JEc0ei7pf6coO91vNZ2hcqcoAiVn7WK9fGz8fGz8fG1tyq18fGAXOAvMOAvMOAvMOkvvNZ201eVogOK9fG7nbfcmAY2hDAvMOAvMOAvMOAVXEjs8iZs8i9ctAkCtHB1WbYQPDiVFTBvMOAvMOAvMOAVXOAGhD9QmDf1mAYG8fGR9fGAXOAvMOAvMOAvMOkvvNZ2oDpctMjs8ii1IBJCmgq1m8JAorecoDO7nTiGvNnAIBeCmgzVWbkVhBE705fc0bpVIEiG8fGAoDJCmHLuWrecoDO7nTBuvNE705fc0bpVdkghnbk7FMghIDAvMOAvMOAvMOAVXEBuvrnQtyq14kghWAOcobpVINEvMOAvMOAvMOAvtyAK9fGz8fG7obIV0Od201/VngfCtZY25Zzc0Z4coAiVn7JG8fGR9fGCtQJCmgq1m8JAoDJCmHLuWDl70Mi2hQn2tOqmFl/V09JAoDJCmHLuWDl70Mi2hQnCmgq1m8JAoDJCmHLunyeQnbkGvNnAI5i7/ZYctykGhDfC0Oq34lkQtAOVhEBAI1i7PgOchBEc0ei7pf6Ct8i2hQn2tOqmFl/V09JAoDJCmHLunOEGvEghIDAvMOAvMOAvMOkvt9BuvNIRFOEKI7I3IDfC0Oq34li1hNY2I7kV05I1t9+Ap2YAoDJCmHLunyeQnbk2hTIApyfRmrOKI7I3IDfC0Oq34lfRmrO2hTIApy9QmDf1mAYKI7I3IDfC0Oq34l9QmDf1mAY2hTIAPfIK9fG1tyq18fGAXOAvMOAvMOAvtyAVhNZ2hA57WAa7dJBMFZL1vra1IrfC0MBQFZkct/Y2orpVPrO7WDi1mHBQmAO20lachrq1m8BVP2BVWbkVhNIK9fG7nbfcmAY2hDAvMOAvMOAvMOkvt9js8iZs8iZs8idV05q7prWcOAacfgOV09ghWkghWrpVPDOQPDO1hNEcn5kctMjs8i97nZf1tgf1t8BA01tQty/14kghWrpVPDOQPDO1hNEcoO914kghWr/QnyiQprnctldc0OaVIrzmFgaVWgf7WbdchBEcoO914/Yctyk3hDFQty/14/Yctyk3hDnbn5kctMZVWbkVhEghWkghIDfC0Oq34lFQty/1vNZ20l/V09js8JEc0ei7pf61O1eVobO2sfBVWbkVskghIDfC0Oq34lfRmrO2sfBVWbkVskghIDfC0Oq34lAvMOAvMOAvMOkv4XJAo1eVobOG4kghIDfC0Oq34lAvMOAvMOAvMOkVXEJA01tQty/1vEjs8JEc0ei7pf6vMOAvMOAvMOAv4XyGhDfRmrOG4kghWfghWr/QnyiQprnctldc0OaVIrAvMOAvMOAvMOkv4XJAo1eVobOG8fGR9fGCtQJG0Oq7FbfGhDFQty/1vEi2hQnGh5i7/ZYctykGhDFQty/1vEiG8fGAoDJCmHLuW1eVobO2sfBAo1eVobOK9fGz8fG7obIV0Od201/VngfCtZY2XOAvMOAvMOAvtykvvBE1O1eVobOG8fGR9fGCtQJG0Oq7FbfGhDnbn5kctMiGvNnAIBeCmgzVWbkVhBE1O1eVobOGvEis8JEc0ei7pf61O1eVobO2sfBA01tQty/14kghWfghWr/QnyiQprnctldc0OaVIrAvMOAvMOAvMOAH4XJAoDl70Mis8ijs8ii1IBJCmgq1m8JAoDl70MiGvNnAIBeCmgzVWbkVhBEcoO91vEiG8fGAoDJCmHLuWDl70MBuvNEcoO914kghWfghWr/QnyiQprnctldc0OaVIrzmPDaMPDpCtlWGhEghWkghnOnG0OqmFl/V09JAoDJCmHLuW1eVobOGvNnAnOqmFl/V09JAoDJCmHLun1tQty/1vEis8ip1mD/7nTB2I2js8JEvMOAvMOAvMOAV0yk2sfB2WLFKI2js8JEvMOAvMOAvMOAV0yk2hTZ2hDfC0Oq34lfRmrO2sfZ2hAqcoAiVn7Iup2W2dJB2I2js8ii1IBEc0ei7pf6cn5kctMBu4fZ2oDpctMis8JEvMOAvMOAvMOAV0yk2hTZ2hAf7WbO2dkghnbk7Fbi1IBEc0ei7pf6cn5kctMBu4fZ201eVogOG8fGAXOAvMOAvMOAvtykVhNYuvNI1n5k7FMIK9fG1tyq18fGAXOAvMOAvMOAvtykVhNYuvNEc0ei7pf6cn5kctMjs8JEvMOAvMOAvMOAV0yk2hTZ2hDfC0Oq34lfRmrO2sfZ2hAqcoAiVn7Iup2W2dJB2I2js8ii1IBJCmgq1m8JAoDJCmHLun1tQty/1vEi2hQnGh5i7/ZYctykGhDfC0Oq34lnbn5kctMiGvEghIDAvMOAvMOAvMOkV09B3dfB2IynKI7I3IDfC0Oq34lnbn5kctMB3I2W2dkghIDAvMOAvMOAvMOkV09B3dfB2WfIK9fG7nbfcmAY2hDAvMOAvMOAvMOkV09js8iZs8iZs8idV05q7prWcEgaVobLVWHghWkghWrpVPDOQPDO1hNEvMOAvMOAvMOAV09y2sfBQmApQmEJG4kghWr/QnyiQprnctldc0OaVIre10DsVFy/VtTJA0OE3hDkQtAOVh9EcoO91v9E705fc0bpVdfI2IEghWkghnOnG0Oq7FbfGhDfRmrOGvNnAI5i7/ZYctykGhDfRmrOGvNnAnOq7FbfGhDkQtAOVhEBAIQeCmgzVWbkVhBEV05I1t9i2hQnCmgq1m8JA0OEGvNnAI5i7/ZYctykGhDi1hEis8ie7WAeRbZ9cmgJGhDfC0Oq34lAvMOAvMOAvMOkVsXkVnbP20cF8FZk8FbkVhBECt8kA0yeQnbk3hDfRmrO3hD9QmDf1mAYGvEjs8iOVogOs8ip1mD/7nTB1n5k7FMjs8iZs8i9ctAkCtHB1WbYQPDiVFTBm/ZfV/gf7nOY1pBis8ijs8JEvMOAvMOAvMOAVs5k2sfB2ngaVoH+25kIK9fGAXOAvMOAvMOAvt9yHvNZ2oAO7FbfGhDfC0Oq34lAvMOAvMOAvMOkVsXiK9fGcFeiV0MJAXOAvMOAvMOAvt9yHvNeu4fBDE5HMfMis8ijs8JEvMOAvMOAvMOAVs5k2hTZ2hDAvMOAvMOAvMOkH4Xjs8JEvMOAvMOAvMOAVsXy2sfBVnbTchBEc0ei7pf6vMOAvMOAvMOAV09yG4kghnOnGhDAvMOAvMOAvMOkH4XB24fZ2X1r45g5G8fGAXOAvMOAvMOAvt9yVhNYuvNI3h2js8iZs8JEvMOAvMOAvMOAVs5k2hTZ2hAc2dkghWAOcobpVINEvMOAvMOAvMOAVs5kK9fGz8fGz8fGQFye7PHB1P1vVP7ghWkghWrpVPDOQPDO1hNEvMOAvMOAvMOAHMEy2sfBQmApQmEJG4kghWr/QnyiQprnctldc0OaVIrAvMOAvMOAvMEyVXEJAoDl70MkAo1eVobO3hDnbn5kctMis8ijs8ie7WAeRbZ9cmgJGhDfC0Oq34lAvMOAvMOAvMEyv4XkVnbP20cFMnZP8FbkVhBEcoO91v9Ecn5kctMkA01tQty/1vEiK9fGz8fG7obIV0Od201/VngfCtZY2XOAvMOAvMOAv45kVhBis8ijs8ie7WAeRbZ9cmgJGhDfC0Oq34lAvMOAvMOAvMEyv4XkVnbP20cFMnZP8FbkVheYctyk30l/V09kVWbkVhEiK9fGz8fG7obIV0Od201/VngfCtZY25Zzc0Z4coAiVn7JG8fGR9fGAXOAvMOAvMOAv45kHvNZ2hAjQqiV2dkghIDAvMOAvMOAvMEyHMEBuvrp1mgOchBEc0ei7pf6vMOAvMOAvMOAHMEyG4kghWcJCtyOGhDAvMOAvMOAvMEyHMEB24fZ2X1r45g5G8fGR9fGAXOAvMOAvMOAv45kHvNYuvNEvMOAvMOAvMOAH45AK9fGAXOAvMOAvMOAv4XyvvNZ20lORo8JAoDJCmHLuEOAvMOAvMOAv45AHvEjs8ii1IBEvMOAvMOAvMOAH45A2hXZuvr08My4DvEghIDAvMOAvMOAvMEyVsXB3dfB2I9IK9fGz8fGAXOAvMOAvMOAv45kHvNYuvNImmfIK9fG7nbfcmAY2hDAvMOAvMOAvMEyVsXjs8iZs8iZs8idV05q7prWcOgf7nbeVtbps8ijs8i97nZf1tgf1t8BAXOAvMOAvMOAv4XyVhNZ2h2IK9fG7oAac0bdc0bE2hDAvMOAvMOAvMEyH4XBuvNI2dkghWrpVPDOQPDO1hNEvMOAvMOAvMOkvMOAK9fG7oAac0bdc0bE2hDAvMOAvMOAvtyAvt9Buvre7WAeRvBiK9fG7oAac0bdc0bE2hDAvMOAvMOAvtyAv4Xjs8i97nZf1tgf1t8BAXOAvMOAvMOAVXOkv4kghWrpVPDOQPDO1hNEvMOAvMOAvMOkvtykK9fG7obIV0Od201/VngfCtZY25ZzQFZY7PDpctgfGhEghWkghWfghWr/QnyiQprnctldc0OaVIriVnOfGhDf7mBZVWbkVhEghWkghIDfC0Oq34lAvMOAvMOAvMEyHt9BuvNI1FZa1FyO3W1i7PbeV0O+QmDiVFTYMmbO7WEY7FbfMnbq70ZY7FMJRp2js8JEvMOAvMOAvMOkvMEy2sfB2dNIK9fGAXOAvMOAvMOAVXOkvvNZ2hDfC0Oq34lAvMOAvMOAvtykvMEJG4kghIDfC0Oq34lAvMOAvMOAvMEyHt9B3dfB2W1O7WgiVFT+AqNYgv7k2dkghIDfC0Oq34lAvMOAvMOAvMEyHt9B3dfB2WAO7MOEKI7I3IDAvMOAvMOAvtyAv4XB3I2W3h2js8JEc0ei7pf6vMOAvMOAvMOAH45k2hTZ2hAqc05fcmH+AFZwAp9IK9fGAoDJCmHLuEOAvMOAvMOAv4XyVhNYuvNI7FOWKI7I3IDAvMOAvMOAvtyAVXEB3I2W3h2js8JEc0ei7pf6vMOAvMOAvMOAH45k2hTZ2hAfQtAk14ij2dkghIDfC0Oq34lAvMOAvMOAvMEyH4XBuvNIzmfiKp2js8JEc0ei7pf6vMOAvMOAvMOkvMOA2sfBVnbP20cF8FZkct/Y7pBiK9fGz8fG7obIV0Od201/VngfCtZY205E1XgaVobLVIBECt8kA0yeQnbk3hDfRmrO3hD9QmDf1mAYuv2IG8fGR9fGAoDJCmHLuEOAvMOAvMOAVXOAvvf6QtDE8FZkct/YGhDi1h9EV05I1t9kAoDl70MkAorecoDO7nTiK9fGz8fG7obIV0Od201/VngfCtZY205E1XlOc/AacpBis8ijs8ie7WAeRbZ9cmgJGhDfC0Oq34lAvMOAvMOAvtyAvt9kVnbP20cFMnZPGhEiK9fGz8fG7obIV0Od201/VngfCtZY205E1XbL7oDl8FbkV5DaMnZPGhEghWkghnbY1hBEc0ei7pf6vMOAvMOAvMOkvMOkGvf6vMOAvMOAvMOAHtykGhEjs8iZs8i9ctAkCtHB1WbYQPDiVFTBQtDEMPDpCtlW8FbkV5DaMnZPGhDFQty/1v9E1O1eVobOutl/V09is8ijs8iOVn8JAoDJCmHLuEOAvMOAvMOAVXOAVhELuEOAvMOAvMOAv45kvvBI7PDpCtlW2I9Ecn5kctMkA01tQty/1vEjs8iZs8i9ctAkCtHB1WbYQPDiVFTBQtDE4WbLQnbp8FbkV5DaMnZPGhDFQty/1v9E1O1eVobOutl/V09is8ijs8iOVn8JAoDJCmHLuEOAvMOAvMOAVXOAVhELuEOAvMOAvMOAv45kvvBIVWbLQnbp2I9Ecn5kctMkA01tQty/1vEjs8iZs8i9ctAkCtHB1WbYQPDiVFTBQtDED05f1MgOV0yMV/AacpBERtbe7I9EVtZYc0BkA0DeRv9EC0Z/7df93hDLCtl/c0bqu4NkAogOQFZY1oHZHh9E1O1eVobOutl/V09is8ijs8ii1IBEVtZYc0BBusfBHhEghIDLVFlfChNZ2sNjs8iOVogOs8JEVtZYc0BB34fBH4kghnbY1hBEc0ei7pf6vMOAvMOAvMOkvMOkGvf6vMOAvMOAvMOAHtyAGhAEQmDO2I9IVnbP2XDec0MJ2ITERtbe7INY2I9I3IDLVFlfChNY2I9I3IDEQmEB3I2k2ITEC0Z/7INY2I9I3IDLCtl/c0bq2hTI3h2YAogOQFZY1oHB3I2i2I9E1O1eVobOG4kghWfghWr/QnyiQprnctldc0OaVIre10DXQmDOc0OL1MgOV0yMV/AacpBERtbe7I9EVtZYc0BkA0DeRv9EC0Z/7df93hDLCtl/c0bqu4NkAogOQFZY1oHZHh9E1O1eVobOutl/V09is8ijs8ii1IBEVtZYc0BBusfBHhEghIDLVFlfChNZ2sNjs8iOVogOs8JEVtZYc0BB34fBH4kghnbY1hBEc0ei7pf6vMOAvMOAvMOkvMOkGvf6vMOAvMOAvMOAHtyAGhAEQmDOc0OL1v2k2nlOcprXQmDOGh2YAoOOQm2B3I2k2ITEVtZYc0BB3I2k2ITE105l2hTI3h2YA0eacm2B3I2k2ITEVtOYcmDO7pNY2I9I3IDq1tgaVnDq2hTIGv2kA01tQty/1vEjs8iZs8i9ctAkCtHB1WbYQPDiVFTBQtDEb0OL1MgOV0yMV/AacpBEC0Z/7I9EVtOYcmDO7p9E7FbdVFlE7qf93hDAvMOAvMOAvtyAHMEZHh9E1O1eVobOutl/V09is8ijs8iOVn8JAoDJCmHLuEOAvMOAvMOAVXOAVhELuEOAvMOAvMOAv45kvvBIc0OL1v2k2OkI3IDJVPbp2hTI3h2YA0/iVWbf1mHB3I2k2ITE7FbdVFlE7pNY2I9I3IDAvMOAvMOAvtyAHMEB3IAc2I9E1O1eVobOG4kghWfghWr/QnyiQprnctldc0OaVIre10DhVFZk8FbkV5DaMnZPGhDFQty/1v9E1O1eVobOutl/V09is8ijs8iOVn8JAoDJCmHLuEOAvMOAvMOAVXOAVhELuEOAvMOAvMOAv45kvvBIQnZaVh2kAo1eVobO3hDnbn5kctMiK9fGz8fG7obIV0Od201/VngfCtZY25Zzc0Z4coAiVn7JG8fGR9fGAXOAvMOAvMOAVXEyVhNZ2hDfC0Oq34lAvMOAvMOAvMEyHt9js8JEvMOAvMOAvMOkv45k2hTZ2hDfC0Oq34lAvMOAvMOAvtyAvMEjs8JEvMOAvMOAvMOkv45k2hTZ2h2k7nZP7qJBtp2js8JEvMOAvMOAvMOAH45A2sfB7nbq1m8JAoDJCmHLuEOAvMOAvMOAVXOAVhEjs8iPC0Ok1vBEvMOAvMOAvMOAH45A2hXZuvr08My4DvEghWkghIDAvMOAvMOAvtyAHt9B3dfBAXOAvMOAvMOAv4Xyv4kghIDAvMOAvMOAvMEyHMEBuvrY1mefGhDfC0Oq34lAvMOAvMOAvtyAvt9iK9fGCtQJAXOAvMOAvMOAv4XyvvNeu4fBDE5HMfMis8JEvMOAvMOAvMOkv45k2hTZ2h2k2dkghWfghIDAvMOAvMOAvtyAHt9B3dfB2OfIK9fGAXOAvMOAvMOAVXEyVhNYuvNEc0ei7pf6vMOAvMOAvMOAH4XyK9fGAXOAvMOAvMOAVXEyHvNZ205p7n5lGhA77I2k2OyY2I9Imo8IG4kghIDAvMOAvMOAvtyAHt9BuvrqcoAz7nb9V05d1vBEvMOAvMOAvMOkv4Xy3h2I3hDAvMOAvMOAvtyAHt9iK9fG7nbfcmAY2hDAvMOAvMOAvtyAHt9js8iZs8i97nZf1tgf1t8B1WbYQPDiVFTBvMOAvMOAvMOkVXOAGhEghWkghWgpQtlEGhDfC0Oq34lAvMOAvMOAvtykHMEJGvEjs8JEvMOAvMOAvMOkVXEy2sfB7n5Y1hBiK9fGAXOAvMOAvMOAV0ykVhNZ2oAeVn8JG4kghIDAvMOAvMOAvtykVsXBuvrpQtlEGhEjs8ip1mD/7nTB7PDpcn5kGhDAvMOAvMOAvtykv4Xi2hlqcoAFQt9JAXOAvMOAvMOAV0ykVhEB3Wgf7W1eVhBEvMOAvMOAvMOkV09yG4kghWfghWrpCm1ec0MB1WbYQPDiVFTBvMOAvMOAvMOkVs5AGhEghWkghnyi7P8JAXOAvMOAvMOAV09yVh9EvMOAvMOAvMOkVsXyGvNZ20bT70ya10MJApNW30/iQPAac0OL1vBiG4kghWAOcobpVINJ1nyaQm8i2hDAvMOAvMOAvtykH4XBGpBJ1nyaQm8i2hDAvMOAvMOAvtykHt9BGINyHsN9HsNiK9fGz8fGz8fG Also, I'd like to modify this plugin. Is there anyway to decode this? Thx.

-proper escaping for mysql queries -image uploading and validation -sessions -POST, GET, SERVER vars I'll try to think of more. Check TOC's for PHP/MYSQL books too.

<input name="gender" type="radio" id="gender" value="male" <?php echo ($gender_prof == 'male') ? "CHECKED='CHECKED'" : ""; ?> /> <input name="gender" type="radio" id="gender" value="female" <?php echo ($gender_prof == 'female') ? "CHECKED='CHECKED'" : ""; ?> />