PHP - Select Not Retrieving All Rows

So I have an array of IDs that I would only like to select from a database table instead of everything in the table.

How might I go about doing that?

Hi,

I have the project where i want to get the structure like tree.

My table structu

Section_Id Section_Parent   Section_Name
1                0                        America
2                0                        China
3                1                       New york
4                1                       Washington
5                2                       Buffalo

How to retrieve the records..

I need a structure like this in a select button:

America
  New york
    Buffalo


Thanks,

Hello, i am trying to get my form to list usernames ascending as an option, but the select field just returns blank.

Here is my code:

Code: [Select]
/**
 * editUserForm - Displays the users database table in
 * a nicely formatted field table.
 */

function editUserForm(){
   $q = "SELECT * "
       ."FROM ".TBL_USERS." ORDER BY username ASC";
   $result = $database->query($q);

while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row["username"].'">'.$row["username"].'</option>';
}
}

Code: [Select]
              <form action="/" method="post">

                <div class="column">
                  <p>
                    <select name="user" id="user" placeholder="Select A User To Edit" class="{validate:{required:true}}">
                      <option>Select A User To Edit</option>
                      <? editUserForm(); ?>
                    </select>
                  </p>

                <div class="action_bar">
                  <input type="submit" class="button blue" value="Submit Post" />
                  <a href="#modal" class="modal button">Cancel</a>
                </div>

              </form>

All help is appreciated

How can i select the last 3 rows in a table and order it by ASC. When i use DESC it displays the results in the wrong order.

$query24 = mysql_query("SELECT * FROM notifications WHERE to_id='$session' AND state='1' ORDER BY id DESC LIMIT 3 ");

Hello folks,   In trying to improve the user experience for my first WebApp I have decided to create two new tables - one a master file to contain a list of all stores, and the second a master file to contain a list of all products that are normally purchased - and I would like to use the values from these two tables as lookup values in dropdown listboxes, to which the user can also add new entries.   As it turns out, I'm stuck on the very first objective i.e. to lookup/pull-in the distinct values from the master tables.   The problem I'm having is that the query seems to return no rows at all...in spite of the fact that there a records in the table, and the exact same query (when run within the MySQL environment) returns all the rows correctly.   Is there something wrong with my code, or how can I debug to see whether or not the query is being executed?   Objective # 2, which is to allow new values to be entered into the dropdown listbox, and then inserted into the respective table is certainly waaay beyond my beginner skills, and I'll most certainly need to some help with that as well..so if I can get some code/directions in that regard it will be most appreciated.   Thank you.

<?php
   $sql = "SELECT DISTINCT store_name FROM store_master ORDER BY store_name ASC";

   $statement = $conn->prepare($sql);
   $statement->execute();

   $count = $statement->rowCount();                                    
   echo $count;

   // fetch ALL results pertaining to the query
   $result = $statement->fetchAll();

   echo "<select name=\"store_name\">";
   echo '<option value="">Please select...</option>';
   foreach($result as $row)
       {
          echo "<option value='" . $row['store_name'] . "'></option>";
       }
       echo "</select>";
?>

I am building a commenting system, it's sort of like facebooks comments. I have it right now so it loads the first last 3 comments in the database, and then there's a button to view all comments. I have it working fine, except when you add another comment to it, and then click the view all comments,


This is the script that loads onload showing the last 3 comments


$limit  = 3;

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$id' ORDER BY id DESC LIMIT $limit");



This is the php script that runs when you click view more




//($start_id would be 3 in this case)

$query5 = mysql_query("SELECT * FROM sub_comments WHERE status_id='$comment_id' ORDER BY id DESC LIMIT $start_id, 1000");

so to try to show you what's happening:

OnLoad--------------------------------|---When you add more comments, (let's just say u add 1 comment before u click view comments)----
comment 9   --------------------------|   comment 10
comment 8   --------------------------|   comment 9
comment 7   --------------------------|   comment 8
------------------------------------------|   comment 7
----to be loaded onclick-------------|------What's loaded onclick---
comment 6   --------------------------|   comment 7
comment 5   --------------------------|   comment 6
comment 4   --------------------------|   comment 5
comment 3   --------------------------|   comment 4
comment 2   --------------------------|   comment 3
comment 1   --------------------------|   comment 2
------------------------------------------|   comment 1


(see how "comment 7" is being shown twice in a row)

I'm making a game I have finished but have spent days and still can't figure out this part or how it should be done:

Gamer will type in keyword on the form box on my page then click submit

the page will connect to yahoo search then save/put the address bar URL search result of the keywords into a variable onto my page but the gamer will never have his page directed to yahoo but continue staying on my page while this all happens.


Any Help in the right direction or some code would be appreciated? 

i have had a difficult time trying to work this out.I need to do some pattern matching for certain urls and retrieve information from it.
For example,
$url=http://www.test.com/showpic.php?do=showpic&u=89165&a=34933

if $url contains the value showpic.php,then i need to retrieve the following
{
  $u=value of u(i.e. 89165 in this case)
  $a=value of a(i.e. 34933 in this case)
}
else do nothin..

the format of the url will always be the same as above if it contains showpic.php

i have this script called view.php
Code: [Select]
<?php
  include 'db.inc';

  $file = clean($file, 4);

  if (empty($file))
     exit;

  if (!($connection = @ mysql_pconnect($hostName,
                                       $username,
                                       $password)))
     showerror();

  if (!mysql_select_db("Php_test", $connection))
     showerror();

  $query = "SELECT mime, data FROM file 
            WHERE id = $file";

  if (!($result = @ mysql_query ($query,$connection)))
     showerror();  

  $data = @ mysql_fetch_array($result);

  if (!empty($data["data"]))
  {
    // Output the MIME header
     header("Content-Type: {$data["mime"]}");
    // Output the image
     echo $data["data"];
   }
?>after i have db.inc
Code: [Select]
<?php

// These are the DBMS credentials
$hostName = "localhost";
$username = "root";
$password = "oxioxi";

// Show an error and stop the script
function showerror()
{
   if (mysql_error())
      die("Error " . mysql_errno() . " : " . mysql_error());
   else
      die("Could not connect to the DBMS");
}

// Secure the user data by escaping characters 
// and shortening the input string
function clean($input, $maxlength)
{
  $input = substr($input, 0, $maxlength);
  $input = EscapeShellCmd($input);
  return ($input);
}

?>and i have my page witch part of it is  this
Code: [Select]
   <?php
  include 'db.inc';
  
  $query = "SELECT id, name, mime FROM file";

  if (!($connection = @ mysql_pconnect($hostName, 
                                    $username,
                                    $password)))
     showerror();

  if (!mysql_select_db("php_test", $connection))
     showerror();
        
  if (!($result = @ mysql_query ($query, $connection)))
     showerror();
?>
    <h1>Image database</h1>


<?php 


  if ($row = @ mysql_fetch_array($result))
  {
?>

    <table>
    <col span="1" align="right">
    <tr>
       <th>Short description</th>
       <th>File type</th>
       <th>Image</th>

    </tr>
<?php
   do 
   {
?>
    <tr>
       <td><?php echo "{$row["name"]}";?></td>         
       <td><?php echo "{$row["mime"]}";?></td>
       <td><?php echo "<img src=\"view.php?file={$row["id"]}\">";?></td>
    </tr>
<?php
   } while ($row = @ mysql_fetch_array($result));
?>
    </table>
<?php
  } // if mysql_fetch_array()
  else
     echo "<h3>There are no images to display</h3>\n";
?>i have do it right but for some reason it doesnt displays the pictures the type and the name are displayed normally but not the picture!! instead of them there are small icons of not existing pictures.. please i want help i really need to do it

Hi,
I need to get data from an XML file, like the format below:
Code: [Select]
<ISBNdb server_time="2011-05-31T19:19:42Z">
<BookList total_results="1" page_size="10" page_number="1" shown_results="1">
<BookData book_id="build_your_own_database_driven_web_site_using_php_mysql_4th_" isbn="0980576814" isbn13="9780980576818">
<Title>
Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition
</Title>
<TitleLong/>
<AuthorsText>Kevin Yank, </AuthorsText>
<PublisherText publisher_id="sitepoint">SitePoint</PublisherText>
<Details change_time="2009-04-02T00:30:10Z" price_time="2011-05-31T17:46:10Z" edition_info="Paperback; 2009-06-15" language="" physical_description_text="360 pages" lcc_number="" dewey_decimal_normalized="5" dewey_decimal="005"/>
</BookData>
</BookList>
</ISBNdb>
I need to know how you get the details from <title>,<AuthorsText><PublisherText> and Bookdata. Tried using the example on W3C, using simplexml_load_file but it only returns:
Code: [Select]
ISBNdb
BookList:
Code I'm currently using is:
Code: [Select]
$xml = simplexml_load_file("http://isbndb.com/api/books.xml?access_key=----&results=details&index1=isbn&value1=".$isbn);
echo $xml->getName() . "<br />";

foreach($xml->children() as $child)
  {
  echo $child->getName() . ": " . $child . "<br />";
  }

In my script, users login with their Username & Password. However, I'd like to be able to echo the email address used on their account. I've tried adding the email to the session
I'm not having much luck... Here's a piece of the login code(untouched);

                $username = $_POST['name'];
                $passwd = $_POST['passwd'];
                $query = "SELECT name,passwd FROM users WHERE CONCAT('0x', hex(passwd)) = '{$salt}'";
		$result = mysql_query($query);
		$login_ok = false;
		if(mysql_num_rows($result) > 0) {
		    $login_ok = true;
		}
		if($login_ok)
		{
		    $row = mysql_fetch_array($result, MYSQL_NUM);
		    $_SESSION['user'] = $row;

I've also tried messing around with this piece below in a few different ways but still nothing.

<?php echo htmlentities($_SESSION['user']['email'], ENT_QUOTES, 'UTF-8'); ?>

Any help is greatly appreciated..

$qID = '';
$question = 'Question not set';
$answerA = 'unchecked';
$answerB = 'unchecked';
$answerC = 'unchecked';
$answerD = 'unchecked';
$answerE = 'unchecked';



?>

<html>
<head>
<script type="text/javascript">
function show_alert()
{
alert("Please Click OK to proceed!");
                 
}
</script>
</head>
<form action="Process1.php" method="POST">
<table>
<tr>
<td>
<?php

$SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id
";
$result = mysql_query($SQL);
while($db_field = mysql_fetch_assoc($result)){

   $qID = $db_field['question_id'];
   $question = $db_field['question'];
   $A = $db_field['answer1'];
   $B = $db_field['answer2'];
   $C = $db_field['answer3'];
   $D = $db_field['answer4'];
   $E = $db_field['answer5'];
   print $question;
?>
</td>
</tr>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'A' <?PHP echo $answerA; ?>><?PHP echo $A; ?>
<INPUT TYPE = "Hidden" Name = "h"  VALUE = <?PHP print $qID; ?>>
<?php echo $qID;?>
</td>
</tr>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'B' <?PHP echo $answerB; ?>><?PHP echo $B; ?>
<?php echo $qID;?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'C' <?PHP echo $answerC; ?>><?PHP echo $C; ?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'D' <?PHP echo $answerD; ?>><?PHP echo $D; ?>
</tr>
</td>
<tr>
<td>
<INPUT TYPE = 'Radio' Name ='q'  value= 'E' <?PHP echo $answerE; ?>><?PHP echo $E; ?>
<br>
<?php }  mysql_close(); ?>
</tr>
</td>
<tr>
<td>


Please add any comments you may have:</br>
 <textarea rows="3" cols="60" name="comments" id="comments">
 </textarea>

</td>
</tr>


</table>

<input type="submit" onclick="show_alert()" value="Submit" />
</form>

</html>

I ran to some problems here. After filling every question up with the answers. When i process the form, i only managed to get QID of 20 and the answer of 1st question as my database have only 20questions. How do i go about in solving, so that i'm able to retrieve all result and update my database correctly

      $selected_radio = $_POST['q'];
      
      
      $qID = $_POST['h'];

      echo $selected_radio;
      
      echo $qID;
         
         $SQL = "UPDATE answers SET $selected_radio = $selected_radio + 1 WHERE question_id='$qID'";
         $result = mysql_query($SQL);
         mysql_close();
         print "Thanks for voting!";


?>
THis is my process page, and i echo out the answer to be B and qid as 20.

Hi,

so i have a problem. I'm using a script to enable and disable checkboxes, and i'm id-ing them fetching values from a database:

while($data = mysqli_fetch_array($sql))
{
  if ($count % 5 == 0) {
    echo '</tr><tr>';
    $count = 0;
  }
  echo '<td><input name="subject_level[]" class="subject_a" disabled="disabled" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
  echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
  $count++; //Increment the count
}

The names of the checkboxes come out fine, just that, is there any way to retrieve the values of the checkboxes into an array of some sort so that i could build a search query later?

if($_POST(subject_level)) or if($_POST(subject_level[]))  doesn't return true. does it make sense? im new to php so please forgive my ignorance. Help appreciated. Thanks!

I have a basic table where I am trying to retrieve records that are filtered by a form request. Here is the code I have...

$ps = $pdo->prepare("SELECT * FROM `Products` Where `Vendor` LIKE concat('%',?,'%');
$ps->execute(array($_POST['Vendor']));;
echo "post=" . $_POST['vendor']; ////Displays correct data from form request
$count = $ps->rowCount();
echo "Count=" . $count; ////Count = 0 although I know for a fact that there is 1 record that should be in there

////Used for display of records
foreach ($ps as $row){
echo $row, PHP_EOL . "xxx<br>";
}

Where is the incorrect code? I am new to php and pdo. Thank you in advance

K

ok im back quicker than i thought....

i got my drop box sorted and i got it reloading the page. so it all works correctly.

but how do i get the page to display information regarding the film i have selected in the drop box.? i have no code for this at the mo.

also i would like the drop box to display the selected item at top of box when it refreshes

code for drop box:

Code: [Select]
<FORM>
<?php $result = mysql_query( "SELECT * FROM movie_info ORDER BY title ASC ")
;
echo "<select name= Film onChange='submit()' >film name</option>";
while
($nt=mysql_fetch_array($result)){
?>
<?php
  echo "<option value='$nt[id]'>$nt[title] </option>";
}
?>
</select>
</FORM>



any help would be great