UPDATE after INSERT?

[solinent]

Can I do the following in the SAME PHP script?

 

INSERT some columns

SELECT inserted columns along with others

UPDATE all the columns.

[Wildbug]

Sure, why not?  As separate queries, of course.

 

$query1 = "INSERT....";

$query2 = "SELECT...";

$query3 = "UPDATE...";

[solinent]

Yeah, I am doing that, but it doesn't seem to work.  The SELECT doesn't return good results, or some error is happening.

 

First I crawl some webpages, insert values into a table.

 

Then, I SELECT the table in order, and then UPDATE it with the order number (because doing it with mysql every time would take too much time).

 

This needs to run every day with cron, so I need to fit it in one script.  It works if I separate the scripts.

[Wildbug]

You should check for MySQL errors after each query, especially while debugging/writing code.