PHP - Select Records Based On Months

Hello:

I am trying to select all the records from a table, and display them.

Having an issue...

This is the code:
Code: [Select]
<ul>

<?php $query = mysql_query("SELECT id,mySectionTitle FROM myWebSiteData");
while($menuData = mysql_fetch_array($query))
{
<li><a href="a_websiteData.php?id=" .echo $menuData['id'] ."">echo $menuData['mySectionTitle']</a></li>
}
?>

</ul>

This is the error:
Code: [Select]
Parse error: syntax error, unexpected '<' in /html/admin/a_websiteData.php on line 91

line 91 is the one that starts with "<li>"

What am I missing, or what would be the best way to do this?

This topic has been moved to MySQL Help.

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

Hi,

I have a DB with two tables, customers and orders. One customer may have many orders, What I want to do is do a select on the two tables and get the customer info once, and then all the orders associated with the account.

I saw how to do this once before using a join and then having to use a PHP foreach to break it up. I am just not sure of how to put the two together to make it work, or maybe there is an easier way completely.

Any help is appreciated.

Thanks

B

Example:

Bob Smith
Shoes
Coat
Boots
Gloves

Sally Jones
Hat
Purse
Boots
Umbrella

Hello,
Please excuse me if this sounds like a bit of a newb question.
If I have a link to a users profile and use GET to pull information about that user from various tables using something like this:

Code: [Select]
<?php
{
$id = $_GET['id'];
$user = mysql_query("SELECT * FROM users,tbl1,tbl2,tbl3,tbl4,tbl5 WHERE $id=tbl1.user_id AND tbl1.user_id=tbl2.user_id AND tbl2.user_id=tbl3.user_id ANDtbl3.user_id=tbl4.user_id AND tbl4.user_id=tbl5.user_id");
$user=mysql_fetch_assoc($user);
}
?>
<h3>Table 1</H3>
<?php echo "<b>".$user['tbl1_title']."<br>"; ?><br />

<h3>Table 2</H3>
<?php echo "<b>".$user['tbl2_title']."<br>"; ?><br />

<h3>Table 3</H3>
<?php echo "<b>".$user['tbl3_title']."<br>"; ?><br />

<h3>Table 4</H3>
<?php echo "<b>".$user['tbl4_title']."<br>"; ?><br />

<h3>Table 5</H3>
<?php echo "<b>".$user['tbl5_title']."<br>"; ?><br />

Why does it only show the 1st record for that user from each table?
And mostly, how do I change it to show all or a certain number of records from each table?

Any help would be greatly appreciated.
Thanks in advance 

Hi all

I am trying to write a piece of code that selects different products from the database based on the URL parameter. There are 3 fields; category, type and colour.

My URL will look like this if there is all three selected:

product.php?category=31&type=74&colour=3

Basically, if what ever is set in the url I need this to be selected from the database. Here's my code:

if (!isset($_GET['category']) && !isset($_GET['type']) && !isset($_GET['colour'])){
 $fetchproducts = mysql_query(" SELECT * FROM `products` ");
  $lightboxcount = 0;
   while($returnedProduct = mysql_fetch_array($fetchproducts)) {
    $lightboxcount ++;
     include('product-cell.php');
}
}

Although if there is no colour or the colour is blank like this:

product.php?category=31&type=74&colour=

I want it to select the items from the database just where the category and type are set.

Please help!

Many thanks

Hey guys, I am wanting to select a dropdown value based on the value of 'level' in the row of the user select by a $_GET.


It will house the ranks of the user.


Here is my script.


RANK
<?php

mysql_connect("localhost","root","") or die(mysql_error());

mysql_select_db("chat");

$result = mysql_query("SELECT * FROM users WHERE user_id = '$_GET[id]'");

$row = mysql_num_rows($result);

?>




<form id="main_form" name="main_form" method="post" action="">
<select name="rank">
<option value="0" <?php if($row['level']=="0") { echo "selected"; }?>>Unactivated</option>
<option value="1" <?php if($row['level']=="1") { echo "selected"; }?>>Banned</option>
<option value="2" <?php if($row['level']=="2") { echo "selected"; }?>>Regular User</option>
<option value="3" <?php if($row['level']=="3") { echo "selected"; }?>>Donator</option>
<option value="4" <?php if($row['level']=="4") { echo "selected"; }?>>Moderator</option>
<option value="5" <?php if($row['level']=="5") { echo "selected"; }?>>Administrator</option>
<option value="6" <?php if($row['level']=="6") { echo "selected"; }?>>Owner</option>


</select>
<input type="submit" id="main_submit" name="main_submit" value="submit" />
</form>


It is not selecting for some reason at all.




Can someone tell me what I am doing wrong?

Here is my code:

//Grab all the monster in Monster zone 1

$q = $db->query('SELECT * from rpg_monsters where monster_zone = 1');

while ($monsterdata = $db->fetch_assoc($q))
    {
        $monster_chance[] = $monsterdata;
        
    }

and my var_dump:

array (size=4)
0 =>
array (size=8)
'monster_id' => string '1' (length=1)
'monster_name' => string 'Merman' (length=6)
'monster_level' => string '1' (length=1)
'monster_type' => string 'Normal' (length=6)
'monster_hp' => string '10' (length=2)
'monster_dmg' => string '1' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)
1 =>
array (size=8)
'monster_id' => string '2' (length=1)
'monster_name' => string 'Chris Wilson' (length=12)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Unique' (length=6)
'monster_hp' => string '25' (length=2)
'monster_dmg' => string '3' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.04' (length=4)
2 =>
array (size=8)
'monster_id' => string '3' (length=1)
'monster_name' => string 'Seaman Warrior' (length=14)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Magic' (length=5)
'monster_hp' => string '20' (length=2)
'monster_dmg' => string '2' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)
3 =>
array (size=8)
'monster_id' => string '4' (length=1)
'monster_name' => string 'Goblin Attacker' (length=15)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Normal' (length=6)
'monster_hp' => string '15' (length=2)
'monster_dmg' => string '2' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)

As you can see, the Unique Monster (Chris Wilson) is the lowest chance at only 4%. And all the other mobs at at 10% chance to spawn.   Here is my code for probability:

$rate = (double) '0.03'; // 3%
$max = 1 / $rate; // 100
if (mt_rand(0, $max) === 0) {
    // chance < $rate
    echo "Only 3% probability, holy cow!";
}

My problem is, I'm a bit lost as how to get my probability code inside a loop and having the dynamic $rate correspond to my "chance" row. Although, I could just use ORDER BY rand() in mysql, it wouldn't let me use any probability and chances... hmmm
Edited by Monkuar, 12 October 2014 - 11:12 AM.

This topic has been moved to JavaScript Help.

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

Hi,

I am trying to create a drop down menu that will select a value that is stored in the database - right now the code creats a dropdown (with nothing selected) - hope someone can help.

in the database, the values are stored as
--null-
Option1
Option2
Option3

my code is
Code: [Select]

$instruction = $_GET['instruction'];

<?php 
<select id="instruction" name="instruction">
<option value="" <?php if (!empty($instruction) && $instruction == '' ) echo 'selected = "selected"'; ?>></option>     
<option value="Option1" <?php if (!empty($instruction) && $instruction == 'Option1')  echo 'selected = "selected"'; ?>>Option1</option>
<option value="Option2" <?php if (!empty($instruction) && $instruction == 'Option2')  echo 'selected = "selected"'; ?>>Option2</option>
<option value="Option3" <?php if (!empty($instruction) && $instruction == 'Option3')  echo 'selected = "selected"'; ?>>Option3</option>
</select>
<?

Not sure why this isnt working.
Code: [Select]
<?php session_start(); ?>
<!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>
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />


<LINK REL=StyleSheet HREF="inc/dyn_style.css" TYPE="text/css" MEDIA=screen />
<?php

 ?>
<?php include('logic.inc'); mysqlConnect(); ?>
<script type="text/javascript" src="bbeditor/ed.js"></script>
<link rel="stylesheet" type="text/css" href="dyn_style.css" />
<title>
Social
</title>
<script type="text/javascript">
function changeTitle(title)
{
document.title = title;
}
</script>

</head>

<body>
<?php
$inc = 'new_story.php';
$view = 'Newest ';
$by = 'added';
$where = " ";
$where2 = " ";
$order = "ASC"; 
$gen = "All";
$rat = 'All';
$blerg = "";
$sort = 'newest';
//----------------------------------------------------------------------
if(isset($_GET['sub']))
{
$sort = $_GET['sort'];
switch($sort)
{
case "Most Popular";
$by = 'views';
$view = 'Most Popular ';
$order = 'DESC';
break;
case "Most Reviewed";
$view= 'Most Reviewed  ';
$by = 'reviews';
$order = 'DESC';
break;
case "Newest";
$by = 'added';
$view = 'Newest';
$order = 'ASC';
break;
}

$genre = mysql_real_escape_string($_GET['cat']);
$rating = mysql_real_escape_string($_GET['rat']);
if($gen ==  'All')
{
$where = " ";
$blerg = "";
}
else
{
$where = "WHERE cat='$gen'";
}
if ($rat == "All")
{
$where2 = ' ';
$blerg = 'AND';

}
else 
{
$where2 = $blerg ."
 rating = '$rat'
";
}
}
//----------------------------------------------------------------------


?>
<?php serch(); ?>
<form action="story.php" method="get">
<label id='inline'> Order By: </label>
<select name='sort'>
<option selected='yes' label='Currently Selected' > <?php echo $view;  ?> </option>
<option> Newest   </option>
<option> Most Popular</option>
<option>  Most Reviewed </option>
</select>
<input type='hidden' value='spec_view' name='p' />
<label id='inline'> Genre/Catagory:  </label>
<select name='gen'>
<option selected='yes' label = 'Selected Genre - <?php echo $gen; ?>'> <?php echo $gen; ?> </option>
<option> All </option>
<option> Fantasy </option>
<option> Adventure </option>
<option> Science Fiction</option>
<option> Drama</option>
<option> Fable </option>
<option> Horror</option>
<option> Humor</option>
<option> Realistic Fiction </option>
<option> Tall Tale</option>
<option> Mystery  </option>
<option> Mythology  </option>
<option> Poetry  </option>
<option> Shorty Story </option>
<option> Romance </option>

</select>
<label id='inline'> Rating: </label>
<select name='rat'>
<option selected='yes' label = "Selected Genre - <?php echo $rat; ?>"> <?php echo $gen; ?> </option> 
<option> All </option>
<option> C </option>
<option> C13 </option>
<option> YA </option>
<option> A </option>

</select>

<input type='submit' value='Go!'  name = 'go' />
</form>
<?php

$query = "
SELECT * FROM story_info
ORDER BY $by $order 
$where
$where2
";
echo $query;
$select = mysql_query($query) or die(mysql_error());

while($rows = mysql_fetch_assoc($select))
{
$viewsdb = $rows['views'];
$titledb = $rows['title'];
$userdb = $rows['user'];
$catdb = $rows['cat'];
$ratdb = $rows['rating'];
$id_db = $rows['story_id'];
$sumdb = shorten($rows['sum']);
echo "<h3><a href='?p=page&id=$id_db'> $titledb </a>   </h3>";
echo "<div id='fun_info'>";
echo "$sumdb <br />";
echo "By <a href='?p=profile&user=$userdb'> $userdb </a> <br /> ";
echo "$viewsdb Views | Rated: $ratdb | Catagory: <a href='?p=cat_view&gen=$catdb'> $catdb </a>  </div>";
}
?>
</div>

</body>
</html>

I am having trouble showing reports for a given date range. Currently if I specify something like 11/03/2010 to 11/05/2010 I get results for all years within that month and day such as I may get results for 11/03/2008 11/03/2009 11/03/2010 11/04/2008 11/04/2009 11/04/2010 11/05/2008 11/05/2009 11/05/2010.
I am using the following code
$result = mysql_query("SELECT * FROM report WHERE date>='$date_begin' and date<='$date_end' ORDER BY 'date'",$db);

I use the following format in my date feild mm/dd/yyyy

My script is finally working as intended, but I want to add some additional data results.

I am trying to resolve how I can display a count of ONLY the records updated by my query:

// START :: Query to replace matches
mysql_query("UPDATE orig_codes_1a AS a
      JOIN old_and_new_codes_1a AS b ON concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)
   SET a.orig_code_1 = b.new_code_1,
                           a.orig_code_2 = b.new_code_2") or die(mysql_error());
// END :: Query to replace matches


In this query I count ALL records selection:


// START :: Create query to be displayed as final results of original codes table.
$result = mysql_query("SELECT * FROM orig_codes_1a") 
or die(mysql_error());  

I want to display a count on this part of the query:

....concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)....

Hello,

I had 8 select boxes(dropdowns) in a form. Its like a search kind of implementation in the website. I don't know what the user selects, he may choose different select boxes, any number of select boxes.

So, based upon the user selection, I need to generate the data. The data fields to be generated would be almost same.

So, How would I know what the user selection is and how many select boxes has been selected and how could I generate different data based upon selected boxes.

I had to make a small note abt this, that the data generation fields may change for some of the user select combinations, but most of the result fields would be same.

so, can you please help me out, how to do, how to make different combination data generations, because, i had 8 fields, i had to make 8! combinations, that would result in a big code.

I'm trying to figure out for the months I can get it to display the last 5 months including the current month. The reason for this is I"m going to get the total number of hits for my website  for each month as well as the number of successful logins for my CMS script. Any thoughts?

Code: [Select]
<table class="visualize_dashboard">
<caption>
Dashboard Chart Example
</caption>
<thead>
<tr>
<td></td>
<th scope="col">March</th>
<th scope="col">April</th>
<th scope="col">May</th>
<th scope="col">June</th>
<th scope="col">July</th>
</tr>
</thead>
<tbody>
<tr>
<th scope="row">Visits</th>
<td>175</td>
<td>145</td>
<td>212</td>
<td>175</td>
<td>182</td>
</tr>
<tr>
<th scope="row">Logins</th>
<td>94</td>
<td>53</td>
<td>124</td>
<td>92</td>
<td>105</td>
</tr>
</tbody>
</table>