trq

The rest of your code is using some database abstraction layer, and maybe the mysqli extension. What exactly is within your connection.php file?

Where are these image tags coming from?

Your going to need to post all your relevant code. Also, make sure you have error_reporting set to E_ALL and display errors switched on.

Your <select></select> tags are outside of the <form> tags so will never be sent with it. Also, your creating more than one form there by having it within the while() loop.

Hehe... Theres a type in my code. Try this.. if ($select_maxid = mysql_query("SELECT MAX(id) AS max_id FROM pages")) { $row = mysql_fetch_assoc($select_maxid) { echo $row['max_id']; } else { echo mysql_error(); }

Use the code I posted above and post the exact output.

date takes a timestamp, not a formatted date. You'll want to run your dates through strtotime to get a timestamp then into date.

These little snippets of code don't help, we need to see some context.

What format do the dates appear to be in? Example?

Where is $dr defined? More relevant code would be helpful.

Obviously the connection isn't being made. PS: That code is floored.

You seriously need to learn some html. Can we see some relevant code?

You need a http server and your much better off installing one locally. Google for Xampp to get up and running easily.

Your much better off doing this within your query... DATE_FORMAT.

if ($select_maxid = mysql_query("SELECT MAX(id) AS max_id FROM pages")) { $row = mysql_fetch_assoc($select_maxid) { else $row['max_id']; } else { echo mysql_error(); }

This might help you.

$PassSQL = "UPDATE admin SET Password='123415' WHERE Username = 'Admin'";

<li><img src="a.jpg"></li><li><img src="b.jpg"></li><li><img src="c.jpg"></li>

You are kidding right?

Yes its all possible, but you'd need to learn a programming language first.

Have you tried checking your query actually succeeds before using any result it produces? Any debugging at all? What does mysql_error() have to say?

Post your current code.

Providing you have userid stored within the $_SESSION array something like this will do the trick. <?php session_start(); $sql = "SELECT points FROM users WHERE userid = {$_SESSION['userid']} LIMIT 1"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); echo "You have {$row['points']} points"; } }

Id do a Google search for 'web screenshot api' or similar. Ive seen these around, buts its going to cost you.

You need always check your query succeeded and returns some records before you try and use it. You can also catch any errors and debug them a little better. <?php $sql = "SELECT AND SHOW COLUMNS FROM `members` WHERE field='Lens' AND username LIKE '$username'"; if ($result = mysql_query($sql))) { if (mysql_num_rows($result)) { while ($row = mysql_fetch_row($result)) { echo '<select name="lens" style="margin-left:10px; width: 200px; font-size:11px"/>'; echo "<option value=\"0\">Please Select...</option>"; foreach (explode("','",substr($row[1],6,-2)) as $v) { print "<option value=\"".$v."\""; if (isset($_POST['Lens']) && $_POST['Lens']==$v) { print ' selected'; print ">$v</option>"; } } echo '</select>'; } } else { // no results found. } } else { trigger_error(mysql_error() . "<br />" . $sql); } ?> If your expecting more than one result your html is going to be foobar'd. If your not expecting more than one result, you don't need the while loop and should probably put a LIMIT clause in your query.