mattclements

Hey all I am getting the following error: Parse error: syntax error, unexpected T_DOUBLE_ARROW with this code - seems like im missing something stupid! <?php if( (date("d") => 08) && (date("d") < 15) ) { echo "selected"; }; ?> Matt

Thank you so much! I didn't look inside one of the API files (that happens to be called m_email.php) which sets the Authentication details to an external SMTP server (with Authentication) that the old server used to use. I am about to change and test. Thank you so much for your time & help. Matt

Ok - Some how with some flicking through I found the script to stop & fail where building the array. However I made a few minor adjustments and the error seems to have been fixed. I now have a server side issue (i belive) as this script has never been on this server. 3Message was not sent Mailer Error: SMTP Error: Could not authenticate Please report this to support@foo.com3Message was not sent Mailer Error: SMTP Error: Could not authenticate Please report this to support@foo.com3Message was not sent Mailer Error: SMTP Error: Could not authenticate Please report this to support@foo.comDEMO DONE.

Hey all, Right - I have an old server that used to look through a PostgreSQL table called demo users and send out their usernames & passwords if the column "processed" is 0 (then change it too 1). This worked on the old server - however somebody transfered this to a new server a while back and didnt setup the cron job. I have just looked at the script - but can't work out why its not sending the mails. I have found out that when running the script using echo commands to find out how far the script runs - it displays the first echo, but not the second. <? include( "cron_root.php" ); ?> <? //echo "Up to Step 1"; // 1. get email address(s) $proc_demos_q = m_execute_query_full( "XXXX", " select * from demo_users where processed = '0' LIMIT 1 " ); if ( isset( $proc_demos_q ) && ( sizeof( $proc_demos_q ) > 0 ) ) { for( $idx=0; $idx<sizeof( $proc_demos_q ); $idx++ ) { $current_demo_id = $proc_demos_q[$idx][ "uuid_demo_users" ]; $current_email = $proc_demos_q[$idx][ "email" ]; $uuid_partner = $proc_demos_q[$idx][ "uuid_partner" ]; $confirm_email = $proc_demos_q[$idx][ "confirm_email" ]; $confirm_subject = $proc_demos_q[$idx][ "confirm_subject" ]; // 1. create demo application account $acc_params = array(); $acc_params[ "email" ] = $current_email; $acc_params[ "uuid_partner" ] = $uuid_partner; $acc_params[ "current_demo_id" ] = $current_demo_id; $acc_create_r = m_demo_create( $acc_params ); if ( $acc_create_r[ "result" ] == '1' ) { // get partner id email $get_part_q = m_execute_query_full( "XXXX", " select * from partners where uuid_partner = '$uuid_partner' " ); if ( isset( $get_part_q ) && ( sizeof( $get_part_q ) > 0 ) ) { //echo "Up to Step 1"; // 2. send email with details og login. $email[ "from_address" ] = $get_part_q[0][ "partner_email" ]; $email[ "to_address" ] = $current_email; if ( trim( $confirm_subject ) == '' ) { $email[ "subject" ] = "XXXX - Demonstration Account"; } else { $email[ "subject" ] = $confirm_subject; } $email[ "mess_type" ] = "HTML"; // 3. form the message if ( m_url_check( $confirm_email ) ) { $params[ "get_url" ] = $confirm_email; } else { $params[ "get_url" ] = "http://XXXX/demo_email.htm"; } $content = m_get_web_page( $params ); $replace_tok[ "content" ] = $content; $gen_password = $acc_create_r[ "password" ]; $replace_tok[ "name_tokens" ] = array( "{current_email}" => $current_email, "{gen_password}" => $gen_password ); $content = m_replace_tokens( $replace_tok ); $email[ "message" ] = $content; // 4. now send the message m_email( $email ); $organ_name = $get_part_q[0][ "organ_name" ]; // 5. send another copy to development $email[ "to_address" ] = "USER@XXXX"; $email[ "subject" ] = $email[ "subject" ]." (COPY) - ".$organ_name; m_email( $email ); // 6. send another copy to USER@XXXX $email[ "to_address" ] = "USER@XXXX"; $email[ "subject" ] = $email[ "subject" ]." (COPY) - ".$organ_name; m_email( $email ); echo 'DEMO DONE.'; } } } } ?> Any help appriciated. Matt

Does anybody have any ideas about this? It is starting to cause major issues with the site. Regards, Matt

Hello all, I am having a bit of a problem with a script I am currently working on. There is an alias called /static/ which points to a directory outside of my htdocs folder. When running any of these files it asks to download the PHP file, rather than displaying it. I understand that this is something to do with the apache/php link not running - but just in this alias. And from what I understand this is something I need to change in the htaccess or apache config file?! Regards, Matt

Hello, This still leaves a blank page with no errors. Regards, Matt

<?php if ($c = oci_connect("****","****", "****")) { echo "Successfully connected to Oracle"; //oci_close($c); } else { $err = oci_error(); echo "Oracle Connect Error " . $err['text']; } $stmt="BEGIN display_msg(_login_id, _date, _msg); END;" //$stmt=" SELECT * // FROM display_msg"; //if (oci_num_rows($stmt) == 0) { // echo '<meta http-equiv="refresh" content="0;url=changeclub.php" />'; //} $qres=oci_parse($c,$stmt); oci_bind_by_name($qres, "_login_id", $slogin); oci_bind_by_name($qres, "_date", 'sysdate'); oci_bind_by_name($qres, "_msg", $message, 32); oci_execute($qres); //while (oci_fetch($qres)) { // echo oci_result($qres, "msg_meaning") ."<br /><hr /><br />\n"; //} echo $message; oci_commit($c); ?> The oci_bind_by_name is causing a blank screen! So stuck as to why this is happening. Regards, Matt

Hey, Do each of these folders contain an index.html file? Looks to me like the DirectoryIndex index.html is there, but you may have index.htm or index.php etc - if so - add this to the config file. Regards, Matt

Ok, Im going somewhere now. My code looks like follows: $ses_username = $sucid; $ses_date = date('Y-m-d H:i:s',time()); $conn = OCILogon("user","password","server"); $curs = OCINewCursor($conn); $stmt = OCIParse($conn,"begin DISPLAY_MSG('$ses_username', '$ses_date', _msg); end;"); OCIBindByName($stmt,"_msg", &$ses_username, &$ses_date 20) or die ('Can not bind variable'); OCIFreeStatement($stmt); OCIFreeCursor($curs); OCILogoff($conn); However I just get a blank screen, as soon as I comment OCIBindByName out it all works again. Regards, Matt

Also, If you are not the root user, try "sudo (each command)"

Hello there, This could be a number of things. However if you go to the directory where the RPM file is and chmod 777 antiword-0.37-3.rh9.rf.i386.rpm rpm -U antiword-0.37-3.rh9.rf.i386.rpm This should work. Alternatively yum update yum search antiword .. Then if anything is found... yum install (antiword package name) Regards, Matt

Hello there, Ok - Something a bit new for me. I am currently working on a site that uses PHP & Oracle. We have built a procedure where we need to. Input: Login ID Number (PHP Variable) Current Server Date (sysdate in Oracle) Output: A list of messages from the Server The Oracle side works & is tested. However we are getting problems when using the code: $conn = OCILogon("****","****","****"); $curs = OCINewCursor($conn); $stmt = OCIParse($conn,"begin DISPLAY_MSG(_login_id, _date, _msg); end;"); OCIBindByName($stmt,"_login_id",&$gid,32); OCIBindByName($stmt,"_msg",&$curs,-1,OCI_B_CURSOR); //$gid=1; // for gid = 1 only //ociexecute($stmt); //ociexecute($curs); //while (OCIFetchInto($curs,&$friend_cv )) { // echo "<pre>"; // print_r($P_msg); // echo "</pre>"; //} OCIFreeStatement($stmt); OCIFreeCursor($curs); OCILogoff($conn); However - I am stumped! I really don't know where to start, and need to know how to act with the procedure (input & output) and whether I can just use sysdate as the date. Regards, Matt

Get ID3 looks like this: http://audio.ecoptimist.com/getid3/getid3.txt Thanks in advance. Matt

Can you not simply change all those tables to: UserID UserPassword etc etc State and move all records into this new table! The way it is currently done doesn't really cover "Normalised Data!" Let me know what you think, Matt

<?php /* $Id: inlaudition.php,v 1.22 2003/06/05 23:26:23 hpdl Exp $ */ require_once('includes/application_top.php'); $productid = $HTTP_GET_VARS['pid']; $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . $productid . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); require_once 'local/exfunc.php'; ?> <!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script type="text/javascript" src="/catalog/local/jscript/browserdetect.js"></script> <script type="text/javascript" src="/catalog/local/jscript/prototype.js"></script> <script type="text/javascript" src="/catalog/local/jscript/exjs.js"></script> <script type="text/javascript" src="/catalog/local/jscript/effects.js"></script> <script type="text/javascript" src="/catalog/local/jscript/builder.js"></script> <!--[if lte IE 6]> <style type="text/css"> img{behaviour:url(/catalog/iepngfix.htc);} </style> <![endif]--> <style type="text/css"> html{ background: transparent;} body{ font-size:11px;font-family: Arial, Helvetica, Verdana, sans-serif;height:100%;margin:0;padding:0;background: transparent;} .nameblock { position:relative; height:auto; padding:4px; } .modelblock { position:relative; padding:4px; } .bottomblock { position:relative; padding:4px; } .descrblock { padding:12px 4px 12px 4px; position:relative; } .id3block { vertical-align:top; position:relative; } .lside { font-size:11px; color:#969696; } .rside { color:#000000; font-size:11px; font-weight:bold; } .mp3name { font-size:16px; color:#1e1e1e; font-weight:bold; } .mp3model { padding-left:12px; color:#969696; font-weight:bold; } .mp3descr { color:#969696; font-weight:bold; } .id3descr { color:#969696; font-weight:bold; } </style> </head> <body> <?php $startDir = dirname( __FILE__ ); $filedir = $startDir.'/media/'; $pname = $product_info['products_name']; $purl = $product_info['products_url']; $pdesc = $product_info['products_description']; $pmodel = $product_info['products_model']; $pimage = $product_info['products_image']; $pmanuid = $product_info['manufacturers_id']; $manquery = tep_db_query("select manufacturers_name, manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = " . $pmanuid); $man_info = tep_db_fetch_array($manquery); $manname = $man_info['manufacturers_name']; if ( empty($pimage)) { $pimage = $man_info['manufacturers_image']; if ( empty($pimage)) { $pimage = "fronthtml.png"; } } $pimage = DIR_WS_HTTP_CATALOG."images/".$pimage; $pos = strpos($purl, '.wav' ); if ( $pos == false ) { $pos = strpos( $purl, '.flac' ); if ( $pos == false ) { $pos = strpos($purl, '.mp3' ); } } $data = null; if ( $pos !== false ) { $subname = substr($purl, 0, $pos ); $output1 = namefromupload( $purl, '192k'); $idd = new getid3( $output1 ); $data1 = $idd->getmp3data(); $data2 = $idd->gettags(); uksort($data2, 'sorttags' ); $cols = 2; $i = 0; $str = '<table style="width:100%;">'; $flip = 0; foreach( $data2 as $k => $d ) { $longname = $d['longname']; if ( $flip == 0 ) { if ( $i > 0 ) { $str .= "</tr>\n"; } $str .= "<tr>\n"; } if ( $k{0} == 'T' ) { $str .= '<td style="width:50%;">'; $dstr = null; if( $k == 'TCON' ) { $dstr = $d['genre']; } else { $dstr = $d['text']; } if ( $k == 'TSRC' ) { $dstr = fixisrc($dstr); } else if ($k == 'TDAT') { if ( strpos( $dstr, '-' ) !== false ) { $rep = explode( '-', $dstr ); if ( count( $rep ) == 3 ) { $mon = $rep[1]; $day = $rep[2]; $dstr = "$day / $mon "; } } else { // 4 bytes with month and day // ~~~~~~~~~~~~~~~~~~~~~~~~~~ $day = $dstr{0}.$dstr{1}; $mon = $dstr{2}.$dstr{3}; $dstr = "$day / $mon"; } } $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$longname:</span> </td> <td><span class=\"rside\">$dstr</span> </td> </tr> </table>"; } else { switch( $k ) { case 'APIC': { if ( $flip > 0 ) { $str .= '</td></tr><tr>'; $flip = 0; } $str .= '<td style="width:100%" colspan="2">'; $flip++; $mime = $d['mime']; // $format = $d['format']; $imagebits = isset($d['bits'])? $d['bits']: null; // echo "See Image bits<br />"; if ( isset($mime) && isset($imagebits)) { $imsrc = createtemppic($imagebits); // echo "See $imsrc<br />"; if ( $imsrc !== false ) { $str .= "<div style=\"width:100%;\"><img src=\"$imsrc\" alt=\"\" /></div>"; } } // die(); } break; case 'COMM': $str .= '<td style="width:50%;">'; $dstr = $d['text']; $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$longname:</span> </td> <td><span class=\"rside\">$dstr</span> </td> </tr> </table>"; break; default: $str .= '<td style="width:50%;">'; break; } } $str .= '</td>'; if ( ++$flip == $cols ) { $flip = 0; } $i++; } foreach( $data1 as $k => $d ) { if ( $flip == 0 ) { if ( $i > 0 ) { $str .= "</tr>\n"; } $str .= "<tr>\n"; } $str .= '<td style="width:50%;">'; $extra = $k == 'time'? ' seconds': null; $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$k:</span> </td> <td><span class=\"rside\">$d{$extra}</span> </td> </tr> </table>"; $str .= '</td>'; if ( ++$flip == $cols ) { $flip = 0; } $i++; } $str .= '</table>'; } ?> <div style="height:98%;width:100%;overflow:auto;"> <div style="width:100%;"> <div class="nameblock"> <span class="mp3name"><?php echo $pname;?></span><span class="mp3model">[<?php echo $pmodel;?>]</span> </div> <div class="descrblock"> <span class="mp3descr"><?php echo $pdesc;?></span> </div> <div class="id3block"> <?php echo $str;?> </div> </div> </div> <?php $cnt = count( $javascript ); $loadcnt = count( $onload ); if ( $cnt > 0 || $loadcnt > 0 ) { $str = "<script type=\"text/javascript\">\n//<![CDATA[\n"; foreach ( $javascript as $jss ) { $str .= $jss; } if ( $loadcnt > 0 ) { $str .= "Event.onReady(function(){\n"; foreach( $onload as $ld ) { $str .= $ld; } $str .= "});\n"; } $str .= "//]]>\n</script>\n"; echo $str; } ?> </body> </html> http://audio.ecoptimist.com/getid3/getid3.php has "class getID3" However I then get the following: "Fatal error: Call to undefined method getID3::getmp3data() in /content/audio.ecoptimist.com/catalog/inlinfo.php on line 153"

Any body?

http://audio.ecoptimist.com/getid3/getid3.php has "class getID3" But i have changes the "new id3" to "new getid3" to fix it and i now get: "Fatal error: Call to undefined method getID3::getmp3data() in /content/audio.ecoptimist.com/catalog/inlinfo.php on line 153" ???

Hello there, My client uses the following code: <?php /* $Id: inlaudition.php,v 1.22 2003/06/05 23:26:23 hpdl Exp $ */ require_once('includes/application_top.php'); $productid = $HTTP_GET_VARS['pid']; $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . $productid . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); require_once 'local/exfunc.php'; ?> <!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script type="text/javascript" src="/catalog/local/jscript/browserdetect.js"></script> <script type="text/javascript" src="/catalog/local/jscript/prototype.js"></script> <script type="text/javascript" src="/catalog/local/jscript/exjs.js"></script> <script type="text/javascript" src="/catalog/local/jscript/effects.js"></script> <script type="text/javascript" src="/catalog/local/jscript/builder.js"></script> <!--[if lte IE 6]> <style type="text/css"> img{behaviour:url(/catalog/iepngfix.htc);} </style> <![endif]--> <style type="text/css"> html{ background: transparent;} body{ font-size:11px;font-family: Arial, Helvetica, Verdana, sans-serif;height:100%;margin:0;padding:0;background: transparent;} .nameblock { position:relative; height:auto; padding:4px; } .modelblock { position:relative; padding:4px; } .bottomblock { position:relative; padding:4px; } .descrblock { padding:12px 4px 12px 4px; position:relative; } .id3block { vertical-align:top; position:relative; } .lside { font-size:11px; color:#969696; } .rside { color:#000000; font-size:11px; font-weight:bold; } .mp3name { font-size:16px; color:#1e1e1e; font-weight:bold; } .mp3model { padding-left:12px; color:#969696; font-weight:bold; } .mp3descr { color:#969696; font-weight:bold; } .id3descr { color:#969696; font-weight:bold; } </style> </head> <body> <?php $startDir = dirname( __FILE__ ); $filedir = $startDir.'/media/'; $pname = $product_info['products_name']; $purl = $product_info['products_url']; $pdesc = $product_info['products_description']; $pmodel = $product_info['products_model']; $pimage = $product_info['products_image']; $pmanuid = $product_info['manufacturers_id']; $manquery = tep_db_query("select manufacturers_name, manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = " . $pmanuid); $man_info = tep_db_fetch_array($manquery); $manname = $man_info['manufacturers_name']; if ( empty($pimage)) { $pimage = $man_info['manufacturers_image']; if ( empty($pimage)) { $pimage = "fronthtml.png"; } } $pimage = DIR_WS_HTTP_CATALOG."images/".$pimage; $pos = strpos($purl, '.wav' ); if ( $pos == false ) { $pos = strpos( $purl, '.flac' ); if ( $pos == false ) { $pos = strpos($purl, '.mp3' ); } } $data = null; if ( $pos !== false ) { $subname = substr($purl, 0, $pos ); $output1 = namefromupload( $purl, '192k'); $idd = new id3( $output1 ); $data1 = $idd->getmp3data(); $data2 = $idd->gettags(); uksort($data2, 'sorttags' ); $cols = 2; $i = 0; $str = '<table style="width:100%;">'; $flip = 0; foreach( $data2 as $k => $d ) { $longname = $d['longname']; if ( $flip == 0 ) { if ( $i > 0 ) { $str .= "</tr>\n"; } $str .= "<tr>\n"; } if ( $k{0} == 'T' ) { $str .= '<td style="width:50%;">'; $dstr = null; if( $k == 'TCON' ) { $dstr = $d['genre']; } else { $dstr = $d['text']; } if ( $k == 'TSRC' ) { $dstr = fixisrc($dstr); } else if ($k == 'TDAT') { if ( strpos( $dstr, '-' ) !== false ) { $rep = explode( '-', $dstr ); if ( count( $rep ) == 3 ) { $mon = $rep[1]; $day = $rep[2]; $dstr = "$day / $mon "; } } else { // 4 bytes with month and day // ~~~~~~~~~~~~~~~~~~~~~~~~~~ $day = $dstr{0}.$dstr{1}; $mon = $dstr{2}.$dstr{3}; $dstr = "$day / $mon"; } } $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$longname:</span> </td> <td><span class=\"rside\">$dstr</span> </td> </tr> </table>"; } else { switch( $k ) { case 'APIC': { if ( $flip > 0 ) { $str .= '</td></tr><tr>'; $flip = 0; } $str .= '<td style="width:100%" colspan="2">'; $flip++; $mime = $d['mime']; // $format = $d['format']; $imagebits = isset($d['bits'])? $d['bits']: null; // echo "See Image bits<br />"; if ( isset($mime) && isset($imagebits)) { $imsrc = createtemppic($imagebits); // echo "See $imsrc<br />"; if ( $imsrc !== false ) { $str .= "<div style=\"width:100%;\"><img src=\"$imsrc\" alt=\"\" /></div>"; } } // die(); } break; case 'COMM': $str .= '<td style="width:50%;">'; $dstr = $d['text']; $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$longname:</span> </td> <td><span class=\"rside\">$dstr</span> </td> </tr> </table>"; break; default: $str .= '<td style="width:50%;">'; break; } } $str .= '</td>'; if ( ++$flip == $cols ) { $flip = 0; } $i++; } foreach( $data1 as $k => $d ) { if ( $flip == 0 ) { if ( $i > 0 ) { $str .= "</tr>\n"; } $str .= "<tr>\n"; } $str .= '<td style="width:50%;">'; $extra = $k == 'time'? ' seconds': null; $str .= "<table style=\"width:100%;\"> <tr> <td style=\"width:40%;\"> <span class=\"lside\">$k:</span> </td> <td><span class=\"rside\">$d{$extra}</span> </td> </tr> </table>"; $str .= '</td>'; if ( ++$flip == $cols ) { $flip = 0; } $i++; } $str .= '</table>'; } ?> <div style="height:98%;width:100%;overflow:auto;"> <div style="width:100%;"> <div class="nameblock"> <span class="mp3name"><?php echo $pname;?></span><span class="mp3model">[<?php echo $pmodel;?>]</span> </div> <div class="descrblock"> <span class="mp3descr"><?php echo $pdesc;?></span> </div> <div class="id3block"> <?php echo $str;?> </div> </div> </div> <?php $cnt = count( $javascript ); $loadcnt = count( $onload ); if ( $cnt > 0 || $loadcnt > 0 ) { $str = "<script type=\"text/javascript\">\n//<![CDATA[\n"; foreach ( $javascript as $jss ) { $str .= $jss; } if ( $loadcnt > 0 ) { $str .= "Event.onReady(function(){\n"; foreach( $onload as $ld ) { $str .= $ld; } $str .= "});\n"; } $str .= "//]]>\n</script>\n"; echo $str; } ?> </body> </html> Basically I am very confused - it works here: http://www.speciesaudio.com/catalog/inlinfo.php?&pid=35 and not on the new site: http://audio.ecoptimist.com/catalog/inlinfo.php?&pid=35 The site is 100% the same. I really cant work out what is different. Thanks in advance! Matt

Hello there, Ok I am having a problem here.... The maker of a large script that my client is using has used Checkboxes rather than Radio Boxes, therefore: When submitting the form their are 2 columns of data filled: Rights Managed, and Royalty Free, with a one or a zero (I think). You should only be able to select either/or.... basically if I use a radio selector this will only allow data entered to one of the columns.... So... I am ideally after a piece of easy JavaScript which deselects one option when the other is pressed. Any ideas? Thanks, Matt

Try changing the * to the External IP and see if that works, then report back and I can take a better look. I have the same problem with my ISP Cheers Matt

What would the Trigger look like? Cheers Matt

I had the same problems when my control panel was working.... change the * to your external IP... that solved it for me.. Let me know, Matt

This Assignment uses SQL only - No other language else I would use PHP.... is this even physically possible? Cheers Matt

Hey, Yer with some more research I found out the same.... This isn't going to have to be a "production" database as it's just for an assignment. Ive got an extention to finish this off.... Anyway... So far im thinking: ALTER TABLE students CONSTRAINT form CHECK (form LIKE 10LLa); Basically I only want users to be able to enter 1 Optional Number, then 1 Compulsary Numbers, then 2 Compulsary Letters, followed by 1 Optional Letter... Such as: 13JC or 14JCa or 9JC or 9JCa Also is there any way of just limiting the number values to be between 9-14? Thanks, Matthew