Register

[deansatch]

Also, try removing this line:

 

if(isset($_POST['submitted'])) {

 

and the last line:

 

}// End of the main Submit conditional.

[stanleybb]

this bit of code is suppose to show list the users in the table users (on database) but that doesnt work either, there must be a link why it aint working

 

 

 

 

<?php

 

$page_title = 'View the current users';

include ('./includes/header.html');

 

echo '<h1 id="mainhead">Registered Users </h1>';

 

require_once ('../mysql_connect.php');

 

$query = "SELECT CONCAT(last_name, ',', first_name) AS name, DATE_FORMAT (registration_date, '%M %d, %Y') AS dr FROM users ORDER BY registration_date ASC";

$result = mysql_query ($query);

 

if($result) {

 

echo 'table align="center" cellspacing="0" cellpadding="5">

<tr><td align="left"><b>Name</b></td><td align+"left"><b>Date Registered</b></td></tr>

';

 

while($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

echo '<tr><td align="left">' .

$row['name'] . '</td><td align="left">' . $row['dr'] . '</td></tr> ';

}

 

echo'</table>';

 

mysql_free_result ($result);

 

} else {

echo '<p class="error"> The current users could not be retrieved.</p>';

echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>';

}

 

mysql_close();

include ('/includes/footer.html');

?>

[stanleybb]

it doesnt display errors, it works but doesnt save to database

[DarkerAngel]

try rewriting

mysql_query($query);

 

to

 

mysql_query($query) or die($query.'<br>'.mysql_error());

 

And see if an error is returned that way.

[revraz]

There is nothing in that code that actually writes anything to the DB.  Not sure what you were expecting?

[stanleybb]

i have tried that way, but it works nad no error is displayed

[stanleybb]

what is the register.php there is nothing what writes to the DB?

[revraz]

Check your PHP.INI and make sure error reporting is turned on.

 

Echo your querries and makes sure everything looks ok.

[stanleybb]

PHP.ini where is that?