Renlok

the idewa behind it was to be an inforamtion directory, at the moment ive only set up the site directory so thats what your looking at urm i think ive made it more obvious of what is is now. but i dunno.

well ive some more fixes, its better than the old one i know that much but its not great and looking for feedback, be as truthful as possible.

well ive made a new layout not sure ifs any good, but its alot better than the last. [url=http://www.we-link.co.uk]http://www.we-link.co.uk[/url]

lol its good to be negative ive never made a site before so i dont know anything about it tbh this is like seeing what a site needs tpye thing just testing with things and what not. and i know its pritty poorly made but as i said its my first ever atempt. also when i have the time i will remove the google ads as i must agree they look crap, ill sort the footer out changes colours also stick the navigation on the right side of the main box....might look better also youll know where it is. yeah i know the catagories part isnt finnished yet i need to get round to doing that, was going to make a expandable table of contants but dont know if it would look any good.

thanks well ill work on making a decent layout with everything youve mentioned plus is there any features i sould include?

[url=http://welink.ej.am]http://welink.ej.am[/url] what in your opinoin would i need to add to this site to make you come back? other than a layout i already know thats bad. could be anything thanks in advance

urm how do you propose it would be possible offline? as it would be impossible to connect to your database in the first place.

well i didnt download your file i cba but yeah i can be dont with anything but youll have to use some sort of database and quite a bit of php coding.

use a text file to store the count and have the counter on the page/code the button takes you to.

i use dreamweaver mx or Nuspere PhpED or the old classic...notepad ^^

ok im making catagories to catagorize the links in my directory, im in need of help for thinking up ideas for more catagoreis could you please help me out. what ive got so far is on [url=http://welink.ej.am/categories.php]http://welink.ej.am/categories.php[/url] Thanks for any help

thanks for feedback and what does [quote]the page has no DOCTYPE and does not validate. for such a basic site to validate is not great, TBH [/quote]mean? im noob ^o^

[url=http://welink.ej.am]http://welink.ej.am[/url] its a free direcory site still working on a few bits and peices but mostly done.

i found the reason for it not working is that it cant see if your logged in or not

i tryed with once its the most poorly coded rubbish ive ever seen lol well good luck with using it ive no idea have to help you sorry

i own a site and a SMF forum im trying to make it possible for members from my SMF board to be able to login to my site with the same details ive read http://docs.simplemachines.org/index.php?topic=789.0 and tryed it all but it does seem to work can anyone give me any other ideas

anyhelp?

oh ok thanks its working now

For a rating system i made this wassuposed to stop people voting on the same thing twice but it dusnt work. When you send a rating it enters you ip address correctly but it doesnt stop you from sending it as meny times as you want. [code]  $query1 = "select * from rating where ip is $ip and url is $url";   $result1 = $db->query($query1);   $num_results = $result1->num_rows;   if ($num_results > 0)   {       echo 'You have already voted for '.$url;   }   else   {   $query = "insert into rating (ratingValue, URL, ip) values             ('".$rate."', '".$url."', '".$ip."')";   $result = $db->query($query) or die ($db->error);   if ($result)       echo  $db->affected_rows.' You have rated '.$url.'as a '.$rate;       echo '<br>your ip address has been logged as '.$ip.'<br>Thankyou for using our site';   }   $db->close();[/code]

i have havnt i? [code]'%".$searchterm."%'[/code]

i have a search bar which searches my database but at the moment it will only return matches with the exact results how can i have it so say you search for php freaks it will show results with php and freaks anywere instead of php freaks being two words next to each other. Current code: [code]$searchterm=$_POST['searchterm']; $searchtype=$_POST['searchtype']; $searchterm= trim($searchterm); $searchtype= trim($searchtype); if (!$searchterm) { echo 'You have not entered search details. Please go back and try again.'; exit; } if (!get_magic_quotes_gpc()) { $searchtype = addslashes($searchtype); $searchterm = addslashes($searchterm); } $date = date('Y-m-d');   $query2 = "insert into search(searchterm, dateadded) values ('".$searchterm."', '".$date."')";   $result2 = $db->query($query2) or die ($db->error); $query = "select * from link where ".$searchtype." like '%".$searchterm."%'"; $result = $db->query($query);[/code] Ignore $query2 thats just there to add the search information into the database

??? anyone have anything?

Ok there it is [code]          <tr>             <td nowrap class="datacelltwo">                 <?php                     echo stripcslashes($row['siteName']);                 ?>             </td>             <td class="datacellone">                     <?php                                            $name = $row['siteName'];                     echo "<a href=page.php?page=$name>$name</a>";                     ?>             </td>[/code]

Thanks for that i added it to my page Page Title (shows at top of page: [code] <?php $page = $_GET['page']; $query = "SELECT * FROM link WHERE siteName = '$page'"; echo $page; ?>[/code] Main code: [code]   <?php   $result = $db->query($query); $row = $result->fetch_assoc(); echo '<font size=6><b><u>'.stripslashes($row['siteName']).'</b></u></font>'; echo '<p>'; echo 'Added to Our Database at:<br>'; echo stripslashes($row['timeEdited']).'<p>'; echo '<a href="'.stripslashes($row['url']).'">'.stripslashes($row['url']).'</a>'; echo '<p>'; echo '<u>Sites Description:</u>'; echo stripslashes($row['discription']).'<br>'; echo '<u>Keywords Entered For Site:</u>'; echo stripslashes($row['keywords']).'<br>'; echo 'Current Rating: '; $URL = ($row['url']);         $rate_query = "SELECT AVG(ratingValue) FROM rating WHERE URL = '$URL'";         $rate_result = $db->query($rate_query);         $row = $rate_result->fetch_row();         $avg = $row[0];         echo $avg; echo 'Rate Site:<br>';         echo '<form name="'.$URL.'" form action="rate.php" method="post" target="_blank" form>'.         '<select name="rate">'.             '<option value="1">1</option>'.             '<option value="2">2</option>'.             '<option value="3">3</option>'.             '<option value="4">4</option>'.           '<option value="5">5</option>'.               '<option value="6">6</option>'.               '<option value="7">7</option>'.               '<option value="8">8</option>'.               '<option value="9">9</option>'.                 '<option value="10">10</option>'.         '</select>'.         '<input name="url" type="hidden" value="'.$URL.'" size="13" maxlength="125">'.       '<input type="submit" value="Submit">'.     '</form>';   mysqli_free_result($result);       $db->close();   ?>[/code] I have that but it just shows a blank page with the html code on it not sure why.

ok i changed the code to work with my page [code]<?php                                                                                          # line 115                 $sql = mysqli_query("SELECT COUNT('ID') as Number, searchterm                      FROM search                         GROUP BY searchterm                         ORDER BY number");                     echo "<table>\n";                                                          # line 120                 if (mysqli_num_rows($sql) > 0) {                     echo "<tr>\n";                     echo "<td>Rank</td>\n";                     echo "<td>Search Term</td>\n";                     echo "<td>Entries</td>\n";                                                  # line 125                     echo "</tr>\n";                 $count = 0;                 while ($x = mysqli_fetch_array($sql)) {                     $count++;                     echo "<tr>\n";                     echo "<td>$count</td>\n";                     echo "<td>$x[Searchterm]</td>\n";                     echo "<td>$x[Number]</td>\n";                     echo "</tr>\n";                 }             } else {                 echo "<tr><td>No records returned</td></tr>\n";             }             echo "</table>\n";             ?>                                                                                  # line 140 </center>     <?php     mysqli_free_result($result);     $db->close();     ?>                                                                                          # line 145[/code] comes out with the errors [quote]Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/renlok/public_html/topsearch.php on line 119 Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/renlok/public_html/topsearch.php on line 121 No records returned Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, null given in /home/renlok/public_html/topsearch.php on line 143[/quote]