Maq

First, let PHP create the table for you in the while loop after you extract your data. Something like? SELECT * FROM question ORDER BY [date or id] DESC LIMIT 10 Not sure exactly what you mean. Maybe Pagination?

There's no need for all those switch statements. Use something like this: </pre> <form method="POST" action="<?php%20echo%20%24_SERVER%5B'PHP_SELF'%5D;%20?>"> 2009 2008 2007 2006 All Years Last Name Test Date </form> <br><br>if(isset($_POST['submit'])) <br>{<br> // declare vars & describe method of populating vars<br> $datex = $_POST['datex']; //range of dates<br> $sortx = $_POST['sortx']; //sort by <br> $query = "SELECT * FROM passed";<br> $query .= ($datex=='0') ? "" : " WHERE year(testdate) = $datex"; <br> $query .= (isset($sortx)) ? " ORDER BY $sortx" : "";<br> echo $query;<br>}<br

You have to concatenate it to the string by breaking out of the string. echo "Language2"; I believe you can just use curly braces to escape the single quotes in the array as well: echo "Language2";

I think you're looking for: ?lang=2'>Language1

Huh?

Huh? Don't you mean: "There are some things you can figure out, for everything else, there's Google". Yes, I certainly did, Ken. I copied the original quote which uses, "can't" and forgot to change it.

"There are some things you can't figure out, for everything else, there's Google". Nice! I never seen that before Great slogan. You were the inspiration

"There are some things you can't figure out, for everything else, there's Google".

Who's judging? We're just trying to help and for some reason you're taking it the wrong way. All they said was if you call a MySQL DELETE, it will delete, NEVER insert, update, select etc... which is 100% true. Anyway, glad to see it's finally resolved.

Sure, in fact it's better to have some kind of server-side validation due to the fact that users can disable JS. You can use something like: $d = "u12324"; if(preg_match("/^[a-z]\d{4}$/i", $d)) { echo "success"; } else { echo "fail"; } ?>

Try: if ($result) {

Please use Google first: Multiple SELECT.

Apparently Google doesn't like everybody...

Post what you have tried.

I always use FF and it never really lags for me. Although, this morning phpfreaks was just hanging for about an hour, hour and a half. EDIT: I'm using Ubuntu as well.

Let MySQL handle that for you. You can order the ids by descending and limit them by 30. Something like: $sql = "SELECT id, date, title FROM Newsposting ORDER BY id DESC LIMIT 30"; $queryresult = mysqli_query($db, $sql); while($rowresult = mysqli_fetch_array($queryresult, MYSQLI_ASSOC)) { $id = $rowresult['id']; echo ''.$rowresult['date'].' '.$rowresult['title'].''; echo " "; }

Guess we won't know until he elaborates on his application first.

Try this, should be pretty self explanatory, but if you have questions please ask: </pre> <form method="GET" action="file.php?action=1234"> </form> <br><br><br>if($_GET['$action'] == 1234)<br>{<br> print"hi";<br>}<br

You would have to change the CSS to align left, or change the margin-left to negative spacing.

What's the error...?

Yeah sorry... Ken posted the correct code.

Like Ken mentioned earlier, empty refers to all of these conditions, so you only need to check for empty. You should trim first as well. if (empty(trim($unit))) { Here's the scenarios when empty returns true:

Not sure what exactly you mean by: push data from a form into a .xls of sql file. Do you mean and excel sheet that was populated with database records? There are libraries to handle excel sheets.

Great, you mind sharing the final solution for others with the same problem. You should also mark this solved.

You mind posting the final solution, so others can easily refer to it?