eskimo

Myspace only took on the "music orientated" angle after if got annihilated by facebook, it started as a normal social network. I'm not saying that a classifieds website doesn't need traffic to do well (go back and read my posts again), I'm saying that I am looking for a "twist" on classifieds that will make people want to use site to start with. The traffic will come if the site is good. I know what you saying about it being hard to make a classifieds site different, as the concept is pretty simple, but there is always room for improvement. One thing that makes gumtree so great is that users don't need to register to post ads, so it is quick to post an ad (people don't like forms). I'm trying to think of other things like that that will make it easier and quicker for users to post ads, as well as other features that will improve the overall user experience and make people want to use the site so eventually when the site grows people will choose it over another classifieds.

So why is facebook bigger than myspace now? 5 years ago myspace dominated, and now facebook is way bigger? If you think its impossible then stick to making websites for other people and don't bother making any of your own. Me on the the other hand, I'm going to actually try.

Thats a very negative attitude, assuming that there will never be a better classifieds site. I think the only reason everyone loves gumtree is because its so big, and gets so much traffic your ads get a large amount of replies. I don't think it has very much to do with the actual website itself as much. Think about in the States, they don't have or use gumtree (they do have kijiji which is the company that owns gumtree but is a very different site). They use Craigslist. Why hasn't gumtree taken off there if its so fantastic? Because Craigslist is bigger and busier, thats it. Nothing to do with the sites themselves What I am looking to do is create a classifieds site that has features and little things that will make people want to use it over a larger classifieds site. As in, a better, easier site to use. Obviously there is no way (now) that any site could compete with gumtree or craigslist in terms of traffic, but that doesn't mean you can't make a better website than theirs.

Yeah, gumtree does sometimes take up to 24 hours for the ad to go live. Also, do you prefer email authentication, user registration or just a captcha to post ads? I think I'm going with the email notification (no need to register)

I agree with the graphic thing. Gumtree looks a lot nicer than Craigslist still Also, do you prefer the new gumtree.com or the old style one (like on gumtree.co.za) I think another great thing about gumtree is the fact that users don't need to register to post an advert. That is one feature I want to make as easy as possible, posting ads. Obviously I still need to have measures to prevent spam ads, but I want to make it as quick and easy as possible to post. What else people? Tell me what you want to see in a classifieds!

What do you guys think makes a good classifieds site? I'm talking along the lines of gumtree and craigslist. What sets them apart? Why do you think they are so popular? What features do you like about them the most? What features would you like to see added? What is the worst thing about them? As I'm sure you have guessed, I am working on a classifieds site, and I'm looking for a little feedback from the community.

Thanks for the reply. The scrolling down thing is like that so when the site is monetized properly, the first thing users encounter on each page is the adverts. It is designed to increase Click Thru Rate. It's a pain, but it is the point of the site really evil With the models, the way the database is structured would make this quite a pain, but is definitely something I will look into Thanks again for the feedback!

If any of you have a minute or 2 to test my new site. Basically, the site works out the book value of you car. You don't need a car (I suppose) to test out the site, just and idea of how much second hand cars are worth. I would really appreciate some feedback The URL is: http://www.book-value.co.uk Thanks guys

please help me fix this so i dont have to shoot myself thanks basically i am writing a script to insert info from a text file into my database the listings in the text file look like this: Kia Picanto 1.0 5dr £6495 Fiat Panda 1.1 Active ECO 5dr £7095 etc... my database has 4 records: id (auto inc) make model price id does not get a value from the script, but auto increments make gets its value from the first word in the line of text (ie, Kia or Fiat etc...) model is the text up until (and not including) the £ price is supposed to be everything after the £ that is where the problem comes in the id, make and model are getting written to the database fine, but the price is not. i have tried making the price a varchar instead of an int but it makes no difference. it seems the else if loop is never actually running Here is the code: <?php include ('Connections/textcon.php'); $handle = @fopen("xyz.txt", "r"); // Open file form read. if ($handle) { while (!feof($handle)) // Loop til end of file. { $theData = fgets($handle, 4096); // Read a line if (strlen($theData) > 2) { if (strrpos($theData, "£") === false ) { $carmake = substr($theData, 0, strpos($theData, " ") ); // goes from character position 0 to the first occurance of a space $carmodel = substr($theData, strpos($theData, " " , strlen($theData) )); // goes from first occurance of a space to end $queryinsert = "INSERT INTO carsuk.cars (makeid, model) VALUES ('$carmake','$carmodel')"; $result= mysql_query($queryinsert) or die ("error in query: $query. " . mysql_error()); } else if (strrpos($theData, "£") === true) { $lengthy = strlen($theData); echo "hello"; $carprice = substr($theData, 1,$lengthy ); $getlastrowiinserted_queryn=sprintf("SELECT count(*) as rowid FROM carsuk.cars"); $getlastrowiinserted= mysql_query($getlastrowiinserted_queryn, carsuk.cars) or die(mysql_error()); while ($line=mysql_fetch_array($getlastrowiinserted)) { $rowid= $line['rowid']; } mysql_query("UPDATE carsuk.cars SET price= '$carprice' WHERE rowid = '$rowid' "); } } } } fclose($handle); ?>

thanks for the reply. i actually figured it out' i put in: if ($imgpath === $noimage) === is exactly equals.

howdy! i have put in the following at the end: $thumbpath = $tsrc; $imgpath = $add; $noimage = "upimg/"; $defimg = "upimg/no_image.gif"; if ($imgpath = $noimage) {$imgpath = $defimg; } if ($thumbpath = $noimage) {$thumbpath = $defimg; } And i echo $thumbpath and %imgpath before and after the if statement,but it is changing $imgpath and $thumbpath to $defimg whether i upload an image (and therefore change $imgpath and $thumbpath to upimg/uploadedimag.gif and thbimg/uploadedimage.gif) or not. any idea? is the syntax for the if statement correct?

Hello I am making a classifieds site. I have a form that the user fills in to post an advert, and one of the fields is an image upload. I have used a script that i found online to process the image upload, and create thumbnails for the images. I want to make it so if the user does not upload an image, a default "no image" picture is shown. Here is the script: $n_width=100; // Fix the width of the thumb nail images $tsrc="thimg/".$_FILES[userfile][name]; // Path where thumb nail image will be stored //////////// Starting of GIF thumb nail creation/////////// if (@$_FILES[userfile][type]=="image/gif") { $im=ImageCreateFromGIF($add); $width=ImageSx($im); // Original picture width is stored $height=ImageSy($im); // Original picture height is stored $ratio= $width / 100; $n_height= $height / $ratio; $newimage=imagecreatetruecolor($n_width,$n_height); imageCopyResized($newimage,$im,0,0,0,0,$n_width,$n_height,$width,$height); if (function_exists("imagegif")) { Header("Content-type: image/gif"); ImageGIF($newimage,$tsrc); } elseif (function_exists("imagejpeg")) { Header("Content-type: image/jpeg"); ImageJPEG($newimage,$tsrc); } chmod("$tsrc",0777); }////////// end of gif file thumb nail creation////////// ////////////// starting of JPG thumb nail creation////////// if($_FILES[userfile][type]=="image/jpeg"){ $im=ImageCreateFromJPEG($add); $width=ImageSx($im); // Original picture width is stored $height=ImageSy($im); // Original picture height is stored $ratio= $width / 100; $n_height= $height / $ratio; $newimage=imagecreatetruecolor($n_width,$n_height); imageCopyResized($newimage,$im,0,0,0,0,$n_width,$n_height,$width,$height); ImageJpeg($newimage,$tsrc); chmod("$tsrc",0777); I want to make it so if the user does not upload an image, the value which is strored in the database is the path upimg/no_image.gif & thbimg/no_img.gif I have tried by setting the default value in the database, but this obviously gets overwritten by the script, and makes the image path "upimg/" and "thbimg/" I need to put in some sort of "if" statement, but I just can't seem to get it right! please help!

Hello I am working on a form submit thingy for my new site (php). On the page wit the form, I generate a random 16 digit srting, which is then to be used to verify the users post. This works fine. Except... I want to declare the value of the random string as a hidden form variable ($activatecode), something like: <input type="hidden" name="random" value= "<?php $activatecode ?>"> I need to do this so when the form is processed on the next page, the value of @activatecode is stored in my database, to be used later to activate the users posting. It doesnt seem to be working? The $activatecode variable is being created by my random string function correcly, and everything else being passed as hidden, and non-hidden values by the form to the next page is working perfect What is the correct syntax for declaring a variable as a value in a hidden form field

Hey all I am working on a sort of classifieds script 3 Questions: Question 1 I need to make it so a user has to confirm their posting via email. What is the best/easiest way to do this? Basically i have a table with: ad id ad title ad content email address active "active" will have either a value of 0 or 1 (0 for not active, 1 for active) how can i make it so the user is send an email with a link to activate their ad? Question 2 How can i make it that the ads automatically expire after a certain amount of time? i imagine i need another record in the table (post date). how will i make it do this automatically? Question 3 Damn... forgot the 3rd question...

Hello I am working on a site (http://www.taotrophies.co.za/index.php)<---- make sure you put in the index.php as there is an index.html which redirects to the old site while this one is under construction. The site is working and looking good - except for good old farkin internet explorer 6 In IE6 the main navigation bar at the top is down a line (underneath the black bar going across) instead of on it (like it is supposed to be) To see what I mean, visit the site in firefox/chrome etc... and then visit it in IE Please help! here is the CSS /* body { margin: 0; padding: 0; background: #E3E7ED url(images/img01.gif) repeat-x left top; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #787878; } h1, h2, h3 { margin: 0; padding: 0; font-family: Georgia, "Times New Roman", Times, serif; font-weight: normal; color: #F93D00; } h1 { font-size: 2em; } h2 { font-size: 1.6em; } h3 { font-size: 1.6em; } p, ul, ol { margin-top: 0; line-height: 180%; } ul, ol { } a { text-decoration: none; border-bottom: none; color: #417FDA; } a:hover { } #wrapper { width: 968px; margin: 0 auto; padding: 0; } /* Header */ #header { width: 968px; height: 150px; margin: 0 auto; background: url(images/img02.gif) no-repeat left top; } /* Logo */ #logo { float: left; width: 968px; height: 60px; color: #616161; } #logo h1, #logo p { margin: 0; padding: 0; } #logo h1 { float: left; padding: 80px 0 0 80px; letter-spacing: -1px; text-transform: lowercase; font-size: 2.6em; } #logo p { float: left; margin: 0; padding: 90px 10px; font: normal 14px Georgia, "Times New Roman", Times, serif; font-style: italic; } #logo a { border: none; background: none; text-decoration: none; color: #616161; } /* Search */ #thumby { padding: 5px; text-align: center; margin: 4px; background: #FFF; border-width: 1px; border-color: #778899; } #search { float: right; width: 230px; padding: 0; } #search form { height: 41px; margin: 0; padding: 70px 0 0 0px; } #search fieldset { margin: 0; padding: 0; border: none; } #search-text { width: 210px; border: none; text-transform: lowercase; font: bold 1.2em Arial, Helvetica, sans-serif; color: #FFFFFF; } #search-submit { display: none; } /* Menu */ #menu { width: 968px; height: 50px; margin: 0 auto; padding: 0; } #menu ul { margin: 0; padding: 0; padding-left: 10px; list-style: none; line-height: normal; } #menu li { float: left; height: 50px; background: url(images/img03.gif) no-repeat right top; } #menu a { display: block; margin-top: 10px; margin-right: 3px; padding: 7px 20px 7px 20px; text-decoration: none; font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: #FFFFFF; border: none; } #menu a:hover, #menu .current_page_item a { } #menu a:hover { text-decoration: underline; } /* Page */ #page { width: 968px; margin: 0 auto; background: url(images/img05.jpg) repeat-y left top; } #page-bgtop { background: url(images/img04.jpg) no-repeat left top; } #page-bgbtm { background: url(images/img06.jpg) no-repeat left bottom; } /* Content */ #content { float: right; width: 700px; padding: 60px 20px 0 0; } .post { margin-bottom: 8px; background: url(images/img09.jpg) repeat-y left top; } .post-bgtop { background: url(images/img08.jpg) no-repeat left top; } .post-bgbtm { background: url(images/img10.jpg) no-repeat left bottom; } .post .title { padding-top: 15px; padding-left: 20px; color: #000000; } .post .title a { color: #000000; border: none; } .post .meta { border-bottom: 1px dashed #B5DEF4; padding-left: 20px; padding-bottom: 5px; text-align: left; font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-style: italic; } .post .entry { padding: 10px 20px 15px 20px; text-align: justify; } /* Sidebar */ #sidebar { float: left; width: 220px; padding: 60px 0 0 20px; color: #787878; } #sidebar ul { margin: 0; padding: 0; list-style: none; } #sidebar li { margin: 0; padding: 0; } #sidebar li ul { padding-bottom: 30px; } #sidebar li li { line-height: 35px; border-bottom: 1px dashed #D2D4C9; } #sidebar li li span { display: block; margin-top: -20px; padding: 0; font-size: 11px; font-style: italic; } #sidebar h2 { height: 32px; padding: 8px 0 0 30px; background: url(images/img11.gif) no-repeat left top; letter-spacing: -.5px; color: #FFFFFF; } #sidebar p { padding-bottom: 20px; text-align: justify; } #sidebar a { color: #417FDA; border: none; } #sidebar a:hover { text-decoration: underline; color: #787878; } /* Calendar */ #calendar { } #calendar_wrap { padding: 20px; } #calendar table { width: 100%; } #calendar tbody td { text-align: center; } #calendar #next { text-align: right; } /* Footer */ #footer { height: 50px; margin: 0 auto; padding: 0px 0 15px 0; font-family: Arial, Helvetica, sans-serif; color: #B2B2B2; } #footer p { margin: 0; line-height: normal; font-size: 9px; text-transform: uppercase; text-align: center; } #footer a { color: #3D444F; } please help!

I need to make some sort of a form where the users can fill in text as well as paste images, or any other HTML content. So, for example, in this text area that I am filling in right now, I could paste an image. Any idea of how to do this?

Yeah, so basically, there is a list/menu which dynamically displays the records from the DB. The user can select which one to edit. This menu is populated by a recordset aboutEDIT. It displays the names, and get its value from the userID, which is the primary key. There is then a form variable, editme, which i need to bind to the selection from the list/menu (this is the part im struggling with, how do i bind the form variable to the selection) There is a second recordset, chosen, which is filtered to display the record with the userID = to the form variable editme. This is then displayed in the update form, which is made using the update form wizard in DW Everything is working except for the editme variable being set. Shoul it be a form variable, or something else?

Thanks for the reply Here is the code: <?php require_once('../../../Connections/imageDB.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $updateSQL = sprintf("UPDATE about SET name=%s, text1=%s, text2=%s, text3=%s WHERE aboutNUM=%s", GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['text1'], "text"), GetSQLValueString($_POST['text2'], "text"), GetSQLValueString($_POST['text3'], "text"), GetSQLValueString($_POST['aboutNUM'], "int")); mysql_select_db($database_imageDB, $imageDB); $Result1 = mysql_query($updateSQL, $imageDB) or die(mysql_error()); $updateGoTo = "admin.php"; if (isset($_SERVER['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?"; $updateGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $updateGoTo)); } mysql_select_db($database_imageDB, $imageDB); $query_logindetails = "SELECT * FROM adminlogin"; $logindetails = mysql_query($query_logindetails, $imageDB) or die(mysql_error()); $row_logindetails = mysql_fetch_assoc($logindetails); $totalRows_logindetails = mysql_num_rows($logindetails); mysql_select_db($database_imageDB, $imageDB); $query_Recordset1 = "SELECT * FROM contact"; $Recordset1 = mysql_query($query_Recordset1, $imageDB) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); mysql_select_db($database_imageDB, $imageDB); $query_aboutEDIT = "SELECT * FROM about"; $aboutEDIT = mysql_query($query_aboutEDIT, $imageDB) or die(mysql_error()); $row_aboutEDIT = mysql_fetch_assoc($aboutEDIT); $totalRows_aboutEDIT = mysql_num_rows($aboutEDIT); $colname_chosen = "1"; if (isset($_POST['editme'])) { $colname_chosen = (get_magic_quotes_gpc()) ? $_POST['editme'] : addslashes($_POST['editme']); } mysql_select_db($database_imageDB, $imageDB); $query_chosen = sprintf("SELECT * FROM about WHERE aboutNUM = %s", $colname_chosen); $chosen = mysql_query($query_chosen, $imageDB) or die(mysql_error()); $row_chosen = mysql_fetch_assoc($chosen); $totalRows_chosen = mysql_num_rows($chosen); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Image Worx Wellness Institute - Admin Login</title> <meta http-equiv="Content-Language" content="English" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="../../../style.css" media="screen" /> <style type="text/css"> <!-- .style1 {color: #693A34} body,td,th { font-size: 0.74em; } a:link { color: #666666; text-decoration: none; } a:visited { color: #666666; text-decoration: none; } a:hover { color: #CCCCCC; text-decoration: none; } a:active { color: #666666; text-decoration: none; } .style3 {color: #FFFFFF} --> </style> </head> <body> <div id="wrap"> <div id="top"></div> <div id="content"> <div class="breadcrumbs style1"> <div align="center" class="style3"><a href="../../../index.php">Home</a> - <a href="../../../about.php">About</a> - <a href="../../../treatments.php">Treatments</a> - <a href="../../../contact.php">Contact</a> </div> </div> <div class="middle"> <h2 class="style3">Edit the About Page </h2> <p>Here you can edit the fields in the about page.</p> <p>Select the profile you would like to edit </p> <table width="360" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="15"> </td> </tr> </table> <form name="whoto" id="whoto" method="post" action=""> <p>Who's profile would you like to edit?</p> <p> <select name="who" id="who" title="<?php echo $_SESSION['aboutchange']; ?>"> <?php do { ?> <option value="<?php echo $row_aboutEDIT['aboutNUM']?>"><?php echo $row_aboutEDIT['name']?></option> <?php } while ($row_aboutEDIT = mysql_fetch_assoc($aboutEDIT)); $rows = mysql_num_rows($aboutEDIT); if($rows > 0) { mysql_data_seek($aboutEDIT, 0); $row_aboutEDIT = mysql_fetch_assoc($aboutEDIT); } ?> </select> <input name="me" type="submit" id="me" value="Submit" /> </p> <p> </p> </form> <p>you have selected: <?php echo $_POST['editme']; ?></p> <p><br /> </p> <form method="post" name="form1" action="<?php echo $editFormAction; ?>"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">AboutNUM:</td> <td><?php echo $row_chosen['aboutNUM']; ?></td> </tr> <tr valign="baseline"> <td nowrap align="right">Name:</td> <td><input type="text" name="name" value="<?php echo $row_chosen['name']; ?>" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Text1:</td> <td><input type="text" name="text1" value="<?php echo $row_chosen['text1']; ?>" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Text2:</td> <td><input type="text" name="text2" value="<?php echo $row_chosen['text2']; ?>" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Text3:</td> <td><input type="text" name="text3" value="<?php echo $row_chosen['text3']; ?>" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Update record"></td> </tr> </table> <input type="hidden" name="MM_update" value="form1"> <input type="hidden" name="aboutNUM" value="<?php echo $row_chosen['aboutNUM']; ?>"> </form> <p> </p> </div> <div class="right"> <h2 align="right"> </h2> <h2 align="right"> </h2> <h2 align="right"> </h2> </div> <div id="clear"> <p> </p> <p> </p> </div> </div> <div id="bottom"></div> </div> <div id="footer"> <p> copyright Image Worx Wellness Institue 2009<br /> Design by <a href="http://www.pennyfarthingdesign.co.za">Pennyfarthing Design Studio </a><br /> <a href="../../../adminlogin.php">admin login </a> </p> </div> </body> </html> <?php mysql_free_result($logindetails); mysql_free_result($Recordset1); mysql_free_result($aboutEDIT); mysql_free_result($chosen); ?>

Hello I'm using Dreamweaver MX 2004 I am making a backend update section for a site. Here is what I need to do: Let the user select which record to update from a drop down menu Update the record What I have done is: I made a drop down menu which is filled dynamically from the database I have made an update record form with the update record form wizard in Dreamweaver Now, I need the form to display (and then update) the record which the user selected from the drop down menu Right now, it just displays the first record from the recordset. So, I have made another recordset, which is equal to the form variable (which should be defined from the drop down list), and the update record form wizard is getting its data from the for second recordset. I think I'm binding the form variable wrong though or something, because i get the update form always still displays the first record in the database. How do I bind the form variable to the selection in the drop down menu, and do I have to go to another page to display the update form, or will it refresh to the recordset selected (by the form variable) automatically? Thanks!!

Please have a look at my site: http://www.pennyfarthingdesign.co.za and tell me what you guys think? Graphically I think it looks pretty sweet. It's made with CSS, and I actually started with a template and then edited it to my liking. The one thing I'm worried about is the SEO. Any feedback and I would be stoked!