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
339
54
Other forums
How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But
Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system
Files in current folder. Should be an easy fix.
Never mind. I've asked about this before and just found my answer. Anyway to delete this?
Save data in input fields when they press "BACK BUTTON"
Hi, this is html form: And let's say they get a error "Please enter ur title must be more then
WM transfer order: confirm different batch than proposed by system
Hi folks,
following scenario: we have a full WM with mixed batch numbers allowed in stora
PHP Tab Control
Hi All,
I would like to have PHP tab control with/without Javascript.
But I want to r
Display thumbnails as square while retaining aspect ratio
I am trying to figure out a way to make an image display as a square, for example 80x80 pixels, when
Calling variables
I want to call this to my website but it doesn't display what I want it to,
Code: <h5&
Problem with creating FI documents
Hi, Experts!
when i create Fi doc. with standart transaction, i ve been had such problem
TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.