PHP - Multiple Commands In One Statement With A Single Line Output?

why it giving me single row data?? what i m missing here ... any help wil b appreciated..

<?php$comments= "";$result = mysql_query("SELECT * FROM comment");while($row = mysql_fetch_array($result))  { $serials= $row['serial']; $names= $row['name']; $emails= $row['email']; $msges= $row['msg']; $date_added= $row['date']; $comments= "$names <br /> $msges <br /> $date_added"; } ?>()

Okay, I have a question. Is there a way to combine three fields within a single table (x, y, z) into a single variable?

Something like: x~y~z? (the ~ would be needed)

I came up with this but it outputs the value 3 times... (because there are 3 variables)

ie mathsmathsmaths

How do I fix this or do it the correct way? Thanks

Code: [Select]
$subject = "maths";
$phone = "1235";
$colour = "red";
$all_vars = compact("subject", "phone", "colour");

get_value($subject);

function get_value($variable){
global $all_vars;
foreach($all_vars as $key=>$value){
if ($key = $variable) {
echo $key;
}
}
}

I need to get the 2nd code working. Please help.

This works
$query = "SELECT DISTINCT addressz FROM abs WHERE statez = 'AZ'";
$results = mysql_query($query);

But this dosen't.
$SomeVar = $_POST['disloc'];
$query = "SELECT DISTINCT addressz FROM abs WHERE statez = '".$SomeVar."' ORDER BY addressz ASC";
$results = mysql_query($query);

how do i handle single quotes in sql query

Code: [Select]
" SELECT name from phrase WHERE name='$stitle' ";this returns an error because the name contains single quotes like this:
Johnson's.

This sounds like it should be pretty simple but I've looked for a while and I'm having trouble finding an answer.  What I have is a simple table with 3 columns with predetermined widths.  When the text that is queried from the database is inserted into the table, and the text string is longer than the column width, it pushes the text to a second line, which throws the whole table out of whack.  Instead, I want the text to be cut off before going to the next line.  For example:

This is what is happening:

This is a sample string of
text.

This is what I'm trying to do:

This is a sample string...

Can anyone tell me where to find the solution to this problem?

Not that it's needed, but here is some simple code that I'm working with:
Code: [Select]
<?php

$message = "This is a sample string of text.";

echo "<table width=\"150\" height=\"20\"border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr>";
echo "<td width=\"50\" height=\"20\" align=\"left" valign=\"top\">Column 1</td>";
echo "<td width=\"50\" height=\"20\" align=\"left" valign=\"top\">Column 2</td>";
echo "<td width=\"50\" height=\"20\" align=\"left" valign=\"top\">$message</td>";
echo "</tr>";
echo "</table>";

?>

I'm ok with PHP but probably not half as good as some of you guys on here.

I am basically trying to find a way to grab a line from a huge and I mean huge text file.... its basically a list of keywords I want to call by line number but without preferably going through them all before I get to that line.....otherwise couldmcrash my server obviously.

At the moment im using this

Code: [Select]
$lines = file('http://www.mysite.com/keywords.txt');

// Loop through our array, show HTML source as HTML source; and line numbers too.
foreach ($lines as $line_num => $line) {
echo "$line_num";
}
This works but im sure theres gotta be a better way of doing to save on usuage because this is putting the whole file into the memory and if I can simply say to php give me line number 97, would umm RULE....

Hope you guys can come up with a solution as your much smarter than me ty

Hi,

I am pretty much a new newbie when it comes to PHP, and have a problem that I need to solve, for a website that has to go live tomorrow.

Basically I have been using a javascript upload script called 'uploadify' which had an option for the upload folder which was added to the script in the form:

Code: [Select]
'folder'    : '/songs/<?php echo $_SESSION["name"];?>',
I added the php echo to return the username from a PHP login, so it gets added to the path to the upload folder (each user has their own subfolder for uploading to).

With the new version of the uploadify script, the folder option has been moved to a separate PHP file where it is now in the form:

Code: [Select]
$targetFolder = '/songs/';
I need to find a way of adding the username variable to this line.  I have tried using echo in various ways, and googled about, but it has stumped me, simple as it may be.

If anyone could let me know how I construct this line I'd be very grateful.  Time is of the essence, as they say...

Thanks,

Nick

I have some page that generates JSON array but the problem that java script ajax can't recognize it as a JSON code because it begins in the third line of the output ( press CTRL+U to see it )
I found out that the problem is my function php page that is Included ( include() ) there. but this function page doesn't send any output?! what is the problem!?

http://maadif.co.cc/stuff/ajax_request.php

I can use the first while loop, but there is no data in the second while loop. Is there a better way as I have never done this before...

Code: [Select]
              <?php
                $featured_results = mysql_query("SELECT * FROM products LEFT JOIN product_images ON products.product_id=product_images.product_id WHERE products.product_featured='1' AND products.product_active='1' AND thumb='1'");

$fa=0;
while($featured_row = mysql_fetch_assoc($featured_results))
   {
$fthumb_result = mysql_query("SELECT image_name FROM product_images WHERE product_id='".$featured_row['product_id']."' AND thumb='1'");
$fthumb = mysql_fetch_row($fthumb_result);

if ($fa==0) {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
} else {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload home-slider-photo-unsel\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
}
$fa++;
}

echo "<div id=\"home-slider-photo-price\">";
$fb=0;
while($featured_row2 = mysql_fetch_assoc($featured_results))
   {
if ($fb==0) {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
} else {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price home-slider-photo-price-unsel\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
}
$fb++;
}
echo "</div>";
?>

I have the form:

Hey guys,

I'll be the first to say that I'm a real php n00b, and only understand the basics.
I have a website already in place that someone else coded and I just need to add something to.

There's a form that posts to another page and then back to a sql database. What I want to do is have the form also email me the contents of the form when it is submitted.

Is there a way to have a form do multiple actions? I'm not sure the best way to go about this, so if someone has some pointers, I'd really appreciate it.

Thanks!

Hi all,

slightly confusing title!

What I am trying to do is make a simple stores system whereby I can add and remove stores.

It is purely php and no mySQL.

My idea was to create a text file with the individual number and then include the file on the table on the page.

I have worked out how to increment one value by one, but the others I am struggling with.

Example I wish to have two links one which I click to increase and another to decrease the value by one. 

It's the multiple issue that is confusing me, I create a txt file and a php file using a variable from a submitted form (part number).  The php file holds info and the text file holds the number which is default at '0' (Zero).

My idea was to write some php to the file, perhaps when I click the plus it will open and write to the file + 1 ..

Any guidance or points in the right direction would be greatly appreciated.  Thanks.

Shugs

Hi.   I have a product database w/ tables each for product series, model, sub-model and optionals. One item in each of these makes up one product. So Series K, Model 7, sub-model 2, optional 3 will be a product called K 7/2-3 .The permutations and combinations of these are all possible products.   In the same db, I have a quotations table. Each quotation has a unique id / record.  A quotation can include any number of products : it can have K 7/2-3, KA 561/1-2 , FPN 311/2-1  or it can only have KA 561/1-2 etc.   Now I am stuck. Don't know how to   a. structure the quotations table   b. create a MySQL select so that one statement can make multiple selections . I thought of using a checkbox but that doesn't work either since the series/model/sub model/optionals must chosen sequentially.   Any ideas I can follow thru ?   Many thanks Swati      

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you