ok. Ugly girl

First to Comment! Gosh!!! I can't believe this.

I will like to say hi to my family. Your sibling Lilly
is on front page.

Shout out to our pastor for his prayers. And to MTN for not disappointing me.

But one question I have, why must all these Bloggers do copy and paste every time. Even if you can't create contents yourself, can't you at least edit it to suit the Nigerian environment/audience?

michaelwilli my email is not working o

Locotech dueal ANTONINEUTRON sleepingdemon Joshuabase wisemania spikesC Booyakasha crotonite splashz hollyfat Kodejuice teampregar

Thanks everybody. It's now working. I really appreciate the help

Tnx. My system is off. till light comes.

dueal:
Did u put double quotes btw d single quotes? And not 4 single quotes?

I put double quotes

dueal:
You can do: function getID(elem){ var localvar = '"' + elem.id + '"'; } you need to concatenate d quotes with the id to form a proper string.

It didn't work

dueal:
Try onClick="getID(this)" or onClick="alert(this.id)". Also generate ur id's to start with a letter not a number

Tnx. If I do it this way, it would truly alert the id. But I would like to put the id inside a Variable. How do I do that.

Tanx

dueal:
Understand that your source first gets interpreted on the server side. Place Id = v<?php phpcho $id;?>. Before that make sure $id variable in php is not an array and a proper name.

Thanks. But let me expansiate further. Suppose I have this three links:

<a href='#' id='1' onClick='getID()> Click Me </a>
<a href='#' id='2' onClick='getID()> Click Me </a>
<a href='#' id='3' onClick='getID()> Click Me </a>

Normally, if the links weren't dynamically generated, I could do this to get the id:

function getID {
var MyID=document.getElementById('2').id;
alert.(MyID);
}

This would return 2 which is the id of the second link.

But the problem is that the links are dynamically generated. And they have unique ids.

Please help me out.

Locotech:


/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "demo";

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}

// Escape user inputs for security
$first_name = mysqli_real_escape_string($link, $_POST['firstname']);
$last_name = mysqli_real_escape_string($link, $_POST['lastname']);
$email_address = mysqli_real_escape_string($link, $_POST['email']);

// attempt insert query execution
$sql = "INSERT INTO persons (first_name, last_name, email_address) VALUES ('$first_name', '$last_name', '$email_address')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

// close connection
mysqli_close($link)

Na wa o. Sir this is not what i'm asking. Thanks for taking the time anyway.

^^^ Tnx for the reply. But the problem i have now is totally different from that. My problem is :

How do I get the ID of a link, once i click the link. if I should use onClick='alert.(this.id)', it would alert the ID whenever i click the link. But i want to insert the ID into my database instead of alerting it. Please how do i do that

Please guys help me o. I've searched all over the internet and still can't find solution to this.

I have a link (html element), whose ID is automatically generated with PHP. Whenever the link is clicked, i want to insert the ID of the link into my database. The only problem now is how to get the ID.

This is my mock code:

///// The PHP that generates the id:
<?php
$id=(an array of numbers returned from a while loop);
?>


////the html link
<a href='#' onClick='MyId()' id='<?php echo $id ;?>'>Click Me</a>

/// the javascript function
function MyId() {
var ID=document.getElementById( the id of the element generated by php ).id;
}

My question now is how do i get and put the id of the clicked link into variable var ID

Godmother:


It should be this month. This Feb seems to be pretty bad. I have gotten just 20 sales this month. Why not try uploading your fictions to okadabooks.com

Thanks. Do you write fictions?

Lolz. Okadabooks? The fiction is western themed

Pls answer me o. Has anyone published a fiction on Amazon. Is it selling?
Im asking because all my non fictions are not selling

Pls who has written a novel here. Is it selling? Or is everybody writing non fiction

So this is the Goldbetz my brother always talk about

hollyfat:

$sql = mysql_query("select amount from table where user='dami24'" or die(mysql_error());
$product = 1; //initialize your product
while($rs = mysql_fetch_assoc($sql)){
$amt = $rs['amount']; //get the amount
$product *= $amt;
}
echo $product;

My God It Worked! Im really, really grateful. I can't thank you enough.

I spent up to 3 hours before i was finally able to make the other one work, only to realize it was multiplication i was seeking, not addition.

I had even given up, and accepted my fate that i will never be a programmer, only for me to try out ur code and it worked!

Thanks very much.

My God! Its multiplication im looking for not addition. Im totally unserious! Please help me out

hollyfat:


$sql = mysqli_query("SELECT SUM(Amount) as total FROM table where user='dami24'" or die(mysqli_error());

$rs = mysqli_fetch_assoc($sql);
$sum = $rs['total'];

echo $sum;

Does this also work on regular mysql (not mysqli) ?
I tried it, it didnt work

Thanks everybody for taking your time out to help me. Its finally working.

coldspot:
lol.. you can sum it up right from your SQL statement

SELECT SUM(column_name) FROM table_name WHERE condition;

Select sum(Amount) From Table Where user=dami24;

Thanks. How do i echo the result?

I cant believe all the programmers here are only programmers by mouth. It is well o

Pls help me out o

yorex2011:



Ensure your semicolons are correct... Send a screen shot of the code if possible

And mysqli is properly spelt

Ive cross checked it. It's properly spelled. And no ommission. Pls help me out

yorex2011:
Try this <?php


$query = "SELECT * FROM `table` WHERE `User`='dami24'"; $result = mysqli_query ($link, $query) ; $row = msqli_fetch_assoc($result) ; $row_cnt = $result->num_rows; $sum = 0; $cnt = 0; //try 1 if 0 doesnt work properly while ($cnt < $row_cnt) { $row = msqli_fetch_assoc($result) ; $amount = $row['amount'] ; $sum = $sum + $amount; $cnt++; } ? >

It's showing error: Unexpexted T Variable on this line:
$row_cnt = $result->num_rows;
... and the ending curl bracket ( } ).
And please how do i echo the result out, and also store it into a vairable
Thanks

Hi NL Programmers, pls this php code is running me mad. I really need your help.

In my database Table, I have 2 rows. The first is named 'User' and d second is named 'amount'.

There are two records in the table:

Record 1: User=dami24, Amount=120

Record 2: User=dami24, Amount=30

What im trying to do is to "Select Amount From Table Where user=dami24"

After selecting the amounts, i want to add them together, so the final result should be 150 (120+30).

l've tried all i could without the desired result. Array_sum, implode/explode, mysql-fetch_array, yet no result

pls help me out

christofa1:
They Have Finally Resolved The Issue.
I've been able to transfer the money

That's nice to hear. Pls Modify the topic. You are no more grieving.
Biko

^^^ Malu

christofa1:

Lol it seems u didn't read what I just wrote.
I've contacted them so many times (email, phone number) without any solution. It's either they tell me their head of customer support is not around or that they will contact me back.
That's how they've been doing. Playing me like game

When will we stop scamming each other in this country?

Cc lalasticlala naijacutee pls do the needful

ThisBoyGay:
Continued...
characteristics.

Now here is who they are usually attracted to:

- Guys that don't talk too much (that are somehow shy)
- Guys that are very caring.
- Weak Guys (even though they might accuse you of being a sissy, but they love it).
- girly guys (this is not general though. But most Dominant Types like guys that are not too muscular, that are beautiful instead of handsome, e.t.c

Wow! It seems u are describing me.

But u definitely need more than just knowing about me to woo me.

Goodluck with wooing thos 3 girls