₦airaland Forum

sinaj:
I subscribed b4 my data finished nd they gave me 1.6gig.

I had to call their cust. care b4 they gave me additional 1.6gig.

I wonder how many days 1.6gig would av last for me mitcheeeeew!

The annoying thing is that their ntwk is slower now.
M xo done with glo

i got 7gig after some hours i even tot i wont get the so called double, but now its like u dont reload after 3days oyo for u, by fire by force, glo done join apc.

so if 3days pass i no reload data 100 % go b dat na wow oh

aieromon:
About $45 from Amazon. You can contact mayorall to give you a favorable quote.

i meant the laptop

aieromon:
Have you considered a battery replacement? I just ordered one myself

hw much u order urs

emperorizzy:
you're right, I have an aspire s3 whose battery is ver poor.

how much did u buy urs n where

webdeveloperqx:
You will need more of javascript /jquery and css. you can fetch the users who match your constraints and loop your main menu same time loop the sub menu , thats is just like get all categories and why getting the categories get the sub categories as well.

if only i knew how to go about it, can u help with d code?

hello programmers again really need your help with this, i Need a menu linked to a sub menu

i have a menu code and a submenu code but they arent linked, both i select manually, so i need help linking both of them.
the menu consist of two values team1 and team2 i want when i select team1 it should drop down a menu of users who selected team1 and vice versa.

for the MENU we got two tables they are

auctions: with column: id team1 team2
bids: with column: auction bidder willwin


and for the submenu we also have two tables
bids with: column: auction bidder willwin
users with: column: nick


MENU CODE

// MENU team select
$query = "SELECT a.id, a.team1, a.team2, b.auction, b.bidder, b.tagged, b.willwin, b.willlose FROM " . $DBPrefix . "auctions a
LEFT JOIN " . $DBPrefix . "bids b ON (b.auction = a.id)
WHERE a.id = :auc_id and a.id = a.id group by a.id";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

$TPL_team_list = '<select name="willwin" class="form-control">' . "\n";
while ($row = $db->fetch())
{
$TPL_team_list .= "\t" . '
<option value="' . $row[''] . '" ' . $selected . '>' . $row[''] . '</option>
<option class="team1" value="' . $row['team1'] . '" ' . $selected . '>' . $row['team1'] . '</option>
<option class="team2" value="' . $row['team2'] . '" ' . $selected . '>' . $row['team2'] . '</option>
' . "\n";
}

$TPL_team_list .= '</select>' . "\n";

{
$template->assign_block_vars('tag_bidder', array(
'TEAM' => $TPL_team_list,

));
$i++;
}



SUBMENU CODE
// SUBMENU user name
$query = "SELECT b.*, u.nick, u.rate_sum FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id order by b.willwin";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

$TPL_team_list = '<select name="tagged" class="form-control">' . "\n";
while ($row = $db->fetch())
{
$TPL_team_list .= "\t" . '
<option value="' . $row[''] . '" ' . $selected . '>' . $row[''] . '</option>
<option value="' . $row['bidder'] . '" ' . $selected . '>' . $row['nick'] . '...' . $row['willwin'] . '</option>
' . "\n";
}

$TPL_team_list .= '</select>' . "\n";

{
$template->assign_block_vars('tag_bidder', array(
'NAME' => $TPL_team_list,

));
$i++;
}


really looking forward to ur help thanks.

this: $country_result = $conn->query("SELECT b.auction, a.id FROM " . $DBPrefix . "vs_auctions a

connect to this database

<?php
$conn = new mysqli('localhost', 'root', 'pass', 'db');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

while these: $query = "SELECT a.id, b.auction FROM " . $DBPrefix . "auctions a

connect to this database

<?php
$DbHost = "localhost";
$DbDatabase = "db";
$DbUser = "root";
$DbPassword = "pass";
$DBPrefix = "vs_";
$main_path = ":\\xampp\\htdocs\\vset\\";
$MD5_PREFIX = "ca801ec4f5c664bc6a492f942b3a07eb";
?>


how do i rewrite this
$country_result = $conn->query to work like this $query =

what kind of drugs can one take to accomplish sure mission

u try but nope

chygoz3:
From my understanding of your code, when the page loads, the countries select input is populated with a list of countries. Assuming all the php code is in one file, the part where you are trying to get the States for a country will result in an error because $_POST['country-id'] will not have a value (loading the page the first time is done using the http GET method).
Now since you want to load the states in a selected country asynchronously via AJAX when a country is selected, you need to pass the fill the url parameter of ajax which tells Ajax which php file to call.
From the code you provided, it is unclear what the error you are trying to fix is.

ok i get what u saying, am think of trying something else, will update soon

chygoz3:
Which URL are you making your Ajax call to?

i only have aa menu code without d submenu so not calling yet

no response

i have this code below its working fine but i need it to display result the other way round for example the code display result like this

On click(Nigeria) it shows drop menu of (3,6,4)
On click (Ghana) it shows drop menu of (5,2)

i want the code altered so it displays this way

On click(Nigeria) it shows drop menu of (5,2)
On click (Ghana) it shows drop menu of (3,6,4)


code below thanks



<?php
error_reporting(E_ALL);
ini_set('display_errors',0);
require_once('conn.php');
$country_result = $conn->query('select * from countries');
?>

<select name="country" id="countries-list">
<option value="">Select Country</option>
<?php
if ($country_result->num_rows > 0) {
// output data of each row
while($row = $country_result->fetch_assoc()) {
?>
<option value="<?php echo $row["id"]; ?>"><?php echo $row["country_name"]; ?></option>
<?php
}
}
?>
</select>
</br></br></br>
<select name="state" id="states-list">
<option value=''>Select State</option>

</select>
<?php

$country_id = mysql_real_escape_string($_POST['country_id']);
if($country_id!='')
{
$states_result = $conn->query('select * from states where country_id='.$country_id.'');
$options = "<option value=''>Select Name</option>";
while($row = $states_result->fetch_assoc()) {
$options .= "<option value='".$row['country_id']."'>".$row['state']."</option>";
}
echo $options;
}

?>


<script src="js/jquery-1.3.0.min.js"></script>
<script>
$('#countries-list').on('change', function(){
var country_id = this.value;
$.ajax({
type: "POST",
data:'country_id='+country_id,
success: function(result){
$("#states-list".html(result);
}
});
});
</script>

youngest85:
When the business boom finish, u go kill the person throway

hahahha every body dey fear like mad for nija

i simply used column = column group by column this will limit only that column

smartty68:
Use leg press the siro and ego work

i tried that didn't work i even try ear

i press zero for customer care but its not going, abi mtn done sack all there customer care rep

easier said than done

dhtml18:
It is good that you have figured it out, you should have mentioned your solution then - maybe it might help someone.
Figuring out how to sort out a JOIN JAM without having the tables is not exactly simple.

make another seperate query, thus not including left join

dhtml18:
Hmn, i rest my case then. My advice is to study well each of the things you use, that way you wil figure out what the best thing to use is.

already figure it out n d method u said didnt work, sooooooooo.

dhtml18:
There are many ways to approach it, but without seeing the schema of your table,
I can tell you that what you need is group by

e.g.

$query = "SELECT b.*, u.nick, a.id, a.team1, a.team2 FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
LEFT JOIN " . $DBPrefix . "auctions a ON (a.id = b.auction)
group by b.id
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

group by id reduced both to 1 result was hoping to reduce a.id to 1 n let d rest by as they are

am having a duplicate result because of bids.
i need to limit the result for only auctions to 1, i tried "limit 1" but they all get limited to 1 both bids n auctions, how do i limit only auctions to 1
how do i go about this, thanks.

$query = "SELECT b.*, u.nick, a.id, a.team1, a.team2 FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
LEFT JOIN " . $DBPrefix . "auctions a ON (a.id = b.auction)
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

stanlink:
Thank you sir, please point them out am willing to correct them.

why are nigerian blame

ewizard1:
Seen... You can remove it please!!!

+917506028156
+982196738352

is name is alex

ewizard1:
Thanks sir! Can I speak with you please? Your line?

09075252828

TrapQueen77:



Werris the pishure?

look closely its there in link style

ewizard1:
Hello, I need an Indian contact to help me with a deal in India. Preferred location is Bombay but can check with other locations.

Please, I need a legit and trustworthy person.

I can be reached on chat 07038616199

Thanks!

+918806460712 his name is apa he is the chairman for edo people in mumbai my name is ehis.

cbrass:
did you write this code your self?

rewrote em from an existing code

cbrass:
It can't update now since its not David that tagged but was tagged

yeah anyway one can update it?

hi programmer i have an issue here.
so let me explain better, if david place a bid but doesnt tag any one the column looks like this

bidder......tagged
david ..... 0

and if someone else(mike), place a bid and tag david

the column look like this

bidder......tagged
Mike ..... david

this shows both mikes and david rows
bidder......tagged
david ..... 0
mike ..... david

u can see david row doesnt update, it should show mike and not 0, hope u understand.

below is the code am using to fill the form

// tag someone
$query = "SELECT b.*, u.nick FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id ";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

$i = 0;
while ($row = $db->fetch())
{
$template->assign_block_vars('tag_bidder', array(
'ID' => $row['bidder'],
'NAME' => $row['nick'],
'TAGGED' => $row['tagged']
));
$i++;
}

can u pm me thanks