PHP - Finding Mutual Friends And Selecting Information From Separate Tables Mysql

I have two button that load the next and previous pages of friends, I'm having trouble doing so, it sort of works, but it's got bugs so it's not right.

Next:
Code: [Select]
$query = mysql_query("SELECT * FROM friends WHERE (friend_1='".$id."' OR friend_2='".$id."') AND id>$last_id ORDER BY id ASC LIMIT 16");previous:
Code: [Select]
$query = mysql_query("SELECT * FROM friends WHERE (friend_1='".$id."' OR friend_2='".$id."') AND id<$last_id ORDER BY id ASC LIMIT 16");
$id = id of the users profile.
$last_id = the last loaded friend id (unique id to friends table , not the friends actual id)

Hi Guys,

I need a little help. This one is giving me a real head ache :-(

I have created a archive database in mysql. Within the database there are tables named  YYYYMMDD_var. The tables layout is as follows:
####################################
node + T00 + T03 + T06 + T09 + T12 + T15 + T18 + T21
####################################

I have created some drop down menus in php to call for the dates Dateto and Datefr. I then calculate the diff between the dates and return the output (20101101_var, 20101102_var etc,,,)

But when I call for the mysql Select I cant get all tables :-(

This is the following code I have been using, starting from getting requesting the dates from the drop down menus.

The problem lies in the UNION, where because it's caught in the loop, it returns it at the end of the line. Which creates the error.

If anybody has any other ideas, please help :-)

//dates from
$dayfr = $_REQUEST['dayfr'];
$monthfr = $_REQUEST['monthfr'];
$yearfr = $_REQUEST['yearfr'];
//dates to
$dayto = $_REQUEST['dayto'];
$monthto = $_REQUEST['monthto'];
$yearto = $_REQUEST['yearto'];
$var = $_REQUEST['var'];

//cacluate the diff
function days($date1, $date2){
$month1 = date("m", strtotime($date1));
$day1 = date("d", strtotime($date1));
$year1 = date("Y", strtotime($date1));
$month2 = date("m", strtotime($date2));
$day2 = date("d", strtotime($date2));
$year2 = date("Y", strtotime($date2));
$first = gregoriantojd($month1, $day1, $year1);
$second = gregoriantojd($month2, $day2, $year2);
$diff = abs($first-$second);
return $diff;
}

$date1 = "$yearfr-$monthfr-$dayfr";
$date2 = "$yearto-$monthto-$dayto";

$days = days($date1, $date2);
for($i=0; $i<$days; $i++){
$newdate = date("Ymd", strtotime("$date1 +$i days"));

$datevar="$newdate$var ,";
$getdata="SELECT * FROM $newdate$var WHERE node='1' UNION ";
echo "$getdata";
}
//NOW SELECT OUR TABLES FROM THE ARCHIVE DATABASE
$data=mysql_query("$getdata") or die(mysql_error()); 

I have the following code, and really can't see what is wrong with it. Any help would be great.

<?php
if (!mysql_connect('127.0.0.1', 'root', '')) {
echo 'Could not connect to mysql';
exit;
}

$dbname = 'Requests';
$result = mysql_list_tables($dbname);
if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}

while($row2 = mysql_fetch_row($result)) {
   foreach ($row2[0] as $table_id) {
      
$query = "SELECT * FROM $table_id";
$dbresult = mysql_query($query);

// added code to use the tablename and select all records from that table
// create a new XML document
$doc = new DomDocument('1.0');
// create root node
$root = $doc->createElement('mixes');
$root = $doc->appendChild($root);
// process one row at a time
while($row = mysql_fetch_assoc($dbresult)) {
     // add node for each row
  $occ = $doc->createElement($table_id);
  $occ = $root->appendChild($occ);
   // add a child node for each field
  foreach ($row as $fieldname => $fieldvalue) {
       $child = $doc->createElement($fieldname);
    $child = $occ->appendChild($child);
   $value = $doc->createTextNode($fieldvalue);
    $value = $child->appendChild($value);
     } // foreach
} // while
}
}


echo 'Wrote: ' . $doc->save("s.xml") . ' bytes'; // Wrote: 72 bytes

?>

To accomplish the layout I was looking for, I used the following code:

for ($i=1; $i<=7; $i++)
   {

//set day of week for display as title of columns
$dow=date("l", strtotime($year.'W'."$weekno"."$i"));

echo "<td class=\"wvcolumn\" valign=\"top\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" width=\"$daycolumn\">
<tr><th class=\"wvtitle\" valign=\"bottom\" align=\"center\" width=\"$daycolumn\"><a class=\"titledate\" href=\"createticket.php?action=o&month=".date("m", strtotime($year.'W'."$weekno"."$i"))."&date=".date("d", strtotime($year.'W'."$weekno"."$i"))."&year=".date("Y", strtotime($year.'W'."$weekno"."$i"))."\">$dow, ".date("F d", strtotime($year.'W'.$weekno."$i"))."</a>&nbsp;<a onClick=\"window.open('http://www.batchgeo.com')\" title=\"Map $dow's Appointments\" href=\"mapday.php?week=$weekno&year=$year&day=$i\"><img width=\"20\" style=\"border-style: none\" src=\"../images/icon_globe.png\"></a></th></tr>";

if(date("Y-m-d")==date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))) {
$query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 23:59:59' UNION SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status = 'Pending' ORDER BY status ASC, apptdatetime ASC";
} else { $query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 23:59:59' ORDER BY apptdatetime ASC"; }

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
//if ticket is open show appt time and business, if ticket pending display DELIVERY and business name
if($row[status]=="Open") { $href="createticket.php?action=e&ticket=".$row[ticketnumber]; $time=$row[fapptdatetime]; $delivery=""; } elseif($row[status]=="Pending") { $href="createticket.php?action=c&ticket=".$row['ticketnumber'].""; $time=""; $delivery="DELIVER"; }
echo "<tr><td valign=\"top\"><a title=\"".$row[ticketnumber]." - ".$row[title]."\" class=\"".$row[status]."\" href=\"$href\"><span>$delivery$time ".substr($row['business'], 0, $displaychars)."</span></a></td></tr>\n"; }

echo "</table>";

}

echo "</td></tr>
</table>";

Output is similar to this, and any existing "deliveries" are displayed under the current day.
 _________________________________________________ ______________
|     Monday     |     Tuesday     |    Wednesday    |     Thursday     |       Friday       |
|appointments |appointments |appointments     |appointments   |appointments

This works great, but requires 5 separate queries. My database is very small for now, so its not a big deal, but I know this can be done much more efficiently.

How can I query the whole week and put appointments in their corresponding tables (days)? Thank you for your help!

Hi this is what I have set up -

SQL tables -

Members -
memberid - primary key
Username
Password
Orders -
Orderid - primary key
memberid - foreign key
orderno

In my sql table there are two members and two orders.
1 order is assigned to 1 member and the other order to the other member.

After each member logs in I need to 'echo' that order on the page.


I've not been able to write any succesful php code that 'gets' the specific order that is related to the member that has signed in.

I would appreciate help on this!
Thanks