[[SOLVED] Last Row]

I have looked all over the internet, and all over the forums, and I cannot find what I am looking for.

 

I am trying to take the last row out of the DB, or the max id. How would one go about this?

 

-Thanks!

[[SOLVED] PHP Menu System]

wow thanks, I was looking for ideas, but that works

[[SOLVED] PHP Menu System]

lol, writing the if statement is a bit of annoyance, that is what I am saying. I want a automated system.

[[SOLVED] PHP Menu System]

so that sounds great, but I have to write a new if statement every time I make a page.

 

here is my current code:

<?php
if($page == "register"){
$reg = 'class="current"';
}
if($page == "home"){
$home = 'class="current"';
}
echo'
<div id="menu">
<ul id="si-menu">
<li><a href="index.php" title="Home" '.$home.'>Home</a></li>
<li><a href="login.php" title="Login" '.$log.'>Login</a></li>
<li><a href="register.php" title="Register" '.$reg.'>Register</a></li>
</ul>
</div>';
?>

 

is there a way around this?

[Encrypting Password]

so if he\she is right, then you don't have to decrypt.

 

hash the password with salt, then when the user goes to login, hash the entered password, with the same salt for validation, and you should be fine.

[[SOLVED] PHP Menu System]

I have a CSS menu and it when you are on the "Home" page, on the menu it is selected. Well I have a dynamic php website, and I want to know how I can tell if the user is on that page so I can use the select feature. I cannot wrap my head on something that could be so simple, I want it to be easily manipulated without touching the source code. How would one go about this?

[[SOLVED] Two Order Bys?]

I am trying to create a mysql query with two order bys, and I am lost.

 

I want to order by the sticks first, then by the ids, and I am getting every forum topic sticky'ed, and locked.

 

here is my code:

 

<?php
$sql = "SELECT * FROM mb ORDER BY id AND sticky DESC";
$result = mysql_query($sql);
?>

[A scrpit to announce ip address]

<?php
$ip = $_SERVER['REMOTE_ADDR'];  
echo $ip;
?>

 

you should post in the php help section for more..

[Wrong Place, but ....]

You Too!

[Where do you shop?]

I am looking for a new motherboard, but I have a type in mind but wherever I look I cannot find it.

 

its is the: ASUS M2N-SLI Deluxe AM2 DDR2

 

I have looked at: amazon, and newegg, tigerdirect, and frys.

 

So besides ebay, where do you shop?

[New - Prompt]

I am starting something new, and I decided AJAX is the best way  to go  with, but I have never ever worked with AJAX, and was hoping for some direction.

 

I want to make a prompt, like the DOS. I will enter in information, and the script will check the database for a response.

 

Example:

user types: hello

database response: hi

 

How would I go about doing this?

[Easter Egg Hunt]

LMAO!

[Egg Hunt]

love the feed back! I will post some changes soon!

[Easter Egg Hunt]

Meaning append it as a query string.

 

Yep!

[Egg Hunt]

crap, wrong board! Could this be moved to Web Crit.?

[Egg Hunt]

I am working on a new project, and I want to know if this design is decent. What should I change or add? Thanks!

 

http://lamezz.com/

[Easter Egg Hunt]

you are getting closer..

[not quite sure]

http://www.htmlgoodies.com/beyond/webmaster/article.php/3548746

[not quite sure]

look up php image upload script

[How to do auto update in database?]

I am not sure, but I think you need a cron job

[INNER JOIN causing odd problem, PHP Problem I think!]

well, so I need to make a id column in my foot_picks?

 

all I am trying to do is take the id from foot_bowls and order my other query using that id from foot_bowls.

 

Am I headed in the right direction?

[INNER JOIN causing odd problem, PHP Problem I think!]

The answer to the first two questions, are yes. I am not too sure what you mean by the last question. I have fixed my query, I am just not getting anything returned.

[INNER JOIN causing odd problem, PHP Problem I think!]

no it is called user, but nothing is being returned.

 

I used phpmyadmin, and I got this

 

 

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0015 sec)

 

Why!?

[INNER JOIN causing odd problem, PHP Problem I think!]

yes, $u = to the username!

 

Now I get this,

Unknown column 'foot_picks.user' in 'where clause'

but user is in the foot_picks table.

[INNER JOIN causing odd problem, PHP Problem I think!]

last bump.