Hi There,
I am trying to get the information that i have put in the database to be displayed on the screen but i am getting this error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\capat\result.php on line 44
The error doesn't seem to go away AT ALLL
this is my code
questions.php
<?php
/**
*
* Install setup page to allow the inital user to be set up
*
*/
require_once("include/inc_global.php");
//build the page
$UI->page_title = 'Web-PA Admin Setup';
$UI->menu_selected = '';
$UI->breadcrumbs = array ('Admin setup' => null ,);
$UI->head();
$UI->body();
$UI->content_start();
// see if any of the settings have been sent
$question1 = (string) fetch_POST('question1', null);
$question2 = (string) fetch_POST('question2', null);
$question3 = (string) fetch_POST('question3', null);
$question4 = (string) fetch_POST('question4', null);
$question5 = (string) fetch_POST('question5', null);
$username = (string) fetch_POST('username', null);
$password = (string) fetch_POST('password', null);
//if we have at least the username and the password then we can say that we are processing
if ($username and $password){
// Sanitize the username/password data
$username = substr($username,0,32);
$password = substr($password,0,32);
//hash the password
//$password = md5($password);
//add this information to the database
$sql = 'INSERT INTO questions(question1, question2, question3, question4, question5, username, password)
VALUES ("'.$question1.'", "'.$question2.'", "'.$question3.'", "'.$question4.'", "'.$question5.'", "'.$username.'", "'.$password.'");';
$DB->_process_query($sql);
?>
<div class="content_box">
<p> Your details have been set up on the server and a new Administrator account has been created.</p>
<p> To ensure that no other administrator accounts can be created we recomend that you remove this file from the server</p>
</div>
<?php
}else{
?>
<div class="content_box">
<p>You can enter your details as required below.</p>
<p>If you are intending to use the Database Authentication then you will need to enter a passsword. If you are using the LDAP
Authentication then you still need to enter all the information, but the password is not required. </p>
<form action="result.php" method="post" name="login_form" style="margin-bottom: 2em;">
<div style="width: 300px;">
<table class="form" cellpadding="2" cellspacing="1" width="100%">
<tr>
<th><label for="question1">Question 1</label></th>
<td><input type="text" name="question1" id="question1" maxlength="30" size="30" value=""/></td>
</tr>
<tr>
<th><label for="question2">Question 2</label></th>
<td><input type="text" name="question2" id="question2" maxlength="30" size="30" value="" /></td>
</tr>
<tr>
<th><label for="question3">Question 3</label></th>
<td><input type="text" name="question3" id="question3" maxlength="30" size="30" value="" /></td>
</tr>
<tr>
<th><label for="question4">Question 4</label></th>
<td><input type="text" name="question4" id="question4" maxlength="30" size="30" value="" /></td>
</tr>
<tr>
<th><label for="question5">Question 5</label></th>
<td><input type="text" name="question5" id="question5" maxlength="30" size="30" value="" /></td>
</tr>
<tr>
<th><label for="username"></label></th>
<td><input type="hidden" value="none"name="username" id="username" maxlength="16" size="10" value="" /></td>
</tr>
<tr>
<th><label for="password"></label></th>
<td><input type="hidden" value="none" name="password" id="password" maxlength="16" size="10" value="" /></td>
</tr>
</table>
<div class="form_button_bar">
<input class="safe_button" type="submit" name="submit" value="Set up" />
</div>
</div>
</form>
</div>
<?php
}
$UI->content_end(false);
?>
and result.php
<?php
ob_start();
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="pa"; // Database name
$tbl_name="questions"; // Table name
// Get info from the session
// Connect to server and select databse.
$db_handle= mysql_connect("$host", "$username", "$password")or die("cannot connect");
//$db_found = mysql_select_db("$db_name")or die("cannot select DB");
$db_found = mysql_select_db($db_name, $db_handle);
// Define $myquestion1 and $myquestion2 and $myquestion3 and $myquestion4 and $myquestion5
$myquestion1=$_POST['myquestion1'];
$myquestion2=$_POST['myquestion2'];
$myquestion3=$_POST['myquestion3'];
$myquestion4=$_POST['myquestion4'];
$myquestion5=$_POST['myquestion5'];
//$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and //password='$mypassword'";
//$result=mysql_query($sql);
//$sql=("SELECT * FROM $tbl_name WHERE question1='$myquestion1' and question2='$myquestion2' and question3 ='$myquestion3' and question4='$myquestion4' and question5='$myquestion5'");
//$result=mysql_query($sql);
// Mysql_num_row is counting table row
//$count=mysql_num_rows($result);
// If result matched $myquestion1 and $myquestion2 and $myquestion3 and $myquestion4 and $myquestion5, table row must be 1 row
//if ($db_found) {
$sql = "SELECT * FROM tb_questions";
$result = mysql_query($sql);
$rowdetail = mysql_fetch_array($result);
//while ($db_field = mysql_fetch_array($result)) {
//echo $db_field['question1'] . "<BR>";
//echo $db_field['question2'] . "<BR>";
//print $db_field['question3'] . "<BR>";
//print $db_field['question4'] . "<BR>";
//print $db_field['question5'] . "<BR>";
print "<p>Name: ".$rowdetail['firstname']." ".$rowdetail['surname']."<br />\n";
print "Address: ".$rowdetail['address']."<br />\n";
print "<input name= password id=password maxlength=316 size=110 />cxvbcv</td>"
//print "Postcode: ".$rowdetail['postcode']."\n";
//ob_end_flush();
?>
Please help me out!!!!