PHP - Database And Php 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!

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!