PHP - Auto Numbered League Table

Hey guys I need some help, Im trying to generate a numbered list by using i++ and an if statement but I cant seem to get the values to start over to 0, here is a look at my code
Code: [Select]
$make = "SELECT * FROM category_description ORDER BY category_id ASC LIMIT 1000";
$makeresult = mysql_query($make);
while($make1 = mysql_fetch_array($makeresult)){
  $parent = "SELECT * FROM category WHERE parent_id = {$make1['category_id']} LIMIT 1000";
$parentresult = mysql_query($parent);
while($parent1 = mysql_fetch_array($parentresult)){
    if(($make1['category_id'] == $parent1['parent_id']) AND ($make1['name'] == $make1['name'])){
 $i += 1;
  $count = $i;
 echo "[". $count . "]" . " " . $parent1['category_id'] . " " . $make1['category_id'] . " " . $parent1['parent_id'] . " " . $make1['name'] . "<br />";
Basically the output comes out like this:
Code: [Select]
[1] 100 10 10 Acura
[2] 101 10 10 Acura
[3] 102 10 10 Acura
[4] 103 10 10 Acura
[5] 104 10 10 Acura
[6] 105 10 10 Acura
[7] 106 10 10 Acura
[8] 107 10 10 Acura
[9] 108 10 10 Acura
[10] 109 10 10 Acura
[11] 110 10 10 Acura
[12] 111 10 10 Acura
[13] 112 10 10 Acura
[14] 113 10 10 Acura
[15] 114 10 10 Acura
[16] 115 10 10 Acura
[17] 116 10 10 Acura
[18] 117 10 10 Acura
[19] 118 10 10 Acura
[20] 119 10 10 Acura
[21] 120 10 10 Acura
[22] 121 10 10 Acura
[23] 122 10 10 Acura
[24] 123 10 10 Acura
[25] 124 10 10 Acura
[26] 125 10 10 Acura
[27] 126 11 11 Audi
[28] 127 11 11 Audi
[29] 128 11 11 Audi
[30] 129 11 11 Audi
[31] 130 11 11 Audi
[32] 131 11 11 Audi
[33] 132 11 11 Audi
[34] 133 11 11 Audi
[35] 134 11 11 Audi
[36] 135 11 11 Audi
[37] 136 11 11 Audi
[38] 137 11 11 Audi
But I need it to come out like this, so basically if Acura = Acura generate 1,2,3,4 etc and if Audi = Audi generate 1,2,3,4......Im still somewhat new to this would really appreciate the help if someone can point me in the right direction:
Code: [Select]
[1] 100 10 10 Acura
[2] 101 10 10 Acura
[3] 102 10 10 Acura
[4] 103 10 10 Acura
[5] 104 10 10 Acura
[6] 105 10 10 Acura
[7] 106 10 10 Acura
[8] 107 10 10 Acura
[9] 108 10 10 Acura
[10] 109 10 10 Acura
[11] 110 10 10 Acura
[12] 111 10 10 Acura
[13] 112 10 10 Acura
[14] 113 10 10 Acura
[15] 114 10 10 Acura
[16] 115 10 10 Acura
[17] 116 10 10 Acura
[18] 117 10 10 Acura
[19] 118 10 10 Acura
[20] 119 10 10 Acura
[21] 120 10 10 Acura
[22] 121 10 10 Acura
[23] 122 10 10 Acura
[24] 123 10 10 Acura
[25] 124 10 10 Acura
[26] 125 10 10 Acura
[1] 126 11 11 Audi
[2] 127 11 11 Audi
[3] 128 11 11 Audi
[4] 129 11 11 Audi
[5] 130 11 11 Audi
[6] 131 11 11 Audi
[7] 132 11 11 Audi
[8] 133 11 11 Audi
[9] 134 11 11 Audi
[10] 135 11 11 Audi
[11] 136 11 11 Audi
[12] 137 11 11 Audi

I have an SQL query:
SELECT username, dl_sumtotal
FROM `vb_user`
ORDER BY dl_sumtotal DESC
LIMIT 0 , 30
Right now, its results display like this:

username3: 500
username1: 400
username2: 300

How can I give these results a numbered column so it displays like this:


1: username3: 500
2: username1: 400
3: username2: 300

I would like to output that number in my PHP script. thanks for any help.

Hello,

I'm generating a list of questions from a database, say $questions.  I'd like to number the questions AFTER I load them from the database (I know that I could enter a number associated with them in the database, but it could get tricky, as the questions will continually be updated and deleted).  My question, then, is how can a create a new array which associates each question with a number.

Thank you!

hai this is mani,i am new to php and mysql ...first of all forgive for my english...i am having problem with my mysql .i am having a table 'user' and fields 'id','name','status' .i can enter the values to the table.
for example....
id=1,name="db' status='first'
what i need is i have to update the status value to 'second' automatically after one year.
how can i do that?     

I have a row in a MySQL table called id, which auto-increments.

I was wondering if anyone knows a PHP solution to find out what the highest number in the row is?

I am thinking perhaps execute a MySQL query that will list the highest number, and then echo the result, like $row[id] in PHP?

//php code
<?php
include_once('con.php');
if(!empty($_GET['search'])) {
$search = $connect->prepare('SELECT * FROM posts WHERE title LIKE :search');
$search->bindValue(':search', '%'.$_GET['search'].'%', PDO::PARAM_STR);
$search->execute();
?>
<?php
while($row = $search->fetch()) {?>
<li class="result" onClick="searchValue('<?php echo $row['title'];?>')"><?php echo $row['title'];?></li>    
<?php } ?>
<?php } ?>

//ajax

$('#inputsch').keyup(function(){
	$.ajax({
	type: 'GET',
	url: 'fetch.php',
	data:'search='+$(this).val(),
	success: function(data){
		$('#box').show();
		$('#box').html(data);
	}
	});
}); 
});
function searchValue(val) {
$('#inputsch').val(val);
$('#box').hide();
}


//search box

 <form action="search.php">
 <input id="inputsch" type="text" name="search" placeholder="search..." autocomplete="off" autofocus>
 <button type="submit" value="search" >search</button> 
 </form>
 <div id="box"></div>


//the problem here is when i click the result is only added to input, but i want it to autosubmit

 

So a project I have simply to learn how it is done is to make an auto updating sitemap with a auto submitter. I have been doing a little research on sitemaps but haven't found much in the way of a tutorial or white paper or similar, anyway I was wondering if I am on the right track or not.

What I was thinking for the auto-updating sitemap is since site maps are XML, when an article is published using my custom CMS/Blogging system, I make it rewrite the sitemap appending the new URL that will be generated.

Then for the auto-submit, I can either make it a cron job or just manual press, but it would go though a for list of URLs, replacing the end part with my site map url. I think that is how it would be done.

If you have a better idea, or can point out an article so I can understand a lot more with sitemaps, I will appreciate it, I am trying to learn as much as possible, I have gone to the offical website (sitemaps.org) but it doesn't have what I am looking for.

Thanks,

James

the info posts beautifully i just canst seem to get the button to auto click or submit, tried numerous ways!  help

Code: [Select]
<?php  

require_once "../store/paypal/utility.php";
require_once "../store/paypal/constants.php";

$url = "https://www.".DEFAULT_ENV.".paypal.com/cgi-bin/webscr";
$postFields =   "cmd=".urlencode("_notify-synch").
            "&tx=".urlencode(htmlspecialchars($_GET["tx"])).
            "&at=".urlencode(DEFAULT_IDENTITY_TOKEN);
$ppResponseAr = Utils::PPHttpPost($url, $postFields, true);

if(!$ppResponseAr["status"]) {
   Utils::PPError($ppResponseAr["error_msg"], $ppResponseAr["error_no"]);
   exit;
}

$httpParsedResponseAr = $ppResponseAr["httpParsedResponseAr"];

// assign posted variables to local variables
   $item_name = $httpParsedResponseAr['item_name'];
   $item_number = $httpParsedResponseAr['item_number'];
   $receiver_email = $httpParsedResponseAr['receiver_email'];
   $receiver_id = $httpParsedResponseAr['receiver_id'];
   $quantity = $httpParsedResponseAr['quantity'];
   $first_name = $httpParsedResponseAr['first_name'];
   $last_name = $httpParsedResponseAr['last_name'];
   $payer_email = $httpParsedResponseAr['payer_email'];
   $txn_type = $httpParsedResponseAr['txn_type'];
   $address_street = $httpParsedResponseAr['address_street'];
   $address_city = $httpParsedResponseAr['address_city'];
   $address_state = $httpParsedResponseAr['address_state'];
   $address_zip = $httpParsedResponseAr['address_zip'];
   $item_number = $httpParsedResponseAr['item_number'];
   $option_name1 = $httpParsedResponseAr['option_name1'];
   $option_selection1 = $httpParsedResponseAr['option_selection1'];
   $option_name2 = $httpParsedResponseAr['option_name2'];
   $option_selection2 = $httpParsedResponseAr['option_selection2'];
   $invoice = $httpParsedResponseAr['invoice'];
   $custom = $httpParsedResponseAr['custom'];
   $payer_id =$httpParsedResponseAr['payer_id'];

?>
<html lang="en">
<head>
<title>Rec</title>
<link REL="stylesheet" href="include/style.css" type="text/css">
<!--[if IE]>
<link REL="stylesheet" href="include/styleIE.css" type="text/css">
<![endif]-->
<style>
#center_block {width:50%;margin:0 auto;min-width:500px;}
#contents_block {text-align:center;}
#header_block {white-space:nowrap;height:25px;padding:0 10px 5px;text-align:center;}
#fields_block {width:100%;margin:0;padding:10px}
#header_block  span {margin:0 5px}
#buttons_block {padding:10px 10px 5px}
#buttons_block div {padding:3px}
#delimiter {margin:2px}
#fields_block td {padding:3px 14px}
#username_block td {padding-top:13px;white-space:nowrap;}
#remember_block td {padding-bottom:13px;white-space:nowrap;}
#required_block {text-align:left;padding:5px}
</style>
<!--[if IE]>
<style>
#main_block {width:100%}
</style>
<![endif]-->
</head>
<body>
<script language="JavaScript" src="include/jquery.js"></script>

<script language="JavaScript" src="include/jsfunctions.js"></script>

<script language="JavaScript" src="include/runnerJS/RunnerBase.js"></script>





 
 
<form action="rec.php" method="post" id="rec" name="rec.php">

<table id="center_block" align="center">
   <tr><td id="contents_block">
 
 
<div class="main_table_border2 loginshade" id="main_block">
 
<table cellpadding=0 cellspacing=0 border=0 id="fields_block" class="loginshade">
 
<tr id="email_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_email_1">Email:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_email_0" style="white-space: nowrap;"><input id="value_email_1" style="" type="text" name="value_email_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["payer_email"]) ?>">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="pass_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_pass_1">Pass:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_pass_0" style=""><input style="" id="value_pass_1" type="Password" name="value_pass_1"  maxlength=50 value="1234">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="confirm_block">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_confirm_1">Re-enter password:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_confirm_0" style=""><input style="" id="value_confirm_1" type="Password" name="value_confirm_1"  value="1234">&nbsp;<font color="red">*</font></span>
      <div class="error"></div>
   </td>
</tr>
 
 
<tr id="fname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_fname_1">First Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_fname_0" style="white-space: nowrap;"><input id="value_fname_1" style="" type="text" name="value_fname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["first_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="lname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_lname_1">Last Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_lname_0" style="white-space: nowrap;"><input id="value_lname_1" style="" type="text" name="value_lname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["last_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="address_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_address_1">Address:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_address_0" style="white-space: nowrap;"><input id="value_address_1" style="" type="text" name="value_address_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_street"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="city_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_city_1">City:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_city_0" style="white-space: nowrap;"><input id="value_city_1" style="" type="text" name="value_city_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_city"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="state_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_state_1">State:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_state_0" style="white-space: nowrap;"><input id="value_state_1" style="" type="text" name="value_state_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_state"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="zip_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_zip_1">Zip:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_zip_0" style="white-space: nowrap;"><input id="value_zip_1" style="" type="text" name="value_zip_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_zip"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="cosponsor_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_cosponsor_1">Cosponsor:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_cosponsor_0" style=""><input id="type_cosponsor_1" type="hidden" name="type_cosponsor_1" value="checkbox"><input id="value_cosponsor_1" type="Checkbox" name="value_cosponsor_1" ></span>
          </td>
</tr>
 
 
<tr id="recipients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_recipients_1">Recipients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_recipients_0" style="white-space: nowrap;"><input id="value_recipients_1" style="" type="text" name="value_recipients_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["quantity"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="clients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_clients_1">Clients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_clients_0" style=""><input id="type_clients_1" type="hidden" name="type_clients_1" value="checkbox"><input id="value_clients_1" type="Checkbox" name="value_clients_1" ></span>
          </td>
</tr>
 
 
<tr id="space_block"></tr>
 
</table>
 
 
</div>
</td></tr>
</table>
    <input type=submit value="Submit" class=button id="saveButton1" onload="Submit"></form>

</body>
</html>

Hi I am trying to send a auto email to a variable email address throught php. But im not sure how to do it? I think this is the kind of php code I have to use:

$to = "<?php echo $Adminmail ?>";
$subject = "Join Faction Request!";
$message = "<?php echo $user wishes to join your faction?>";
echo "Mail Sent.";

Also how would i send php code in the email?

Any help would be great thanks 

Freid001

Html code Code: [Select]
<div id="feedback">
          <p class="error wrong_name"> Fill the correct name</p>
          <p class="error wrong_email"> Incorrect email</p>
          <p class="error wrong_message"> Enter your message</p>
        </div>
        <form action="sendemail.php" id="contact_us" method="post">
          <p class="label_name">Name</p>
          <p class="input_form">
            <input type="text" name="Name" width="20"/>
          </p>
          <p class="label_name">Email</p>
          <p class="input_form">
            <input type="text" name="Email" />
          </p>
          <p class="label_name">Message</p>
          <p class="input_form" id="textarea">
            <textarea name="Message" rows="5" cols="4" id="message_input"></textarea>
          </p>
          <p id="submit">
            <input type="submit" value="Send" name="submitButton" class="button" />
          </p>
        </form>
        <p id="success">Your message was sent succesfully!</p>



Php code Code: [Select]
<?php
$mailTo = 'vmoore@minoritybiz.org';
$name = htmlspecialchars($_POST['Name']);
$mailFrom = htmlspecialchars($_POST['Email']);
$subject = 'Information Request';
$message_text = htmlspecialchars($_POST['Message']);

$message =  'From: '.$name.'; Email: '.$mailFrom.' ; Message: '.$message_text;

mail($mailTo, $subject, $message);

?>
this works  real simple I would like to add a auto respond to the person click the submit button.

Hello

can anyone tell me why this function don't return anything ?


<?php include_once('./header.php'); ?>

<?php
    $var = Array();
    $data = $db->get("omnot", "fullname");
    
    foreach($data as $var){
        $var = $data;        
    }
    $input = strtolower( $_GET['input'] );   // the input is ok
    $len = strlen($input);
    
    
    $aResults = array();
    
    if ($len)
    {
        for ($i=0;$i<2;$i++)
        {
            if (strtolower(substr(utf8_decode($var),0,$len)) == $input)
                $aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($var[$i]));
        }
    }


from the database i get the values: "roey" , "rrr" , "try"
input == r

why the function don't go to the line:  Code: [Select]
$aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($var[$i]));
whats wrong with the IF ?

Hi all,

I am having some trouble with a part of code. Basically the code is set for a Factory to produce 750 items every 30 minutes. It does this fine IF AND ONLY IF someone clicks the Factory page. For example, it produces 750 bullets, then I leave the page alone for say 20 minutes, but when I click back, it doesn't have 10 minutes left before the next produce. Instead, It has 30 minutes. So it only produces when someone on the game clicks the page. I have tried the basic html refresh but that doesn't work.

Any idea's?

Thanks in advance

Hello,

I am creating a job setup form and have a need for the job id field to increment based on the last inserted job id into our Oracle database.
So far I have created a function that selects the maximum job id from the job table and adds 1 to the number.

However, I run into the problem of when a user is filling out the form and another user opens it and begins filling out the form they both will receive the same job id in the field. I'm assuming this could possibly be solved with sessions, but I'm not sure where to start.

Also, the form is not inserted into the table on submit (instead an excel sheet is created with the information and someone will enter the data into the database manually). Since the form data can be entered anytime from completion to next week/two weeks, how can I ensure that that job id is not used again.

Thanks

I have an issue with my delete feature on my site.  A user selects a photo to delete.  It then takes them to the are you sure you want to do this page with the id of the image under  delete polaroid.  This page has the following code on it....
 <div id="editindexpage">
           <?php
    $qGetId  =  "SELECT * FROM `polaroids` WHERE id='".$_GET['delete_polaroid']."'";
   $result = mysql_query($qGetId) or die (mysql_error()) ;
$pola=mysql_fetch_array($result);
 
$GetCat = "SELECT * FROM category WHERE cat_name='".$pola['catid']."'";
$Result = mysql_query($GetCat);
$GotCat = mysql_fetch_assoc($Result);

?>         
        <p class="bold">Are you sure you want to delete <?php echo $GotCat['cat_name'];?> and its image from the database?</p><br/>

 
        <a href="polaroids.php?delete_comp=
<?php mysql_query("DELETE FROM polaroids WHERE id='".$_GET['delete_polaroid']."'");
mysql_query("DELETE FROM category WHERE cat_name='".$pola['catid']."'");
?>">Yes</a>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<a href="polaroids.php">No</a>
</div>

My issue is this.  Even if you select no for some reason it deletes the selected file.  I dont understand how this is possible can anybody please help?

Thank you

is there a way to auto refresh the same page youre on after a script runs?