Variable in a MySQL Table?

[chmpdog]

Hola,

 

In my script I have a variable, and I need to echo it. But here is the tricky part. I need to echo it in a certain place in a paragraph, which is taken from MySql.

 

So, does anyone know how to do this?

 

Thankyou

[dclamp]

I am a little confused. Let me try to clarify.

 

You have a paragraph (i will use a sentence for example sake):

"Hello my name is Name!"

 

and you want to put some one's name in there?

[haku]

Elaborating on that:

 

$name = 'John';
$paragraph = 'My name is NAME';
$formatted_paragraph = str_replace('NAME', $name, $paragraph);

[chmpdog]

Im pretty sure that will work... Thanks

[redarrow]

I am sure this will do the same try it mate.......

<?php
$sql="select SUBSTRING(field_name,-4) from table_name";
$res=mysql_query($sql)or die(mysql_error());
?>

[dclamp]

I am sure this will do the same try it mate.......

<?php
$sql="select SUBSTRING(field_name,-4) from table_name";
$res=mysql_query($sql)or die(mysql_error());
?>

that is assuming my example was what he actually needed.

[corbin]

Uhm....  What?!

 

 

Edit:  That was at redarrow.  Also, it wouldn't work alone because he would have to concatenate the name (or whatever) to the end.

[redarrow]

say in the database you had  "my name is john"

 

why wouldnt it just echo john from the field name from the database........

 

<?php

$sql="select SUBSTRING(name,-4) from text where id='$session_id'";
$res=mysql_query($sql)or die(mysql_error());

while($rec=mysql_fetch_assoc($rec)){

echo " ".$rec["name"]." ";
}
?>

[dclamp]

yeah but if the name is changing frequently, then it woulnt work.

[redarrow]

u can use REGEXP in the select statement,

to show the word afther the 3rd space in the database field and that word can be any size.........

[dclamp]

Well still, you are basing your code off of my example. The OP stated that there is a paragraph and he needed to change something within the paragraph. The easiest solution is str_replace()

[redarrow]

Agree sorry.........