This is probably really simple... but it's been years since I've written anything, so bare with me!
I've got a MySQL database setup with a table that has multiple fields, where one is a numerical balance. I want to fetch all of these balances, add them together, and print a total.
This is what I have so far:
$acctTotal = mysql_query('SELECT bal FROM assets WHERE term = 'C'');
while($row = mysql_fetch_assoc($acctTotal)){
echo $row[bal];
}
Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting. How would I connect to the database on my hosting account? Currently I am using the following but
Having a problem get the selected item from a drop down menu
I have been looking at this for days now.I have a drop down menu that get it's values from an sql database That works but now I want to get the item and pass it to another query that's where I get
Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:
Hi All,I am trying to connect to the database server from the client server using ruby and facing the following issue-$ruby -r oci8 -e "OCI8.new('temp','temp','//host:1521/sid').exec('select count(1)
default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?
script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. However in our database points are called crystals. If the person has 500 points, and the script
. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!My son-in-law created a php script for my website about 10 years ago to show pictures like a manual slideshow, and
division gives infinity anser
int main(){ int z=0; int i=1/z; cout<<i;}It doesn't throw any error in Visual Studio 2008. .......What setting one has to change so that it will show runtime error in VS 2008.....
Problem with PHP code- simple contact form
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a contact form with PHP code in it- grabbed it from the sitemaster website. Unfortunately my form isn't sending any
need help in update query
hi i have a dynamic form. i need help in how can i use update query when values from dynamic form get pass to php file.currently when i press submit it displays this and does not update fieldsCode:
getAlexaRank($url) function not working
I have made a function to get alexa rankthe site is here: http://mytestsite.rack111.com/1but the Alexa rank is showing up blank and I dont know why can someone please tell me if there is something
