PHP - Show Top 15 Database Entries

Is there any other way of getting PHP form data into C# any other way besides calling  

www.downloadHandler.text

I am having issues  bringing all the entries into C# and breaking them all up.  I can do one row fine but multiple rows isn't working.  I keep getting an out range error.

This is my PHP echo

echo $row['userName']. '|' .$row['level']. '|' .$row['points']. '|' .$row['killRate']. '/';

And this is my C# code

                string nothing = "Not Placed";
                string Data_string = www.downloadHandler.text;
                string[] DataArray;
                DataArray = Data_string.Split('/');

                int numberOfEntries = DataArray.Length;
                Debug.Log(numberOfEntries);

                if (DataArray[0] == null || numberOfEntries == 1)
                {
                    DataArray[0] = nothing;
                    Debug.Log("Data Array [0] isn't there");
                    High_Points_1.text = DataArray[0];

                }
                else
                {
                    High_Points_1.text = DataArray[0];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[1] == null || numberOfEntries == 2)
                {
                    DataArray[1] = nothing;
                    Debug.Log("Data Array [1] isn't there");
                    High_Points_2.text = DataArray[1];
                }
                else
                {
                    High_Points_2.text = DataArray[1];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[2] == null || numberOfEntries == 3)
                {
                    DataArray[2] = nothing;
                    Debug.Log("Data Array [2] isn't there");
                    High_Points_3.text = DataArray[2];
                }
                else
                {
                    High_Points_3.text = DataArray[2];
                }
                if (DataArray[3] == null || numberOfEntries == 4)
                {
                    DataArray[3] = nothing;
                    Debug.Log("Data Array [3] isn't there");
                    High_Points_4.text = DataArray[3];
                }
                else
                {
                    High_Points_4.text = DataArray[3];
                }
                if (DataArray[4] == null || numberOfEntries == 5)
                {
                    DataArray[4] = nothing;
                    Debug.Log("Data Array [4] isn't there");
                    High_Points_5.text = DataArray[4];
                }
                else
                {
                    High_Points_5.text = DataArray[4];
                }

I have two entries in the database.  But when I debugged the number int he array I get 3 strings.

I want to show the top five entries in the database.

For some reason my for loop only seems to be storing some data in my fields, most of the time the data is not true but simply duplicating one of the entries. So instead of having a string of 1,2,3,4 for instance it would store all of them as 4. The entires are selected using fields in a multiple select box, in theory of someone choses 10 unique entries from the "Systems" category all 10 should be made into rows in the MySQL table.

Any idea why this is happening?

The form,

if ($type == "games") {

echo "<tr><td>".$name."</td><td><select name='".$name."_".$i."'[] multiple='multiple'><option value='' selected>--------</option>";

$sqla = mysql_query("SELECT * FROM ".$pre."games ORDER BY `name` ASC") or die(mysql_error());

while($row2a = mysql_fetch_array($sqla)) {
$system = mysql_fetch_array(mysql_query("SELECT * FROM ".$pre."systems WHERE id = '".$row2a[system]."'"));
echo "<option value='".$row2a[id]."'>".$row2a[name]." - ".$system[name]."</option>";
}
echo "</select></td></tr>";
}

if ($type == "system") {
echo "<tr><td>".$name."</td><td><select name='".$name."_".$i."'[] multiple='multiple'><option value='' selected>--------</option>";

$sqlb = mysql_query("SELECT * FROM ".$pre."systems ORDER BY `name` ASC") or die(mysql_error());
while($row2b = mysql_fetch_array($sqlb)) {
echo "<option value='".$row2b[id]."'>".$row2b[name]."</option>";
}
echo "</select></td></tr>";
}

The PHP code,

while($row = mysql_fetch_array($query)) {
$name = "$row[name]";

for ($i = 0; $i < count($_POST["systems_$i"]); $i++) {
   mysql_query("INSERT INTO ".$pre."fielddata VALUES (null, 'systems', '".$_POST["systems_$i"]."', '".$fetch[0]."', 'content')");
}

for ($i = 0; $i < count($_POST["games_$i"]); $i++) {
   mysql_query("INSERT INTO ".$pre."fielddata VALUES (null, 'games', '".$_POST["games_$i"]."', '".$fetch[0]."', 'content')");
}

Hi,
I want to be able to generate visitor statistics for a blog I'm creating. I'm going to be collecting numerous pieces of data when a post is viewed, including a time stamp of the visit.

I need to be able to select timestamps that were within the current day, the previous day, the day before that ect.. So that I can generate the statistics.
Show it for the current week (current day and 6 previous days).

So it would be the entries where the timestamp was made on the days: 11/1, 10/1, 9/1, 8/1, 7/1, 6/1, 5/1. For example.

Not quite sure how I could do this.

Thanks.

Hello,

I am using the following code to display images managed by a MySQL database.  Basically another program manages a bunch of images, but this script displays certain ones (ones with INCLUDE = 1 in the database) on my main page.  My question is, is there an easy way to limit the number of images it displays, say to 5?  I'm not too concerned which images actually display (ascending or descending)... or better yet, random!  Most importantly, I only want five to display.  Each image will be linked to the full page, which displays all the images.

Any ideas?

Thanks!


Code: [Select]
<?php
$username="XXXXXXX";
$password="XXXXXXX";
$database="XXXXXXX";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM ft_form_12 WHERE col_24='1'";
// $query="SELECT * FROM ft_form_12";
// SELECT * FROM ft_form_12 WHERE col_24='1'
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

<?php
$i=0;
while ($i < $num) {

$f20=mysql_result($result,$i,"col_23"); //Photo file name
$f21=mysql_result($result,$i,"col_24"); //INCLUDE
?>

<a href="http://www.domain.com/display_whole_page.shtml"><img src="http://www.domain.com/the_file/pictures/<?php echo $f20; ?>" height="50" border="0"></a>&nbsp;&nbsp;&nbsp;
               
<?php
$i++;
}
?>

Hello. Many thanks for your help.

I am writing a PHP/MySQL dating-site and have hit a programming impass.

I have a database full of members and a search form consisting of checkboxes.

So to search, a member ticks say...gender: female; age: 21,22,23,24,25,26; height: 5'4",5'5",5'6",5'7"; county: cornwall,devon,somerset

How can a run a check on the database selecting all entries that fall into the selected criteria. For example a 23 year old female of 5'5" living in Cornwall and a 26 year old female of 5'4" living in Somerset?

The key index of my database is 'id' and the fields a age,height,county
The names of the form checkboxes a
Gender: male, female; Age: 21,22,23,24 etc; Height: 5_4,5_5,5_6 etc; county: cornwall,devon etc

I coded the following but some parts are not working (the "curveball" mentioned at the end).
How would YOU do this?

I have a page (A) displaying a form with a textarea field using a WYSIWYG interface.
The user will enter a list of unordered items and upon submit the string will look something like this:

This is my list of food items:
 <ul>
  <li> Lettuce </li>
  <li> Tomatoes </li>
  <li> Eggs </li>
 <ul>




Upon submit, I need to give each list item an unique id and store this id along with the text next to it in a separate table:

List_item_id   List_item_text  List_item_state
food_1             Lettuce
food_2             Tomatoes
food_3             Eggs





The user will then land in another page with a form displaying the list. The text is now in the page itself and not in a textarea.
Instead of the bullets a dropdown list appears, and the user can select "buy" or "sell" for each list item. 
This page (B) looks something like this:

<form>
This is my list of food items:
  <br><select name="food_1">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Lettuce

  <br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Tomatoes

  <br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Eggs

<input type=submit value="submit">
</form>




When the user hits "submit" the table with the list items will be updated with the values selected in the dropdown list:

List_item_id   List_item_text  List_item_state
food_1             Lettuce        Buy
food_2             Tomatoes       Buy
food_3             Eggs           Sell



The next time the user goes to Page B the list will remember the states.


Here's the curveball: At any point the user may click on "EDIT LIST" on Page B so they may add more items (at the begining, middle or end of the string). On edit mode the list items should appear as bullets again inside the WYSIWYG interface.

Keep in mind that some of the text in the string may not be a list item (ie, "this is my list of food...")

Im trying to create a website where users login, and then when they add a new entry to the database there name is put as the author. This is how my tables are set up. One table is named job and has the columns id, jobtext, jobdate, and authorid. Another table is called author. This table contains the columns id, username, password, and name. Authorid from the job table matches with id from the author table. When a user logins in this code is used to register the name...session_start();
$_SESSION['myusername'] = $_POST['myusername'];
$_SESSION['mypassword'] = $_POST['mypassword'];
header("location: index.php");
}
else {
echo "Wrong Username or Password";
}

This is the form users use to add a new entry...
if (isset($_GET['add']))
{
$pagetitle = 'New Job';
$action = 'addform';
$text = '';
$authorid = '';
$id = '';
$button = 'Add job';

include $_SERVER['DOCUMENT_ROOT'] . '/jobs/includes/db.inc.php';

// Build the list of authors
$sql = "SELECT id, name FROM author";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching list of authors.';
include 'error.html.php';
exit();
}

while ($row = mysqli_fetch_array($result))
{
$authors[] = array('id' => $row['id'], 'name' => $row['name']);
}

// Build the list of categories
$sql = "SELECT id, name FROM category";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching list of categories.';
include 'error.html.php';
exit();
}

while ($row = mysqli_fetch_array($result))
{
$categories[] = array(
'id' => $row['id'],
'name' => $row['name'],
'selected' => FALSE);
}

include 'form.html.php';
exit();
}

if (isset($_GET['addform']))
{
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';

$text = mysqli_real_escape_string($link, $_POST['text']);
$author = mysqli_real_escape_string($link, $_POST['author']);

if ($author == '')
{
$error = 'You must choose an author for this job.
Click &lsquo;back&rsquo; and try again.';
include 'error.html.php';
exit();
}

$sql = "INSERT INTO job SET
jobtext='$text',
jobdate=CURDATE(),
authorid='$author'";
if (!mysqli_query($link, $sql))
{
$error = 'Error adding submitted job.';
include 'error.html.php';
exit();
}

$jobid = mysqli_insert_id($link);

if (isset($_POST['categories']))
{
foreach ($_POST['categories'] as $category)
{
$categoryid = mysqli_real_escape_string($link, $category);
$sql = "INSERT INTO jobcategory SET
jobid='$jobid',
categoryid='$categoryid'";
if (!mysqli_query($link, $sql))
{
$error = 'Error inserting job into selected category.';
include 'error.html.php';
exit();
}
}
}

header('Location: .');
exit();
}


Form.html.php =
<?php include_once $_SERVER['DOCUMENT_ROOT'] .
'/includes/helpers.inc.php'; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php htmlout($pagetitle); ?></title>
<meta http-equiv="content-type"
content="text/html; charset=utf-8"/>
<style type="text/css">
textarea {
display: block;
width: 100%;
}
</style>
</head>
<body>
<?php session_start(); ?>

<h1><?php htmlout($pagetitle); ?></h1>
<form action="?<?php htmlout($action); ?>" method="post">
<div>
<label for="text">Type your job he </label>
<textarea id="text" name="text" rows="3" cols="40"><?php
htmlout($text); ?></textarea>
</div>
<div>
<label for="author">Author:</label>
<select name="author" id="author">
<option value="">Select one</option>
<?php foreach ($authors as $author):?>
<option value="<?php htmlout($author['id']); ?>"<?php
if ($author['id'] == $authorid)
echo ' selected="selected"';
?>><?php htmlout($author['name']); ?></option>
<?php endforeach; ?>
</select>
</div>
<fieldset>
<legend>Categories:</legend>
<?php foreach ($categories as $category): ?>
<div><label for="category<?php htmlout($category['id']);
?>"><input type="checkbox" name="categories[]"
id="category<?php htmlout($category['id']); ?>"
value="<?php htmlout($category['id']); ?>"<?php
if ($category['selected'])
{
echo ' checked="checked"';
}
?>/><?php htmlout($category['name']); ?></label></div>
<?php endforeach; ?>
</fieldset>
<div>
<input type="hidden" name="id" value="<?php
htmlout($id); ?>"/>
<input type="submit" value="<?php htmlout($button); ?>"/>
</div>
</form>
</body>
</html>


Right now, under authors, it displays all the authors in the database. I want it to just show/submit the authorid of the logged in user.

Maybe some of the great coders here can help this noob out.
So here is what I have so far:

Code: [Select]
//set age criteria for deletion
$age = 60;

//get current date
$datenow  = date("Y-m-d");

//set the range we want to delete
$delete_range = $datenow - $age;

//get old user_id from users table
$oldusers_users = mysql_query ("SELECT user_id FROM users WHERE lastvisit < $delete_range ");

//get user_id from images table that correspond to users table
$oldusers_images = mysql_query ("SELECT user_id FROM images WHERE $oldusers_users=user_id.images ");

//find folders that correspond to the usernames and delete
$oldusers_files = mysql_query ("SELECT username FROM users WHERE lastvisit < $delete_range ");
//print out username
//$result = mysql_($oldusers_files);
$foldername = mysql_result($oldusers_files, 0);

$sigspath = "sigs/";
unlink($sigspath . $foldername . ".gif/index.php");
rmdir($sigspath . $foldername . ".gif");
//now delete user_id's from database
mysql_query("DELETE * FROM users WHERE user_id=$oldusers_users");
mysql_query("DELETE * FROM images WHERE user_id=$oldusers_images");
unset($oldusers_users, $oldusers_images, $oldusers_files, $foldername, $sigspath );
mysql_close($link);
Right now it is only returning the first entry, not the entire list that meets the criteria.  It does delete that one file though but does not remover the rows from the database.

I am sure the database stuff is jacked up I am really new to that part.  What am I doing wrong here or is there a better way to do this perhaps

Hi ,

I know my code sucks but i'm learning fast!! I'm trying to show a form if the qty value in a database == 10 or a different form if the value ==20.  I tried but failed.  Any help really appreciated.

Code: [Select]

<?php require_once('Connections/book.php'); ?>
<?php
$colname_cardpayment = "-1";
if (isset($_GET['orderid'])) {
  $colname_cardpayment = (get_magic_quotes_gpc()) ? $_GET['orderid'] : addslashes($_GET['orderid']);
}
mysql_select_db($database_book, $book);
$query_cardpayment = sprintf("SELECT * FROM cards WHERE orderid = '%s' ORDER BY qty ASC", $colname_cardpayment);
$cardpayment = mysql_query($query_cardpayment, $book) or die(mysql_error());
$row_cardpayment = mysql_fetch_assoc($cardpayment);
$totalRows_cardpayment = mysql_num_rows($cardpayment);

 // Database connect
$con = mysql_connect("mysql1.myhost.ie","admin_book","root123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book_test", $con);


//Parse Values from Coupon.php Form
$orderid = mysql_real_escape_string(trim($_POST['orderid']));
$name  = mysql_real_escape_string(trim($_POST['name']));
$surname  = mysql_real_escape_string(trim($_POST['surname']));
$add1 = mysql_real_escape_string(trim($_POST['add1']));
$add2 = mysql_real_escape_string(trim($_POST['add2']));
$town = mysql_real_escape_string(trim($_POST['town']));
$county = mysql_real_escape_string(trim($_POST['county']));
$postcode = mysql_real_escape_string(trim($_POST['postcode']));
$phone = mysql_real_escape_string(trim($_POST['phone']));
$email = mysql_real_escape_string(trim($_POST['email']));
$letterstyle = mysql_real_escape_string(trim($_POST['letterstyle']));


$sql="INSERT INTO custdetails (orderid, name, surname, add1, add2, town, county, postcode, phone, email, letterstyle)
VALUES
('$orderid','$name','$surname','$add1','$add2','$town','$county','$postcode','phone','$email','$letterstyle')";

if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Digital Scribe Books</title>
<link href="style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>


</head>

<body onload="MM_preloadImages('images/buttons/home_over.png','images/buttons/books_over.png','images/buttons/cards_over.png','images/buttons/letters_over.png')">


<div id="snow">
<div id="wrapper">


<div id="header">

<div id="logo"><img src="images/digital_scripe.png" width="218" height="91" /></div>


<div id="menu"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Home','','images/buttons/home_over.png',1)"><img src="images/buttons/home_act.png" name="Home" width="131" height="132" border="0" id="Home" /></a><a href="books.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Books','','images/buttons/books_over.png',1)"><img src="images/buttons/books_act.png" name="Books" width="131" height="132" border="0" id="Books" /></a><a href="cards.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Cards','','images/buttons/cards_over.png',1)"><img src="images/buttons/cards_act.png" name="Cards" width="131" height="132" border="0" id="Cards" /></a><a href="letters.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Letters','','images/buttons/letters_over.png',1)"><img src="images/buttons/letters_act.png" name="Letters" width="131" height="132" border="0" id="Letters" /></a></div>
 </div>
 
 
 
 
<div id="content">



<?php 
echo 'Order ID is :  '. $orderid . '.<br />';

if ($row2['qty'] == 10)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="10 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="12.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";

if ($row2['qty'] == 20)
    echo "<div>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="accounts@agraphics.ie">
<input type="hidden" name="lc" value="IE">
<input type="hidden" name="item_name" value="20 Christmas Cards">
<input type="hidden" name="item_number" value="<? echo $orderid; ?>">
<input type="hidden" name="amount" value="21.99">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="shipping" value="2.99">
<input type="hidden" name="return" value="http://www.digitalscribe/thanks.php">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</div>";


?>

</div>


<div id="footer" class="clear"><div id="sign"><div id="sign_text">Personalised<br />
Books</div>
</div></div>

</div></div>






</body>
</html>
<?php
mysql_free_result($cardpayment);
?>

ok, so I have this code to start with:
Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['username'])) { 
   echo 'Please <a href="/login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql_1.php";
// Place Session variable 'id' into local variable
$username1 = $_SESSION['username'];
?>
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT hometown, about, month, day, year, id FROM general WHERE user='$username1'");
while($row = mysql_fetch_array($sql)){
$userid = $row["userid"];
$hometown = $row["hometown"];
$about = $row["about"];
$month = $row["month"];
$day = $row["day"];
$year = $row["year"];
$userid1 = $row["id"];

}
$sql = mysql_query("SELECT * from sessions WHERE username='$username1'");
while($row = mysql_fetch_array($sql)){
$name1 = $row["name"];

}
?>
<?php if($month == "January"){ $month2 =="1";}else if($month =="February"){$month2 =="2";}else if($month =="March"){$month2 =="3";}else if($month =="April"){$month2 =="4";}else if($month =="May"){$month2 =="5";}else if($month =="June"){$month2 =="6";}else if($month =="July"){$month2 =="7";}else if($month =="August"){$month2 =="8";}else if($month =="September"){$month2 =="9";}else if($month =="October"){$month2 =="10";}else if($month =="November"){$month2 =="11";}else if($month =="December"){$month2 =="12";}

?>
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * from pics WHERE user='$username1'");
while($row = mysql_fetch_array($sql)){
$link123 = $row["link"];

}
?>
<?php
if(isset($_SESSION['username']))
{

   $query = "SELECT sport FROM sports where user ='$username1'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($sport) = $row;

      $cs .=  "$sport<br>
";
   
   }}
  

  

?>   
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script src="SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<script language="javascript" type='text/javascript'>
function hideDiv() {
if (document.getElementById) { // DOM3 = IE5, NS6
document.getElementById('hideShow').style.visibility = 'hidden';
}
else {
if (document.layers) { // Netscape 4
document.hideShow.visibility = 'hidden';
}
else { // IE 4
document.all.hideShow.style.visibility = 'hidden';
}
}
}

function showDiv() {
if (document.getElementById) { // DOM3 = IE5, NS6
document.getElementById('hideShow').style.visibility = 'visible';
}
else {
if (document.layers) { // Netscape 4
document.hideShow.visibility = 'visible';
}
else { // IE 4
document.all.hideShow.style.visibility = 'visible';
}
}
}
</script>
<script language="javascript" type='text/javascript'>
function hideDiv1() {
if (document.getElementById) { // DOM3 = IE5, NS6
document.getElementById('apDiv4').style.visibility = 'hidden';
}
else {
if (document.layers) { // Netscape 4
document.apDiv4.visibility = 'hidden';
}
else { // IE 4
document.all.apDiv4.style.visibility = 'hidden';
}
}
}

function showDiv1() {
if (document.getElementById) { // DOM3 = IE5, NS6
document.getElementById('apDiv4').style.visibility = 'visible';
}
else {
if (document.layers) { // Netscape 4
document.apDiv4.visibility = 'visible';
}
else { // IE 4
document.all.apDiv4.style.visibility = 'visible';
}
}
}
</script>
<style type="text/css">
#apDiv1 {
position:absolute;
left:0px;
top:0px;
width:100%;
height:50px;
z-index:1;
background-color: #000;
padding: 0px;
text-align: left;
}
#menu {
position:absolute;
top:15px;
width:411px;
height:34px;
z-index:41;
right: 0px;
}
</style>
<link rel="stylesheet" href="css/structure.css" type="text/css" />
<link rel="stylesheet" href="css/form.css" type="text/css" />

<!-- JavaScript -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
$(function() {

$(".submit").click(function() {


    var name = $("#name").val();

     

    var dataString = 'name='+ name;



if(name=='')
{
$('.success').fadeOut(200).hide();

    $('.error').fadeOut(200).show();

}


else
{
$.ajax({
type: "POST",
    url: "join.php",
    data: dataString,
    success: function(){
$('.success').fadeIn(200).show();
    $('.error').fadeOut(200).hide();

$(document).ready(function(){

$('#submit').click(function(){

var a = $("#name").val();
if(a != "")
{
$.post("join.php",{

}, function(response){

$('#posting').prepend($(response).fadeIn('slow'));
$("#name").val("what's on your mind?");
});
}
});
});

   }
});




}


    return false;
});



});
</script>
<style type="text/css">

.error{

color:#d12f19;
font-size:12px;


}
.success{

color:#006600;
font-size:12px;


}
</style>
<link href="Spry-UI-1.7/css/Menu/basic/SpryMenuBasic.css" rel="stylesheet" type="text/css" />
<script src="Spry-UI-1.7/includes/SpryDOMUtils.js" type="text/javascript"></script>
<script src="Spry-UI-1.7/includes/SpryDOMEffects.js" type="text/javascript"></script>
<script src="Spry-UI-1.7/includes/SpryWidget.js" type="text/javascript"></script>
<script src="Spry-UI-1.7/includes/SpryMenu.js" type="text/javascript"></script>
<script src="Spry-UI-1.7/includes/plugins/MenuBar2/SpryMenuBarKeyNavigationPlugin.js" type="text/javascript"></script>
<script src="Spry-UI-1.7/includes/plugins/MenuBar2/SpryMenuBarIEWorkaroundsPlugin.js" type="text/javascript"></script>
<style type="text/css">
/* BeginOAWidget_Instance_2141544: #MenuBar */
/* Settable values for skinning a Basic menu via presets. If presets are not sufficient, most skinning should be done in
these rules, with the exception of the images used for down or right pointing arrows, which are in the file SpryMenuBasic.css

These assume the following widget classes for menu layout (set in a preset)
.MenuBar - Applies to all menubars - default is horizontal bar, all submenus are vertical - 2nd level subs and beyond are pull-right.
.MenuBarVertical - vertical main bar; all submenus are pull-right.

You can also pass in extra classnames to set your desired top level menu bar layout. Normally, these are set by using a preset.
They only apply to horizontal menu bars:
MenuBarLeftShrink - The menu bar will be horizontally 'shrinkwrapped' to be just large enough to hold its items, and left aligned
MenuBarRightShrink - Just like MenuBarLeftShrink, but right aligned
MenuBarFixedLeft - Fixed at a specified width set in the rule '.MenuBarFixedLeft', and left aligned. 
MenuBarFixedCentered -  - Fixed at a specified width set in the rule '.MenuBarFixedCentered',
and centered in its parent container.
MenuBarFullwidth - Grows to fill its parent container width.
 
In general, all rules specified in this file are prefixed by #MenuBar so they only apply to instances of the widget inserted along
with the rules. This permits use of multiple MenuBarBasic widgets on the same page with different layouts. Because of IE6 limitations,
there are a few rules where this was not possible. Those rules are so noted in comments.

*/

#MenuBar  {
background-color:#000000;
font-family: Arial, Helvetica, sans-serif; /* Specify fonts on on MenuBar and subMenu MenuItemContainer, so MenuItemContainer,
MenuItem, and MenuItemLabel
at a given level all use same definition for ems.
Note that this means the size is also inherited to child submenus,
so use caution in using relative sizes other than
100% on submenu fonts. */
font-weight: normal;
font-size: 16px;
font-style: normal;
padding:0;
border-color: #000000 #000000 #000000 #000000;
border-width:0px;
border-style: none none none none;
}
/* Caution: because ID+class selectors do not work properly in IE6, but we want to restrict these rules to just this
widget instance, we have used string-concatenated classnames for our selectors for the layout type of the menubar
in this section. These have very low specificity, so be careful not to accidentally override them. */

.MenuBar br { /* using just a class so it has same specificity as the ".MenuBarFixedCentered br" rule bleow */
display:none;
}
.MenuBarLeftShrink {
float: left; /* shrink to content, as well as float the MenuBar */
width: auto;
}
.MenuBarRightShrink {
float: right; /* shrink to content, as well as float the MenuBar */
width: auto;
}
.MenuBarFixedLeft {
float: left;
width: 80em;
}
.MenuBarFixedCentered {
float: none;
width: 80em;
margin-left:auto;
margin-right:auto;
}
.MenuBarFixedCentered br {
clear:both;
display:block;
}
.MenuBarFixedCentered .SubMenu br {
display:none;
}
.MenuBarFullwidth {
float: left;
width: 100%;
}

/* Top level menubar items - these actually apply to all items, and get overridden for 1st or successive level submenus */
#MenuBar  .MenuItemContainer {
padding: 0px 0px 0px 0px;
margin: 0; /* Zero out margin  on the item containers. The MenuItem is the active hover area.
For most items, we have to do top or bottom padding or borders only on the MenuItem
or a child so we keep the entire submenu tiled with items.
Setting this to 0 avoids "dead spots" for hovering. */
}
#MenuBar  .MenuItem {
padding: 0px 24px 0px 0px;
background-color:#000000;
border-width:0px;
border-color: #cccccc #ffffff #cccccc #ffffff;
border-style: none solid none solid;
}
#MenuBar  .MenuItemFirst {
border-style: none none none none;
}
#MenuBar .MenuItemLast {
border-style: none solid none none;
}

#MenuBar  .MenuItem  .MenuItemLabel{
text-align:center;
line-height:1.4em;
color:#ffffff;
background-color:#000000;
padding: 6px 15px 6px 39px;
width: 10em;
width:auto;
}
.SpryIsIE6 #MenuBar  .MenuItem  .MenuItemLabel{
width:1em; /* Equivalent to min-width in modern browsers */
}

/* First level submenu items */
#MenuBar .SubMenu  .MenuItem {
font-family: Arial, Helvetica, sans-serif;
font-weight: normal;
font-size: 14px;
font-style: normal;
background-color:#ffffff;
padding:0px 2px 0px 0px;
border-width:0px;
border-color: #cccccc #cccccc #cccccc #cccccc;
/* Border styles are overriden by first and last items */
border-style: solid solid none solid;
}
#MenuBar  .SubMenu .MenuItemFirst {
border-style: solid solid none solid;
}
#MenuBar  .SubMenu .MenuItemFirst .MenuItemLabel{
padding-top: 6px;
}
#MenuBar .SubMenu .MenuItemLast {
border-style: solid solid solid solid;
}
#MenuBar .SubMenu .MenuItemLast .MenuItemLabel{
padding-bottom: 6px;
}
#MenuBar .SubMenu .MenuItem .MenuItemLabel{
text-align:left;
line-height:1em;
background-color:#ffffff;
color:#333333;
padding: 6px 12px 6px 5px;
width: 7em;

}

/* Hover states for containers, items and labels */
#MenuBar .MenuItemHover {
background-color: #666666;
border-color: #cccccc #cccccc #cccccc #cccccc;
}

#MenuBar .MenuItemWithSubMenu.MenuItemHover .MenuItemLabel{
background-color: #666666; /* consider exposing this prop separately*/
color: #ffffff;
}
#MenuBar .MenuItemHover .MenuItemLabel{
background-color: #666666;
color: #ffffff;
}
#MenuBar .SubMenu .MenuItemHover {
background-color: #666666;
border-color: #666666 #cccccc #cccccc #cccccc;
}

#MenuBar .SubMenu .MenuItemHover .MenuItemLabel{
background-color: #666666;
color: #ffffff;
}
/* Submenu properties -- First level of submenus */
#MenuBar .SubMenuVisible {
background-color: #ffffff;
min-width:0%;  /* This keeps the menu from being skinnier than the parent MenuItemContainer - nice to have but not available on ie6 */
border-color: #ffffff #ffffff #ffffff #ffffff;
border-width:0px;
border-style: none none none none;
}
#MenuBar.MenuBar .SubMenuVisible {/* For Horizontal menubar only */
top: 100%; /* 100% is at the bottom of parent menuItemContainer */
left:0px; /* 'left' may need tuning depending upon borders or padding applied to menubar MenuItemContainer or MenuItem,
and your personal taste.
0px will left align the dropdown with the content area of the MenuItemContainer. Assuming you keep the margins 0
on MenuItemContainer and MenuItem on the parent
menubar, making this equal the sum of the MenuItemContainer & MenuItem padding-left will align
the dropdown with the left of the menu item label.*/
z-index:10;
}
#MenuBar.MenuBarVertical .SubMenuVisible {
top: 0px;
left:100%;
min-width:0px; /* Do not neeed to match width to parent MenuItemContainer - items will prevent total collapse */
}
/* Submenu properties -- Second level submenu and beyond - these are visible descendents of .MenuLevel1 */
#MenuBar .MenuLevel1 .SubMenuVisible {
background-color: #ffffff;
min-width:0px; /* Do not neeed to match width to parent MenuItemContainer - items will prevent total collapse*/
top: 0px; /* If desired, you can move this down a smidge to separate top item''s submenu from menubar -
that is really only needed for submenu on first item of MenuLevel1, or you can make it negative to make submenu more
vertically 'centered' on its invoking item */
left:100%; /* If you want to shift the submenu left to partially cover its invoking item, you can add a margin-left with a
negative value to this rule. Alternatively, if you use fixed-width items, you can change this left value
to use px or ems to get the offset you want. */
}
/* IE6 rules - you can delete these if you do not want to support IE6 */

/* A note about multiple classes in IE6.
 * Some of the rules above use multiple class names on an element for selection, such as "hover" (MenuItemHover) and "has a subMenu" (MenuItemWithSubMenu),
 * giving the selector '.MenuItemWithSubMenu.MenuItemHover'.
 * Unfortunately IE6 does not support using mutiple classnames in a selector for an element. For a selector such as '.foo.bar.baz', IE6 ignores
 * all but the final classname (here, '.baz'), and sets the specificity accordingly, counting just one of those classs as significant. To get around this
 * problem, we use the plugin in SpryMenuBarIEWorkaroundsPlugin.js to generate compound classnames for IE6, such as 'MenuItemWithSubMenuHover'.
 * Since there are a lot of these needed, the plugin does not generate the extra classes for modern browsers, and we use the CSS2 style mutltiple class
 * syntax for that. Since IE6 both applies rules where
 * it should not, and gets the specificity wrong too, we have to order rules carefully, so the rule misapplied in IE6 can be overridden.
 * So, we put the multiple class rule first. IE6 will mistakenly apply this rule.  We follow this with the single-class rule that it would
 * mistakenly override, making sure the  misinterpreted IE6 specificity is the same as the single-class selector, so the latter wins.
 * We then create a copy of the multiple class rule, adding a '.SpryIsIE6' class as context, and making sure the specificity for
 * the selector is high enough to beat the single-class rule in the "both classes match" case. We place the IE6 rule at the end of the
 * css style block to make it easy to delete if you want to drop IE6 support.
 * If you decide you do not need IE6 support, you can get rid of these, as well as the inclusion of the SpryMenuBarIEWorkaroundsPlugin.js script.
 * The 'SpryIsIE6' class is placed on the HTML element by  the script in SpryMenuBarIEWorkaroundsPlugin.js if the browser is Internet Explorer 6. This avoids the necessity of IE conditional comments for these rules.
 */
.SpryIsIE6 #MenuBar .MenuBarView .MenuItemWithSubMenuHover .MenuItemLabel /* IE6 selector  */{
background-color: #666666; /* consider exposing this prop separately*/
color: #ffffff;
}
.SpryIsIE6 #MenuBar .MenuBarView .SubMenu .MenuItemWithSubMenuHover .MenuItemLabel/* IE6 selector  */{
background-color: #666666; /* consider exposing this prop separately*/
color: #ffffff;
}
.SpryIsIE6 #MenuBar .SubMenu .SubMenu  /* IE6 selector  */{
margin-left: -0px; /* Compensates for at least part of an IE6 "double padding" version of the "double margin" bug */
}


/* EndOAWidget_Instance_2141544 */
#apDiv2 {
position:absolute;
left:5px;
top:75px;
width:591px;
height:284px;
z-index:2;
}
#hideShow {
position:absolute;
left:84px;
top:211px;
width:506px;
height:47px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:4px;
top:354px;
width:306px;
height:45px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:82px;
top:275px;
width:290px;
height:34px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:17px;
top:205px;
width:861px;
height:172px;
z-index:2;
}
.fullname {
position:relative;
left:0px;
width:100px;
height:30px;
z-index:4;
top:25px;
background-color:black;
color:white;
text-align: center;
}
#apDiv5 #TabbedPanels1 .TabbedPanelsContentGroup .TabbedPanelsContent.TabbedPanelsContentVisible #form1 table tr td {
text-align: right;
}
</style>
<script type="text/xml">
<!--
<oa:widgets>
  <oa:widget wid="2141544" binding="#MenuBar" />
</oa:widgets>
-->
</script>
<link href="SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
<style type="text/css">
#apDiv6 {
position:absolute;
left:4px;
top:54px;
width:162px;
height:147px;
z-index:3;
}
</style>
</head>

<body onLoad="javascript:TabbedPanels1.showPanel(<?php echo $_COOKIE['index'];?>)">
<?php $birthday1 = "$year-$month2-$day"; ?>
<div id="apDiv1">
  <div id="menu">
    <ul id="MenuBar" class="MenuBarHorizontal">
  <li><a href="index.php">Home</a>  </li>
  <li><a href="profile.php">Profile</a></li>
  <li><a class="MenuBarItemSubmenu" href="#">Account</a>
    <ul>
      <li><a href="settings.php">Account Settings</a>      </li>
      <li><a href="privacy.php">Privacy Settings</a></li>
      <li><a href="logout.php">Logout</a></li>
    </ul>
  </li>
</ul>
    <script type="text/javascript">
// BeginOAWidget_Instance_2141544: #MenuBar
var MenuBar = new Spry.Widget.MenuBar2("#MenuBar", {
      widgetID: "MenuBar",
  widgetClass: "MenuBar  MenuBarRightShrink",
  insertMenuBarBreak: true,
      mainMenuShowDelay: 100,
      mainMenuHideDelay: 200,
      subMenuShowDelay: 200,
      subMenuHideDelay: 200
      });
// EndOAWidget_Instance_2141544
    </script>
  </div>
<a href="/main.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image1','','/hover.png',1)"><img src="/main.png" name="Image1" width="600" height="50" border="0" id="Image1" /></a> </div>

<?php

// Process the form if it is submitted
if ($_POST['general']) {
$city1 = $_POST['city'];
$hometown1 = $_POST['hometown'];
$about1 = $_POST['about'];


$sql = mysql_query("UPDATE general SET city='$city1', hometown='$hometown1', about='$about1' WHERE id='$userid1'")or die(mysql_error());
$message ='Your Account info has been saved';
echo "<font color = 'red'>";
echo  $message;
echo "</font>";
} // close if post
?>
<div id="apDiv5">
  <div id="TabbedPanels1" class="VTabbedPanels">
    <ul class="TabbedPanelsTabGroup">
      <li class="TabbedPanelsTab" tabindex="0">Basic Info</li>
      <li class="TabbedPanelsTab" tabindex="0">Profile Picture</li>
      <li class="TabbedPanelsTab" tabindex="0">Sports</li>
      <li class="TabbedPanelsTab" tabindex="0">Activities</li>
      <li class="TabbedPanelsTab" tabindex="0">Contact Info</li>
</ul>
    <div class="TabbedPanelsContentGroup">
      <div class="TabbedPanelsContent"><form id="form1" name="form1" method="post" action="">
          <label for="city"></label>
          <table width="496" border="0" cellspacing="2" cellpadding="0">
            <tr>
              <td width="157" scope="col">Current City:</td>
              <td width="333" scope="col"><div align="left">
                <input type="text" name="city" id="city" value="<?php echo $city; ?>" />
              </div></td>
            </tr>
            <tr>
              <td>Hometown:</td>
              <td><div align="left">
                <label for="hometown"></label>
                <input type="text" name="hometown" id="hometown" value="<?php echo $hometown; ?>" />
              </div></td>
            </tr>
            <tr>
              <td>Birthday:</td>
              <td><div align="left"><?php echo $month;?> <?php echo $day; ?>, <?php echo $year; ?></div></td><tr><td></td><td> <div align="left"><?php

  //calculate years of age (input string: YYYY-MM-DD)
  function birthday ($birthday){
    list($year,$month,$day) = explode("-",$birthday);
    $year_diff  = date("Y") - $year;
    $month_diff = date("m") - $month;
    $day_diff   = date("d") - $day;
    if ($day_diff < 0 || $month_diff < 0)
      $year_diff--;
    return $year_diff;
  }
 echo  birthday($birthday1). " years old";

?></div></td></tr></td>
            </tr>
            <tr>
              <td>About Me: </td>
              <td><label for="about"></label>
              <textarea name="about" id="about" cols="45" rows="5"></textarea></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td><div align="left"><input name="general" id="general" type="submit" value="Save information" class="fullname" /></div></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
          </table>
        </form></div>
      <div class="TabbedPanelsContent"><form enctype="multipart/form-data" action="profile.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="900000000000000000000000000000000000000000000000000000000000000000000000000" />
Choose a file to upload:

     <div id="dynamicInput">
          <p>Entry 1</p>
          <p>
           
            <br>
            <input type="file" name="uploadedfile[]">
          </p>
     </div>
   
<input type="submit" value="Upload File" id="submit" name="submit" />
</form>
<?php
if($_POST['submit']){
// Where the file is going to be placed
$target_path = 'images/'.$username1.'/';

foreach ($_FILES["uploadedfile"]["name"] as $key => $value) {
$uploadfile = $target_path . basename($_FILES["uploadedfile"]["name"][$key]);
$uploadfile1 =   basename($_FILES["uploadedfile"]["name"][$key]);
//echo $uploadfile;
if (move_uploaded_file($_FILES['uploadedfile']['tmp_name'][$key], $uploadfile)) { 
$sql = mysql_query("UPDATE pics SET link='$uploadfile', name='$uploadfile1' WHERE user='$username1'")or die(mysql_error());
$sql = mysql_query("UPDATE facebook_posts SET pic='$uploadfile' WHERE f_name='$name1'")or die(mysql_error());
$sql = mysql_query("UPDATE facebook_posts_comments SET pic='$uploadfile' WHERE f_name='$name1'")or die(mysql_error());
echo $value . ' uploaded<br>'; }
}

}

?>
</div>
      <div class="TabbedPanelsContent"><form autocomplete="off"
enctype="multipart/form-data" method="post"  name="form">

<div class="info" style="padding-left:20px">
<h2>&nbsp;</h2>
<div></div>
<div>
  <p>Sport:
    <input id="name" name="name" type="text" class="field text medium" value="" maxlength="255" tabindex="1" />
    </p>
  <p></p>
</div>
<div></div>
</div>
<div class="buttons">
<input  type="submit" value="Submit" style=" background:#0060a1; color:#FFFFFF; font-size:14px; border:1px solid #0060a1; margin-left:12px" class="submit" name="submit" id="submit"/><span class="error" style="display:none"> Please Enter Valid Data</span><?php 
if($_POST['submit']){
?><span  class="success" style="display:none">
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?php
$sql123 = mysql_query("SELECT id, sport, user FROM sports WHERE user='$username1'");
while($row = mysql_fetch_array($sql123)){
$id = $row["id"];
$sport1 .= $row["sport"];
$user = $row["user"];}
echo $sport1;
;}
?></span>
  </div>
</form></div>
      <div class="TabbedPanelsContent">Content 4</div>
      <div class="TabbedPanelsContent">Content 5
       
      </div>
</div>
  </div>
</div>
<div id="posting" align="center">

<?php 

include_once "posting.php"; ?>
 
</div>
       
<div id="apDiv6"><?php echo '<img src="'.$link123.'" width="162""/>'; ?></div>
<script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>
</body>
</html>
My goal is to make it so that where the really long comment(well with no words), is at that it runs after the ajax at the begining of the script so that the database input it does shows up in that result.  here is the code of join.php
Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['username'])) { 
   echo 'Please <a href="/login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql_1.php";
// Place Session variable 'id' into local variable
$username1 = $_SESSION['username'];
?>
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT hometown, about, month, day, year, id FROM general WHERE user='$username1'");
while($row = mysql_fetch_array($sql)){
$userid = $row["userid"];
$hometown = $row["hometown"];
$about = $row["about"];
$month = $row["month"];
$day = $row["day"];
$year = $row["year"];
$userid1 = $row["id"];

}
$sql = mysql_query("SELECT id, sport, user FROM sports WHERE user='$username1'");
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
$sport1 = $row["sport"];
$user = $row["user"];

}
if($_POST)
{
$sport=$_POST['name'];

mysql_query("INSERT INTO sports (id, sport, user)
VALUES ('$userid1', '$sport', '$username1')");
}else { }

?>
<html>
<head>
</head>
<body>
<?php echo $sport1; ?>
</body>
</html>
I hope this makes sense.  so once again, I need the results that the code by the long comment(sorta)  will basically run after the ajax uses join.php to input info into the dbase.  or is there a better way to do this?  currently the results are loading even before the page loads. so that it returns the results when it is supposed to, it just didn't query the database at the right time.

Hello all,

I am making a database with all the Boeing deliveries sorted by month. I made a index with all the months and when you click on a month you will get a full list of the type and quantity of aircraft that has been deliverd.

I have two problems and I can't figure it out.
The first problem I have, is that I want to show the visitors which airline has bougt which type of aircraft and how many.
The second problem I have is a want to show them the total amount of deliveries, not just per type of aircraft, but a total number.

Here are some shots of my problem and what I have:

This is how my MYSQL-database lookes like. The columns I have a id, day, month, year, airline, aircraft, amount (just a simple translation of the Dutch words ).
As you can see, there are some airlines that received one type of aircraft two times (TUI Travel PLC has received 2x Boeing 737-800). Keep this in mind, I will get back to this.


This is the table on my website. The first column shows the type of aircraft. The secon column shows us how many of that type has been deliverd. In the last column I want to have all the airlines that has received that type of aircraft. As I mentioned above, TUI Travel PLC has received 2x B737-800, so in the row of B737-800 I want to have TUI Travel PLC (2x). If the airline received more then 1 aircraft, I would like to have (.....x) (and the amount on the dots --> TUI example: 2 aircraft, so 2x). So you will get TUI Travel PLC (2x).

This is the code I have so far (sorry I am a real noobie in PHP/MYSQL so my programming ain't that great )

Code: [Select]
<?php
mysql_connect(".....", ".....", ".....") or die(mysql_error());
mysql_select_db(".....") or die(mysql_error());

$maand = $_GET['maand'];
$jaar = $_GET['jaar'];


$query = "SELECT aircraft, jaar, maatschappij, COUNT(maatschappij) FROM deliveries_orders_boeing WHERE maand = '$maand' AND jaar = '$jaar' GROUP BY aircraft"; 
 
$result = mysql_query($query) or die(mysql_error());

// Print out result
echo "<br /><h3>Boeing deliveries ".$maand." ".$jaar."</h3><br />
<table border='0' width='700'>";
while($row = mysql_fetch_array($result)){

echo "<tr><td id='aircraft'>". $row['aircraft']. "</td><td id='aantal'>". $row['COUNT(maatschappij)'] ."</td><td id='maatschappijen'>different companies</td></tr>";
}
echo "<tr><td id='totaal'>Totaal</td><td id='totaal_aantal'>....</td><td></td></tr></table>";

?>
</td>
</tr>
</table>

Maybe a little confusing, but I hope someone can help me with this.

Kind regards,
Flyboeing

Like the title says. I have 4 of the same number in my database, but I only want my website to display one of the 4.

How can I do something like this?

I have got a flash file that is stored in the database. So I fetch it and put it in a variable then put the variable in the flash embed code where the src is but the flash comes up blank.

$file = "SELECT * FROM table WHERE column='$name'";

$file2 = mysql_query($sqlfile);
        $file3 = @mysql_fetch_assoc($file2);

$file4 = $file3['gamefile'];
  //skip some code to html embed section
<object width='550' height='400'>
<param name='movie' value='valuename'>
<embed src='$file4' width='550' height='400'>
</embed>
</object>

    


then the page comes up with a white box which when you hover over it says 'file not loaded'.

I have a form gathering data from the database. There is one field 'country' which is a combo box. The combo box is populated from the countries table which joins the customers table to provide the country specific to the customer. I'm trying to have the combo box display the country associated with the customer. I think I'm close in my code, but unsure. This is a playground to so I can implement on our other site. 

<?php
require_once('database.php');
$sql2 = "SELECT * From countries
";
$countries = $db->query($sql2);

if(isset($_GET['customerID'])) {
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $sql = "SELECT * FROM customers  WHERE customerID =$customerID ";
//$sql2 = "SELECT * From countries
//INNER JOIN customers ON countries.countryCode=customers.countryCode
//WHERE customers.customerID = $customerID";
    $stmt = $db->query($sql);
}
if(isset($_GET['customerID'])){
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $countryQuery = "
    {$sql2} INNER JOIN customers ON countries.countryCode = customers.countryCode WHERE customers.customerID = $customerID";

    $countriesQuery = $db->prepare($countryQuery);
    $countriesQuery->execute(['customerID' => $_GET['customerID']]);

    $selectedCountry = $countriesQuery->fetch(PDO::FETCH_ASSOC);

    var_dump($selectedCountry);

}

?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<!-- the head section -->
<head>
    <title>My Guitar Shop</title>
    <link rel="stylesheet" type="text/css" href="main.css" />
</head>

<!-- the body section -->
<body>
<div id="page">

    <div id="header">
        <h1>SportsPro Technical Support</h1>
        <p>Sports management software for the sports enthusiast.</p></h1>
    </div>

    <div id="main">

        <h1>View/Update Customer</h1>

        <form action="update.php" method="get" >
        <?php




        ?>
        <div id="content">
            <!-- display a table of products -->
            <h2>Customers</h2>
            <form  name="customerInfo">
               <?php foreach ($stmt as $cust) { ?>
                <div>
                    <label>First Name</label>
            <input type="text" name="name" class ="form-control" value ="<?php echo $cust['firstName']; ?>">
            </div><br>
                <div>
                    <label>Last Name</label>
                    <input type="text" name="name" class ="form-control" value ="<?php echo $cust['lastName']; ?>">
                </div><br>
            <div>
            <label>Address</label>
            <input type="text" name="address" class ="form-control" value ="<?php echo $cust['address']; ?>">
                </div><br>
                <div>
                    <label>City</label>
            <input type="text" name="city" class ="form-control" value ="<?php echo $cust['city']; ?>">
                </div><br>
                <div>
                    <label>State</label>
            <input type="text" name="state" class ="form-control" value ="<?php echo $cust['state']; ?>">
                </div><br>
                <form action="update.php" method="get">
                    <select name="country">
                        <option value=""></option>
                        <?php
                        foreach ($countries->fetchAll() as $country): ?>
                            <option value="<?php echo $country['customerID']; ?>
                          <?php echo isset($customerID) == $selectedCountry['customerID'] ? ' selected':''?>
                            "><?php echo $country['countryName']; ?></option>

                        <?php endforeach;?>

                    </select>


                </form>
                </div>



                <br>
                <div>
                    <label>Country Code</label>
            <input type="text" name="countryCode" class ="form-control" value ="<?php echo $cust['countryCode']; ?>">
                </div><br>
                <div>
                    <label>Zip Code</label>
            <input type="text" name="postalCode" class ="form-control" value ="<?php echo $cust['postalCode']; ?>">
                </div><br>
                <div>
                    <label>Email </label>
            <input type="text" name="email" class ="form-control" value ="<?php echo $cust['email']; ?>">
                </div><br>
                <div>
                    <label>Phone Number </label>
            <input type="text" name="phone" class ="form-control" value ="<?php echo $cust['phone']; ?>">
                </div><br>
                <div>
                    <label>Password </label>
            <input type="text" name="password" class ="form-control" value ="<?php echo $cust['password']; ?>">
                </div><br>
                <div>

                <?php    }

                                ?>


        </div>

    </div>
            <form action="UpdateCustomer.php" method="get">
                <input   type="submit" name="data" value="Update_Data"></input>
            </form>
    <div id="footer">
        <p>
            © <?php echo date("Y"); ?> SportsPro, Inc.
        </p>
    </div>

</div><!-- end page -->
</body>
</html>

 

Hi all,

The below example is a workable code, taken from tutor_profile.sql table
Code: [Select]
<?php
    $query = "SELECT tutor_id, religion_id FROM tutor_profile WHERE tutor_id = '" . $_GET['tutor_id'] . "'";
    
$data = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));

// The user row was found so display the user data
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);

print_r($row);
    if ($row != NULL) {
  $religion_id = $row['religion_id'];
  $tutor_id = $row['tutor_id'];

    }
    else {
      echo '<p class="error">There was a problem accessing your profile.</p>';
    }
  }

<!--Religion-->   
  <tr>
      <td class="label">Religion:</td>
<td>
<select id="religion_id" name="religion_id">
<option value="1" <?php if (!empty($religion_id) && $religion_id == '1') echo 'selected = "selected"'; ?>>Buddhism</option>
<option value="2" <?php if (!empty($religion_id) && $religion_id == '2') echo 'selected = "selected"'; ?>>Christianity</option>
<option value="3" <?php if (!empty($religion_id) && $religion_id == '3') echo 'selected = "selected"'; ?>>Hinduism</option>
<option value="4" <?php if (!empty($religion_id) && $religion_id == '4') echo 'selected = "selected"'; ?>>Islam</option>
<option value="5" <?php if (!empty($religion_id) && $religion_id == '5') echo 'selected = "selected"'; ?>>Taoism</option>
<option value="6" <?php if (!empty($religion_id) && $religion_id == '6') echo 'selected = "selected"'; ?>>Others</option>
</select>
</td>
  </tr>
?>

As you can see I have hard coded the names of the religion in html code
example - <option value="3" <?php if (!empty($religion_id) && $religion_id == '3') echoselected = "selected"'; ?>>Hinduism</option>

And if our record shows that the tutor has previously selected '3', it will reflect as 'hinduism' in his profile. View profile.jpg for example
example - <option value="3" <?php if (!empty($religion_id) && $religion_id == '3') echo 'selected = "selected"'; ?>>Hinduism</option>

In fact, these names can be found in another table called religion.sql, but I hard coded it anyway, without using loop (while function), since there are only 8 names
Code: [Select]
<!--Religion-->  
  <tr>
      <td class="label">Religion:</td>
<td>
<select id="religion_id" name="religion_id">
<option value="1" <?php if (!empty($religion_id) && $religion_id == '1') echo 'selected = "selected"'; ?>>Buddhism</option>
<option value="2" <?php if (!empty($religion_id) && $religion_id == '2') echo 'selected = "selected"'; ?>>Christianity</option>
<option value="3" <?php if (!empty($religion_id) && $religion_id == '3') echo 'selected = "selected"'; ?>>Hinduism</option>
<option value="4" <?php if (!empty($religion_id) && $religion_id == '4') echo 'selected = "selected"'; ?>>Islam</option>
<option value="5" <?php if (!empty($religion_id) && $religion_id == '5') echo 'selected = "selected"'; ?>>Taoism</option>
<option value="6" <?php if (!empty($religion_id) && $religion_id == '6') echo 'selected = "selected"'; ?>>Others</option>
</select>
</td>
  </tr>

Currently I am facing an issue, I guess I will need to use looping, as there are 22 names in another table which I will need to call forth, tutor_educational_level.sql, and the number of names get more and more in other tables.

My question is, how do I pull out the entire list of names into a drop down box and yet showing the selected name which the user has chosen, more elaboration can be seen in profile.jpg. In profile.jpg - as you can see the list of names are shown in the drop down box and the system is able to decipher the chosen name.

Another
Example
1) N level
2) O level
3) A level
4) University

User selected '3', which is A level, and system would still show the list of educational_names in a drop down box,, but selecting A level as the one to appear.

Example
1) N level
2) O level
3) A level (selected)
4) University

It should have the same overall result as the religion which I have stated above, however this time round, it is using looping function (while) to retrieve the entire list of names, select and show the name which the user has chosen


Below is my code, and I know it is wrong, but generally would like to relate my idea across.
Code: [Select]
<?php
<!--Teaching Credentials-->   
  <tr>
      <td class="label">Teaching Credentials:</td>
<td>
<?php
echo '<select name="educational_level" id="educational_level">';

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or die(mysqli_error($dbc));
$query = "SELECT tp.educational_id, el.educational_name AS educational_name, el.educational_id AS list_educational_id " . 
  "FROM tutor_profile AS tp " .
  "INNER JOIN * tutor_educational_level AS el USING (educational_id) " .
  "WHERE tp.tutor_id = '" . $_GET['tutor_id'] . "'";
$sql = mysqli_query($dbc, $query)
or die(mysqli_error());



while($data = mysqli_fetch_array($sql)) {
echo'<option value="'.$data['list_educational_id'].'">'.$data['educational_name'].'</option>';
if (!empty ($data['educational_id']) && ($data['educational_id']) == ($data['list_educational_id'])) {
echo 'selected = "selected"';
}
}
echo '</select><br/>';

mysqli_close($dbc);
?>
</td>
  </tr>
?>