[thelist] help with project design

Terion Miller webdev.terion at gmail.com
Tue Nov 25 15:53:37 CST 2008


Well I still get the insert failed, I'm starting to panic as my date for
this is next tuesday I have to have it finished and I haven't even gotten to
the hard stuff....

Here is my full code:
<?php
if(isset($_POST['add']))
{
include 'inc/dbconnOpen.php';
$HREF = $_POST['HREF'];
$TITLE = $_POST['TITLE'];
$BLURB = $_POST['BLURB'];

$query = "INSERT INTO 'textads'  (`ID`, `title`, `href`, `blurb`, `bDate`,
`eDate`, `expos`, `xCount`) VALUES ('$title', '$href', '$blurb', '$bDate',
'$eDate', '$expos')";


mysql_query($query) or die('Error, friggin insert query failed');

echo "New Dream Job Text Ad  added";
}
else
{
?>
<form method="post">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">TITLE</td>
<td><input name="title" type="text" id="title"></td>
</tr>
<tr>
<td width="100">Blurb</td>
<td><input name="blurb" type="text" id="blurb"></td>
</tr>
<tr>
<td width="100">LINK</td>
<td><input name="href" type="text" id="href"></td>
</tr>


<tr>
<td width="100">&nbsp;</td>
<td><input name="add" type="submit" id="add" value="Add AD"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>

On Tue, Nov 25, 2008 at 3:49 PM, Abdullah Mancy <mancy3000 at gmail.com> wrote:

> oh sorrychange $query line to
>
> $query = "INSERT INTO `textads` (HREF, BLURB, TITLE) VALUES
> ('$HREF','$TITLE','$BLURB')";
>
>
> On Tue, Nov 25, 2008 at 11:48 PM, Abdullah Mancy <mancy3000 at gmail.com
> >wrote:
>
> > change $query line to
> >
> > $query = "INSERT INTO 'textads' ('HREF', 'BLURB', 'TITLE') VALUES
> > ('$HREF','$TITLE','$BLURB')";
> >
> >
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



More information about the thelist mailing list