how to output (substr)function????

kurd · **Posted:** Mon Oct 27, 2008 10:58 am

please i have this problem any one can help me?????

i want to display the output of this script:

/*
Database name= dost
Table name= farmwda
Field name= drezha
*/

$con=mysql_connect("localhost","root");
if(!$con){
die('could not connect:'.mysql_error());
}

mysql_select_db("dost",$con);
mysql_query("set names 'utf8'");

$result = mysql_query("SELECT substr(drezha,0,150) FROM farmwda WHERE ID LIKE '1' ") ;

if ($result && mysql_num_rows($result)>0)
{
while ($rows = mysql_fetch_array($result))
{
echo $rows['drezha']."<br>";
}
}else{
echo "nothing found";
}
mysql_query("set names 'utf8'");

mysql_close($con);

thanks for your reply

bylla · **Posted:** Mon Oct 27, 2008 7:54 pm

Don't you get any output at all or do you just get "nothing found" because I can't really see any problems (but then I haven't test run the script only looked at the code).

/Andreas

kurd · **Posted:** Mon Oct 27, 2008 9:16 pm

dear nothing display me
yes i know there is no problem and error in my cod so i don't know why no data display during output???????????????

bylla · **Posted:** Tue Oct 28, 2008 8:06 pm

If I where you I would try to change this code:

Code:

if ($result && mysql_num_rows($result)>0)
{
while ($rows = mysql_fetch_array($result))
{
echo $rows['drezha']."<br>";
}
}else{
echo "nothing found";
}

to something like

Code:

if (mysql_num_rows($result) == 0)
{
       echo "nothing found";
}
while ($rows = mysql_fetch_array($result))
{
       echo $rows['drezha']."<br>";
}

Also make sure you got something in the database to display.

/Andreas

kurd · **Posted:** Thu Oct 30, 2008 9:22 am

dear i try your code but the result is same thing

please can you test this script in your computer? so as to know that this script in your computer work or not???

Battegenprono · **Posted:** Thu Jul 28, 2011 2:53 am

i have a system which is it using asp language but the problem is i need to convert the system to php language..and i need help ..i dont know how to convert them..

how to output (substr)function????

Who is online