PHP - Making A Loop

Good Evening -  I am in the process of trying to call back a list of categories and sub categories using a WHILE LOOP inside of a WHILE LOOP. It works on a different part of the site within the admin panel but not here. Here it only calls one sub category and moves on to the next parent category instead of finishing the loop and pulling all sub categories out...

// CATEGORIES

$query  = "SELECT * FROM cat";
$result = mysql_query($query);



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

$catid = $row['id'];
$catname = $row['name'];

$output .= "<li class=\"level0 nav-2 parent\" onmouseover=\"toggleMenu(this,1)\" onmouseout=\"toggleMenu(this,0)\">
<a href=\"product.php?cat=$catid\">
<span>$catname</span>
</a>\n";


$querynav = "SELECT * FROM subcat WHERE pid = '$catid'";
$resultnav = mysql_query($querynav);

while($array = mysql_fetch_array($resultnav, MYSQL_ASSOC))
{

$subcatid = $row['id'];
$subcatname = $row['name'];

$output .= "<ul class=\"level0\">
<li class=\"level1 nav-2-1 first\">
<a href=\"product.php?cat=$catid&subid=$subcatid\">
<span>$subcatname</span>
</a>
</li>
</ul>
</li>";
}

}

Hi..
I have while loop inside while loop but I encountered problem in displaying data inside while loop or the second while loop.

here is my code:

Code: [Select]
<?php
  error_reporting(0);
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
?>
<script type="text/javascript">
function showDetails(pcode) {
 
 var clickElement = pcode.value;
 var click_id = pcode.id;
               
// var value_ =  document.getElementById(click_id).checked
 //    =  document.getElementById(clickElement).checked;   
 //var Table = (document.getElementsByName('list')[0].value);     
 
 var Table = document.getElementById('kanban_list');

 var rows = Table.rows;   
 
 var strSelect = document.getElementById(click_id).value;
 //alert(strSelect)
 
 for (var i = 0; i < rows.length; i++) {     
      var row = rows[i];     
    //row.style.display = (row.id.substr(0,3) == strSelect) ?      'none'         :          '';   
    //row.style.display = (row.id.substr(0,3) == strSelect) ?
   // row.style.display = 'none';
   // row.style.display = '';
   
    if (row.id.substr(0,3) == strSelect) {
        row.style.display = ((document.getElementById(click_id).checked) == false) ?  'none' : ''
    }
    //(document.getElementById(click_id).checked == false) ?  'none'               : '' : '';   
 
 } 
   
}

</script>
<?php
$sql = "SELECT kc.PCODE, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion, 
kc.count_wip_forming, kc.count_wip_deflashing, kc.kanban, kc.virtual, p.max_lot, p.min_lot FROM kanban_checker kc 
JOIN plan p ON kc.PCODE = p.PCODE ORDER BY p.PCODE";    
$result = mysql_query($sql, $con);       
?><label>Display Details:</label><input  onclick='showDetails(this);' id='chkDetail'   type='checkbox' checked='checked' value='wip'/>
<?php
echo "<table id='kanban_list'>";
echo "<tr>
        <th> PCODE </th>
        <th> LOT CODE </th>
        <th> CHEMICAL WEIGHING </th>
        <th> COMPOUNDING </th>
        <th> EXTRUSION </th>
        <th> FORMING </th>
        <th> DEFLASHING </th>
        <th> KANBAN </th>
        <th> VIRTUAL </th>
        <th> MAX LOT </th>
        <th> MIN LOT </th>
     </tr>";
while($row = mysql_fetch_assoc($result)){ 
    echo "<tr>
        <td>$row[PCODE]</td>
        <td>&nbsp;</td>
       <!-- <td>$row[LOT_CODE]</td>   -->
        <td>$row[count_wip_chemical_weighing]</td>
        <td>$row[count_wip_compounding]</td>
        <td>$row[count_wip_extrusion]</td>
        <td>$row[count_wip_forming]</td>
        <td>$row[count_wip_deflashing]</td>
        <td>$row[kanban]</td>
        <td>$row[virtual]</td>
        <td>$row[max_lot]</td>
        <td>$row[min_lot]</td>
        </tr>";     
$sql = "SELECT kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming, kd.wip_deflashing 
FROM kanban_data kd JOIN plan p ON kd.PCODE = p.PCODE ORDER BY p.PCODE "; 
$result_kanban_data = mysql_query($sql, $con);   

while($row_data = mysql_fetch_assoc($result_kanban_data)){    
    echo "<tr id='wip'>
    <td></td>
    <td>&nbsp;$row_data[LOT_CODE]</td>
    <td>&nbsp;$row_data[wip_chemicalweighing]</td>
    <td>&nbsp;$row_data[wip_compounding]</td>
    <td>&nbsp;$row_data[wip_extrusion]</td>
    <td>&nbsp;$row_data[wip_forming]</td>
    <td>&nbsp;$row_data[wip_deflashing]</td>
    </tr>"; 
}       
}
echo "</table>";
     
?>
I attach the image of result from this code

But the output that I want is all LOT_CODE with P35 PCODE will only display below P35
and all LOTCODE with P35M PCODE will only display below P35M.

Thank you

I hope somebody can help me..

So I have a PHP parent page that is accesses that scans the database for the passed token in the URL and then replaces content on the template page using a loop. My issue is that I am trying to use a loop on the secondary page which causes the white screen of death. From what I can tell the loop inside a loop is causing the issue.
I'll paste the code below, let a newbie know if you have any ideas or can point me in the right direction.

Thanks everyone!


Here is the chunk of code from the parent page with the loop function....


// output pre content
eval("\$preContent = \"$preContent\";");
print_r( replaceChar($preContent) );

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS;
$resultSearch = mysql_query($sqlSearch);

while($displayrows = mysql_fetch_assoc($resultSearch)) {
   $display = replaceTokens($loopTemplate);
   $display = str_replace('\\', '[backslash]', $display);
   $display = str_replace('[%', '$displayrows[', $display);
   $display = addslashes(str_replace('%]', ']', $display));
   $display = replaceTokens($display);
   $display = changeCase($display);

   eval("\$display = \"$display\";");

   $display = stripslashes($display);
   $display = str_replace('[backslash]', '\\', $display);
   $display = replaceChar($display);

   print_r( $display );

}
// output post content


And here is the loop function from the page that the above code loops through replacing tokens in.



<?php
$mySQLServer = "xxxxxxxxx";
$mySQLUser = "xxxxxxxxxx";
$mySQLPass = "xxxxxxxx";
$mySQLDB = "xxxxxxxxxxxxx";
$SQLToday = date("m/d/y") . "<br />";
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y"));
$SQLsevenname = (date("l", $SQLsevendays));
$SQLsevennumber = (date("jS", $SQLsevendays));
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass)
  or die("Couldn't connect to SQL Server on $myServer");
$selected = mssql_select_db($mySQLDB, $dbhandle)
  or die("Couldn't open database $myDB");
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8";
$data = mssql_query($query);
$result = array();

while ($row = mssql_fetch_object($data))
{
       $result[] = $row;
       $returnedresults = (97*($row->TotalApprovals)) ;
 }

$englishreturnedresults = number_format($returnedresults);
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . '  has delivered ';
echo $englishreturnedresults;
echo '  Here are just a few people ';

echo '<ul class="BulletCheck">';

mssql_next_result($data);


while ($row = mssql_fetch_object($data))
{
       $result[] = $row;
       echo '<li>' . '  ' . $row->FirstName  . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>';
 }


mssql_close($dbhandle);
?>   

A WHILE loop in a FOR loop problem

Script about links and sublinks from 1 table.

In fact 2 questions about that.
1) In the FOR loop I have for example to do the loop 3 times. (needs to find 3 results withing the loop with if and else)
When first time, he's gonna search within the WHILE loop that holds (for example) 10 records of the DB in a variable.
He needs to search for rowid number 5, he found it
He goes out of the WHILE loop and goes searching again but now for rowid number 2
 
Now it seem that the WHILE loop start searching for number 2 but won't start from his first row in the variable (10 rows from the db ).
He start at row number 6 instead of beginning all over again !!!

-> so the order of the numbers of rows MUST be in an ascending order, ortherwise he won't find them all ! But the numbers I have are NOT in an ascending order !!!
Why doesn't the WHILE loop begin again from his row 1 in the variable ?

FOR loop
{
   WHILE loop    {   content here,     break;  }
 }


2) even when I get all the result in an ascending order, he won't go doing a second search but with a different rowid number that he gets from the FOR loop.
It is giving me back indeed the right new rowid number,  but the WHILE loop is doing nothing. 
I have put many echo "..."; and other stuff for checking but can't find the cause !

Here's the code :

Code: [Select]
// $ResultShow = 10 rows from mysql db
if(isset($ResultShow)){

if (mysql_num_rows($ResultShow) >= 1){


//$linksuborder = "2,3,4";
$array1 = explode(",", $linksuborder);
sort($array1);

for ($n = 0;  $n < count($array1);  $n++){ // searchin for the right row id in the variable $ResultShow where we find the numbers for next loop
$r1 = each($array1);

While($Row2 = mysql_fetch_array($ResultShow))  {
 
if($Row2["linkid"] == $r1['value'])  // found it, now look for the numbers that we'll put in an array
{  echo "---here the content---"; 

// linksuborder is where numbers from row id's are stored like  5,2,8
//now put them in an array
$array2 = explode(",", $Row2["linksuborder"]);
        sort($array2);

for ($n2 = 0;  $n2 < count($array2);  $n2++){
$r2 = each($array2);

////// here searching for the sublinks //////
While ($Row3 = mysql_fetch_array($ResultShow))
{
if($Row3["linkid"] == $r2['value']) // search for the right row id within the variable $ResultShow
{
echo "---here the content---";
  break; // found it, so no need to do the rest of the loop
 
} // end if
} //end while
////// end searching for sublinks //////

}  // end for
}  // end if

else
{
echo "--- content here ---"; 
}
 


}  // end while
}  // end for


} //end if
} // end if


Table :

linkid     linksuborder     linktitle
1                  2,3,4   
2                  9,7,8           mainlink1
3                  10               mainlink2
4                                     mainlink3
5
6
7                                      sublink3
8                                      sublink2
9                                      sublink1
10                                    sublink4

-> linksuborder 2,3,4 are the row id's for the mainlink
-> than we put the numbers 9,8,7  (also row id's)  mentioned in row linkid 2  also in a new array
-> now we can search for the sublinks
-> get the details from row linkid 9, than 7, than 8

-> First mainlink is compleet, now go to row linkid 3 to do it all over again for the next mainlink...


RESULTS from an sorted array -> sort($linksuborder);
-------------------------------------------------------------
mainlink1 : sublink1, sublink2, sublink3

mainlink2  : **no result back  but it should *

mainlink 3 : **no result back  but it should *

Hi,

I am new to PHP. Can someone explain me clearly how to use while loop inside while loop to print "*" in square shape.

Thank you for your help.

I'm having a really bad brain fart and I cannot get the logic correct here lol.

I need divs wrapped around every set of 5 images so if there is a total of 8 images then there would be 2 sets of divs (first with 5 images, second with 3 images) and if there was 12 images then there would be 3 sets of divs (first two with five images, last one with 2 images) etc etc What am I doing wrong and is there an easier way to do this?

http://pastebin.com/QfsFxe4G


Thanks!

Code: [Select]
<?php 
$hierachy = new hierachy;
$iterator = new RecursiveIteratorIterator(new recursiveArrayIterator($hierachy->getLocalSubNodes($name1)));
try {
    foreach($iterator as $key=>$value)
        {
        echo $value = substr($value,0,-1).'<br />';
        }
    }
catch(Exception $e)
    {
    echo $e->getMessage();
    }?>

I am having a dilemma.  I am working on a script for a client.  It is a match making system.  It takes all the teams, minimum of 20 teams. 10 matches a season.  No team can play the same team in the season.  Here is my code I have so far.  If it does not make sense ask me, I will try to explain more in depth.

<?php
error_reporting(E_ALL);
include("security/config.php");

//create season for testing purposes
$sql_season = "insert into season (`season`) values ('1')";
$conn->query($sql_season) or die($conn->error);

$season = 1; //testing purpose
echo "Season 1:<br />"; //testing purpose

//get number of teams
$sql_teams = "select * from teams";
$rs = $conn->query($sql_teams) or die($conn->error);
$num_of_teams = $rs->num_rows;
echo "&nbsp;&nbsp;Number of teams this season: {$num_of_teams}<br />"; //testing purpose
//put all teams in array
$teams = array();
while($ts = $rs->fetch_array(MYSQLI_ASSOC)){
	$teams[] = $ts;
}


if($num_of_teams % 2 != 0){
	$teams[] = array('name' => 'bye week', 'id' => 0);
	$sql_dummy = "insert into teams (`name`) values ('bye week')";
	$conn->query($sql_dummy);
}

//how many matches
$weeks = 10;
$matches = 10;
echo "&nbsp;&nbsp;This Seaon will be {$weeks} consisting of {$matches} matches<br /><br />"; //testing purpose
for($i = 0; $i < $weeks; $i++){
	//mix up teams
	$teams1 = $teams;
	$teams2 = $teams;
	shuffle($teams1);
	shuffle($teams2);
	
	$week = $i + 1;
	
	//$sql_week = "insert into weeks (`number`, `season_id`) values ('{$week}', '{$season}')";
	//$conn->query($sql_week) or die($conn->error);
	//$weekID = $conn->insert_id;
	echo "&nbsp;&nbsp;&nbsp;&nbsp;Week {$week} Created:<br />";
	
	//$matchup = array();

	for($x = 0; $x < $matches; $x++){
		shuffle($teams1);
		shuffle($teams2);
		$team_1 = array_pop($teams1);
		$team_2 = array_pop($teams2);

		$rs = false;

		$rs = ($team_1['id'] == $team_2['id'] ? true : false);
		$sql_search = "select * from matches where season_id = '{$season}' "
		$sql_search .= "and team_1 = ('{$team_1['id']}' or '{$team_2['id']}') ";
		$sql_search .= "and team_2 = ('{$team_1['id']}' or '{$team_2['id']}')";
		$rss = $conn->query($sql_search) or die($conn->error);
		if(!$rs || !$rss){
			
			$sql_create = "insert into matches (`team_1`, `team_2`, `week`, `season_id`) values ('{$team_1['id']}', '{$team_2['id']}', '{$week}', '{$season}')";
			$rs = $conn->query($sql_create);
			if($rs){
				echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; //testing purpose
				echo "{$team_1['name']} vs {$team_2['name']}<br />"; //testing purpose
			}
			else{
				echo 'error: ' . $conn->error . '<br />'; //testing purpose
			}
		}
		else{
			$teams1[] = $team_1;
			$teams2[] = $team_2;
			$x--;
		}
		
		
	}
}
 

Let's try something simple:

I have a form that retrieves data from database and organizes the numbers inside of a table (sometimes in an input box).

Is there a simple code so that VALUES > zero will be in BOLD font?

What kinds of things can I do to make Logging-In and being Logged-In *secure*??

I get the whole form validation thingy, but what about from the standpoint of how/where I store data in my database and how I keep track of who is logged in and where they can go, and so on?

Thanks,


Debbie

Hi am in the middle of making a blog but am having problems with one page am working on if anyone can help me please.
What is am looking for is to post username and avatar instead of just the username.
I have already paid some guy to work on this but he didnt get back to me and  ihave no more cash to give for the code to be finished so
i would really appreciate if someone could help to finish this off please thanks.

this is the where the username and text shows which i would like avatar to show as well.
Code: [Select]
<?php
    $query = yasDB_select("SELECT * FROM user WHERE username = '$user'");
$row = $avatarfile;
$query = yasDB_select("SELECT * FROM topic WHERE userid = '$id' ORDER BY id DESC LIMIT 5");
    if($query->num_rows == 0) { ?>
<div id="memberstext">This topic has no comments, be the first to add one!</div>
<?php 
} 
else { 
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$text = $row['comment'];
$text = str_replace(':D','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/biggrin.gif" title="biggrin" alt="biggrin" />',$text);
$text = str_replace(':?','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/confused.gif" title="confused" alt="confused" />',$text);
$text = str_replace('8)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cool.gif" title="cool" alt="cool" />',$text);
$text = str_replace(':cry:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cry.gif" title="cry" alt="cry" />',$text);
$text = str_replace(':shock:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/eek.gif" title="eek" alt="eek" />',$text);
$text = str_replace(':evil:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/evil.gif" title="evil" alt="evil" />',$text);
$text = str_replace(':lol:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/lol.gif" title="lol" alt="lol" />',$text);
$text = str_replace(':x','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/mad.gif" title="mad" alt="mad" />',$text);
$text = str_replace(':P','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/stlyes/images/smileys/razz.gif" title="razz" alt="razz" />',$text);
$text = str_replace(':oops:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/redface.gif" title="redface" alt="redface" />',$text);
$text = str_replace(':roll:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/rolleyes.gif" title="rolleyes" alt="rolleyes" />',$text);
$text = str_replace(':(','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/sad.gif" title="sad" alt="sad" />',$text);
$text = str_replace(':)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/smile.gif" title="smile" alt="smile" />',$text);
$text = str_replace(':o','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/surprised.gif" title="surprised" alt="surprised" />',$text);
$text = str_replace(':twisted:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/twisted.gif" title="twisted" alt="twisted" />',$text);
$text = str_replace(':wink:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/wink.gif" title="wink" alt="wink" />',$text);
            if ( $row['useavatar'] == '1' ) {
        $avatarimage = $siteurl . 'avatars/' . $row['avatarfile'];
            }
            else { 
        $avatarimage = $siteurl . 'avatars/useruploads/noavatar.gif';
            } ?>
<div id="box">
<div class="name"><img src="<?php echo $avatarimage;?>" height="40" width="40" align="left"><br /><?php echo $row['name'];?></div>
<div class="comment_text"><?php echo $text;?></div></div>
This is the form part of it to add the text
Code: [Select]
<div id="box2">
<form name="addcomment" method="post" action="">
<strong>Message:</strong><br />
<textarea name="comment" rows="3" cols="40" id="comment_message"></textarea><br />
<input name="userid" type="hidden" value="<?php echo $id;?>" />
<input type="hidden" name="timestamp" id="timestamp" value="<?php echo time(); ?>" />
</center>
<!-- start of smiles -->
<div id="smiles"><center>
<a href="javascript:addsmilie(' :D ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/biggrin.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :? ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/confused.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' 8) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cool.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :cry: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cry.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :shock: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/eek.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :evil: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/evil.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :lol: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/lol.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :x ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/mad.gif';?>" border="0"  /></a><br />
<a href="javascript:addsmilie(' :P ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/razz.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :oops: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/redface.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :roll: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/rolleyes.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :( ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/sad.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/smile.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :o ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/surprised.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :twisted: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/twisted.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :wink: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/wink.gif';?>" border="0"  /></a>
</center></div>
<input name="name" type="hidden" value="<?php echo $_SESSION['user'];?>" /><br />
    <input name="addcomment" type="submit" value="Add Comment" style="border: 1px solid #000; margin-top: 2px;" />
    </form></div>

Hi, I am trying to make a search based on information about a user in the database. Here is my code so far, notice any words like "and" or "the" in a multiword entry would mess it up. Any advice greatly appreciated. Ideally I would like a list of the matches by user name, and put the word "match" next to the matching data, because I used the OR statement it is going to bring back all of the user's info if one of the criteria matches. Any tutorials on the subject or keywords for google would be greatly appreciated. thanks.

here is the search code.

Code: [Select]
<?php 
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$host = " ;
$database  = " ";
$username  = " ";
$password  = " ";
$tbl_name   = "users";


$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());

if($conn)
{
mysql_select_db($database);
echo "connected to database!!";
 } else {
  echo "failed to select database";
}




//include('bouncer.php');


 
 
//$currentUser = $_SESSION['myusername'];
 
if(isset($_POST['submit'])) 

{  


 
$dob = mysql_real_escape_string( $_POST['dob']);
$gender = mysql_real_escape_string( $_POST['gender']);
$ethnic = mysql_real_escape_string( $_POST['ethnic']);
 
  //THE SEARCH FUNCTION
$sql = mysql_query ( "SELECT * FROM users WHERE dob  LIKE '%$dob%' 
OR gender LIKE '%$gender%'
OR race  LIKE  '%$ethnic%' 
OR dob  LIKE '%$dob%' 
 ") or die(mysql_error());  
 
  

$result = mysql_query($sql) or die( "<br>Query: $sql<br>Failed with error: " . mysql_error() );

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//       then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
    echo $row["dob"];
    echo $row["gender"];
    echo $row["race"];
}



 

 }//if(isset($_POST['submit']))
?>
<html>
<body>
<p>Login Successful</p>
<p>&nbsp;</p>

<form action="login_success7.php" method="post">
  <p>
 
 
    <input name="dob" type="text" size="20" id="dob" />
    Date of Birth<br />
    <input type="text" name="gender" size="20" id="gender" />
  Gender <br />
  <input type="text" name="ethnic" size="20" id="ethnic" />
  Ethnicity
  <br />
 
    <input type="submit" name="submit" value=" search" />
    <input type="reset" value="Reset fields" />
  </p>
</form> 


 

 
 
 
</body>
</html>

 cud any1 tell me why this happens?
when i run SOME of the php script using localhost, it says APACHE HTTP SERVER STOP WORKING

Hello.

I want to make a web-based rpg with mysql and php but need alot of help, I tryed once and failed.

Please msn me:
cginbarrhaven@hotmail.com

I need LOTS of help.

Im stuck!

Zeroth

Hi,

Im trying to make pages switch.
Read data from database and but every 10 data in 1 pages.
I got my way on making pages by using PHP, but my way is not efficient.
 
Please teach me and tell me the correct way or concept to do it.
Or is there any website teaching this?

Appreciate for the help thanks.