barrowvian

I'm pretty new to mysql so couldn't even tell you the exact name of the problem I'm having Basically, I have a simple database with 3 fields; name, county and decision. What I'm wanting to do is select the data from the database and list it in alphabetical order; $sql = "SELECT * FROM names ORDER BY name ASC LIMIT $offset, $rowsperpage"; Once this is done I want to output the results depending on the 'decision field'. If the decision field = yes then I want the output result to be shown in green. If it = no then output it in red. But I still want to maintain the alpha order. Is this possible and how would I achieve this? thanks

Hi guys and girls, I said I'd help my bud out by posting a message on a couple of the forums I use. If it's against the rules at all then I apologise :whistling: He has made a new site, overonemillionads.com / over1000000ads.com where he is aiming to display over one million ads on a single homepage. Just for a bit of fun on his part, mainly to see if it can be achieved. Anyway, each ad costs just $10 (approx £7) and every penny of it goes to a children's charity, to help create opportunities for terminally ill children. You can advertise anything (e.g. business, personal site, blog etc) just to show your support for the cause. Any support is greatly appreciated. Again, the site is overonemillionads.com / over1000000ads.com Thank you for taking the time to read this.

I'm a bit stuck at the moment, and I've not used the body onload function before. What Ive decided upon is... do the initial form with validation and then pass that data to the second form. The second form simply displays what the user has entered (and cannot edit it at this point). This gives the user the chance to confirm the details that theyre going to submit. If they click confirm then it does the image upload and directs the user to paypal with all of the details, if they want to edit it they can press back and go start again. How would I implement the data from the first form into the second? With sessions or will the post still field still work? Also, how would I go about adding the upload function to the paypal button? thanks

That sounds fairly straight forward. Just to clarify, your'e recommending using two buttons? 1 to do the validation and 1 to 'continue' which would be the button that takes the user to paypal?

I have this code so far; <form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="hidden" name="cmd" value="_xclick"> <input type="hidden" name="business" value="[email protected]"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="item_name" value="product"> <input type="hidden" name="amount" value="10.00"> <input type="hidden" NAME="return" value="http://www.mybiz.com/success"> <table> <tr><td><input type="hidden" name="on1" value="Firstname" maxlength="50">Firstname:</td><td><input type="text" name="os1"></td></tr> <tr><td><input type="hidden" name="on2" value="Surname" maxlength="50">Surname:</td><td><input type="text" name="os2"></td></tr> <tr><td><input type="hidden" name="on3" value="Email" maxlength="200">Email:</td><td><input type="text" name="os3"></td></tr> <tr><td><input type="hidden" name="on4" value="Contact Number" maxlength="50">Contact Number:</td><td><input type="text" name="os4"></td></tr> <tr><td><input type="hidden" name="on5" value="Company Name" maxlength="50">Company Name:</td><td><input type="text" name="os5"></td></tr> <tr><td><input type="hidden" name="on6" value="Company URL" maxlength="200">Company URL:</td><td><input type="text" name="os6"></td></tr> <tr><td><input type="hidden" name="on7" value="Keywords" maxlength="200">Keywords:</td><td><input type="text" name="os7"></td></tr> <tr><td>Quantity:</td><td><input type="text" name="quantity" value="1" size="5" /></td></tr> </table> <input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but01.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"> </form> I am also wanting the user to be able to upload an image. Is there any certain way that I'd need to add validation to this paypal form to ensure that the information entered is accurate? I also want to store the image file in a folder too (I can do that) but I just need some starters for the validation, thanks

Thank you Syed, I removed the value attribute and its worked

I had a basic contact form in place at the moment. When Im using a simple text field everything works fine; echo '<tr> <td width="10%" align="left" valign="top">Full Name:</td> <td width="20%" align="left"><input type="text" name="name" style="width: 200px" value="'; if ($errorName_Field) echo $_POST['name']; if (isset($_POST['name']) && $errorName_Field==false) echo $_POST['name']; echo '" /></td> <td width="70%" align="left">'; if ($errorName_Field) echo "$errorTextName_Field"; echo '</td>'; echo '</tr>'; If the input is incorrect then is keeps it there for the user to edit along with displaying an error message. If the input is correct it keeps it there too but doesnt display the message. My problem is when it comes to using the same function with a text area. I use pretty much the same code; echo '<tr> <td width="10%" align="left" valign="top">Message:</td> <td width="20%"align="left"><textarea rows="5" name="message" style="width: 199px;" value="'; if ($errorMessage || $errorMessage1) echo $_POST['message']; if (isset($_POST['message']) && $errorMessage==false && $errorMessage1==false) echo $_POST['message']; echo '" /></textarea></td>'; echo '<td width="70%" align="left">'; if ($errorMessage) echo "$errorTextMessage"; if ($errorMessage1) echo "$errorTextMessage1"; echo '</td>'; echo '</tr>'; But for some reason it doesnt work at all. It doesnt keep the input within the area no matter if the input is correct or incorrect. Is there something I have to do different with it being a text area? Ive done a simple echo to return the value of what is inserted upon submission and that works, but it doesnt when its in the text area.

Yeah Ive just been playing around with the paypal sandox tools and its nice and easy to incorporate onto my site...just as a button that links to paypal though. Do you know how I'd go about linking that paypal button to the submission button, so that it doesnt email me the submission details unless the paypal button is pressed? Also, is there any way to link it to not email me the details until a payment is complete rather than just the initial submission? Thanks

I'm not sure if this is in the right sections, so I'm sorry if its not. I've been helping my friend make a basic modelling site as part of a project but I've never made anything with any kind of payment function/gateway before. What I'm wanting it to go like is; 1 - User goes to register page (basic submission form with function for uploading image) - I've done this part. 2 - If all is OK, then they're forwarded to a payment page. The register function doesnt do anything yet except store the data. 3 - If payment is OK then send the data to me in a email (I can send an email with the data). I don't know how I'd link the payments to the submission form etc, or how I'd go about using a payment method. Please could someone offer me their advice and point me in the right direction, thank you

haha very help mr state the obvious dezkit thank you though kenrbnsn that really helped. I hadnt changed my db to fulltext index. It works now though thanks again

This is part of my code for a simple search function. It works for my test site on wampserver; //sql fulltext statement against words/phrase user enters $sql = "SELECT *, MATCH(company_name, search_data) AGAINST('%$_GET[searchterms]%') AS score FROM adverts WHERE MATCH(company_name, search_data) AGAINST('%$_GET[searchterms]%') LIMIT 0, 500"; $result = mysql_query($sql); //display an error if the query returns no results if (mysql_num_rows($result) < 1 && strlen($searchTerms) > 3 && strlen($searchTerms) < 50) { echo "<font color=\"red\">No results found for <strong>{$searchTerms}</strong></font>."; $flag = "NOTOK"; } However, when I host it live and try to use it I get this error message; Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/overone1/public_html/search.php on line 70 Line 70 is if (mysql_num_rows($result) < 1 && strlen($searchTerms) > 3 && strlen($searchTerms) < 50) { Please could someone explain what I have done wrong here and what the best way to fix it is? Thank you

this is the current css style i have at the moment; @charset "UTF-8"; /* Background-Styles */ body { margin:0px; padding:0px; background-color:#01398e;/* very bottom of the page*/ font-family:Arial, Helvetica, sans-serif; color:#7f7d78; font-size:13px; line-height:19px; } #main { background:#e3e8f1 url(images/background_light_slice.jpg) repeat-x; /*main body colour, plus image for top main section*/ padding-bottom:5px; } #main .container { background-image:url(images/background_light.jpg); background-repeat:no-repeat; } #footer { background-image:url(images/background_footer.jpg); background-repeat:repeat-x; padding-top:20px; padding-left:40px; padding-right:40px; padding-bottom:0px; position:relative; top:-10px; } .container { width:950px; margin:0 auto; position:relative; } /* Header-Styles */ #header { padding-top:20px; padding-bottom:20px; } #logo h1, #logo small { margin:0px; display:block; text-indent:-9999px; } #logo { /*background-image:url(images/logo.png);*/ background-repeat:no-repeat; width:300px; height:100px; } ul#menu { margin:0px; padding:0px; position:absolute; right:233px; height: 23px; width: 335px; } ul#menu2 { margin:0px; padding:0px; position:absolute; right:233px; height: 23px; width: 500px; } ul#menu3 { background-image:url(images/logo.png); background-repeat:no-repeat; margin:0px; padding:0px; position:absolute; left:0px; height: 115px; width: 515px; top: 15px; } ul#menu li { display:inline; margin-left:12px; } ul#menu li a { text-decoration:none; color:#01398e; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:bold; text-transform:uppercase; } ul#menu li a.active, ul#menu li a:hover { color:#211e1e; text-decoration:underline; } /* 2nd menu */ ul#menu2 { margin:0px; padding:0px; position:absolute; right:-2px; height: 33px; width: 230px; top: 16px; text-align: right; } ul#menu2 li { display:inline; margin-left:12px; } ul#menu2 li a { text-decoration:none; color:#716d6a; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:bold; text-transform:uppercase; } ul#menu2 li a.active, ul#menu li a:hover { color:#211e1e; } /* Block-Styles */ .block { border:1px solid #01398e; background-color:#ffffff; margin-bottom:20px; position:relative; /* min-height: 460px; */ } .block_inside { display:block; border:1px solid #ffffff; background: #ffffff url(images/background_block_slice.jpg) repeat-x; padding:30px; overflow:auto; } .text_block { float:left; width:100%; margin-left:0px; padding-top:0px; } /* Block-Content-Styles */ #content_area { width:665px; float:left; } #content_area .block_inside { min-height:400px; } #content_area h2 { font-size:32px; line-height:31px; } #content_area .separator { border-top:1px solid #e3e3e3; margin-top:40px; padding-top:40px; } /* Text-Styles */ h1 { margin:10px 0px 5px 0px; font-size:14px; line-height:21px; font-family:Helvetica, Arial, Sans-serif; color:#7f7d78; text-align:center; } h2 { margin:0px 0px 10px 0px; font-size:24px; font-family:Helvetica, Arial, Sans-serif; color:#01398e; line-height:39px; letter-spacing:-1px; } h3 { margin:10px 0px 5px 0px; font-size:14px; line-height:21px; font-family:Helvetica, Arial, Sans-serif; color:#000000; } h4 { color:#007de2; margin:0px 0px 0px 0px; } small { color:#595856; font-weight:bold; font-size:11px; display:block; margin-bottom:15px; } a { color:#26689f; text-decoration:none; } small a { color:#007de2; } a:hover { text-decoration:underline; } p { margin: 0px 0px 15px 0px; } /* Footer-Styles */ #footer { font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; } #footer .long { width:100%; } #footer h3 { color:#e2dddc; text-transform:uppercase; font-size:10px; } /* Fix up IE6 PNG Support */ img, #logo { behavior: url(scripts/iepngfix.htc); } As you can see in the block section I have set the min height; .block { border:1px solid #01398e; background-color:#ffffff; margin-bottom:20px; position:relative; /* min-height: 460px; */ } Yes I know its commented out at the moment When I change the px value it updates accordingly, but if there is hardly any information on the page the block obviously doesnt fill the users browser. How would I go about changing it to a percentage correctly (100%). Ive already tried just changing it to 100% but nothing happens.

<?php // USER ENTERED VARIABLES $name_field = isset($_POST['name']) ? trim($_POST['name']) : ''; $email_field = isset($_POST['email']) ? trim($_POST['email']) : ''; $message = isset($_POST['message']) ? trim($_POST['message']) : ''; // USER ENTERED VALIDATION if (!preg_match("/^[a-zA-Z\-\s]{2,40}$/", $name_field)) $errorName_Field = true; if (!preg_match('/^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)+$/', $email_field)) $errorEmail = true; if (strlen($message) < 5 ) $errorMessage = true; if (strlen($message) > 250 ) $errorMessage1 = true; if (empty($_SESSION['6_letters_code'] ) || strcasecmp($_SESSION['6_letters_code'], $_POST['6_letters_code']) != 0) $errorCaptcha = true; // FORM FUNCTION function showForm($errorName_Field=false, $errorEmail=false, $errorMessage=false, $errorMessage1=false, $errorCaptcha=false){ if ($errorName_Field) $errorTextName_Field = "<font color=\"red\">Invalid Entry (A-Z only)</font>"; if ($errorEmail) $errorTextEmail = "<font color=\"red\">Invalid Entry</font>"; if ($errorMessage) $errorTextMessage = "<font color=\"red\">Message must be over 5 characters</font>"; if ($errorMessage1) $errorTextMessage1 = "<font color=\"red\">Message must be under 250 characters</font>"; if ($errorCaptcha) $errorTextCaptcha = "<font color=\"red\">Invalid Entry</font>"; echo '<FORM name="email" action="contact.php" method="post" >'; echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">'; //NAME echo '<tr> <td width="10%" align="left" valign="top">Name:</td> <td width="20%" align="left"><input type="text" name="name" size="38" /></td> <td width="70%" align="left">'; if ($errorName_Field) echo "$errorTextName_Field"; echo '</td>'; echo '</tr>'; //EMAIL echo '<tr> <td width="10%" align="left" valign="top">Email:</td> <td width="20%" align="left"><input type="text" name="email" size="38" /></td> <td width="70%" align="left">'; if ($errorEmail) echo "$errorTextEmail"; echo '</td>'; echo '</tr>'; //SUBJECT DROPDOWN echo '<tr> <td width="10%" align="left" valign="top">Subject:</td> <td width="20%" align="left"> <select size="1" name="drop_down"> <option>General Enquiries</option> <option>Sales Enquiries</option> <option>Press Enquiries</option> </select></td> <td width="70%" align="left"></td> </tr>'; //MESSAGE echo '<tr> <td width="10%" align="left" valign="top">Message:</td> <td width="20%"align="left"><textarea rows="5" name="message" cols="30"></textarea></td> <td width="70%" align="left">'; if ($errorMessage) echo "$errorTextMessage"; if ($errorMessage1) echo "$errorTextMessage1"; echo '</td>'; echo '</tr>'; //CAPTCHA echo '<tr>'; echo '<td width="10%" align="left" valign="top"></td>'; echo '<td width="20%" align="left"><img src="captcha_code_file.php?rand=' . rand() . '" id=\'captchaimg\' > <br />'; echo '<label for=\'message\'>Enter the code above here :</label><br />'; echo '<input id="6_letters_code" name="6_letters_code" type="text"><br />'; echo '<small>Can\'t read the image? click <a href=\'javascript: refreshCaptcha();\'>here</a> to refresh</small> </p></td>'; echo '<td width="70%" align="left">'; if ($errorCaptcha) echo "$errorTextCaptcha"; echo '</td>'; echo '</tr>'; // SUBMIT AND END OF FORM echo '<tr> <td width="10%" align="left" valign="top"></td> <td width="20%"align="left"><input type="submit" name="SubmitForm" value="Sumbit"></td> <td width="10%" align="left"></td> </tr>'; echo '<script language=\'JavaScript\' type=\'text/javascript\'> function refreshCaptcha() { var img = document.images[\'captchaimg\']; img.src = img.src.substring(0,img.src.lastIndexOf("?"))+"?rand="+Math.random()*1000; } </script>'; } if (!isset($_POST['SubmitForm'])) { showForm(); } else { session_start(); //Init error variables $errorName_Field = false; $errorEmail=false; $errorMessage=false; $errorMessage1=false; $errorCaptcha=false; $name_field = isset($_POST['name']) ? trim($_POST['name']) : ''; $email_field = isset($_POST['email']) ? trim($_POST['email']) : ''; $message = isset($_POST['message']) ? trim($_POST['message']) : ''; $dropdown = $_POST['drop_down']; if (!preg_match("/^[a-zA-Z\-\s]{2,40}$/", $name_field)) $errorName_Field = true; if (!preg_match('/^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)+$/', $email_field)) $errorEmail = true; if (strlen($message) < 5 ) $errorMessage = true; if (strlen($message) > 250 ) $errorMessage1 = true; if (empty($_SESSION['6_letters_code'] ) || strcasecmp($_SESSION['6_letters_code'], $_POST['6_letters_code']) != 0) $errorCaptcha = true; // Display the form again as there was an error if ($errorName_Field || $errorEmail || $errorMessage || $errorMessage1 || $errorCaptcha){ showForm($errorName_Field,$errorEmail,$errorMessage,$errorMessage1,$errorCaptcha); } else { //send the email to location based upon result of dropdown menu if($dropdown == "General Enquiries"){ $to = "ENTER EMAIL HERE"; $subject = "General Enquiry"; $body = "From:" . htmlspecialchars($name_field) . "\n E-Mail:" . htmlspecialchars($email_field) . "\n Message:" . htmlspecialchars($message); echo "Your email has been submitted,<strong> " . htmlspecialchars($name_field) . "</strong>. I aim to reply to all emails within 48 hours."; mail($to, $subject, $body); }elseif($dropdown == "Sales Enquiries"){ $to = "ENTER EMAIL HERE"; $subject = "Sales Enquiry"; $body = "From:" . htmlspecialchars($name_field) . "\n E-Mail:" . htmlspecialchars($email_field) . "\n Message:" . htmlspecialchars($message); echo "Your email has been submitted,<strong> " . htmlspecialchars($name_field) . "</strong>. I aim to reply to all emails within 48 hours."; mail($to, $subject, $body); }elseif($dropdown == "Press Enquiries"){ $to = "ENTER EMAIL HERE"; $subject = "Press Enquiry"; $body = "From:" . htmlspecialchars($name_field) . "\n E-Mail:" . htmlspecialchars($email_field) . "\n Message:" . htmlspecialchars($message); echo "Your email has been submitted,<strong> " . htmlspecialchars($name_field) . "</strong>. I aim to reply to all emails within 48 hours."; mail($to, $subject, $body); } } } ?> Right, I have this contact page that loops itself and displays the appropriate error messages. My problem isnt with the actual functionality of the contact form but with the footer. The footer is very simple and only includes <div id="footer"> <div class="container"> <div class="footer_column long"> <center>All rights reserved. I am not responsible for the content of external sites. <a href="contact.php">Terms and Conditions</a></center> </div> </div> </div> </body> </html> <?php mysql_close($connection); ?> When I include this footer it doesnt appear at the bottom of the page like it should, it does initially, but upon submission it appears half way up the screen.

thank you for the help F1Fan. Got it working now

I have the pagination function working fine. Its combining it with my previously displayed code that is the problem. Im not sure how to integrate it with the pagination code found in the tutorials section.