[SOLVED] Finding a string within a string - 2 different locations

[refiking]

I have records in a db like this

line1<br>

line2<br>

 

What I need are 2 different variables.  Here's the code I have (or more of what I need)

 

while ($row = mysql_fetch_assoc($sql){
$line1 = //everything before the <br> tag
$line2 = //everything between the two <br> tags

[JasonLewis]

Well, that code is incorrect because your missing a bracket off your while() loop.

 

So, basically you have 2 lines in your database, in the one field. And you stored at <br> tag in there as well? Or is it a newline? Hm, please explain a bit more.

 

Here is what I'm thinking though.

 

while($row = mysql_fetch_assoc($sql)){
$lines = explode("<br>", $row['field']);
$line1 = $lines[0]; //Should hold line1
$line2 = $lines[1]; //Should hold line2
}

[refiking]

Almost.  Line2 still has a <br> tag there.  How can I remove that one as well?

[JasonLewis]

It does? It shouldn't.

[refiking]

Sorry.  It did.  I forgot to add the tag to one of the records and it screwed up the table.  Thanks!