Recent content by neilmurray

Thanks, I'll give it a go. Neil.

Hi, Supposing I have a database with customer and number of items wanted as 2 columns. If I have 1000 items to sell how would I find out at which customer is my 1000 items sold. i.e. Customer number 1 100 2 500 3 300 4 200 5...

Hi, Is there any way that I can my php page run itself at say 12am every morning? This is so I can save the mornings beginning information in my mysql database? Thanks, Neil.

Hi, How do you change a variable that is a real number say $real=4.76 to an interger. i.e change the variable to 4. Thanks, Neil.

Trying to return variables from a function to teh main programme. Using return array($var1,$var2,$var3); Where are these variables then stored? I can't find them. Thanks, Neil.

Thanks, made stupid mistake somewhere else. Neil

Hi, I want to read in a variable $comid which will be a number 1-40 and I then want to find the relevant value in and array, i.e. array[$comid] (of array[40] say) how would I do this? Thanks, Neil.

Thanks, I'll give it a go. Neil.

Hi, I have a mysql database with a persons login date and time as a field and I have designated it as timestamp. I then want to get this info and plot it on a graph. I call for it from the database and it comes in this format. 200506210000000 which is 2005 june 21st 00:00:00. I have tried loads...

Hi, where can I find info on what $this-> does. Tried checking th ePHP manual but no Joy. Thanks, Neil.

Hi, I have selected a row from a table where the column names are: id, money, com1, com2, com3, com4, com5, com6 I want to do a loop where I run a function on each one of the com1, com2 etc. values one at a time. Is there any way I can format the text to be say for ($i=1;$i<=20;$i++) {...

Thanks, That worked. Neil.

Hi I have the following snippet of code from a bigger programme. while ( $row = mysql_fetch_array($result)) { extract($row); $l++; $offerpricecom[$i][$l]=$offerprice; echo $offerpricecom[$i][$l]; // line 1 } for ($l==1;$l<=3;$l++) { $newprice=$offerpricecom[$i][$l]; echo...

Thanks, Neil.

Hi, I am running the following query $query = "select sum(offernumber) from offers where offerprice='120'"; result= mysql_query(query); how do I then extract this result? Thanks, Neil.