PHP - What's The Best Way To Randomly Select A Single Variable From Two Variables?

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 

I currently have a problem where I'm trying to list alot of products with the category heading only being returned once and then the long list of products within that category being listed.
For Example

Football boots
Nike
Addidas
Puma
etc

Whereas at the moment I'm getting.
Football boots
Nike
Football boots
Addidas
Football boots
Puma

My current code for this is as follows.

<?php while($row = $db->fetchrow($stuff)) { ?>
   <li><a href="store-<?php echo $row['cat_id']; ?>/<?php echo seo_makeSafeURI($row['cat_title']); ?>.html"><strong><?php echo stripslashes(htmlentities($row['cat_title'])); ?></strong></a></li>
   
   
   <li><a href="store-<?php echo $row['cat_id']; ?>-<?php echo $row['prod_id']; ?>/<?php echo seo_makeSafeURI($row['prod_title']); ?>.html"><?php echo stripslashes(htmlentities($row['prod_title'])); ?></a></li>
   <?php } ?>

Any help would be much appreciated.

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you

Hi,

I am able to parse php variable in double quote but not in single quote.

How can I parse in single quote.

Following example shows 2 results and I want same result in both.

First Name :    Zohaib
First Name :    $firstname

Code: [Select]
// Connecting, selecting database
$link = mysql_connect('localhost', 'root', 'password');
mysql_select_db('dbname');

// Performing SQL query
$query = 'SELECT first_name FROM tablename';
$result = mysql_query($query);

// Printing results in HTML
while ($row = mysql_fetch_assoc($result)) {
$firstname=$row['first_name'];
}

echo"<table>
<tr>
<td>First Name : </td>
<td>$firstname</td>
</tr></table>";

echo'<table>
<tr>
<td>First Name : </td>
<td>$firstname</td>
</tr></table>';
What are the changes I need to do to achieve same result.

Any solution ?

- Thanks.

Hello everyone,

I can get Test 2 to successfully operate the if statement using a variable variable.

But when I try the same method using a session variable (Test 1) the if statement is not executed. Please could you tell me why the if statement in Test 1 is not being executed?

Code: [Select]

<?php
# TEST 1
$_SESSION[test_variable] = "abcd";
$session_variable_name = "_SESSION[test_variable]";
if ($$session_variable_name == "abcd")
{
echo "<br>line 373, abcd<br>";
}

# TEST 2
$test_variable = "efgh";
$test_variable_name = "test_variable";
if ($$test_variable_name == "efgh")
{
echo "<br>line 379, efgh<br>";
}

?>
Many thanks,

Stu

What I'm wanting to do is pass the $propertyid = "1";  threw my select value as you can see. so it passes variable so to speak.'



Code: [Select]
print "<td>Control:<form action=\"dashboard.php\" method=\"GET\" target=\"_self\">
        <select name=\"control\" onChange=\"this.form.submit()\">
        <option selected></option>
        <option>Take a Payment</option>
        <option>Print Ledger </option>
        <option>-----------------</option>
        <option value=\"comadd?propid=$propertyid\">Add Communication</option>
        <option>----------------</option>
        <option>Modify Property</option>
        <option>Remote Property</option>
        </select></td>";

$var = @$_GET['q'] ;
$trimmed = trim($var);
$table = @$_GET['field'];
$query="SELECT * FROM contacts WHERE @'table' contains @'trimmed' order by id";
$result=mysql_query($query);
$num=mysql_numrows($result);


Why wont this work?

Zacron

Hello.

I have  a simple enough code that takes information from one table and drops it into another.  This is great, but I have 2a new complexities that I have been unable to code correctly.

A.  'lastname', 'firstname' on table1 need to be combined into 'name'

How & Where do I combine these strings and then pass them?

Code: [Select]
<?php
include('dbconfig.php');


// Make a MySQL Connection
mysql_connect("localhost", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

$result = mysql_query(
"INSERT INTO table2 (lastname, firstname, email)
SELECT lastname, firstname, email
FROM table1
WHERE email='someemail@gmail.com' ") or die(mysql_error());

?>

Code: [Select]
$query  = "SELECT content FROM license WHERE serial  = '".$serial."'";

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>

Hi everyone,

I have this php code, which connects to a mysql database (through dbconnect.php) and is meant to select the lowest difference between two variables. I can't get very far. The most valuable differences are not the lowest per se, as much as the closest to 0, either positive or negative. Both numbers are positive integers. The page dictates the relative 'ranking' of the page, by multiplying the rank by 20, so that with each successive page, the retrospective line is 20 higher in ranking. The section 20*$page+x is not a value, but a ranking, so the instance would by, in words 'select the lowest difference between two numbers. If the number closest to 0 cannot be selected, can we find the highest value out of the two variables and subtract the lower (they are interchangeable)
Code: [Select]
<?php
 $page = $_GET['page'];
 include("dbc.php") //connect to mysql database
 $result = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +1}"); // { indicates my unsure section
while($row = mysql_fetch_array($result)){
 $id = $row['id'];
 $username = $row['id'];
 $sum1 = $row['id'];
 $sum2 = $row['id'];
}
 $result1 = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +2}"); // { indicates my unsure section
while($row1 = mysql_fetch_array($result1)){
 $id2 = $row['id'];
 $username2 = $row['id'];
 $2sum1 = $row['id'];
 $2sum2 = $row['id'];
}
//this continues with the mysql $page+x increasing successively 
?>
Also, could we apply a formula that would increase the weighting of those with a higher sum.

Thanks a lot, this is really over my head

Jack

I am not sure how to do the below, would variable variables be the way -- those are a new and confusing thing for me :-/

i have an array:

$contactData = array('admin_firstName' => 'John', 'admin_lastName' => 'Smith', 'user_firstName' => 'Betty', user_lastName => 'Jones'); 

I have a function that little function that looks like this:

function compare($contactSet, $var, $value){

global $contactData;

    $key = $contactData . "['" . $contactSet . "_" . $var ."']";
    //above doesnt work, but you can see how the array key is constructed
    
if ($key == $value) { 
// So, if the array key varied it would look like:
// if ($contactData['admin_firstName'] == $value

echo "same";

} else {

echo "different";

}

}


and then I want to call it like this:
compare('admin', 'firstName', 'John'); //would echo "same";

Any help is greatly appreciated. I have often wanted to use variable variables, or whatever this would be called, but don't know to pull it off. I can add another example if this wasnt clear enough.

I need to use a variable variable.

I need:

$row['pos_1']
$row['pos_2']

to use $i for the numbers

I have this:

if ($row{[pos_.$i]} == 'ad')

which is throwing an error

Quote

Parse error: syntax error, unexpected '['



Any ideas?

Thanks!

Hi, all... have a basic question here as a newbie that I am...

Many times, in some scripts I see (I think, if not mistaken), places where within a echo sentence I see variables echoed like this with no quotes:

echo "First Name: $firstName and Last Name: $lastName"; 
as opposed to like one would expect:
echo "First Name: " . $firstName . " and Last Name: " . $lastName"; 

Sometimes I see that also when variables are used in select/update statements I think.. like this:
$query = mysql_query("SELECT FROM table WHERE column = $columnname");
Instead of like this within quotes:
$query = mysql_query("SELECT FROM table WHERE column = '$columnname'");


Is it because some of these values may be numbers (numeric) as opposed to "strings"??
Not sure if I make sense... appreciate teh feedback,
Thanks!

I know how to use $$ and ${} to use variable variables, but how would I get the same functionality out of a variable that is storing an object name?

I have a function that is passed the name of an array of objects.  As you can guess, that name will change based on which portion of the program is calling
the function.  How would I use variable variables of objects in this instance?  Would it just be:

Code: [Select]
$this->${$objArrayName}->threadName = etc;
?

To make sure I'm not being misunderstood, I have 3 arrays of objects (replies, mainThreads, and stickies) and depending on which name I pass the function, I want it
to use $this->replies OR $this->mainThreads OR $this->stickies to apply properties of those objects to.

Thanks for any help.

-Adam