PHP - Select Abs() Not Returning Expected Result

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

Hi there I am new to this forum and not much of a php expert. I hope you can assist me. My problem is as follows: I have a column consisting of several values (in this case: sceience, art, humanistics and music) I would like to use the following mysqli query in order to count the appearances of each value in this column:     $query = "SELECT SUM (IF(department = 'science', 1, 0)) AS science, SUM(IF(department = 'art', 1, 0))-> AS art FROM new2"   I have tried lots of ways to loop the results but couldn't get the it working. Can anyone suggest any idea?   Thanks   Hanan  

Okay so, I'm adding a reply feature to my text-board, and I'm wondering how I can select a single result from the DB
I've tried this
$board = mysql_real_escape_string($_GET['board']);
$thread = mysql_real_escape_string($_GET['thread']);

$result = mysql_query("SELECT subject, name, id, timestamp, body FROM $board LIMIT $thread,$thread");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<div id='html1' style='background-color:#F0E0D6;border:solid 1px #800000;font-family:arial; font-size: 12px; padding:2px; margin:2px;'><font color='#CC1105'>%s </font><font color='#117743'>%s</font> <font color='#800000'>Post # %s - %s<br />%s<br /></div>", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6]);
mysql_free_result($result);
}
?>
Kinda works but if I pu
?thread=56
then it would show thread 57, which in this example does not exist.

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

I am trying to update a mysql table called AvItems with the value 'Torso' in the Equip "section?" I have been through the forums and cannot see anything to match.
I dont mind if the page looses the onsubmit() and has a button instead.
Though I would like to update the database and link back to the same page: There is a display that shows the item that is currently equiped, I have put this in to show it works, or doesn't as the case may be.
Hope I got the code /code right this time.

many thanks in advance

Andy Curtis

Code: [Select]
create table Items(
ItemID integer unsigned auto_increment primary key,
ItemName varchar(20) not null,
Type varchar(10),
UsedOn varchar(10),
);

create table AvItems(
AvItemID integer unsigned auto_increment primary key,
AvID integer unsigned,
ItemID integer unsigned,
Equip varchar(8));


<?php

$username="root";
$password="MyPassword";
$database="MyDataBase";
$AvName = "AndyJCurtis";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$AvAccR = mysql_query( " SELECT AvID FROM AvAcc WHERE AvName = '$AvName' " );
$AvID = mysql_result($AvAccR, 0, 'AvID');
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$Torso = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' AND UsedON = 'Body' ");
$TorsoE = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' And UsedON = 'Body' AND Equip = 'Body' ");
if(mysql_num_rows($TorsoE) != 0)
{
$TorsoItem = mysql_result($TorsoE ,0,"ItemName");
//mysql_close();
?>

<title></title>
<head></head>
<body>
<form action="http://localhost/CI/Equip2.php" method="post">

<table border=1>
<tbody>
<tr>
<td>Torso<BR>
<?PHP
echo "$TorsoItem <BR>";
?>
<select name="Torso" onchange="submit();" value =" Update">
<?PHP
while($TorsoRow = mysql_fetch_array($Torso))
{
echo "<option value=\"".$TorsoRow['ItemName']."\">".$TorsoRow['ItemName']."\n </option>";
}
?>
</select>
</td>
</tr>

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?php
if($_POST['Torso'] == 'Update')
{
mysql_query("update AvItems set Equip = '' where Equip='Torso'") or die("cant update unequip"); 
mysql_query("update AvItems set Equip = 'Torso' where ItemID='{$_POST['ItemName']}'") or die("cant update equip"); 
}
?>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

</tbody>
</table>
</.form>
</body>
</html>

Hey guys.
Me again...

Essentially what i am doing is pulling data from a MySQL database about the number of thumbnails on a page.
The user can then change this using a <select> dropdown menu.

How ever, i want the <select> to default to the amount already specified by the Database.
I know i can do this by inserting a Selected attribute to one of the <options> but what is the best way of doing this?

Heres my code..
$NumberOfThumbnails = mysql_result($data, 0,"NumberOfThumbnails");
 <select name="numberofthumbnails"> 
    

<option value="0">None</option>
        <option value="2">2</option>
        <option value="4">4</option>
        <option value="6">6</option>
        <option value="8">8</option>
        <option value="10">10</option>
        <option value="12">12</option>
        <option value="14">14</option>
        <option value="16">16</option>
        <option value="18">18</option>
        <option value="20">20</option>
        <option value="22">22</option>
        <option value="24">24</option>
        <option value="25">25</option>
        <option value="26">26</option>
        <option value="27">27</option>
        <option value="28">28</option>
    </select>


Thanks - Danny

When I run

'select 1700-price as blah from goldclose as t2 order by dayid desc limit 1'

by itself in mysql I get a numerical result: one row, one column.

In my php script, the 1700 is actually a variable. so here it is

$changequery = sprintf("select $goldprice-price as change from goldclose order by dayid desc limit 1");
$change = mysql_query(changequery);
while ($row = mysql_fetch_array($change)) {
    printf("$row[0]"); 
}

mysql_free_result($changeresult);


I get the following error,

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/root/fuzzy/htmlmain4.php on line 99

Warning:  mysql_free_result(): supplied argument is not a valid MySQL result resource in <b>/root/fuzzy/htmlmain4.php on line 103

Not sure why? All i want is to get the result of that select statement into a variable such as $change

Hi, I have come up with the following code, I need it to get the details of several scattered products and echo the results, the trick is I don't want it to echo the results one after the other... I want to have the products scattered between unique text on the page but don't want to run the query several times for performance reasons.

E.g.- PAGE to look like this:

$Product_1

unique text/images

$Product_2
$Product_3

unique text/images

$Product_4


Current Code:

Code: [Select]
<?
$result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");
while($row = mysql_fetch_array($result))
  {
    $x = "1";
      while ($x<=3)
{
          echo $x;
          $Product = "Product_";
          $Product = $Product.$x;
          echo $Product;
          $Product = $row['Product_ID'];
          echo $Product;
          $x++;
          echo $x;
        }
  }

At the moment it returns the following results:

Quote

1
Product_1
465
2

2
Product_2
465
3

3
Product_3
465
4

1
Product_1
475
2

2
Product_2
475
3

3
Product_3
475
4


A few problems...

In Blue... it duplicates for product 465
In Red... It repeats again for 475
Also.... it starts with 465, but I want it to go in order as how it appears - $result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");  so should start with 475


I want to get the following result:

Quote

1
Product_1
475
2

2
Product_2
465
3

3
Product_3
234
4

4
Product_4
567
4

(and so on.....)



If anyone could provide me assistance with my troubled 'while loop' statement that would be much appreciated! 

Hi I am new to php,  I am trying to capture the url and place into a variable but I only get the 1st digit to show,  I just cant see what I am doing wrong. 

Sorry to ask such a basic question but I just can't work it out,  I have attached a screen shot of all me code, your help would be very very much appreciated.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/aci/docs/admin/hours.php on line 20

Code: [Select]
<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}

?>
Code: [Select]
CREATE TABLE `hours` (
  `hoursID` int(5) NOT NULL auto_increment,
  `member` varchar(20) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`hoursID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `hours`
--

INSERT INTO `hours` VALUES (4, 'aci', '2010-11-30', '14:31:39');
INSERT INTO `hours` VALUES (2, 'aci', '2010-11-30', '14:31:08');
INSERT INTO `hours` VALUES (3, 'aci', '2010-11-30', '14:31:23');
INSERT INTO `hours` VALUES (5, 'aci', '2010-11-30', '14:31:40');
       

Im doing a search system and Im having some problems. I need to search in two tables (news and pages), I already had sucess doing my search system for just one table, but for two tables its not easy to do. I already use a select statment with two tables using UNION because I want to show number of search results, that is number of returned rows of my first sql statment. But now I need to do a select statment that allows me to acess all fields of my news table and all fields of my pages table. I need to acess in my news table this fields: id, title, content, link, date, nViews I need to acess in my pages table this fields: id, title, content, link Im trying to do this also with UNION, but in this case Im not having any row returning. Do you see what I have wrong in my code?   <?php
//first I get my $search keyword
$search = $url[1];

$pdo = connecting();
//then I want to show number of returned rows for keyword searched
$readALL = $pdo->prepare("SELECT title,content FROM news WHERE title LIKE ? OR content LIKE ?
UNION SELECT title,content FROM pages WHERE title LIKE ? OR content like ?");
$readALL->bindValue(1,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(2,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(3,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(4,"%$search%", PDO::PARAM_STR);
$readALL->execute();
//I show number of returned rows
echo '<p>Your search keyword returned <strong>'.$readALL->rowCount().'</strong> results!</p>';
//If dont return any rows I show a error message
if($readALL->rowCount() <=0){
echo 'Sorry but we didnt found any result for your keyword search.';
}
else{
//If return rows I want to show, if it is a page result I want to show title and link that I have in my page table
//if it is a news result I want to show title and link that I have in my news table and also date of news
echo '<ul class="searchlist">';
$readALL2 = $pdo->prepare("SELECT * FROM news WHERE status = ? AND title LIKE ? OR content LIKE ? LIMIT 0,4
UNION SELECT * FROM pages where title LIKE ? OR content LIKE ? LIMIT 0,4");
$readALL2->bindValue(1, '1');
$readALL2->bindValue(2, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(3, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(4, "%$search%", PDO::PARAM_STR);
$readALL2->execute();

while ($result = $readALL2->fetch(PDO::FETCH_ASSOC)){
echo '<li>';
echo '<img src="'.BASE.'/uploads/news/'.$result['thumb'].'"/>';
echo '<a href="'.BASE.'/news/'.$result['id_news'].'">'.$result['title'].'</a>';
//if it is a news result I also want to show date on my list
//echo '<span id="date">'.$result['date'].'</span>';
echo '</li>';
}
echo ' </ul>';
//but how can I do my select statement to have access to my news table fields and my page table fields??
}
?>

I am really lost here with this date issue of mine. The below code is the last part of a query:
Code: [Select]
$defendercheck_3 = $row_checkifattacked3['atdate'];
$defendercheck1_3 = strtotime("$defendercheck_3");
$defendercheck2_3 = date("D", $defendercheck1_3);
The query does not return any results as expected, but when echoing the various steps I get following:

echo "$defendercheck3"; = nothing (as expected)

echo "$defendercheck1_3"; = nothing (as expected)

echo "$defendercheck2_3"; =  result! (NOT expected)

why does it return anything on "date("D", $defendercheck1_3)" when "$defendercheck1_3" is blank?

Hello everyone,

I'm working on an account update page where users can update their email address, password, or security question/answer as desired.  The way I currently have it set up is so that only the information that the user enters will be updated in the database.  So if they only enter a new email address, the email field in the database is updated and all other fields are left as is.

I'm also trying to set a javascript even handler (onUnload) depending on whether or not anything was updated.  When their info is successfully updated, I want to alert the user accordingly, as well as when no information was updated.  To do this, I have a variable "$updated" that is set at "false" by default and is supposed to be set to "true" when something is updated and "none" when nothing is updated.  The form and mysql commands are working and the correct fields are being updated as expected.  The problem that I'm having is the $updated variable is not being set correctly and is ALWAYS being set to "true", even when it is expect to be set to "none." Here's the code that I have:

Code: [Select]
<?php
function safe($value){
    return mysql_real_escape_string($value);
}

$updated = "false";

if (isset($_POST['submit'])) { // If the form has been submitted.

$newemail = $_POST['newemail'];
$pword1 = $_POST['pword'];
$question = safe($_POST['question']);
$answer = safe($_POST['answer']);
$updated = $_POST['updated'];

$pword = md5($pword1);

$q = mysql_query("SELECT * FROM `signin` WHERE email = '$newemail'") or die (mysql_error());
$r = mysql_num_rows($q); // Checks to see if anything is in the db.

if ($r == 1 && $email == $newemail) {

$noemail = "true";

} elseif ($r == 0) {

$noemail = "true";

} else {

$noemail = "false";

}

if ($newemail != "" && $pword1 == "" && $question == "0") {

if ($noemail == "true") {

mysql_query("UPDATE `signin` SET `email` = '$newemail' WHERE email = '$email'") or die (mysql_error());

$_SESSION['email'] = $newemail;

$updated = "true";

}

} elseif ($newemail == "" && $pword1 != "" && $question == "0") {

mysql_query("UPDATE `signin` SET `pword` = '$pword' WHERE email = '$email'") or die (mysql_error());

$updated = "true";

} elseif ($newemail == "" && $pword1 == "" && $question != "0") {

mysql_query("UPDATE `signin` SET `question` = '$question',`answer` = '$answer' WHERE email = '$email'") or die (mysql_error());

$updated = "true";

} elseif ($newemail != "" && $pword1 != "" && $question == "0") {

if ($noemail == "true") {

mysql_query("UPDATE `signin` SET `email` = '$newemail',`pword` = '$pword' WHERE email = '$email'") or die (mysql_error());

$_SESSION['email'] = $newemail;

$updated = "true";

}

} elseif ($newemail != "" && $pword1 == "" && $question != "0") {

if ($noemail == "true") {

mysql_query("UPDATE `signin` SET `email` = '$newemail',`question` = '$question',`answer` = '$answer' WHERE email = '$email'") or die (mysql_error());

$_SESSION['email'] = $newemail;

$updated = "true";

}

} elseif ($newemail == "" && $pword1 != "" && $question != "0") {

mysql_query("UPDATE `signin` SET `pword` = '$pword',`question` = '$question',`answer` = '$answer' WHERE email = '$email'") or die (mysql_error());

$updated = "true";

} elseif ($newemail != "" && $pword1 != "" && $question != "0") {

if ($noemail == "true") {

mysql_query("UPDATE `signin` SET `email` = '$newemail',`pword` = '$pword',`question` = '$question',`answer` = '$answer' WHERE email = '$email'") or die (mysql_error());

$_SESSION['email'] = $newemail;

$updated = "true";

} 

} else {

$updated == "none";

}
}
?>

//This is where the event handler (onUnload) is set according to what has occurred in the code above

<?php
if (isset($_POST['submit']) && $updated = "true") {

echo "<body onUnload=\"alert('Your information has been successfully updated.')\">";


} elseif (isset($_POST['submit']) && $updated = "false") {

echo "<body onUnload=\"alert('There have been no updates made to your account information.')\">";

} else {

echo "<body>";

}
?>

Can anyone see a problem with this and why the $updated variable is not being set as expected.  Any ideas on a better way to accomplish what I want to do?  Thanks in advance for anyone's help!

I wish to find a way to test if multiple sites are up or not.

I have been using get_headers but it seems that this does not do what I thought I would.

I wish to know if the sites are down or not.

Is there another function that can test what state the site is in.

i.e.  server not found, server issues prevented the page from showing...

Using get_headers will still show the site is live even if the server is not found, due to server problems, if any.

Hello I want to check that a variable the user enters is not empty and that it is a string (no numbers). Here is what i have written:

Code: [Select]
<?php
include('css/layout.css.php');
include('css/menu.css');
if (isset($_POST['submit'])) {
include('includes/dbconn.php');
if (is_string($_POST['name']) && strlen($_POST['name']) > 0) {
$name = mysql_real_escape_string($_POST['name']);
} else {
echo "Category name must be a word!<br />";
}
if (isset($name)) {
echo $name;
} else {
echo "something";
}
}
?>
and this is the form i'm getting the data from:

Code: [Select]
<form action="category_add.php" method="post">
<table class="table-view">
  <tr>
    <td><label for="name">Category Name</label></td>
    <td><input type="text" name="name" id="name"></td>
  </tr>
  <tr>
  <td><input type="submit" value="Save changes" name="submit" id="submit"></td>
  </tr>
</table>
     </form>
If i enter nothing it works fine, if i enter a string it also works fine, the problem is when i enter 123 in the textbox, i dont get the "Category name must be a word!" as i expected i would. Could someone help me with this one please?

Thanks in advance.