Michael4172

[code]                        $select_team = "SELECT *";                         $from_team   = " FROM mc_base";                         $where_team = " WHERE mc_sponsor_id = '$myid'";                         $sname_team = mysql_query($select_team . $from_team . $where_team, $dbcnx);                                                $count = 0;                 while ($sname_view_list = mysql_fetch_array($sname_team)) {                 $count++;                 $member_fname = $sname_view_list["mc_fname"];                                         echo("<tr><td>$count</td>");                                         echo("<td>$member_fname</td></tr>");                                         echo("</table> } [/code]

You can get a function at the below link. I believe if you change the content type to whatever image format you have (.gif / .bmp) it would work [a href=\"http://uk.php.net/imagecopyresized\" target=\"_blank\"]PHP Manual - imagecopyresized[/a]

Post the code please.

[!--quoteo(post=388351:date=Jun 27 2006, 12:16 AM:name=Crayon Violent)--][div class=\'quotetop\']QUOTE(Crayon Violent @ Jun 27 2006, 12:16 AM) [snapback]388351[/snapback][/div][div class=\'quotemain\'][!--quotec--] the reason why ^ returns blank page is because you do this: $key_row = $row['keyword']; before your if statement. this makes it true, even if there is no value. you are creating the variable, so simply doing if ($key_row == true) ... well it exists, even if it is empty, so it's true. what is your query string? are you expecting more than 1 row returned? something like this should work if you are expecting more than 1 row returned. there are more efficient ways if only 1 row is expected to be returned [code] $found = FALSE; while($row = mysql_fetch_array($result)) {    //not sure how your data is stored, so this should cover your bases    if (($row['keyword'] != NULL) && (!empty($row['keyword'])) && (trim($row['keyword']) != "")){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";       $found = TRUE;     } } if ($found == FALSE) {    echo "not found"; } [/code] [/quote] I am just expecting one match per keyword, but the code you supplied works great :) Thanks for that.

[!--quoteo(post=388339:date=Jun 26 2006, 11:37 PM:name=phpstuck)--][div class=\'quotetop\']QUOTE(phpstuck @ Jun 26 2006, 11:37 PM) [snapback]388339[/snapback][/div][div class=\'quotemain\'][!--quotec--] Try this [code] while($row = mysql_fetch_array($result))         $key_row = $row['keyword'];   if ($key_row != ""){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";   } else {       echo "The keyword wasn't found";   } [/code] [/quote] This code works correctly if the keyword isn't in the DB...but displays the blank page if it does exist....kinda odd... [code] while($row = mysql_fetch_array($result))   {      $key_row = $row['keyword'];   if ($key_row > 0){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";}   else {       echo "The keyword wasn't found";}   } [/code] I tried this, It gives a "Keyword wasn't found" when I type in a keyword that's in the database. It returns a blank page when an incorrect keyword is entered. [code] while($row = mysql_fetch_array($result))   {      $key_row = $row['keyword'];   if (! $key_row){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";}   else {       echo "The keyword wasn't found";}   } [/code] This does same thing as #1 [code] while($row = mysql_fetch_array($result))   {      $key_row = $row['keyword'];   if ($key_row == true){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";}   else {       echo "The keyword wasn't found";}   } [/code] This returns the keyword when its found. But returns a blank page when the keyword isn't found. :( In addition I've also attempted = true and === true on this one as well. Also tried $key_row = 1... I also have tried this [code] while($row = mysql_fetch_array($result))   {      $key_row = $row['keyword'];   if ($key_row == true){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";}   else if ($key_row == false){       echo "The keyword wasn't found";}   } [/code] It returns the keywords if true, but returns a blank page if false :(

I'm doing a simple IF test statement below. I would expect it to return the $rows if $key_row equals anything other than a blank, and would expect it to return keyword wasn't found if its blank. However, when I use the code below it returns keywork and definition if true, but returns a blank page if they weren't found. Am I overlooking something below? [code] while($row = mysql_fetch_array($result))   {      $key_row = $row['keyword'];   if ($key_row != ""){       echo $row['keyword'];       echo "<br />";       echo $row['definition'];       echo "<br />";}   else {       echo "The keyword wasn't found";}   } [/code]

For others who may wanna try this, for it to work, I ended up doing the following: [code] <?php $user = "user"; $pass = "password"; $db = "joa"; $link = mysql_connect( "localhost", $user, $pass ); if ( ! $link )    die( "Couldn't connect to MySQL" ); mysql_select_db( $db, $link )   or die ( "Couldn't open $db: ".mysql_error() ); if (isset($_REQUEST['keyword'])) { // Do this if a keyword was set $result = mysql_query("SELECT * FROM joa WHERE keyword='$keyword'"); while($row = mysql_fetch_array($result))   {   echo $row['keyword'];   echo "<br />";   echo $row['definition'];   echo "<br />";   } } else { echo "Didn't work"; } ?> [/code] Thanks for all the help gentlemen :)

Actually I was echoing $result. :) Thanks for the help

Ok so far here is what I got: [code] <?php $user = "user"; $pass = "pass"; $db = "joa"; $link = mysql_connect( "localhost", $user, $pass ); if ( ! $link )    die( "Couldn't connect to MySQL" ); mysql_select_db( $db, $link )   or die ( "Couldn't open $db: ".mysql_error() ); if (isset($_REQUEST['keyword'])) { // Do this if a keyword was set $keyword = $_REQUEST['keyword']; //Sets $keyword equal to what its the URL $sql = "SELECT * from joa WHERE keyword='$keyword'";  // Selects all fields for the APPLE or whatever the keyword is $result = mysql_query($sql); // Now you are connected to the database, table and the correct row for the keyword } else { echo "Didn't work"; } ?> [/code] However, when I type in a keyword that is in the db... "Apple" as [a href=\"http://www.site.com/keyword.php?keyword=Apple\" target=\"_blank\"]http://www.site.com/keyword.php?keyword=Apple[/a] it just shows as a blank page.....Any ideas?

Thanks, I'm gonna play around with it some :)

The code I displayed is actually the code where I'm inputting the data to MYSQL so I guess that is not a good example. Lets say I create a page whose purpose is to SOLEY display the keyword.php?keyword=APPLE . How would I set it up so if you view keyword.php by itself its blank, but if you input keyword.php?keyword=APPL (assuming APPLE is int he db) it would display that ID, keyword, def ect...

[!--quoteo(post=388129:date=Jun 26 2006, 01:11 PM:name=DaveLinger)--][div class=\'quotetop\']QUOTE(DaveLinger @ Jun 26 2006, 01:11 PM) [snapback]388129[/snapback][/div][div class=\'quotemain\'][!--quotec--] But saying keywords.php?keyword doesnt tell the php code anything. You'd need keywords.php?keyword=thewordtolookfor [/quote] Ok well that is fine as well. Question is, how would I set that up?

Ok here is the code (I have thus far) for the db where I insert the information into the MySql itself: [code] <?php $keyword = $_REQUEST['keyword']; $definition = $_REQUEST['definition']; $user = "user"; $pass = "password"; $db = "joa"; $link = @mysql_connect( "localhost", $user, $pass ); if ( ! $link ){     die( "Couldn't connect to MySql: ".mysql_error() ); } print "<h2>Successfully connected to server</h2>\n\n"; @mysql_select_db( $db )     or die ( "Couldn't open $db: ".mysql_error() ); print "Successfully selected database \"$db\"<br />\n"; $query = "INSERT INTO joa( keyword, definition )     values ( '$keyword', '$definition' )"; print "running query: <br />\n$query<br />\n"; mysql_query( $query, $link )     or die ( "INSERT error: ".mysql_error() ); mysql_close( $link ); ?> [/code] WHat I'm doing is entering keywords and definitions. I have a bit of javascript where you can click on anyword in an article and a popup window comes up. I aim at filling the DB full of words, and if they click one that's not there, it'll take them to a form where they can submit a request for that word. What I"m trying to do is, in the javascript it looks for somthing like [a href=\"http://www.mysite.com/keywords.php?keyword\" target=\"_blank\"]http://www.mysite.com/keywords.php?keyword[/a]. Ideally I could get the ?keyword to show like that :)

[!--quoteo(post=387865:date=Jun 25 2006, 06:40 PM:name=adamwhiles)--][div class=\'quotetop\']QUOTE(adamwhiles @ Jun 25 2006, 06:40 PM) [snapback]387865[/snapback][/div][div class=\'quotemain\'][!--quotec--] the only time you would want to do that is if your passing a variable or value to a page like say, you want to view the 5th post in a database, you will do [a href=\"http://www.yourdomain.com/posts.php?post=5\" target=\"_blank\"]http://www.yourdomain.com/posts.php?post=5[/a] Then in your php code on posts.php you would have something like this: $_GET['post']; the value of $_GET['post'] would be 5 since you had the ?post=5 after posts.php [/quote] I'm actually trying to do the same thing. A couple questions though. Would the name 'post' be the database name or would it be a table in the database itself?

Are you wanting the user to be required to enter in a unique username and password in order to download the files on your site?

PHP Mail - [a href=\"http://us3.php.net/mail\" target=\"_blank\"]http://us3.php.net/mail[/a] Or a better option is if you the PEAR module for SMTP authentication.

golebara, A simple fix to this is to sign up for a hosted shopping cart. Once payment is processed through there, most have an option where a download link is sent to the user (you can set the link to expire XX mins/hrs after payment is received). To me this would be your easiest solution.

Testing Hmmm, I keep getting: Fatal error: Call to a member function on a non-object. on line 18. Line 18 appears to be: [code] $mail = $smtp->send($to, $headers, $body); [/code]

Thanks for the code. However, I'm trying to use the other one since it makes use of SMTP and I don't have that option with just using that code. Any ideas on the original code? :)

I'm attempting to use the following piece of code that I've downloaded from the web. However when I run the script it gives me a "Fatal error: Undefined class name 'mail' on line 15'. Any ideas? [code] <?php require_once "test.php"; $from = "<[email protected]>"; $to = "<[email protected]>"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?"; $host = "abc.abc.net"; $username = "[email protected]"; $password = "abc"; $headers = array ('From' => $from,'To' => $to,   'Subject' => $subject); $smtp = Mail::factory('smtp',array ('host' => $host,'auth' => true,'username' => $username,'password' => $password)); $mail = $smtp->send($to, $headers, $body); if (PEAR::isError($mail)) {   echo("<p>" . $mail->getMessage() . "</p>"); } else {   echo("<p>Message successfully sent!</p>"); } ?> [/code]

I found what I was looking for in $_SERVER['HTTP_REFERER']

[!--quoteo(post=384127:date=Jun 15 2006, 07:14 AM:name=Lorian)--][div class=\'quotetop\']QUOTE(Lorian @ Jun 15 2006, 07:14 AM) [snapback]384127[/snapback][/div][div class=\'quotemain\'][!--quotec--] Well if you don't know the previous page, then how to you expect to be able to go to that page and get the contents of the title tag...? [/quote] That was my question. I am not wanting to install this manually on every page (doing this manually for hudnreds of pages is not practical). Like I said this is a dynamic type application, which means that I won't know the page. However I am thinking if there is a referrer type variable that I may use.

[!--quoteo(post=384080:date=Jun 15 2006, 01:07 AM:name=phpvolution)--][div class=\'quotetop\']QUOTE(phpvolution @ Jun 15 2006, 01:07 AM) [snapback]384080[/snapback][/div][div class=\'quotemain\'][!--quotec--] Hey Mike, just pass the variable with the link: [code] <?php $page = file_get_contents("page.php"); preg_match('!<title>(.*?)</title>!is', $page, $match); $title = $match[1]; ?> <a href="emailpage.php?title=<?=$title?>">e-mail this article to a friend</a> [/code] that should do it [/quote] Thanks for the info :) However, that begs the question, what if I won't always know the previous page? How would I get that info? As my site is a CMS that has hundreds of possible pages.

[!--quoteo(post=381601:date=Jun 8 2006, 05:12 PM:name=poirot)--][div class=\'quotetop\']QUOTE(poirot @ Jun 8 2006, 05:12 PM) [snapback]381601[/snapback][/div][div class=\'quotemain\'][!--quotec--] str_replace should do, but you can also use htmlentities or htmlspecialchars with ENT_QUOTES: [code]$string = htmlentities($string, ENT_QUOTES);[/code] [a href=\"http://www.php.net/htmlentities\" target=\"_blank\"]http://www.php.net/htmlentities[/a] [a href=\"http://www.php.net/htmlspecialchars\" target=\"_blank\"]http://www.php.net/htmlspecialchars[/a] They will replace " ' " with & #039; Post #625, that is 25^2 or 5^4. I like this number [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] [/quote] Ok thanks I shall give that a try and play with it some :)

I tried this to no avail. [code] <?php $text = str_replace("'", "'", 'If you haven't been here long, you may want to leave.'); echo $text; ?> [/code] I regularly have things like <div id = "blah"> is the reason I rather use single quotes as oppose to the double on the end.