While Problem
Posted on
16th Feb 2014 07:03 pm by
admin
i am having a problem with a while statement here is the code
Code: [Select]<?php
session_start();
if(!session_is_registered(username)){
header('location:login.php');
}
?>
<?php
include'db.php';
// Php Suubmit if and mysql insert
if(isset($_POST['Submit'])) {
$code=$_POST['code'];
mysql_query("INSERT INTO Ads
(id, Html) VALUES( NULL, '$code' ) ")
or die(mysql_error());
// pull out code
$result = mysql_query("SELECT * FROM Code WHERE id='1'");
while($row = mysql_fetch_array($result))
//find ad id
$res = mysql_query("SELECT * FROM Ads WHERE html='$code'");
while($row1 = mysql_fetch_array($res))
echo"
<label>
<textarea name='paste_code' id='paste_code' cols='100' rows='5'>
<?php
include 'db.php';
". $row['ad'] ." = mysql_query(". $row['lick'] ." SELECT * FROM Ads WHERE id='". $row1['id'] ." '". $row['lick'] ." );
while(". $row['row'] ." = mysql_fetch_array(". $row['ad'] ."))
{
". $row['echo1'] ."
". $row['echo2'] ."
}
?>
</textarea>
</label>";
}
else
{
echo"
<table width='439' height='351' border='0'align='center'>
<tr>
<td width='293'><form id='form1' name='form1' method='post' action=''>
<label></label>
Paste Html Here
</td>
<td width='136'> </td>
</tr>
<tr>
<td><textarea name='code' id='code' cols='45' rows='5'></textarea></td>
<td> </td>
</tr>
<tr>
<td><label>
<center> <input type='submit' name='Submit' id='Submit' value='Submit' /></center>
</label> </form></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>New Add</title>
</head>
<body>
</body>
</html>
it does not pull out both just one i am writing the code wrong
thank you
No comments posted yet
Your Answer:
Login to answer
329 
23 
Other forums
db entry based on primary key
My "topics" table contains 10 entires
*--------------*
topicid topic
------
please help
HTML Code:
Code: <span id="ctl00"><span>
Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place.
I have a main window with a ajax grid
Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi
Error in write byte array into document in SM58
Hi Gurus,
Getting the following error status in Transactional RFC (SM58) ..... *Error i
how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw
Problems with adding a link to one position in a 'foreach' loop, please help
Hello!
Iam pretty new to programming and I wanna create a table with users from an array. It
natcasesort works on one server but not on another
Hi
I have a problem that I was hoping that someone can help me with.
I'm trying to use
How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can
Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve
