How to add multiple data in one column in PHP

ammejohn10

Hello everyone, can anyone let me know how to insert multiple data in one column using PHP?

laserlight

Insert multiple rows. This can be done using a loop with a prepared statement that inserts one row, or by constructing a statement that inserts multiple rows.

ammejohn10

Thanks Laser, I have done same as your suggestion but still its not work properly.

Bonesnap

Can you post some code so we can see what you have tried and to better troubleshoot your issue? Thanks!

schwim

If you would show your PHP code, we could probably help you out a little bit.

Weedpacket

And, also, explaining what it does do instead of working can help with working out what is wrong.

ammejohn10

<?php
$query = "select s.*,cp.state_id,cp.city_id from spa s LEFT JOIN city_place cp ON cp.spaid=s.id where s.id=$id";
$result = mysql_query($query); ?>
<form action='editsql.php' method='post' name='myform' enctype='multipart/form-data'>
<?php $row = mysql_fetch_array($result);
$catid = $row['state_id'];
$sql4 = mysql_query("SELECT state_id, state FROM states "); ?>
<select name="city" id="city" onChange="getPlace(this.value)" >
<option value="0" selected="selected">...SELECT CITY...</option>
<? while($s = mysql_fetch_array($sql4))
{
$selected = "";
$categoryId = $s['state_id'];
$categoryName = $s['state'];
if($catid == $categoryId)
{
$selected = "selected";
}?>
<option value="<?php echo $s['state_id']; ?>" <?php echo $selected; ?> ><?php echo $s['state']; ?></option><?php } ?>
</select>

Hello all, this my code now am sure you will be getting whatever am saying?

Derokorian

Please use the boards [noparse]

..code..

..code..

[/noparse] as described in the forum's FAQs when posting code.

Also, a clear description of what you expect to happen, and what is happening instead will help us help you infinitely easier. Without a clear description of the goal and problem at hand, I can't tell you why the code doesn't do what you want.

ammejohn10

Ok Derokorian, I'll do as per as your instruction. Thanks again

ammejohn10

Thanks all, finally Its working. Now I got perfect solution of my problem. Nice to discuss with all of you.