Click here to Skip to main content
15,066,326 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have two tables in my site. blog_cat, and blog_post_seo I want to select from blog_cat a column (catTile) and insert it data into blog_post_seo table column (catTitle),

this what i try

<select name="catTitle">

$catsql = "SELECT catID, catTitle FROM blog_cats ORDER BY catTitle";

$catres = mysql_query($catsql);
while($catrow= mysql_fetch_assoc($catres))

echo "<option value='" . $catrow['catID']. "'>" . $catrow['catTitle'] . "</option>";

Updated 21-Mar-14 6:30am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900