my sql select id and then update problem.

Posted on 16th Feb 2014 07:03 pm by admin

I need to select some auto incremented ids out of a database and then use those id in a where statement which updates the database at the id's location the below code works up to the update statements where it just dies without coughing up an error or anything......can you spot whats wrong and help me fix it?


Code: $current = Array();
$currsel = mysql_query("select id from page0.page0 where refnum ='$newnum' AND username!='admin'")
or die(mysql_error());
while($currrow = mysql_fetch_array($currsel)){
array_push($current,$currrow['id']);
}
print_r($current);

$current1 = Array();
$currsel1 = mysql_query("select id from page0.page0 where refnum ='$oldnum' AND username!='admin'")
or die(mysql_error());
while($currrow1 = mysql_fetch_array($currsel1)){
array_push($current1,$currrow1['id']);
}
print_r($current1);

$upref1= mysql_query("update page0.page0 SET refnum='$newnum' where id='$current[0]' OR id='$current[1]'OR id='$current[2]'OR'id=$current[3]'")
or die(mysql_error());




$upref11= mysql_query("update page0.page0 SET refnum='$oldnum' where id='$current1[0]'OR id='$current1[1]'OR id='$current1[2]'OR id='$current1[3]'")
or die(mysql_error());

Your Answer:

Login to answer

Other forums

Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Am I setting up my sites oldschool?
Ok,

When I create a site I open a basic template that I have created that consists of a css f

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Set Categories
I am creating a submission form for somebody to come in and submit products. These products are sep

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

Add "width" check when upload
Hi!

Can someone add a function that is checking if picture witdh is bigger then 800px whwn up

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it