PHP - Combobox Show Information Selected From Database

I'm not sure I know how to explain what I want to allow you to understand. I'm working on a ventilation app that has different fan sizes. In the input php file I have a dropdown list that's populated by what's in the database. I'd like a results page that lists the fan size and number of each size and the cfm's each fan kicks out. the problem is that I don't know how to do anything with it other than hard code it.

What I'd like, is for it to also pull all of the fan sizes and list them, that way the database can be fluid.   This is the code I'd like to replace with some sort of loop.    //9" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=9", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity9 = $row['capacity'];

              };
              //---------------------------------------------------------
              //10" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=10", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity10 = $row['capacity'];

              };


                        //---------------------------------------------------------
              //14" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=14", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity14 = $row['capacity'];

              };


                        //---------------------------------------------------------
              //16" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=16", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity16 = $row['capacity'];

              };

              //---------------------------------------------------------
              //18" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=18", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity18 = $row['capacity'];

              }
              //---------------------------------------------------------
              //20" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=20", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity20 = $row['capacity'];

              };
              //---------------------------------------------------------
              //24" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=24", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity24 = $row['capacity'];

              };
              //---------------------------------------------------------
              //36" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=36", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity36 = $row['capacity'];

              };

I am having trouble pulling a youtube embedded code from my database. Everything else comes out fine however it just doesnt pull anything out where the embedded code is supposed to be. Any ideas I put the code below. All help would be greatly appreciated, also if anyone is feeling generous and would like to help me some more please message me I have a couple other small questions.

Code: [Select]
<?php
//open database
$connect = mysql_connect("Database","name","password") or die("Not connected");
mysql_select_db("database") or die("could not log in");

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);

 // Get the page number, if none is set - it is 0
if( isset($_GET['page']) )
{ 
$page =$_GET['page']; 
}
else
{
$page  = 0;
}

$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
{
$link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table
$username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table
$messsage = mysql_result($result,$loops,"message");
$date = mysql_result($result,$loops,"date");
if ($pagelimit == 0)
{
$pagelimit == 1;
}
if ($pagelimit <= 15)
// echo stuff here
$loopz = $loops + 1;
 echo "&nbsp;&nbsp;&nbsp
 </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
  <tr>
<td>$loopz.&nbsp;
</br>
$message
</br>
Posted By: $username $date
</td>
  </tr>
</table></br><br>";
 $count++ ;
 $pagelimit++;
 $loops++;
}

if ( $page!=0 ) // Show 'Previous' link
{
$page--;
$prevpage = ($page +  1);
echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
$page++;
}
if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
{
$page++;
$nextpage = ($page + 1);
echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
}
 
?>

I am creating a music blogging site however the main page will only show one video the code is below anyone have any ideas?

"
<?php
            //open database
            $connect = mysql_connect("******","username","password") or die("Not connected");
            mysql_select_db("collegebooxboox") or die("could not log in");
   
            $query = "SELECT * FROM boox ORDER BY date DESC";
            $result = mysql_query($query);
            
             // Get the page number, if none is set - it is 0
            if( isset($_GET['page']) )
            {
               $page =$_GET['page'];
            }
            else
            {
               $page  = 0;
            }   
            
$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
   {
   $link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table
   $username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table
   $messsage = mysql_result($result,$loops,"message");
   $date = mysql_result($result,$loops,"date");
   if ($pagelimit == 0)
      {
      $pagelimit == 1;   
      }
   if ($pagelimit <= 15)
   // echo stuff here
      $loopz = $loops + 1;
       echo "&nbsp;&nbsp;&nbsp
          </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
                 <tr>
                  <td>$loopz.&nbsp;$link   
                            </br>
                  $message
                  </br>
                  Posted By: $username $date
                  </td>
                 </tr>
               </table></br><br>";
          $count++ ;
          $pagelimit++;
          $loops++;
   }
      
      if ( $page!=0 ) // Show 'Previous' link
      {
         $page--;
         $prevpage = ($page +  1);
         echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
         $page++;
      }
      if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
      {
         $page++;
         $nextpage = ($page + 1);
         echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
      }
   
         ?>
"

Hi there I would be most grateful is someone could tell me why my data is not being entered into my database and not responding with an email confirmation link. Thanks in advance.



<!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>
</head>
<body>
<?
include('config.php');

// table name 
$tbl_name="temp_members_db";

// Random confirmation code 
$confirm_code=md5(uniqid(rand())); 

// values sent from form 
$name=$_POST['name'];
$email=$_POST['email'];
$country=$_POST['country'];

// Insert data into database 
$sql="INSERT INTO $tbl_name(confirm_code,name,email,password,country) VALUES('$confirm_code','$name','$email','$password','$country')";
$result=mysql_query($sql);

// if suceesfully inserted data into database, send confirmation link to email 
if($result){

// ---------------- SEND MAIL FORM ----------------

// send e-mail to ...
$to=$email;

// Your subject
$subject="Your confirmation link here";

// From
$header="from: your name <your email>";

// Your message
$message="Your Comfirmation link \r\n";
$message.="Click on this link to activate your account \r\n";
$message.="http://www.yourweb.com/confirmation.php?passkey=$confirm_code";

// send email
$sentmail = mail($to,$subject,$message,$header);

}

// if not found 
else {
echo "Not found your email in our database";
}

// if your email succesfully sent
if($sentmail){
echo "Your Confirmation link Has Been Sent To Your Email Address.";
}
else {
echo "Cannot send Confirmation link to your e-mail address";
}

?>
</body>
</html>

Hello,
I recently came upon this website and I want to implement something similar. The 'remove' box is what I would like to do with PHP. I have no idea where to start. I would like to be able to search through my database, select one of its components and add it to that window. Within that window I would also like to be able to remove it. Does anyone know where I should go from there?


here is the site:
http://www.sealandserpent.org/schedgen/schedulegenerator.php

information not posting into the database the code below is the check code/insert code. Please if anyone knows why let me know.

Code: [Select]
[color=red]<?php
//msut be logged in page
session_start();

if  ($_SESSION['username'])
{
echo"";
}
else
die("You must log in first!");

//form information
$submit = $_POST['submit'];
$row4 = $_SESSION['username'];

// form data
$link = strip_tags($_POST['link']);
$message = strip_tags($_POST['message']);
$title = strip_tags($_POST['title']);
$author = strip_tags($_POST['author']);
$date = date('Y-m-d');


$connect = mysql_connect("db","username","password") or die("Not connected");
mysql_select_db("username") or die("could not log in");
$querycheck = "SELECT * FROM boox WHERE username='$row4'";
$result = mysql_query($querycheck);
while($rowz = mysql_fetch_array($result))

$linkcheck = $rowz['link'];


if ($submit)
{
if($link&$title&$author)
{
// check username and subject lentgh
if ($linkcheck == $link)
{
die ("This link has already been posted.");
}
else

{
//open database
$connect = mysql_connect("db","username","password") or die("Not connected");
mysql_select_db("username") or die("could not log in");
$queryreg = mysql_query("INSERT INTO boox Values ('','$row4','$link','$title','$author','$message','$date')");
echo "You have just officialy posted on the Catalina Beat Mixers. ";

}

}

}
   
else
{
die ("You forgot to put something in the link/title/author box.");
    }


?>[/color]
[code]

I have these two files and I need to solve the problem that I need the user data in the role column to be taken when logging in. I have written it so that the data can be extracted from the database, but it does not work for me that it is “forwarded” from process.php to admin.php . Please don’t know what the error is that the admin.php file doesn’t want to load $ _SESSION['Role'] from process.php ? Thanks to everyone for helping and here is the code:

process.php

<?php 
require_once('connect.php');
session_start();
    if(isset($_POST['Login']))
    {
       if(empty($_POST['Username']) || empty($_POST['Password']))
       {
            header("location:index.php?Empty= Please Fill in the Blanks");
       }
       else
       {
            $query="select * from role_test where Username='".$_POST['Username']."' and Password='".md5($_POST['Password'])."'";
            $result=mysqli_query($con,$query);

            if(mysqli_fetch_assoc($result))
            {
                $_SESSION['User']=$_POST['Username'];

                while($row = mysqli_fetch_array($result) ){
                $_SESSION['Role']=$row['role'];
                }

                header("location:admin.php");
            }
            else
            {
                header("location:index.php?Invalid= Please Enter Correct User Name and Password ");
            }
       }
    }
    else
    {
        echo 'Not Working Now Guys';
    }

?>

 

admin.php

<?php
    session_start();

    if(!(isset($_SESSION['User'])))
    {
        header("Location: index.php");
        exit(0);
    }	  

?>
<!DOCTYPE html>
<html>
<head>
<title>Role</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<?php
$_SESSION['Role']=$role;

echo $role;

?>

</body>
</html>

 

 

 

hello.

please could someone help me with this conundrum 

im trying to pull my content dynamically. im almost there but im stuck with some code.

so i have a layout with 3 columns and in each column i have a place holder. ph01, ph02, ph03

each page has its own id and depending on what the page id is i what to pull different elements into the 3 placeholders.

so for this code in the database i have the following:


table name: placeholders
pages_id = page id
ph_number = placeholder number
contElements_id = element ids

id    pages_id   ph_number      contElements_id
1     1              1                    1, 2, 3                         
2     1              2                    4, 5, 6                 
3     1              3                    7, 8, 9                         


table name: contelements
name = name of the element

id    name   
1    E1
2    E2
3    E3
4    E4
5    E5
6    E6
7    E7
8    E8
9    E9


SO, page_ID=1 has 3 placeholders and they should show:
ph01 should display = E1, E2, E3
ph02 should display = E4, E5, E6
ph03 should display = E7, E8, E9


this is the code im trying to put together.

on the page im using this include function in the left, center and right columns.

Code: [Select]

$phNo = "1";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "2";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "3";
echo include_admin_contElements($phNo, $pageID); 



now this is where the problem is.... i think
in the function file i have this but its a mess..

Code: [Select]
function  include_admin_contElements($phNo, $pageID){


$PH = Placeholders::find_all();

foreach ($PH as $PHs){
$PHid = $PHs->id;
$PHpid = $PHs->pages_id;
$PHce = $PHs->contElelments_id;
$PHn = $PHs->ph_number;

if($pageID == $PHpid){

$CE = Contelements::find_by_PHce($PHce);

foreach ($CE as $CEs){
echo $CEid = $CEs->id;
echo $CEname = $CEs->name;
}
}
}
}


- so the idea is i get $phNo, $pageID from the page,
- then find all the placeholders in the database Quote

Placeholders::find_all();

- then if the $pageID is the same as the $PHpid in the placeholder database Quote

if($pageID == $PHpid){

get the content elents for that page.
- then i want to get the elements that belong to that page using Quote

Contelements::find_by_PHce($PHce);


but that does not work

Code: [Select]
                public static function find_by_PHce($PHce=0){
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$PHce."";
$result_array = self::find_by_sql($sql);
return $result_array;
                }


anyway... im stuck. this code doesn't even seperate the 3 different placeholders. it needs a more experienced eye..

its a mess

please help

thanks

ricky

Hey guys

I keep getting the error "Database not selected" with this script
<?php
session_start();
if ($_SESSION['adminlogin'] == 1){
//Run
}
else {
header('Location: Log-In.php');
exit;
}
?>
<!DOCTYPE HTML>
<html lang="en-GB">
<head>
            <meta charset="utf-8">
            <!--Search Engine Meta Tags--> 
            <meta name="author" content="Worldwide Lighthouses">
            <meta name="keywords" content="Lighthouses,Lightships,Trinity House,Fog Signals,Fog Horns,Fresnel">
            <meta name="description" content="Worldwide Lighthouses is the number 1 source of information, pictures and videos on the Subject of Lighthouses and Lightships">
            <!--Stylesheets/Javascript-->
            <link rel="stylesheet" href="../../Page-Layout.css" media="screen and (min-width: 481px)">
            <link rel="stylesheet" href="../../Mobile-Page-Layout.css" media="only screen and (max-width:480px)">
            <!--Mobile Browser Support-->
            <meta name="viewport" content="width=320; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;">
            <!--IE Support-->
            <!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> <link rel="stylesheet" href="../Page-Layout.css"><![endif]-->
<meta name="application-name" content="Worldwide Lighthouses"> 
<meta name="msapplication-starturl" content="http://worldwidelighthouses.com/"> 
         <meta name="msapplication-tooltip" content="Worldwide Lighthouses: Your number one source of Lighthouse Information, Videos and Pictures"> 
         <meta name="msapplication-task" content="name=Lighthouses;action-uri=http://worldwidelighthouses.com/Lighthouses.php;icon-uri=http://worldwidelighthouses.com/IE9/Lighthouses.ico"> 
         <meta name="msapplication-task" content="name=Lightships;action-uri=http://worldwidelighthouses.com/Lightships.php;icon-uri=http://worldwidelighthouses.com/IE9/Lightships.ico"> 
<meta name="msapplication-task" content="name=Fog Signals;action-uri=http://worldwidelighthouses.com/Fog-Signals.php;icon-uri=http://worldwidelighthouses.com/IE9/Fog-Signals.ico"> 
        <meta name="msapplication-task" content="name=Glossary;action-uri=http://worldwidelighthouses.com/Glossary.php;icon-uri=http://worldwidelighthouses.com/IE9/Glossary.ico">
             <title>Mailing List Administration | Worldwide Lighthouses</title> 
            </head>
<body>
  <header>
  <h1 id="WWLH">Worldwide Lighthouses</h1>
<form method="get" action="http://www.worldwidelighthouses.com/Search/search.php" id="Search-Box">
<input type="search" placeholder="Search Worldwide Lighthouses" name="query" id="query" size="30" value="" autocomplete="off">
<input type="submit" value="Search">
            <input type="hidden" name="search" value="1"> 
   </form>
</header>  <nav>
   <ul id="Nav">
  <li class="MenuButton" id="Index"><a href="../Index.php"><p class="Nav">Home</p></a></li>
        <li class="MenuButton" id="Lighthouses"><a href="../Lighthouses.php"><p class="Nav">Lighthouses</p></a></li>
        <li class="MenuButton" id="Lightships"><a href="../Lightships.php"><p class="Nav">Lightships</p></a></li>
        <li class="MenuButton" id="FogSignals"><a href="../Fog-Signals.php"><p class="Nav">Fog Signals</p></a></li>
            <li class="MenuButton" id="Daymarks"><a href="../Daymarks.php"><p class="Nav">Daymarks</p></a></li>
            <li class="MenuButton" id="Buoys"><a href="../Buoys.php"><p class="Nav">Buoys</p></a></li>
        <li id="MenuButtonLast"><a href="../Glossary.php"><p class="Nav">Glossary</p></a></li>
</ul>
</nav>
        <?php
if ($_SESSION['adminlogin']==1) {
echo '<div id="logout">
  <div style="float:left; width:30%; text-align:left;!important">
  <a href="Log-In-Accept-Deny.php">Back to Admin Home</a>
  </div>
  <div style="float:right; width:70%;">
  <a href="Logout.php">Log Out of Admin</a>
  <p style="font-size:10px;">Always Sign Out when Finished!</p>
  </div></div>';}
?> 
<article>
    <h1 class="Title">Update Contact Record</h1>
  <div class="Textbox"> 
<?
$id=$_GET['id'];
$username="worldw44_php";
$password="c@rtmeldrive41";
$database="worldw44_newsemail";
mysql_connect(localhost,$username,$password); 
$query="SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query) or die( 'Error: ' . mysql_error() );
$num = mysql_num_rows($result); 
$i=0;
while ($i < $num) { 
$name=mysql_result($result,$i,"name");
$email=mysql_result($result,$i,"email");
?>
<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
Name: <input type="text" name="ud_first" value="<? echo $name; ?>"><br>
E-mail: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
<input type="Submit" value="Update">
</form>
<?
++$i;
}
 
mysql_close();
?>
      <?php
      if ($_SESSION['adminlogin'] == 1){
echo "Logged in on server side.";
}?>
    </div>
</article>
    <footer>
    <ul>
<li><a href="http://www.worldwidelighthouses.com/About.php">About</a></li>
        <li><a href="http://www.worldwidelighthouses.com/Contact-us.php">Contact</a></li>
        <li><a href="http://www.worldwidelighthouses.com/Use-Our-Media.php">Use our media</a></li>
        <li><a href="http://www.worldwidelighthouses.com/Search/search.php">Search</a></li>
        <li><a href="http://www.worldwidelighthouses.com/Social-Networking.php">Social</a></li>
        <li><a href="#Top">Back to top</a></li>
    </ul>
    <br>
    <br>
     &#38;#169; Worldwide Lighthouses <?php echo date("Y"); ?>
</footer>
</body>

I have no idea why?

Any help? AS far as my understanding i have selected it as "Contactinfo"?

Thanks
Danny

Hi all,

Does anyone know if it's possible to generate a dropdown list filled with database information.
I use the following to get the information from the database:
$query                      = "SELECT Name
                               FROM city
                               WHERE member_ID = '$member_ID'";
$result                     = mysql_query($query)
                              or die(mysql_error());
while($row = mysql_fetch_assoc($result))
{
     echo $row['Name'] . '<br>';
}

Thnx Ryflex

hi everyone,
Im trying to make a checkout page, where if the user is logged in, the address information is called from the database and fills the form automatically, my problem is i don't know how to fill the php variables with the result of my sql query..sorry to be a complete noob but can someone explain how i would do this?
<?php
if (!defined('WEB_ROOT')
    || !isset($_GET['step']) || (int)$_GET['step'] != 1) {
exit;
}
require_once 'loginfunctions.php';
checkCustomerLogin();
$errorMessage = '&nbsp;';
?>

<?php
// get the customer id from the session.
$cu_id = $_SESSION['cu_id']
?>
<?php
//connect to server
$mysqli = mysqli_connect("localhost", "root", "", "onlinestore");
//get default shipping and payment address
$mysql = "SELECT cu_id,od_shipping_first_name,od_shipping_last_name,od_shipping_address1,od_shipping_address2,od_shipping_phone,od_shipping_city,od_shipping_state,od_shipping_postal_code FROM tbl_customer WHERE $cu_id = cu_id";
$result = mysqli_query($mysql,$mysqli);
$row = mysql_fetch_assoc($result);
//populate form with values ?
$txtShippingFirstName = 'test';
$txtShippingLastName = 'test';
$txtShippingAddress1 = 'test';
$txtShippingAddress2 = 'test';
$txtShippingPhone = 'test';
$txtShippingState = 'test';
$txtShippingCity = 'test';
$txtShippingPostalCode = 'test';
?>

<script language="JavaScript" type="text/javascript" src="library/checkout.js"></script>
<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
    <tr> 
        <td>Step 1 Of 3 : Please Confirm Shipping And Payment Information </td>
    </tr>
</table>
<p id="errorMessage"><?php echo $errorMessage; ?></p>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>?step=2" method="post" name="frmCheckout" id="frmCheckout" onSubmit="return checkShippingAndPaymentInfo();">
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td colspan="2">Shipping Information</td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtShippingFirstName" type="text" class="box" id="txtShippingFirstName" value="<?php echo $txtShippingFirstName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtShippingLastName" type="text" class="box" id="txtShippingLastName" value="<?php echo $txtShippingLastName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtShippingAddress1" type="text" class="box" id="txtShippingAddress1" value="<?php echo $txtShippingAddress1 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtShippingAddress2" type="text" class="box" id="txtShippingAddress2" value="<?php echo $txtShippingAddress2 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtShippingPhone" type="text" class="box" id="txtShippingPhone" value="<?php echo $txtShippingPhone ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtShippingState" type="text" class="box" id="txtShippingState" value="<?php echo $txtShippingState ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtShippingCity" type="text" class="box" id="txtShippingCity" value="<?php echo $txtShippingCity ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtShippingPostalCode" type="text" class="box" id="txtShippingPostalCode" value="<?php echo $txtShippingPostalCode ?>" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td width="150">Payment Information</td>
            <td><input type="checkbox" name="chkSame" id="chkSame" value="checkbox" onClick="setPaymentInfo(this.checked);"> 
                <label for="chkSame" style="cursor:pointer">Same as shipping information</label></td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtPaymentFirstName" type="text" class="box" id="txtPaymentFirstName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtPaymentLastName" type="text" class="box" id="txtPaymentLastName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtPaymentAddress1" type="text" class="box" id="txtPaymentAddress1" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtPaymentAddress2" type="text" class="box" id="txtPaymentAddress2" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtPaymentPhone" type="text" class="box" id="txtPaymentPhone" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtPaymentState" type="text" class="box" id="txtPaymentState" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtPaymentCity" type="text" class="box" id="txtPaymentCity" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtPaymentPostalCode" type="text" class="box" id="txtPaymentPostalCode" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
      <tr>
        <td width="150" class="entryTableHeader">Payment Method </td>
        <td class="content">
        <input name="optPayment" type="radio" id="optPaypal" value="paypal" checked="checked" />
        <label for="optPaypal" style="cursor:pointer">Paypal</label>
        <input name="optPayment" type="radio" value="cod" id="optCod" />
        <label for="optCod" style="cursor:pointer">Cash on Delivery</label></td>
      </tr>
    </table>
    <p>&nbsp;</p>
    <p align="center"> 
        <input class="box" name="btnStep1" type="submit" id="btnStep1" value="Proceed &gt;&gt;">
    </p>
</form>

Not sure how to even search for what I'm looking for, which is to say I'm really in need of guidance. 

I have a pre-populated database that I set up with about 260 names in it.  It also has information like, height (basketball players) and high school.  It's a list of kids I mean to invite to play in a league.  From there, they will actually come to the league's site and register.

I'd like for my form to check to see if they are already in the database, and if they are just add personal information, like email and phone number.  If they are not, I'd like for the form to enter all of the information (name, school, etc).

I am pulling an youtube embedded code from a database however when I have the homepage pull it from the database it will not show anything after the video....

EXAMPLE...(this is what it should look like)

1.) Title By: Author
     Youtube Video
     Message
     Posted By:

(however this is what it looks like)

1.) Title By: Author
     Youtube Video
 
*The "message" and "Posted By:" just do not show up*

The code is below can someone help me with this problem., it would be greatly appreciated.


Code: [Select]
<?php
//open database
$connect = mysql_connect("Database","name","password") or die("Not connected");
mysql_select_db("database") or die("could not log in");

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);

 // Get the page number, if none is set - it is 0
if( isset($_GET['page']) )
{ 
$page =$_GET['page']; 
}
else
{
$page  = 0;
}

$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
{
$link = mysql_result($result,$loops,"link"); // get result from the 'link' field in the table
$username = mysql_result($result,$loops,"username"); // get result from the 'username' field in the table
$messsage = mysql_result($result,$loops,"message");
$author = mysql_result($result,$loops,"author");
$title = mysql_result($result,$loops,"title");
$date = mysql_result($result,$loops,"date");
if ($pagelimit == 0)
{
$pagelimit == 1;
}
if ($pagelimit <= 15)
// echo stuff here
$loopz = $loops + 1;
 echo "&nbsp;&nbsp;&nbsp
 </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
  <tr>
    <td>$loopz.)&nbsp;$title By: $author
</br>
$link
</br>
$message
</br>
Posted By: $username $date
</td>
  </tr>
</table></br><br>";
 $count++ ;
 $pagelimit++;
 $loops++;
}

if ( $page!=0 ) // Show 'Previous' link
{
$page--;
$prevpage = ($page +  1);
echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
$page++;
}
if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
{
$page++;
$nextpage = ($page + 1);
echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
}
 
?>

Hi Everyone,

I have a program that generates 200 unique images keeping the first image static in each run.The images keep scrolling on to the screen pause for 3 seconds and scroll off I'm able to generated all 200 unique images without repetition, everything is working well except for the lase two images the last two  images are scrolling on to the screen but are not been displayed in the database, Moreover The last image is a duplicate of 197th image.I don't know what is happening.....

Here is MY code..........



<?php
      session_start();
      $sid = $_SESSION['id'];
      $_SESSION['imageDispCnt'] = 0;
$myQuery = "SELECT * from image";
$conn = mysql_connect("localhost","User","Passwd");
mysql_select_db("database_Name",$conn);
$result = mysql_query($myQuery);
$img =Array();
$id =Array();
$i =0;
$imagepath = 'http://localhost/images/';
while ($row = mysql_fetch_array($result))
      {
      $img[$i] =  $imagepath.$row['img_name'];
      $id[$i] =  $row['imageid'];
      $i = $i + 1;
       }
 ?>
      </head>
      <script language="JavaScript1.2">
var scrollerwidth='800px';
var scrollerheight='600px';
var scrollerbgcolor='white';
var pausebetweenimages=3200;
var s;
var sec;
var d;
var j;
var imgid;
var milisec = 0;
var seconds = 0;
var flag = 1;
var ses_id = '<?php echo $sid;?>';
var count = 0;
var i = 0;
var imgname;
var imgid;
var k =0;
var slideimages=new Array();
var img_id = new Array();
var index;

<?php
  $l =0;   
$count = array();
   $j = rand(0,199);
   while($l < 200)
   {
    while(in_array($j, $count))
        {
           $j = rand(0,199);
        }
        $count[$l] =  $j;
        $l++;
       
     }?>
    <?php
  $k = 0;
  for($k = 0;$k<count($count);$k++){
  ?>
  index = <?php echo $k;?>;
  <?php
        $indx = $count[$k];?>
  if(index == 0){
     slideimages[0] = '<img src="http://localhost/images/hbag044.jpg" name="r_img" id="0"/>';
     img_id[0] = '<input type="hidden" value="0" id="imgId" />';
  }
 
  else if(index > 0)
  {
    slideimages[<?php echo $k?>] = '<img src="<?php echo $img[$indx]?>" name="r_img" id="<?php echo $id[$indx]?>"/>';
     img_id[<?php echo $k?>] = '<input type="hidden" value="<?php echo $id[$indx]?>" id="imgId" />';
  }
<?php
}
?>


Can Any one plese help me

Appreciate your help...


Thanks