"; $sql="DESCRIBE $tbnm"; $mysql_result=mysql_query($sql); if (!$mysql_result) { print "DB Error, could not list fields
"; print 'MySQL Error: ' . mysql_error() . '
'; # exit; } else { while ($row = mysql_fetch_row($mysql_result)) { print "$tbnm Field: $row[0]
"; } } echo "
"; } #================================================= $tblnme = 'jos_'; $tb_name=$tblnme."k2_items"; #================================================= ?>

Story Net New

."; $sql="SELECT * FROM $tb_name where video LIKE \"%soundcloud%\" "; $mysql_result=mysql_query($sql); $num_rows=mysql_num_rows($mysql_result); echo "

$tb_name Table ($num_rows)

"; if ( $num_rows == 0 ) { echo "Sorry there is no information"; } else { # we have results echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($row=mysql_fetch_array($mysql_result)) { $id=$row["id"]; $title=$row["title"]; $alias=$row["alias"]; $atid=$row["catid"]; $id=$row["published"]; $published=$row["introtext"]; $fulltext=$row["fulltext"]; $video=$row["video"]; $gallery=$row["gallery"]; $extra_fields=$row["extra_fields"]; $extra_fields_search=$row["extra_fields_search"]; $created=$row["created"]; $created_by=$row["created_by"]; $created_by_alias=$row["created_by_alias"]; $checked_out=$row["checked_out"]; $checked_out_time=$row["checked_out_time"]; $modified=$row["modified"]; $modified_by=$row["modified_by"]; $publish_up=$row["publish_up"]; $publish_down=$row["publish_down"]; $trash=$row["trash"]; $access=$row["access"]; $ordering=$row["ordering"]; $featured=$row["featured"]; $featured_ordering=$row["featured_ordering"]; $image_caption=$row["image_caption"]; $image_credits=$row["image_credits"]; $video_caption=$row["video_caption"]; $video_credits=$row["video_credits"]; $hits=$row["hits"]; $params=$row["params"]; $metadesc=$row["metadesc"]; $metadata=$row["metadata"]; $metakey=$row["metakey"]; $plugins=$row["plugins"]; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
idtitlealiascatidpublishedintrotextfulltextvideogalleryextra_fieldsextra_fields_searchcreatedcreated_bycreated_by_aliaschecked_outchecked_out_timemodifiedmodified_bypublish_uppublish_downtrashaccessorderingfeaturedfeatured_orderingimage_captionimage_creditsvideo_captionvideo_creditshitsparamsmetadescmetadatametakeyplugins
$id$title$alias$catid$published$introtext$fulltext$video$gallery$extra_fields$extra_fields_search$created$created_by$created_by_alias$checked_out$checked_out_time$modified$modified_by$publish_up$publish_down$trash$access$ordering$featured$featured_ordering$image_caption$image_credits$video_caption$video_credits$hits$params$metadesc$metadata$metakey$plugins
"; } # end else #================================================= ?>