PHP - Php, My Sql And Database Help

Hi guys,

I was just wondering if anyone could help me. I've got a My_SQL database containing articles, a summary for the article and a date. I have a basic CMS system set-up, but I want to create a script that when users sign up to a mail list it forwards the summary and dates of the articles database. If that makes sense? But I only want it to forward the most recent 5 rows. I'm pretty new to PHP and I've been mostly following tutorials thus far, but this is quite specific.

Thanks in advance!

hello
I want query from one table and insert in another table on another domain .
each database on one domain name.
for example http://www.site.com $con1
and http://www.site1.com $con.

can anyone help me?
my code is :
<?php



$dbuser1 = "insert in this database";
$dbpass1 = "insert in this database";
$dbhost1 = "localhost";
$dbname1 = "insert in this database";

// Connecting, selecting database

$con1 = mysql_connect($dbhost1, $dbuser1, $dbpass1)
   or die('Could not connect: ' . mysql_error());



mysql_select_db($dbname1) or die('Could not select database');


$dbuser = "query from this database";
$dbpass = "query from this database";
$dbhost = "localhost";
$dbname = "query from this database";

// Connecting, selecting database

$con = mysql_connect($dbhost, $dbuser, $dbpass)
   or die('Could not connect: ' . mysql_error());

mysql_select_db($dbname) or die('Could not select database');

//query from database
$query = mysql_query("SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1");
    while($row=mysql_fetch_array($query)){
$result=$row[0];
$text=$row[1]."</br>Size:(".$row[4].")";
$alias=$row[2];
$link = '<a target="_blank" href='.$row[3].'>Download</a>';
echo $result;
}  
//insert into  database
mysql_query("SET NAMES 'utf8'", $con1); 
$query3= " INSERT INTO `jos_content`
 (`id`,
  `title`,
   `alias`,
    `) VALUES 
                        (NULL, 
                        '".$result."', 
                        '".$alias."', 
                       '')";
if (!mysql_query($query3,$con1))
  {
  die('Error: text add' . mysql_error());
  }


            mysql_close($con);
                        mysql_close($con1);
             


?>

the second database found on the cloud

 

i try to get JSON data but how to insert and update  them to another online database with the same table

my php script to return json data 

<?php        

 include_once('db.php');

        $users = array();

        $users_data = $db -> prepare('SELECT id, username FROM  users');

        $users_data -> execute();

        while($fetched = $users_data->fetch()) {

            $users[$fetchedt['id']] = array (

                'id' => $fetched['id'],

                'username' => $fetched['name']

            );

        }

        echo json_encode($leaders);

 

 

 

 

i get

 

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

 

Edited March 24 by mahenda

<?php
$image_url = 'images/';
 
//User defined variables for page settings
$rows_per_page = 2;
$cols_per_page = 4;
 
//Master array of ALL the images in the order to be displayed
$images = array(
        'image1.jpg', 'image2.jpg', 'image3.jpg', 'image4.jpg',
        'image5.jpg', 'image6.jpg', 'image7.jpg', 'image8.jpg',
        'image9.jpg', 'image10.jpg', 'image11.jpg', 'image12.jpg',
        'image13.jpg', 'image14.jpg', 'image15.jpg', 'image16.jpg',
        'image17.jpg', 'image18.jpg', 'image19.jpg'
    );

//END USER DEFINED VARIABLES
 
//System defined variable
$records_per_page = $rows_per_page * $cols_per_page;
$total_records = count($images);
$total_pages = ceil($total_records / $records_per_page);
 
//Get/define current page
$current_page = (int) $_GET['page'];
if($current_page<1 || $current_page>$total_pages)
{
    $current_page = 1;
}
 
//Get records for the current page
$page_images = array_splice($images, ($current_page-1)*$records_per_page, $records_per_page);
 
//Create ouput for the records of the current page
$ouput = "<table border=\"1\">\n";
for($row=0; $row<$rows_per_page; $row++)
{
    $ouput .= "<tr>\n";
    for($col=0; $col<$cols_per_page; $col++)
    {
        $imgIdx = ($row * $rows_per_page) + $col;
        $img = (isset($page_images[$imgIdx])) ? "<img src=\"{$image_url}{$page_images[$imgIdx]}\" />" : '&nbsp;';
        $ouput .= "<td>$img</td>\n";
    }
    $ouput .= "</tr>\n";
}
$ouput .= "</table>";
 
//Create pagination links
$first = "First";
$prev  = "Prev";
$next  = "Next";
$last  = "Last";
if($current_page>1)
{
    $prevPage = $current_page - 1;
    $first = "<a href=\"test.php?page=1\">First</a>";
    $prev  = "<a href=\"test.php?page={$prevPage}\">Prev</a>";
}
if($current_page<$total_pages)
{
    $nextPage = $current_page + 1;
    $next = "<a href=\"test.php?page={$nextPage}\">Next</a>";
    $last = "<a href=\"test.php?page={$total_pages}\">Last</a>";
}
 
?>
<html>
<body>
<h2>Here are the records for page <?php echo $current_page; ?></h2>
  <ul>
    <?php echo $ouput; ?>
  </ul>
Page <?php echo $current_page; ?> of <?php echo $total_pages; ?>
<br />
<?php echo "{$first} | {$prev} | {$next} | {$last}"; ?>
</body>
</html>

This current code provides an easy way of uploading pictures and having the other pictures move automatically without the need of a database. But I must wonder, if doing this on a database would be faster. Would it be? I mean the example adobe shows I'm only using 19 pictures, but if I ever reach say 1000 pictures, would the php file be too big? Should I just make a database now or it doesn't matter?

Also, the code above, which I took from a phpfreak member, has the pagination not working. Anyone care to do a diagnosis?

Thanks!

Hi there,

*little heads up: English isn't my native language, so excuse me for any mistakes in spelling etc.*

I've got a register/login script with activation mail, I secure my pages with this bit of code:

Code: [Select]
}

 if (!$HTTP_SESSION_VARS["ingelogd"])
    {
        header("Location: login.php");
}
Because if someone logs in, the session is made:

Code: [Select]
// bekijk of de gegevens juist zijn
        if (mysql_num_rows($res) >= 1)
        {
            // registreer sessie (of cookie)
            $ingelogd = mysql_result($res, 0);
            session_register(ingelogd);
            // setcookie("ingelogd", "$ingelogd", time() + 1 * 86400);
            echo "<p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: #000000;\">
U bent succesvol ingelogd.</p>";

            echo "<p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: #000000;\">
Klik hier om <a href=\"home.php\">verder</a> te gaan.</p>";
                       
        }


My question: When someone registered, they entered their 'real' name, which is then placed into the database in the same row
as the username, password etc. I would like to state on the homepage which is secured 'Welcome 'Name'!' I do I get this 'Name' value
out of the database and into my page?

Thanks in advance!

Sander

Not sure if I can post this here, or if I should go to a mySQL forum but...     
I'm trying to keep track of my user's "score". Each time they do a certain thing they get a preset amount of points, depending on what they did. The way I see it would be having a table that is joined to the user's ID, and have a column for each task. Then when they do a task the number in that column will go up. Then I will multiply that number by amount the task is worth. I can't just adjust there score because they need to be able to see what they did.

So I hope that made sense. And if you know a better way to deal with this please let me know!

Hi,

Just need to know if I am on the right lines, basically I am about to create two tables; one to hold customer information and another to hold information the customer gave me. Both tables will be populated with information that they give me at the same time (in other words from a single form).

Just want to know, if I have a field called ID set to a primary key in both the tables, will that be enough to link them both together?

Furthermore, what would the mySQL code look like if I wanted to view all the information referencing to specific ID? so info from the customer table and the other.

Any and all help would be great.

Lee

When I do this:

$matches++;

$sql_update_matches = mysql_query("UPDATE Live_Event SET matches='$matches' WHERE id='$show_id' AND promo_id='$promotion_id'");

But when it should update the database from 0 to 1, it update it to U. What is the problem?

Hello everyone,

I have put together a HTML form in which data is being collected, then verified with a PHP script before being posted into a SQL database.

Is there anyway I can auto assign a unique ID to a database entry other than the default auto increment ID field?

I want to be able to assign random ID numbers to tickets for an event and was hoping that something could be achieved in SQL..?

Many thanks,

BB2011

i have got this code and i can get everything to work on this except the part to get the drop down menu for the sections, i can get the 4 sections to show but every time i try to add something to any section it is added to the last section no matter what please help

Code: [Select]
<?php
require("connection/connection.php");
include("connection/functions.php");
?>
<HTML>
    <head>
        <link href="css/style.css" rel="stylesheet" media="screen" type="text/css" />
        <script src="javascript/functions.js" type="text/javascript"></script>
        <title>.: Bookmarks :.</title>
    </head>
    <body class="musiclist">
        <div id="content" style="top: 36px">
        <form method="post" action="AddBookmark.php">
                <span class="graytitle">Add Bookmark</span>
                <ul class="pageitem">
                    <li class="bigfield"><input type="text" name="BookmarkName" placeholder="Bookmark Name" /></li>
                    <li class="bigfield"><input type="text" name="KindofBookmark" placeholder="Kind of Bookmark" /></li>
                    <li class="bigfield"><input type="text" name="BookmarkLink" placeholder="Bookmark Link" /></li>
                    <li class="select"><select name="d">
                        <?php 
                            $getbookmarksections = mysql_query("SELECT * FROM bookmarksections");
                            confirm_query($getbookmarksections);
                            
                            while($getbm = mysql_fetch_array($getbookmarksections)){
$bmid = $getbm["ID"];
$sn = $getbm["SectionName"];
echo "<option value=\"$bmid\">$sn</option>";
}
                        ?>
                    </select><span class="arrow"></span></li>
                    <li class="button">
                    <input name="AddBookmark" type="submit" value="Add Bookmark" />
                    </li>
                </ul>
            </form>
            <?php
if(isset($_POST["AddBookmark"])){
$Bookmark = $_POST["BookmarkName"];
$KindofBookmark = $_POST["KindofBookmark"];
$BookmarkLink = $_POST["BookmarkLink"];

$add = mysql_query("INSERT INTO `bookmarks` (`ID`,`SectionID`,`KindofBookmark`,`Bookmark`,`BookmarkLink`)
VALUES ('NULL','$bmid','$KindofBookmark','$Bookmark','$BookmarkLink')");
confirm_query($add);
  if($add == TRUE){
  echo "<span class=\"graytitle\">Bookmark '$Bookmark' in '$sn' Added.</span>";
  }
}
                ?>
        </div>
        <div id="footer">
        </div>
    </body>
</HTML>
<?php 
//Close Connection
if(isset($connection)){
mysql_close($connection);
}
?>

I have two tables one with minfo and other is user both have u_id .

i want to access that id in minfo so that it updates with information by that id of user in that data.

somehow  u_id becomes primary of second table and primary of 1st table.

how should i update the value of u_id in second table any help will be appreacited.

 

I created a tabase with two tables.

1) Customers
2) Software

My customers form adds data to the customers table, but on my form I want to assign one or more pieces of software to that particular customer. How do I link up the tables to work that way? My customers table has a unique id.

Im using dreamweaver and php my admin

Thanks in advance

Hi I wondering what i did wrong he
I wont to register 1 or 0 into database. 


Checkbox file:
  <?php 

Hi guys,

I have had to make some changes to a database that I updated hockey players stats with. Since doing this I can no longer edit player stats in my admin section of the website. I was wondering if someone could possibly have a look at it for me. It is driving me nuts not being able to fix it.

What should happen is: I choose the player from a list of teams to update. Their stats show up on next page in a table for the different competitions they play in (league, cup, play-offs). I could then update the stats and then once pressing the edit button at the bottom, this then updates my SQL database.

Can anyone help?
<?php if ($stat==1) { 
// normal players 
$table = "players"; }
else  {
// snl_players
$table ="snl_players"; }

if ($act==edit) {
$query11 = "SELECT * FROM `$table` WHERE `PlayerID` = '$PlayerID'";
$result11 = mysql_query($query11) or die ('Error: Sh2');
$rows = mysql_fetch_array($result11);
$PlayerID = $rows['PlayerID'];
$TeamID = $rows['TeamID'];
$Team = $rows['Team'];
$Player = $rows['Player'];
$Games = $rows['Games'];
$Goals = $rows['Goals'];
$PPGoals = $rows['PPGoals'];
$SHGoals = $rows['SHGoals'];
$Assists = $rows['Assists'];
$PIM = $rows['PIM'];
$Points = $rows['Points'];
$GamesCup = $rows['GamesCup'];
$GoalsCup = $rows['GoalsCup'];
$PPGoalsCup = $rows['PPGoalsCup'];
$SHGoalsCup = $rows['SHGoalsCup'];
$AssistsCup = $rows['AssistsCup'];
$PIMCup = $rows['PIMCup'];
$PointsCup = $rows['PointsCup'];
/* $GamesNPL = $rows['GamesNPL'];
$GoalsNPL = $rows['GoalsNPL'];
$PPGoalsNPL = $rows['PPGoalsNPL'];
$SHGoalsNPL = $rows['SHGoalsNPL'];
$AssistsNPL = $rows['AssistsNPL'];
$PIMNPL = $rows['PIMNPL'];
$PointsNPL = $rows['PointsNPL']; */
$GamesPO = $rows['GamesPO'];
$GoalsPO = $rows['GoalsPO'];
$PPGoalsPO = $rows['PPGoalsPO'];
$SHGoalsPO = $rows['SHGoalsPO'];
$AssistsPO = $rows['AssistsPO'];
$PIMPO = $rows['PIMPO'];
$PointsPO = $rows['PointsPO'];
$Nationality = $rows['Nationality'];

$query11 = "SELECT * FROM `teams` WHERE `TeamID` = '$TeamID'";
$result11 = mysql_query($query11) or die ('Error: Sh2');
$rows = mysql_fetch_array($result11);
$TeamName = $rows['TeamName'];


echo ("<form name=\"form1\" method=\"post\" action=\"playerstats.php?act=editdo&PlayerID=$PlayerID&stat=$stat\">
  <table width=\"80%\" border=\"0\">
    <tr>
      <td width=\"30%\" class=\"data\">Player Name </td>
      <td width=\"70%\"><input name=\"Player\" type=\"text\" id=\"Player\" value=\"$Player\"></td>
    </tr>
    <tr>
      <td class=\"data\">Associated Team ID </td>
      <td class=\"data\">  <select name=\"TeamID\">");
  
$query11 = "SELECT * FROM `teams`";
$result11 = mysql_query($query11) or die ('Error: Sh2');
while ( $rows = mysql_fetch_array($result11) ) {
$TeamName = $rows['TeamName'];   
$TeamID2 = $rows['TeamID'];
  
  if ($TeamID==$TeamID2) { echo("    <option value=\"$TeamID2\" selected>$TeamName</option>"); } else {
  echo("    <option value=\"$TeamID2\">$TeamName</option>"); }
  }
  
  
  echo("</select></td>
    </tr>
    <tr>
      <td class=\"data\">Games</td>
      <td><input name=\"Games\" type=\"text\" id=\"Games\" size=\"6\" value=\"$Games\"></td>
    </tr>
    <tr>
      <td class=\"data\">Goals</td>
      <td><input name=\"Goals\" type=\"text\" id=\"Goals\" size=\"6\" value=\"$Goals\"></td>
    </tr>    <tr>
      <td class=\"data\">PPGoals</td>
      <td><input name=\"PPGoals\" type=\"text\" id=\"Goals\" size=\"6\" value=\"$PPGoals\"></td>
    </tr>    <tr>
      <td class=\"data\">SHGoals</td>
      <td><input name=\"SHGoals\" type=\"text\" id=\"Goals\" size=\"6\" value=\"$SHGoals\"></td>
    </tr>
    <tr>
      <td class=\"data\">Assists</td>
      <td><input name=\"Assists\" type=\"text\" id=\"Assists\" size=\"6\" value=\"$Assists\"></td>
    </tr>
    <tr>
      <td class=\"data\">PIM</td>
      <td><input name=\"PIM\" type=\"text\" id=\"PIM\" size=\"6\" value=\"$PIM\"></td>
    </tr>
    <tr>
      <td class=\"data\">Points</td>
      <td><input name=\"Points\" type=\"text\" id=\"Points\" size=\"6\" value=\"$Points\"></td>
    </tr>
    <tr>
      <td class=\"data\">GamesCup</td>
      <td><input name=\"GamesCup\" type=\"text\" id=\"GamesCup\" size=\"6\" value=\"$GamesCup\"></td>
    </tr>  <tr>
      <td class=\"data\">GoalsCup</td>
      <td><input name=\"GoalsCup\" type=\"text\" id=\"GoalsCup\" size=\"6\" value=\"$GoalsCup\"></td>
    </tr>
<tr>
      <td class=\"data\">PPGoalsCup</td>
      <td><input name=\"PPGoalsCup\" type=\"text\" id=\"GoalsCup\" size=\"6\" value=\"$PPGoalsCup\"></td>
    </tr><tr>
      <td class=\"data\">SHGoalsCup</td>
      <td><input name=\"SHGoalsCup\" type=\"text\" id=\"GoalsCup\" size=\"6\" value=\"$SHGoalsCup\"></td>
    </tr>
    <tr>
      <td class=\"data\">AssistsCup</td>
      <td><input name=\"AssistsCup\" type=\"text\" id=\"AssistsCup\" size=\"6\" value=\"$AssistsCup\"></td>
    </tr>
    <tr>
      <td class=\"data\">PIMCup</td>
      <td><input name=\"PIMCup\" type=\"text\" id=\"PIMCup\" size=\"6\" value=\"$PIMCup\"></td>
    </tr>     <tr>
      <td class=\"data\">PointsCup</td>
      <td><input name=\"PointsCup\" type=\"text\" id=\"PointsCup\" size=\"6\" value=\"$PointsCup\"></td>
    </tr>  "); 

if ($stat==1) { } else { 
echo("
<tr><td class=\"data\">GamesPO</td>
      <td><input name=\"GamesPO\" type=\"text\" id=\"GamesPO\" size=\"6\" value=\"$GamesPO\"></td>
    </tr> <tr>
      <td class=\"data\">GoalsPO</td>
      <td><input name=\"GoalsPO\" type=\"text\" id=\"GoalsPO\" size=\"6\" value=\"$GoalsPO\"></td>
    </tr>
<tr>
      <td class=\"data\">PPGoalsPO</td>
      <td><input name=\"PPGoalsPO\" type=\"text\" id=\"GoalsPO\" size=\"6\" value=\"$PPGoalsPO\"></td>
    </tr>
<tr>
      <td class=\"data\">SHGoalsPO</td>
      <td><input name=\"SHGoalsPO\" type=\"text\" id=\"GoalsPO\" size=\"6\" value=\"$SHGoalsPO\"></td>
    </tr><tr>
      <td class=\"data\">AssistsPO</td>
      <td><input name=\"AssistsPO\" type=\"text\" id=\"AssistsPO\" size=\"6\" value=\"$AssistsPO\"></td>
    </tr><tr>
      <td class=\"data\">PIMPO</td>
      <td><input name=\"PIMPO\" type=\"text\" id=\"PIMPO\" size=\"6\" value=\"$PIMPO\"></td>
    </tr><tr>
      <td class=\"data\">PointsPO</td>
      <td><input name=\"PointsPO\" type=\"text\" id=\"PointsPO\" size=\"6\" value=\"$PointsPO\"></td>
    </tr><tr>
      <td class=\"data\">Nationality</td>
      <td><input name=\"Nationality\" type=\"text\" id=\"Nationality\" value=\"$Nationality\"></td>
    </tr> <td class=\"data\">&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td class=\"data\">&nbsp;</td>
      <td><input type=\"submit\" name=\"Submit\" value=\"Edit\"></td>
    </tr>
  </table>
</form>"); 
}

if ($stat!=0) {
$query = "UPDATE `players` 
SET `Nationality` = '$Nationality', 
`GamesPO` = '$GamesPO' , 
`AssistsPO` = '$AssistsPO' , 
`GoalsPO` = '$GoalsPO' , 
`PPGoalsPO` = '$PPGoalsPO' , 
`SHGoalsPO` = '$SHGoalsPO' , 
`PointsPO` = '$PointsPO' , 
`PIMPO` = '$PIMPO' ,
`PIM` = '$PIM' ,
`PointsCup` = '$PointsCup' ,
`PIMCup` = '$PIMCup' ,
`AssistsCup` = '$AssistsCup' ,
`GoalsCup` = '$GoalsCup' ,
`PPGoalsCup` = '$PPGoalsCup' ,
`SHGoalsCup` = '$SHGoalsCup' ,
`GamesCup` = '$GamesCup' ,
`Points` = '$Points',
`Assists` = '$Assists' ,
`Goals` = '$Goals' ,
`PPGoals` = '$PPGoals' ,
`SHGoals` = '$SHGoals' ,
`TeamID` = '$TeamID' ,
`Player` = '$Player' ,
`Games` = '$Games' 
WHERE `PlayerID` = '$PlayerID'";
$result = mysql_query($query) or die ("Can't Update");
echo ("The player has been updated.<br><br><a href=\"playerstats.php\"> Go back to the player List</a>");

} else {
$query = "UPDATE `snl_players` 
SET `PIM` = '$PIM' ,
`GamesPO` = '$GamesPO' , 
`AssistsPO` = '$AssistsPO' , 
`GoalsPO` = '$GoalsPO' , 
`PPGoalsPO` = '$PPGoalsPO' , 
`SHGoalsPO` = '$SHGoalsPO' , 
`PointsPO` = '$PointsPO' , 
`PIMPO` = '$PIMPO' ,
`PointsCup` = '$PointsCup' ,
`PIMCup` = '$PIMCup' ,
`AssistsCup` = '$AssistsCup' ,
`GoalsCup` = '$GoalsCup' ,
`PPGoalsCup` = '$PPGoalsCup' ,
`SHGoalsCup` = '$SHGoalsCup' ,
`GamesCup` = '$GamesCup' ,
`Points` = '$Points',
`Assists` = '$Assists' ,
`Goals` = '$Goals' ,
`PPGoals` = '$PPGoals' ,
`SHGoals` = '$SHGoals' ,
`TeamID` = '$TeamID' ,
`Player` = '$Player' ,
`Games` = '$Games' 
WHERE `PlayerID` = '$PlayerID'";
$result = mysql_query($query) or die ("Can't Update");
echo ("The player has been updated.<br><br><a href=\"playerstats.php\"> Go back to the player List</a>");

}
} elseif ($act==teamlist) {
$query112 = "SELECT * FROM `teams` WHERE `TeamID` = '$TeamID'";
$result112 = mysql_query($query112) or die ('Error: Sh2');
$rows2 = mysql_fetch_array($result112);
$TeamName = $rows2['TeamName'];
$Logo = $rows2['Logo'];

if ($Logo!="") { echo("<img src=\"../Images/$Logo\" /><br><br>"); } else { }
echo ("<strong>Edit $TeamName Players</strong><br><br>Click Player Names to edit details<br><br>");
$query11 = "SELECT * FROM `players` WHERE `TeamID` = '$TeamID'";
$result11 = mysql_query($query11) or die ('Error: Sh2');
while ( $rows = mysql_fetch_array($result11) ) {
$Player = $rows['Player'];
$PlayerID = $rows['PlayerID'];
$TeamID = $rows['TeamID'];


echo ("<span class=\"style1\"><a href=\"playerstats.php?act=edit&PlayerID=$PlayerID&stat=1\">$Player</a><br>");
} 
} else {
echo ("Click Team Names to view players<br><br>");
$query11 = "SELECT distinct TeamID FROM `players` ORDER BY `TeamID`";
$result11 = mysql_query($query11) or die ('Error: Sh2');
while ( $rows = mysql_fetch_array($result11) ) {
$TeamID = $rows['TeamID'];

$query112 = "SELECT * FROM `teams` WHERE `TeamID` = '$TeamID'";
$result112 = mysql_query($query112) or die ('Error: Sh2');
$rows2 = mysql_fetch_array($result112);
$TeamName = $rows2['TeamName'];

echo ("<span class=\"style1\"><a href=\"playerstats.php?act=teamlist&TeamID=$TeamID&stat=1\">$TeamName</a><br>");
} echo ("<a name=\"snl\"></a><br><strong><a href=\"snlplayerstats.php\">SNL Teams</a></strong><br><br>");

}

?>

Hey guys I am trying to read my xml file and itterate through the list. I am having trouble. 

<?xml version="1.0" encoding="UTF-8"?>
<stock>

	<itemPlace id="1">
		<name>null</name>
		<image>null</image>
		<wholeSale>44</wholeSale>
		<retailPrice>null</retailPrice>
		<quantity>null</quantity>
		<location>null</location>
		<color>null</color>
		<size>null</size>
		<weight>null</weight>
		<description>null</description>
		<itemType>null</itemType>
		<date>null</date>
	</itemPlace>
	<itemPlace id="2">
		<name>null</name>
		<image>null</image>
		<wholeSale>55</wholeSale>
		<retailPrice>null</retailPrice>
		<quantity>null</quantity>
		<location>null</location>
		<color>null</color>
		<size>null</size>
		<weight>null</weight>
		<description>null</description>
		<itemType>null</itemType>
		<date>null</date>
	</itemPlace>
</stock>

<?php 
		$xml = simplexml_load_file('stock.xml');
		foreach ($xml->xpath('itemPlace') as $eq) 
		{
			echo "<p><a class='inline' href=\"#inline_content\"> {$eq->name}</a></p>";
		    echo '<br>';
		    
		  	echo " <div style='display:none'>";
		   	echo " <div id='inline_content' style='padding:10px; background:#fff;'>";
		   	echo " <p>";
		    	
			echo "  <strong>{$eq->wholeSale}</strong>";
                        echo "</div></div>";

Is there a way I can look up the object through the itemPlace id="#" and call out the parameters of the item? Like the name price, etc?   I know how to mySQL query but not XML, and this is a project that needs to use xml... FML..I have been looking for a few hours so any help would be appreciated!