PHP - Pulling And Updating Data From A Seperate Db Table

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?


<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

 = array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>


an example XML file would be:
Code: [Select]
<!--
 Automatically generated data from EVE-Central.com
-->
<!-- This is the new API :-) -->
−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

Code: [Select]
id: 20 Reason: this is a test
id: 21 Reason: Tests
id: 22 Reason: Lolcatz
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: 36 Reason: Test
As you can see on the 2nd code box there are id's 20,21,22 and 36 in the database the rest are not active in the database.

i am using using Code: [Select]
for to pull out the id that starts with the lowest value in the database, and only have it run until it gets to the maximum value.
Code: [Select]
for ($id=$set_min; $set_max<=7; $id++)
{
                // $id=$set_min is pulling the smallest value and $set_max is pulling the maximum value so it stops  after it gets to 36
$query=mysql_query("SELECT * FROM posted WHERE id = $id");
$query_row=mysql_fetch_array($query);

$reason = $query_row[reason];
$pulled_id = $query_row[id];
$pulled_pic22 = $query_row[picture];
$href_pull = "<a href=" . "search.php?id=" . "$id" .">";

echo "<td>" . $href_pull . "<img src=$pulled_pic22 height=200 width=150 />" . "</td>";
}

how would i make it so i do not pull the values 23-35 which are not in the active database.

Example: http://dev.hackmuch.com/of-the-day/search.php?id=36

Hi again all,

Why does the foreach loop im doing, put the array values from collection, into seperate table rows rather than 1 row per whole array?



    <?php
        class registration{                    
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            public $connection;
            
            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }
            
            function insertRow($collection){      
                    //HERE
                    foreach($this->fields as $row => $value){
                        mysql_query("INSERT INTO $this->table ($value)
                        VALUES ('$collection[$row]')");
                    }
                    
                    mysql_close($this->connection->connectData);
            }
            
            function validateFields(){            

                $this->connection = new connection();
                $this->connection->connect(); 
                        
                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);                
                array_unshift($this->fields, $this->dateEntryName);   
                
                foreach($this->data as $value){
                    echo "$value";
                }
                
                $this->insertRow($this->data);
            }
        }
        
        $registration = new registration();
        $registration->validateFields();
    ?>




I end up with 3 rows

row 1: username
row 2: email
row 3 : password

rather than row 1:username email password.

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

index.php?page=1 that link style but there is not hard files it is all to be stored in the DB

here is what i have got so far

Code: [Select]
<?

$result = mysql_query("SELECT * FROM page") or die(mysql_error());
$row = mysql_fetch_array( $result );

if(isset($_GET['page'])) {
echo $row['text'];
} else {
$result = mysql_query("SELECT * FROM page
 WHERE id='1'") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo $row['text'];
}
?>
but always shows page ID 1 (home page) so i no i am missing something just not sure what hehe

DB structu
Code: [Select]
menu
----id (auto increase)
----name (home, about etc)
----id2 (page weight)
pages
----id (auto increase)
----name (page name home, about etc)
----text (page text)


link structure from the menu

Code: [Select]
<?

$result = mysql_query("SELECT * FROM menu ORDER BY id2") or die(mysql_error()); 


?>
<table>
<?
while($row = mysql_fetch_array( $result )) { ?>

<tr><td>
<a href="index.php?page=<? echo $row['id'];?>"><? echo $row['name']; ?></a>
</td></tr> <?
}
?>
</table>


dont think i have missed any info that i have on file but not sure why it will not link so thought of you guys hehe

Thanx in advance

OK, I've scoured the forms on here, searched and tutorial read and even pulled out an old PHP book. Alas, I'm stumped.

First off, my two tables that I'm trying to pull data from:

rubric
-------------------------------------
---- code ---- | ---- title --------
-------------------------------------
ABCD            | Category Name


schedule
----------------------------------------------------
------ name ------ | ------ short_title ------
----------------------------------------------------
ABCD-123-4569   | Title Is Here


Now, none of these share the same value, per say. rubric.code shares the first THREE letters from schedule.name, but that is all.
What I'm trying to do is something similar to the old:

A
apple
automobile

B
banana
basket
bench

C
car
child
crumb

... etc, etc, where the letter heading is actually the rubric.title value and then underneath it it lists all the matching short_title from
schedule where the first four letters of schedule.name match the value of rubric.code - if that even makes sense.

Unfortunately these are the tables I have to work with. If anyone out there has any ideas, I would be thrilled to hear them. Another
thing that is driving me crazy is that this server I'm working on doesn't have error reporting turned on so I've been stuck with just a
white screen to let me know something is amiss.

I'm running PHP Version 5.3.3-7+squeeze8 if that helps.

Thank you!

Ok I have a fairly straight forward question. I am designing a baseball website and I am trying to add in a schedule, here is what I have:

Data Bases
1) Teams DB - Each team has a unique team ID, location, logo, and owner
2) Schedule DB - Each game has a unique game ID, and the schedule is set up like this: AWAY = Team ID, HOME = Team ID....

So I assume I am using the JOIN command to pull the schedule from both databases, any idea how the SQL command would look?

Hey Guys,

I'm struggling with some logic of how to do something wondering if anyone can point me in the right direction.

Details:
I am making a PHP/MySQL game to learn more PHP, I've got my login/logout system created. However I am planning on the game been map based on a 100x100 grid. I have two tables:

USERS
Username, Password, x, y
Test, Test, 1, 1


MAP
X, Y, type
0,1,1
0,2,1
0,3,2
0,4,3
0,5,2
etc

I am stuck on how to get the user's logged in X and Y coordinates and then compare them with the map table X and Y, to see what type of field to show, 1,2 or 3.

Is there a name for this type of function so I can do some research on it? Or could someone give me an example? Would be fantastic if anyone has any advice.

Thanks in advance
NewcastleFan

what is the best way yo do this?

Code: [Select]
<b><font color=green>Get me out please </font> . </b>
thanks in  advance

Hey!

I have it so users can submit info to my site. They have to check some check boxes and radio buttons. I want them to be able to edit this information, so I want to have the data pulled from the MySQL database and have the correct radio button selected (and the text bolded). So I'm thinking some sort of array to check for each value in the database... but I don't really know.

There are a few groups of radio boxes and check boxes but here is an example of one.

Code: [Select]
<input type="radio" name="stage" value="Stage 1" /> Stage 1
 <input type="radio" name="stage" value="Stage 2" /> Stage 2
 <input type="radio" name="stage" value="Stage 3" /> Stage 3

The information is pulled from the database like this:

Code: [Select]
$res=mysql_query("SELECT * FROM ACTIVE WHERE INDEX_ID=$id");
if(mysql_num_rows($res)==0) echo "There is no data in the table <br /> <br />";
else
{
 for($i=0;$i<mysql_num_rows($res);$i++)
 {
  $row=mysql_fetch_assoc($res);
 }
}

So when I pull information (lets say I want to echo it) it'd look like this:

Code: [Select]
$row[STAGE]
The value for the stage selection can only be Stage 1, Stage 2 or Stage 3 so I need it to be selected when the page loads.

Thanks!

Hi,

I have a table that contains posts and each post has a datetime field.

Im trying to work out how I can show entries from today, this week and this month so I can have a link that shows all posts from today or this month etc.

Any one know how I can do this ? My current piece of code that pulls the data from the db looks like this :

Code: [Select]
$texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6");
I want to add a bit that acts like : WHERE date = today


Hope that makes sense, Im a bit of a newbie

Thanks in advance,

Scott

Hi,

having problems getting checkboxes to display all reuslts when a user selects more than one check box say in the category section and one in the location section - see page http://www.partyco.co.uk/event-and-party-venues/ - submit to see reults page:

I managed to get it to display reults if the user only seletc either a right or left column option OR one of each - BUT not when thet select multiple categories and one location - and ideas how to do this ? putting it into an array perhaps - but how - new to some of this....

here is the code for the reults page:
Code: [Select]
<?php
$location = $_POST[location];
$category = $_POST[category];
?>

<?php

$Link = mysql_connect("xxxxxxxxx", "xxxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

// selects db listings when location not given
if (empty($location)) {
$query = "SELECT * FROM venues WHERE category = '$category' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when category not given
} elseif(empty($category)) {
$query = "SELECT * FROM venues WHERE location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when both given
}else {
$query = "SELECT * FROM venues WHERE category = '$category' and location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());
}

while($row = mysql_fetch_array($result)){
echo "<div class=\"resultsShort\" style=\"margin-bottom:10px;\">";
echo "<h2 id=\"resultsHeading\">";
echo $row['title'];
echo "</h2>";
echo "<p class\"resultspara\">". nl2br($row['description']). "</p>";
echo "<h4 style=\"margin:5px 0 0 0; padding:0;\">Contact details</h4>";
echo "<p class\"resultspara\">". nl2br($row['contact']). "</p>";
echo "<div style=\"float:left; width:124px; height:40px; margin:10px 15px 0 0;\">";
echo "<a href=\"/party-supplier-resources/email-supplier.php?title=". $row['title']. "&email=" . $row['email']. "&location=" . $row['location']. "&category=" . $row['category']. "\" title=\"contact this venue here\">";
echo "<img src=\"/images/email-supplier.jpg\" width=\"124\" align=\"right\" height=\"35\" alt=\"contact this supplier button\" border=\"0\" /></a>";
echo "</div>";
echo "</div>";
}


?>


<?php include("../include/shareLinks.php"); ?>


<div id="popupContact">
<a id="popupContactClose" title="close this window">close x</a>
<h1>Supplier Directory Enquiry Form</h1>
<?php include("../include/enquiryform.php"); ?>
</div>
<div id="backgroundPopup"></div>


<?php
mysql_close ($Link);
?>
Any help appreciated!

Aaron

MOD EDIT: [code] . . . [/code] BBCode tags added.