Usingi split function

[kir441]

$query="SELECT COLUMN_NAME,TABLE_NAME FROM xxx WHERE COLUMN_NAME LIKE '" . $search . "%'";

$result2=odbc_exec($cnx,$query);
while(odbc_fetch_row($result2))
{
for($i=1;$i<=odbc_num_fields($result2);$i++)
{
echo "<table>";
list($column,$table) = split(" ",$result2,2);
echo "<a href=http://try5.php>". odbc_result($column,$i)."is in the table". odbc_result($table,$i). "</a>";
echo "</table>";

}
}

There is some data stored in the result set "$result2". That data is according to query i.e. It will select Column_name and Table_name (two separate fields). I want to split them separately by using split function and display as " column_name . table_name ". I dunno where did I go wrong it is not taking the values of $column and $table. Help me out.

Thanks
Kiran

[ofSHIZ]

hmmm well i'm not to sure.. but maybe this might be the problem..
where you are listing $column,$table i thought you would have to have a space in between the , like $column, $table
i really havn't heard of this feature.. but you could check here.. about it
Split

here's what the code would look like after you added the spaces..

$query="SELECT COLUMN_NAME,TABLE_NAME FROM xxx WHERE COLUMN_NAME LIKE '" . $search . "%'"; 

$result2=odbc_exec($cnx, $query); 
while(odbc_fetch_row($result2)) 
{ 
for($i=1;$i<=odbc_num_fields($result2);$i++) 
{ 
echo "<table>"; 
list($column, $table) = split(" ",$result2, 2); 
echo "<a href=http://try5.php>". odbc_result($column, $i)."is in the table". odbc_result($table, $i). "</a>"; 
echo "</table>"; 

} 
}

I'm kind of having a problem myself.. do you know about the
fopen
fwrite
fclose
features? well i'm making a thing so when you login to my website you can add news... i'm using a text document to add it to.. then i want the text document to be displayed on my homepage..

add code

<?php
$fopn = fopen ("news.txt", "w");
$fwrt = fwrite ($fopn, $topic, $message);
$fcls = fclose ($fopn);
{

echo "Success!";

}

?>

print to homepage code

<?php
$fopn = fopen ("news.txt", "r");
$fcls = fclose ($fopn);
?>

are those right? My Homepage

[keith73]

Originally posted by kir441
$query="SELECT COLUMN_NAME,TABLE_NAME FROM xxx WHERE COLUMN_NAME LIKE '" . $search . "%'";

$result2=odbc_exec($cnx,$query);
while(odbc_fetch_row($result2))
{
for($i=1;$i<=odbc_num_fields($result2);$i++)
{
echo "<table>";
list($column,$table) = split(" ",$result2,2);
echo "<a href=http://try5.php>". odbc_result($column,$i)."is in the table". odbc_result($table,$i). "</a>";
echo "</table>";

}
}


There is some data stored in the result set "$result2". That data is according to query i.e. It will select Column_name and Table_name (two separate fields). I want to split them separately by using split function and display as " column_name . table_name ". I dunno where did I go wrong it is not taking the values of $column and $table. Help me out.

Thanks
Kiran

When you use odbc_fetch_row, the information in that table row is stored in an array.
What you are doing is:
1) creating the array in the while loop,
2) creating a for loop for THAT row,
3) trying to access the information from the result resource identifier which you can't do.

you actually don't need the split
Try this:

//comment out the split line or eliminate it
//list($column,$table) = split(" ",$result2,2); 
echo "<a href=http://try5.php>". odbc_result($result2,0)."is in the table". odbc_result($result2,1). "</a>"; 
echo "</table>"; 

odbc_result references the fields of the current row. You can access them by index # 0 to N
where 0 is the first column in the query or 1st column in the table if querying *.
you can also access the fields by name using odbc_result($result2,'column_name');

also look at the usage of odbc_fetch_row and odbc_fetch_array, you probably don't even need the for loop.

http://www.php.net/manual/en/function.odbc-fetch-row.php
http://www.php.net/manual/en/function.odbc-fetch-array.php

• Keith