GoodGuy201

Hi,   I'm trying to use the database of another website to authenticate users in my website.  This way the users at the other websites won't have to register at my website, all I would need to do is verify their name and password using the other website's database.  Is this possible, and if so where do I begin to work on it.

Hi,   I am trying to limit the characters that can be used for PHPBB to just letters,numbers,underscore,and dash.  I don't know how i can do this.  I hope someone can help. Thanks!

Does anyone know if there is a way to retrieve the screen shots of videos from youtube using php? I can't find a pattern, but maybe someone can help me.

This is the code that i finally got after modifying it, but it is still not working.  Something is wrong with this statement [code] if(!((($s + $limit)/$limit)== $pages) && $pages != 1){ // It's all the way at the bottom, theres a comment. $news = $s + $limit; [/code] It's not evaluating to true, so the next link is not being displayed.  I am stuck and don't know where to go from here.  I have received a lot of help from ToonMariner and I appreciate it all.  I dont want to give up, but I've spent few hours just on this one if statement. If anyone can help I will be grateful. Thank you. [code] <?php require_once('./mysql_connect.php'); //connect to the db. $var = @$_GET['business_name']; $var2 = @$_GET['category']; $var3 = @$_GET['state']; //$limit=10; // Handle the form. /* Create an empty new variable. if (isset($var)) { $business_name = TRUE; } // Check for a category. if (isset($var2)) { $category = TRUE; } if (isset($var3)) { $state = TRUE; } if (!isset($var) && !isset($var2) && !isset($var3))   {   echo "<p>We dont seem to have a search parameter!</p>";   } */   $query = "SELECT * FROM Users WHERE "; // start of string $sub = NULL; //initialize substring if (isset($_GET['business_name']) && strlen($_GET['business_name']) > 0) { $sub = "Business_Name LIKE '%" . $_GET['business_name'] . "%'"; } if (isset($_GET['category']) && strlen($_GET['category']) > 0) { $sub .= is_null($sub) ? " Category = '" . $_GET['category'] . "'" : " AND Category = '" . $_GET['category'] . "'"; } if (isset($_GET['state']) && strlen($_GET['state']) > 0) { $sub .= is_null($sub) ? " State ='" . $_GET['state'] . "'" : " AND State ='" . $_GET['state'] . "'"; } $limit = 10; $s = empty($s) ? 0 : $s; $query .=  $sub . "ORDER BY Business_Name, City LIMIT $s, $limit"; // end of string $numresults = @mysql_query($query); $numrows=mysql_num_rows($numresults); $result = mysql_query($query) or die("Couldn't execute query"); echo "<p>You searched for:&quot;" .$var . ",&nbsp;". $var2 . ",&nbsp;". $var3 . "&quot;</p>"; echo "Results <br />"; $count = 1 + $s; while ($row=mysql_fetch_array($result)){ $title=$row["Business_Name"]; echo "$count &nbsp;$title <br />"; $count++; } $currPage = (($s/$limit)+1); echo "<br />"; if ($s >= 1){ $prevs = ($s-$limit); print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&business_name={$_GET['business_name']}&category=${$_GET['category']}&state={$_GET['state']}\">&lt;&lt; Prev 10 </a>&nbsp;&nbsp;"; } $pages=intval($numrows/$limit); if($numrows % $limit){ $pages++; } if(!((($s + $limit)/$limit)== $pages) && $pages != 1){ //Never Evaluates to true. <<<<------------ $news = $s + $limit; echo "&nbsp;<a href = \"$PHP_SELF?s=$news&business_name={$_GET['business_name']}&category={$_GET['category']}&state={$_GET['state']}\">Next 10 &gt;&gt;</a>"; } $a = $s + ($limit); if ($a > $numrows) { $a = $numrows; } $b = $s + 1; echo "<p>Showing results $b to $a of $numrows</p>"; ?> [/code]

Thanks for the tutorial, I did read all of it.  The other problem is I think is that when the script is executed the second time the values in the form are empty so the query is empty.  Is there a way to save those values so that the next time the scripts runs the parameters of the Query won't be empty?  Thanks again for your help ToonMariner.

Thank you so much for your help.  Right now, another problem came up which is that only 10 results get displayed no matter what.  I can change the limit on the number of results but I want there to be 10 per page.  For example if there are 16 results that match the search, then 10 of the records get displayed in the first page and 6 in the second page.  Thank you in advance for your help.  :)

Hi ,  This is my first time here and I really was thrilled to see there is help.  I need help with this , i have been stuck on it for the past 3 days.  I am trying to create a search engine which will display all the records that are like the name they enter or  in a given state if the user just selected a state, or all the records of the selected category if a user selected category, etc.  When I select State and Category the code works, but it doesn't work for Name, and it doesnt work when I try to do searches on individual selections. I keep modifying my code but I still cant get it to work properly.  Can someone please point me in the right direction.  I really would appreciate any help I can get. Thank you sooooooo much in advance. <!---Forum Code above--> -------------------------------------------- <?php require_once('./mysql_connect.php'); //connect to the db. $var = @$_GET['business_name']; $var2 = @$_GET['category']; $var3 = @$_GET['state']; $limit=10; // Handle the form. // Create an empty new variable. if (isset($var)) { $business_name = TRUE; } // Check for a category. if (isset($var2)) { $category = TRUE; } if (isset($var3)) { $state = TRUE; } if (!isset($var) && !isset($var2) && !isset($var3))   {   echo "<p>We dont seem to have a search parameter!</p>";   } if ($business_name && $category && $state) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND State =\"$var3\" AND Category =\"$var2\") ORDER BY Business_Name, City"; } elseif ($business_name && $category) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND Category =\"$var2\") ORDER BY Business_Name, City"; } elseif ($business_name && $state) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND State =\"$var3\") ORDER BY Business_Name, City"; } elseif ($category && $state) { $query = "SELECT * FROM Users WHERE (Category = \"$var2\" AND State =\"$var3\") ORDER BY Business_Name, City"; } elseif ($business_name) { $query = "SELECT * FROM Users WHERE Business_Name LIKE \"%$var%\" ORDER BY Business_Name, City"; } elseif ($category) { $query = "SELECT * FROM Users WHERE Category = \"$var2\" ORDER BY Business_Name, City"; } else//if ($state) { $query = "SELECT * FROM Users WHERE State = \"$var3\" ORDER BY Business_Name, City"; } $numresults = @mysql_query($query); $numrows=mysql_num_rows($numresults); if(empty($s)) { $s=0; } $query .= " LIMIT $s,$limit"; $result = mysql_query($query) or die("Couldn't execute query"); echo "<p>You searched for:&quot;" .$var . ",&nbsp;". $var2 . ",&nbsp;". $var3 . "&quot;</p>"; echo "Results <br />"; $count = 1 + $s; while ($row=mysql_fetch_array($result)){ $title=$row[4]; echo "$count &nbsp;$title <br />"; $count++; } $currPage = (($s/$limit)+1); echo "<br />"; if ($s >= 1){ $prevs = ($s-$limit); print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&business_name=$var\">&lt;&lt; Prev 10 </a>&nbsp;&nbsp;"; } $pages=intval($numrows/$limit); if($numrows % $limit){ $pages++; } if(!((($s + $limit)/$limit)== $pages) && $pages != 1){ $news = $s + $limit; echo "&nbsp;<a href = \"$PHP_SELF?s=$news&business_name=$var&category=$var2&state=$var3\">Next 10 &gt;&gt;</a>"; } $a = $s + ($limit); if ($a > $numrows) {$a = $numrows;} $b = $s + 1; echo "<p>Showing results $b to $a of $numrows</p>"; ?> </body> </html>