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'>&nbsp;</td>
</tr>
<tr>
<td><textarea name='code' id='code' cols='45' rows='5'></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><label>
<center> <input type='submit' name='Submit' id='Submit' value='Submit' /></center>
</label> </form></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</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

339 Like 54 Dislike
Previous php-forum Next php-forum
Other php-forum

PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

date function help
i need help with date function

Code: [Select]<!DOCTYPE HTML PUBLIC "-//W3C//DTD H

Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw

Filename and Line Number Custom Error
I have a class, with a method that accepts 2 parameters. I would like to output error messages.

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

How to show more than 1 users with this code...
Hello,
i have a table that shows users only if I, as Administrator, want to be shown. But its sho

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash