simple echo problem...?

claire

I'm doing a search in MySQL db with:


$sql = mysql_query("SELECT number, string FROM tbl");

while ($row =mysql_fetch_array($sql)) {

$no = $row[number];
$text = $row[string];

echo $no;
echo $text;

}

Echoes out nicely!

If I change the SELECT statement (see below) in order to get a specified part of the string, without changing the echo statement I don't get any output of the $text at all:


$sql = mysql_query("SELECT number, SUBSTRING(string,' ',1) FROM tbl");

What am I doing wrong?

mrmufin

Try:

$sql = mysql_query("SELECT number, SUBSTRING(string, 1) AS 'something' FROM tbl");
if($sql) {
	while($row = mysql_fetch_array($sql, MYSQL_ASSOC)) {
		echo $row['number'];
		echo $row['something'];
	}
}

Alternatively, you could use fetch_row(), since there's only two columns and really no need to be twiddling around with column aliases buggering up fetch_array():

$sql = mysql_query("SELECT number, SUBSTRING(string, 1) AS 'something' FROM tbl");
if($sql) {
	while($row = mysql_fetch_row($sql)) {
		echo $row[0];
		echo $row[1];
	}
}

claire

Thanks, I've been playing around a bit. It is not php (the echo statement) that causes the problem. It is the SELECT statement.

This may not be the right forum...but hopefully someone can give me a tip on how to correct my MySQL?

Im trying to use SUBSTRING(string,' ', 1) in my SELECT statement in order to get the first word (the left word) out of a word pair separated by a blank space.

(The column 'string' includes two words separated by a space)

If I try another substring syntax e g SUBSTRING(string,2,5) it works as it should, outputting a string of 5 characters starting at the second one.

Any ideas??

mrmufin

Well since it's just two little words...

$sql = mysql_query("SELECT number, string FROM tbl");
if($sql) {
	while($row = mysql_fetch_row($sql)) {
		echo $row[0];
        	echo ereg_replace("( .*)+$",'',$row[1]);
        }
}