PHP - Moved: Multiple Select Statement? Or Am I Missing Something?

Moving an application from one server and domain to another.
Have updated all references that I can find to the old url and db.
Mirrored all permissions, etc.

Am getting the following notice:
Notice (8): Undefined index:  CakeCookie [APP/config/bootstrap.php, line 47]

$user_preferred_city = '';
// Checking whether user has already visited our site
$user_preferred_city = $_COOKIE['CakeCookie']['signup_city_name'];


$boot   =   true
$shellPaths   =   null
$localePaths   =   null
$vendorPaths   =   null
$pluginPaths   =   null
$helperPaths   =   null
$viewPaths   =   null
$componentPaths   =   null
$controllerPaths   =   null
$behaviorPaths   =   null
$modelPaths   =   null
$user_preferred_city   =   ""
$user_preferred_city = '';
// Checking whether user has already visited our site
$user_preferred_city = $_COOKIE['CakeCookie']['signup_city_name'];

include - APP/config/bootstrap.php, line 47
Configu :__loadBootstrap() - CORE/cake/libs/configure.php, line 660
Configu :getInstance() - CORE/cake/libs/configure.php, line 137
include - CORE/cake/bootstrap.php, line 43
[main] - APP/webroot/index.php, line 81

What should I look for to resolve this?  Am new to PHP and more of a dba than anything, so I a really appreciate any help you can offer.
Thanks!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=329660.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=354984.0

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

    function setSelected($fieldName, $fieldValue) {
        if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
            echo 'selected="selected"';
        }
    }

And here is my loop:

    $selections = "";
   
    if(isset($_POST["selections"])) {
        foreach ($_POST["selections"] as $selection) {
            $selections .= $selection . ", ";
        }
    }

I have two tables...one is scheduled_umps and one is games.  Both tables have a column 'game_id'. 

I need to select how many games a person is scheduled for in a given time frame.

Here's what I have for the select...and it's not working (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE scheduled_umps.ump_id = '34' AND games.game_id = scheduled_umps.game_id AN' at line 1)

Code: [Select]
<?php
$today_is_this_date = date('Y-m-d');
$four_months_ago = date('Y-m-d', strtotime('-4 months', strtotime($today_is_this_date)));
$four_months_from_now = date('Y-m-d', strtotime('+4 months', strtotime($today_is_this_date)));

/// How many games have you worked? 
//$query = "SELECT COUNT(ump_id) FROM scheduled_umps WHERE `ump_id` = '$_SESSION[ump_id]'";   ///this one selects how many games you've worked NO MATTER WHAT THE DATE

$query = "SELECT scheduled_umps.game_id, games.game_id, COUNT(scheduled_umps.ump_id) WHERE scheduled_umps.ump_id = '$_SESSION[ump_id]' AND games.game_id = scheduled_umps.game_id AND games.game_id BETWEEN $four_months_ago AND $four_months_from_now";

$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "You have been scheduled on <b>". $row['COUNT(ump_id)'] ."</b> dates for the $_SESSION[association_name].";
}
?>
[\code]

Any ideas where I'm going wrong?  Thanks for the help...I HATE multi-table selects!

I have a Select statement that relies on two session variables to complete the statement. One variable, $egroup, supplies a column name. I cannot make the SELECT work. It works fine if I substitute the real name of one of the columns  such as "egroup1", or "egroup6", but that's what the variable $egroup is for. Can anyone tell me where I'm wrong?

I guess the answer is in the syntax, but I'm not very good at this and I've been on it for too long. Any help gratefully taken.

Code: [Select]
<?php                 
$query1 = mysql_query("SELECT * FROM topics WHERE managerId='".$managerId."' AND "$egroup"= 1 ORDER BY title ASC");
?>

$sql=mysql_query("SELECT * FROM `buds` WHERE `level`<='$user_level' UNION SELECT * FROM `buds`, `unlocked_buds` WHERE buds.`id` = unlocked_buds.`bud_id` ORDER BY buds.`id` ASC") or die("A MySQL error has occurred.<br />Your Query: " . $sql . "<br /> Error: (" . mysql_errno() . ") " . mysql_error());



I have been trying to learn about UNION select statements. I ran the query above and got this response:

Quote

Error: (1222) The used SELECT statements have a different number of columns



I think I know what the problem is, but not sure how to fix it.

There is two columns, one is "buds" which holds the flowers seeds info. The seconds is "unlocked_buds" which just links the "id" from buds to "user_id" to the user table.

Both buds and unlocked_buds are both 8 columns.

What do I need to learn?

Hey guys, I'm trying to get this working... No errors right now, but I'm not returning any results :/ been messing with it for days.

Code: [Select]
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" />
<label for="search_by">Search By</label>
<select name="search_by">
    <option value"player">Player</option>
    <option value"city">City</option>
    <option value"alliance">Alliance</option>
    <option value"browse">Browse</option>
    </select>
    <input type="text" name"search">
    <input type="submit" value="search" name="search">
 <?php
  $search_by = $_POST['search_by'];
$search = $_POST['search'];

  echo "<table><tr><td>Player</td><td>city</td><td>alliance</td><td>x</td><td>y</td><td>other</td><td>porters</td><td>conscripts</td><td>Spies</td><td>HBD</td><td>Minos</td><td>LBM</td><td>SSD</td><td>BD</td><td>AT</td><td>Giants</td><td>Mirrors</td><td>Fangs</td><td>ogres</td><td>banshee</td></tr>" ; 

$dbc = mysqli_connect('xx', 'xx', 'xx', 'xx') or die ('Error connecting to MySQL server');

$sql = "SELECT * FROM players WHERE ('$search_by') LIKE ('$search') ";
//problem is here^^?? 
$result = mysqli_query($dbc,$sql)
  or die("Error: " .mysqli_error($dbc));
Not sure, any help would be greatly appreciated.

Hi All, I have the following Query:

Code: [Select]
$query = 'SELECT `BookingID`,`OfferID`, `name`, `OfferCount`,`OfferPrice` FROM `Offers_Finance` JOIN offers_details ON `OfferID` =  `o_d_id` WHERE `BookingID` ="' .$bookerid. '"';
if ( !$result = $mysqli->query( $query ) ) { die( $mysqli->error ); }
$field = $result->fetch_object();

This will return anywhere between 0 and 50 Rows of Data.  For Each Row returned, I want to do the following:

Quote

        echo '<tr>';
   echo '<td>' . $field->name.'</td>';
   echo '<td></td>';
   echo '<td>&pound;' . $field->OfferPrice.'</td>';
   echo '<td></td>';
   echo '<td>' . $field->OfferCount . '</td>';
   echo '<td></td>';
   echo '<td>&pound;' . $field->OfferPrice * $field->OfferCount . '</td>';
   echo '</td>';
   echo '</tr>';



The problem I have is - how do I loop through the results returned from the query to output multiple rows?

Sorry if this doesn't make much snese, I'm new to PHP and the whole web development world, but have been landed with finishing a project someone else started!

If someone would be kind enough to turn this into a working example, it would help no end as I have about 20 of these things to figure out across the project!

Hi everybody
i am beginnet with working with sql in php..so i confused.....i made one scripte and i am making the secound and now i am facing a problem....i hope u could help!!
i have a dat=abse of my chatroom....this is the code i typed...please have a look at it!
Code: [Select]
$usern=$_SESSION['etchat_'.$this->_prefix.'username'];
$con1 = mysql_connect("localhost","manosir_main","********");
if (!$con1)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("manosir_manoshos_main", $con1);
$users= mysql_query(" select etchat_user_online_user_sex  from db1_etchat_useronline where etchat_user_online_user_name = $usern ");


 
in my database, i ahve a table called db1_etchat_useronline that keeps record of online users in chatroom.
as u usee i qant to to get the user sex ( etchat_user_online_user_sex) of th current user!!! as u see i conected to database correctly but now i dont know how to echo the $users . before this i echo my sql results with mysql_fetch_array ..but  now i cant.......i got nothing!!!! can someone help me!!!!!

I have got a set of data for a country for each week of the year, but want to display the data a quarter at a time, using a form which posts a value into LIMIT, which was OK for the 1st quarter, but for subsequent quarters I needed to use LIMIT in the form LIMIT start, rows. I found by experiment that this had to be the last statement in the query. when I added the start I got an error: Parse error: syntax error, unexpected ',' in /homepages/43/d344817611/htdocs/Admin/Visitdata.php on line 10 Here is the SQL part of my code:

$Visit_data="SELECT WeekNo.WNo, WeekNo.WCom, Countries.Country, ctryvisits.CVisits FROM ctryvisits 
LEFT JOIN Countries
ON ctryvisits.country=Countries.CID
LEFT JOIN WeekNo
      ON ctryvisits.WNo=WeekNo.WNo
      WHERE Countries.Country = '".$_POST["Country"]."'
ORDER BY ctryvisits.WNo LIMIT '".$_POST["QUARTER"]."'" - 13, '".$_POST["QUARTER"]."'";

Is this the best way of doing what I require or is there an easier way of achieving what I want?

Hi Guys

I don't know if this is possible but can someone point me in the right direction. I have a php function which takes two inputs and returns an output. for simplicity's sake let's say it's an addition function. What I want to do is use a mysql select statement to show all the rows from a database where field1 and field2 equal '3'. Here's the sort of thing I mean.

function addNumbers($one,$two) {
return $one + $two;
}

mysql_query("SELECT * FROM table WHERE 'addNumbers(field1,field2)' = '3'");

What I actually want to do is a lot more complex than this but I am trying to understand how to make the syntax work in simple terms first.

Can anybody help?

Many Thanks
Dan

here is some simple code for getting and displaying fata from a database

Code: [Select]
$sql="SELECT * FROM messages WHERE m_id = '".$id."'";

$result = mysql_query($sql);

<table border='0' cellspacing="4">

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<th>Message</th>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>" . $row['message'] . "</td>";
  echo "</tr>";
  }

now ive used that while loop to display those results how can i do that again without having a new SQL statement.

i cant do 2 while loops because the first one has already got to the end of the amount of rows

basically how can i have another while loop displaying those same results again?

//DATABASE CONNECTION VARIABLES
$myserver ="localhost";
$myname = "myname";
$mypassword = "mypassword";
$mydb ="mygamedb";


/*SQL CONNECTION*/
// Create connection
$conn = new mysqli($myserver, $myname, $mypassword, $mydb);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
else {

//variables
$username = $_POST["username"];
$password = $_POST["password"];
$ip = $_SERVER['REMOTE_ADDR'];

//INSERT USER
//prepare and bind
$stmt = $conn->prepare("INSERT INTO Players (Username, Password, IP) VALUES (?, ?, ?)");
//bind parameters
$stmt->bind_param("sss", $username, $password, $ip);
//set parameters and execute
$stmt->execute();
//close
$stmt->close();

//FETCH ID
$resultnews = mysql_query("SELECT * FROM Players WHERE Username ='$username'");
$rownews = mysql_fetch_array($resultnews);
$user_id = $rownews["ID"];


}

After having suffered an SQL injection into one of my sites, I figured it was time to overhaul it and use prepared statements. I am new to this. I figured out how to an INSERT with an example, but now I need to fetch an ID and cannot get it to work. Any help much obliged. All I need is just one good example. Looked all over the place, but all I get are insert examples, which is NOT what i need. Really need one with a select and fetch.

What's the correct syntax for having a variable in a select statement?

Here's an example of what I'm trying to do (after I'm already connected to the database).

Code: [Select]
$username = "thomas";
$query = mysql_query( "SELECT * from users WHERE username = $thomas" );
if( mysql_num_rows( $query ) > 0 )
{
bla bla...
It works if I don't put the WHERE part in, but I get an error if I use it, so I'm assuming I have the wrong syntax for using a variable in the select statement.