A difficult MySQL task

pastet89

Hello!
I need a function to do for me the following: from a database, looking-like this one: http://livescore-bg.net/mysql.html , to be extracted consecutively
all the values, untill a value from the column 'bukva' is found in the string

$string = "xbz";

, after that on the screen to be printed the appropriate value from column 'bukva1' (in this case b1), and the whole appropriate row (in this case the row with id=2), to be deleted from the database.
For example:
for the string:

$string = "xbz";

to have finally printed on the screen "b1", and the database to look after the whole operation like this:
http://livescore-bg.net/mysql2.html
I tried to solve the problem, but I still can't... Do you have any ideas?

Elad_Nava

You want to select all rows from a database table until you get to a row that contains a specific string in some column? Run the query, use mysql_fetch_array() on a while(), delete the row, and break out of it when you get a match for the string and the column. Without looking at your code I cannot give you a solution in code.

bradgrafelman

This isn't a difficult task at all; sounds like a simple 'DELETE FROM' query with a WHERE clause, e.g.

DELETE FROM myTable WHERE foo='bar' LIMIT 1

EDIT: If there is still a need to output the row before deletion, you could of course SELECT the row first using a similar WHERE clause, output whatever data you need, and use the 'id' of that row in a DELETE query.