hmm

[aenirtower]

I did this code:

$mysql=mysql_query("SELECT * FROM names WHERE id='2'");
while($result=mysql_fetch_array($mysql)) {
$name=$result['myname'];
}
echo "My name is $name!";

I upload, and I get:
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
My name is !
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

how can I make it so $name isn't blank?

😕

[aenirtower]

and I've tried everything I can!! 🙁

[tha_mink]

Try it this way...

$mysql=mysql_query("SELECT * FROM names WHERE id='2'");
while($result=mysql_fetch_array($mysql)) {
$name=$result['myname'];
echo "My name is $name!";
}

But since you are only looking for one record you don't need the loop, you can do...

$mysql=mysql_query("SELECT * FROM names WHERE id='2'");
$result=mysql_fetch_array($mysql);
$name=$result['myname'];
echo "My name is $name!";

[aenirtower]

weird.. I can't recieve anything from MySQL now.. :-/

[csn]

Slim Shady?

[bastien]

the id field is numeric???

$mysql=mysql_query("SELECT * FROM names WHERE id=2");

therefore no quotes are needed...

[tha_mink]

Do you have a value in the column named 'myname', in the names table with an id of 2?