l17wnj

ne1 any ideas

Yeah i know about the insert every x characters using chunk_split(). is there any way to ensure it doesn't split words. as long as it goes in at the end of a word it will do me.

hi I have a mysql table whisch has a name field, text field and multiple image feilds.Is it possible to automatically insert the images into the displayed text every 'x' lines. Thanks

Thanks very much that worked great.

i've got the queries and the mail section working ok i need this table in the message body <table width="100%" border="0" align="right" cellpadding="5" cellspacing="0" class="row1"> <tr> <td class="headingText"><table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#000000" class="tablebody"> <tr> <td colspan="2"><? $querySearch = mysql_query("SELECT * FROM basket WHERE order_ref = '$invoice' ORDER BY `id` ASC"); while($myrowSearch = mysql_fetch_assoc($querySearch)) { ?></td> </tr> <tr> <td class="tablebody"><div align="left"><? echo $myrowSearch['name'] ?></div> <div align="left"></div> <div align="left"></div></td> </tr> <tr> <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="5" class="tablebody"> <tr> <td colspan="4"><? $category_id = $myrowSearch['product_id']; $queryLinks = mysql_query("SELECT * FROM images WHERE pk = $category_id ORDER BY `pk` ASC"); while($myrowLinks = mysql_fetch_assoc($queryLinks)) { ?></td> </tr> <tr> <td width="250" class="tablebody"><div align="left"><? $msg1 = $myrowLinks['description'] ?></div></td> <td width="250" class="tablebody"><div align="left"><a href="http://<? echo $myrowLinks['website'] ?>" target="_blank"><? echo $myrowLinks['website'] ?></a></div></td> </tr> <tr> <td colspan="4"><? } ?></td> </tr> </table></td> </tr> <tr> <td colspan="2"><hr size="1" /></td> </tr> <tr> <td colspan="2"><? } ?></td> </tr> </table></td> </tr> </table>

I'm Using PHP Version 4.4.9 and MySQL 5.0 I wish to send an email with muliple mysql queries in the body of the message. can this be done. i have the script working ok on a but i don't know how to have the mail function read it. Any help would be very much appreciated Thanks

I have taken the recomendation to create a new table for each new gallery but i can't get a form to create a new table if($_GET['mode'] == "add") { //////////////////////////////////add gallery to DB////////////////////////////////////////// $sqldate = date("Ymd"); $name = $_POST['name']; $sql3 = mysql_query(" CREATE TABLE $name ( `pk` int(11) NOT NULL auto_increment, dateentered varchar(255) NOT NULL default '00000000', description text NOT NULL, image varchar(255) NOT NULL default 'noimage.gif', PRIMARY KEY (`pk`) ) ") or die ( mysql_error() ); $sql2 = "INSERT INTO gallery VALUES ( '', '$sqldate', '$name'"; if ( @mysql_query($sql2) ) { $msg = "Your have succesfully Created your new Gallery"; }else { $msg = mysql_error(); } }?>

there won't be any user profiles on this site it is open to everyone so they can upload their own pictures of club events for all to see.

This is for my local football club and they want anyone to be able to add their own images to the site so there may be thousands of images in the gallery eventually. I am trying create something similar to the galleries in social networking sites and i thought it would be easier to do it this way than creating a new table each time. id (primary key)(auto increment) date name image1 ... image50 description1 ... description50

I am using mysql4.0 I am trying to create a gallery section for a website where users can create a new database and upload pictures. I have created the tables and the php script to create the new row and to edit existing rows. However i want the users to be able to insert up to fifty images in each row and uploading this on a single page would be impractical (timeout etc.). Is it possible to upload the images in smaller groups and assign them to the first available field. Thanks