PHP - 2 Pop Up Windows Only If 2nd Exists

Can someone explain why this code:
if (mysql_result($data,0,$SQLLargeName) = " "){
$LargeImage = "#";
}
else {
$LargeImage = mysql_result($data,0,$SQLLargeName);
}


Gives me this error?
Fatal error: Can't use function return value in write context in /home/worldw44/public_html/SQL.php on line 38


And ways round it?

Thanks.

Hi community,i creating a simple website and description
i analyzed my code about 3days...2hours a day.
if i get the point in my head.then its say Website url is in use..but not..ok maybe i give the code below.
so if you can explain whats wrong.thanks
Code: [Select]
<?php
include_once ('connect.php');
$url= mysql_real_escape_string($_POST['url']);
$desc=mysql_real_escape_string($_POST['desc']);
if ($id == "krauti")
{
    if (empty($_POST['url']) && empty($_POST['desc']))
    {
        die('<br><center>Both Empty!.<center/><br/>');

    }
    if (empty($_POST['url']))
    {
        die('<br><center>URL Empty!.<center/>');

    }
    if (empty($_POST['desc']))
    {
        die('<br><center>desc empty fill it!.<center/>');
    }
    
     
        
       
       $url = htmlspecialchars( stripslashes( strip_tags($_POST['url'] ) ) );
$aprasymas = htmlspecialchars( trim($_POST['desc'] ) );


$query = mysql_query("SELECT * FROM linkai WHERE url = '$url' AND 'desc' = '$desc'");
if( mysql_num_rows( $query ) == 1 ) {
    "INSERT INTO linkai ".
       "(id, url, desc) ".
       "VALUES('','$_POST[url]','$_POST[desc]')";
       echo "Yes!."; 

}
 
    else if (mysql_num_rows($query) == 0 ){
 
echo "No!!";
}

}  
?>

My error below returns (echos) that there is no data under the table sites to display. But, there is. Why is it doing this?

class_l.php

<?php

class displaySites 
{

function grabSites()

{

$query = mysql_query("SELECT title,description,votes,dates,comments,out,in FROM sites ORDER BY id DESC LIMIT 100");

if(mysql_num_rows($query) > 0)

{

while($fetch = mysql_fetch_assoc($query))

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><a href='#'>". $fetch['title'] ."</a></h2>

<h3 class='date'>Submitted on ". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['description'])) ."</p>

</div>

<p class='meta'><a href='#'>View</a></p>

<div class='hr'>

</div>

</div>

";

}

}

else

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><a href='#'>Oh NOEZ!</a></h2>

<h3 class='date'>". date("M-d-Y") ."</h3>

<div class='entry'>

<p>There are currently no sites to display!</p>

</div>

<p class='meta'>View</p>

<div class='hr'>

<hr />

</div>

</div>

";

}

}
}

class register
{

function createAccount()

{

$username = mysql_real_escape_string($_POST['username']);

$password = md5(sha1(sha1($_POST['password'])));

$name = mysql_real_escape_string($_POST['title']);

$description = mysql_real_escape_string($_POST['description']);

if(isset($username) && isset($password) && isset($name) && isset($description))

{

if(!$username || !$password || !$name || !$description)

{

echo '<table border="0"><form action="register.php" method="POST">

<tr><td>Username</td><td><input type="text" name="username" maxlength="20"></td></tr>

<tr><td>Password</td><td><input type="text" name="password" maxlength="30"></td></tr>

<tr><td>Site Name</td><td><input type="text" name="title" maxlength="25"></td></tr>

<tr><td>Site Description</td><td><textarea cols="40" rows="18" name="description" maxlength="750"></textarea></td></tr>

<tr><td>Finish!</td><td><input type="submit"></td></tr>

</form></table>';

}

else

{

$query = mysql_query("SELECT * FROM sites WHERE username = '$username' LIMIT 1");

if(mysql_num_rows($query) > 0)

{

echo "Sorry, an account with this username already exists.";

}

else

{

$date = date("M-d-Y");

$ip = $_SERVER['REMOTE_ADDR'];

//create their account

mysql_query("INSERT INTO sites VALUES (null, '$username', '$password', '$name', '$description', 0, 0, 0, '$date', '$ip', 0)");

echo "You have successfully registered your site on NovaTops! <a href='login.php'>Login</a>";

}

}

}

else

{

echo "One or more of the variables are not set.";

}

}
}

class login 
{

function verifyLogin()

{

$username = mysql_real_escape_string($_POST['username']);

$password = md5(sha1(sha1($_POST['password'])));

if(isset($username) && isset($password))

{

if(!$username || !$password)

{

echo "<table><form action='login.php' method='POST'>

<tr><td>Username</td><td><input type='text' name='username' maxlength='20'></td></tr>

<tr><td>Password</td><td><input type='password' name='password' maxlength='30'></td></tr>

<tr><td>Finished?</td><td><input type='submit'></td></tr>

</form></table>";

}

else

{

$query = mysql_query("SELECT * FROM sites WHERE username = '$username' AND password = '$password'LIMIT 1");

if(mysql_num_rows($query) > 0)

{

echo "Congratulations! You have successfully logged in! <a href='index.php'>Home</a>";

$_SESSION['user'] = $username;

}

else

{

echo "It seems you've typed in the wrong username and/or password. <a href='login.php'>Try Again</a>";

}

}

}

else

{

echo "One or more of the variables aren't set.";

}

}
}
?>


index.php


<?php
include_once('includes/config.php');
include_once('class_l.php');

?>

<!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>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title><?php echo $title; ?></title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper">
   <div class="top_text"><h1><a href="#"><?php echo $site_name; ?></a></h1>

    <h2><a href="#"><?php echo $slogan; ?></a></h2></div>

<div id="content">

<div id="blog">

<div id="post-1" class="post">

<h2 class="title"><a href="#">Welcome to NovaTops!</a></h2>

<h3 class="date">Created on April 06, 2011</h3>

<div class="entry">

<p>Hello there! If your viewing this message right now, your on the awesome site called NovaTops! NovaTops allows you to register

your site in our database, and then the site's script automatically starts to rank your site. The higher your rank, the more likely

your site's going to get a ton of views!</p>

</div>

<div class="hr">

<hr />

</div>

</div>

<!-- end #post-1 -->

<?php

$displaySites = new displaySites();

$displaySites->grabSites();

?>

</div>

<!-- end #blog -->

<?php include_once('includes/navigation.php'); ?>

<!-- end #sidebar -->

<div style="clear: both; height: 1px;"></div>

</div>

<!-- end #content -->

<div id="footer">

<p>Copyright &copy; 2011. Design by <a href="http://www.flashtemplatesdesign.com/" title="Free Flash Templates">Free Flash Templates</a></p>

<p><a href="#">Privacy Policy</a> | <a href="#">Terms of Use</a> | <a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="http://jigsaw.w3.org/css-validator/check/referer" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p>

</div>
</div>
<!-- end #wrapper -->
</body>
</html>

Hi,

I have a sign up form that generates a activation key and emails it to user and they cannot login until account has been activated etc.

My problem is i am not sure how to in php generate a new activation key if the generated one has already been used.

I know how to do the MySQL query to check if activation key already exists but not sure how to basically tell PHP that if the activation key already exists in DB then generate a new key until one is found that does not already exist.

I gather i may need a loop but not sure. Could someone please help ?

Like i say i know how to do the MySQL query just need some sample code to know how to do what i asked above.

Thanks for anyhelp; Much Appreciated

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=328831.0