Latest Member to Join...

Odublar

trying to figure out how to add a way to display the latest member to join...

Now, I took the 10 latest new inputs file, which looks like this...

<?
require_once("conn.php");

//		NEWEST


$q1 = "select * from dd_items where ItemStatus = 'approved' order by DateAdded desc limit 0,9";
$r1 = mysql_query($q1) or die(mysql_error());
while($a1 = mysql_fetch_array($r1))
{
	$Newest .= "<a class=TitleLinks href=\"view.php?ItemID=$a1[ItemID]\">$a1[ItemTitle]</a><br>\n";
}


//get the templates
require_once("templates/MainHeader.php");
require_once("templates/MainNew.php");
require_once("templates/MainFooter.php");

?>

so I figured I'd do this, but I'm getting an error...but I did figure out, by changing the number from 9 to 1, made it display only one....so I'm good so far with that....but when I change the other things, to username and users it shows an error....

<?
require_once("conn.php");

//		NEWEST




$q1 = "select * from dd_users where username order by DateAdded desc limit 0,1";
$r1 = mysql_query($q1) or die(mysql_error());
while($a1 = mysql_fetch_array($r1))
{
	$Newest .= "<a class=TitleLinks href=\"view.php?ItemID=$a1[ItemID]\">$a1[ItemTitle]</a><br>\n";
}


//get the templates
require_once("templates/MainHeader.php");
require_once("templates/MainNew.php");
require_once("templates/MainFooter.php");

?>

any idea what I'm doing wrong?

this is what the table dd_users looks like....

data....

userID username password email

am I right to assume the UserID should replace where username is?

devinemke

you don't need the while loop if you are only expecting 1 row returned

$result = mysql_query('SELECT * FROM dd_users ORDER BY DateAdded DESC LIMIT 1') or exit(mysql_error());
$row = mysql_fetch_array($result);
echo '<a class="TitleLinks" href="view.php?ItemID=' . $row['ItemID'] . '">' . $row['ItemTitle'] . '</a><br>';

Odublar

ok, so I'm new to PHP, as you can probably tell. This echo thing, it basically works like above, but where do I input this?

Do I use the <?PHP <---insert is here---> ?> and insert it into said page....if so, then I will have a database connection problem right? I'm learning as I go, and I've been able to implement it kinda, but recieveing a database error. So I decided to start over, and see what your personnel opinion was on the subject.

Odublar

Can anyone explain this further for me...how do I insert it into the page, do I make it into it's own php file and call it from the page I want it in?

Thanks in Advance for any ideas and help.

dalecosp

PHP and HTML can be interwoven, thus:

<?php

   $pagename="My Page";
?>
<html>
   <head>
      <title><?php echo $pagename; ?></title>
   </head>
   <body>

.... or, PHP can use [man]print[/man] or [man]echo[/man] to output HTML, thus:

<?php

$pagename="My Other Page";

echo "
<html>
   <head>
      <title>$pagename</title>
   </head>
   <body>

";

So, the answer is, put the code where it needs to go to do what you want it to do; in this case, that would seem to be either divided (php at any time prior to the echo statement, and then the echo statement in the correct spot for HTML output), or else do it all in the proper place for HTML output <div>, whatever....

Best to ask about db connection problems in a seperate post. Include the text of the error message, the problem code area, and the steps you've taken thus far....

Odublar

ok, here's the thing, I had to create a DateAdded into the dd_users table exactly like the one for posting something new, which would assign a date to each item...

the post.php file looks like this.....

<php><?
require_once("conn.php");
require_once("access.php");

if(isset($POST[s10]))
{
$MyTitle = strip_tags($POST[title1]);

$cats = explode("|", $_POST[cat1]);
$MyCategory = $cats[0];
$MySubcategory = $cats[1];

$MyText = strip_tags($_POST[text1]);
$t = time();

$q1 = "insert into dd_items set 
				ItemTitle = '$MyTitle',
				ItemCategory = '$MyCategory',
				ItemSubcategory = '$MySubcategory',
				ItemText = '$MyIn|$MyText',
				Contributor = '$_SESSION[username]',
				DateAdded = '$t' ";

mysql_query($q1) or die(mysql_error());

header("location:YourItems.php");
exit();

}

//create the categories dropdown

$SelectCategory = "<select name=cat1>\n\t<option value=\"\"></option>\n";

$q1 = "select * from dd_categories order by CategoryName";
$r1 = mysql_query($q1) or die(mysql_error());
while($a1 = mysql_fetch_array($r1))
{
$SelectCategory .= "<option value=\"$a1[CategoryID]|0\">$a1[CategoryName]</option>\n";

//get the subcategories
$q2 = "select * from dd_subcategories where CategoryID = '$a1[CategoryID]' order by SubcategoryName ";
$r2 = mysql_query($q2) or die(mysql_error());

if(mysql_num_rows($r2) > '0')
{
	while($a2 = mysql_fetch_array($r2))
	{
		$SelectCategory .= "<option value=\"$a1[CategoryID]|$a2[SubcategoryID]\">$a1[CategoryName] - $a2[SubcategoryName]</option>\n";
	}
}

}

$SelectCategory .= "</select>";

//get the templates
require_once("templates/MainHeader.php");
require_once("templates/MainPost.php");
require_once("templates/MainFooter.php");

?></php>

So I dedided, in order to get an actual number, make sure when they register, they get a date....so I applied this code to the register.php

<php><?
require_once("conn.php");

if(isset($_POST[s1]))
{

     $t = time();

$qm = "insert into dd_newsletter set nemail = '$_POST[e1]' ";
mysql_query($qm);

$q1 = "insert into dd_users set 
				username = '$_POST[u1]',
				password = '$_POST[p1]',
				email = '$_POST[e1]' ";
                                    DateAdded = '$t' ";

mysql_query($q1);

if(mysql_error())
{
	$error = "<center>The username <b>$_POST[u1]</b> is already in use.<br>Please, select another one.</center>";
}
else
{
	$to = $_POST[e1];
	$subject = "Your $_SERVER[HTTP_HOST] registration";
	$message = "Hello,\nthis is your login information for $_SERVER[HTTP_HOST]\n\nUsername: $_POST[u1]\nPassword: $_POST[p1]\n\nHave some fun with http://$_SERVER[HTTP_HOST]";
	$from = "From: $_SERVER[HTTP_HOST] <$aset[ContactEmail]>";

	mail($to, $subject, $message, $from);

	$_SESSION[username] = $_POST[u1];

	header("location:post.php");
	exit();
}

}

//get the templates
require_once("templates/MainHeader.php");
require_once("templates/MainRegister.php");
require_once("templates/MainFooter.php");

?></php>

the two things I've added : $t = time();

'
DateAdded = '$t' ";

of course, whenever I click register, the page doesn't show up....I believe I'm doing it right....but something is wrong. I have to figure out how to allow the guest to register and it add the date to the database before I can move on and use the other script. Any ideas?

Odublar

bump....

Odublar

Update, I figured it out, their was an " where it should have been changed to ' and then the next line, needed to have the "

This is starting to become better with each code chase. =D