[SOLVED] php/mysql query questions

[herghost]

Hi all,

 

I have two questions, both of which ill run once a month from a cron script.

 

1, How can I empty a table called users_stocks_details from PHP?

2, In the users_stocks_detils table I have the following coloums:

 

user_id  stock_id  quant

 

Once this has been emptied I want to add every users id that has 10 or more credits (see below) with the stock_id of 0 and the quant of 100.

 

I have this so far but not sure where to go with it!:

 

$query="SELECT credits FROM users_details";
  $result = mysql_query($query, $conn) or die(mysql_error($conn));
$rows = mysql_fetch_array($result);
extract($rows);
  
  

  if ($rows['credits'] => 10)
  {

 

Many Thanks

[Mchl]

1.

TRUCANTE TABLE users_stocks_details

2.

 INSERT INTO users_stocks_details SELECT user_id,0,100 FROM users_details WHERE credits > 10

[herghost]

fantastic!

 

Thanks