[[SOLVED] creating dynamic meta titles and descriptions with a DB]

Simply return the data from the DB as normal.  Then echo this out in the head (so your php has to gpo before this) of your doc.

 

$title = my DB's return

 

 

then in the HTML

 

<title><? echo $title;?></title>

 

etc

etc

[[SOLVED] script not updating mysql database - php + mysql]

are you updating or inserting?  Thorpe is right...you need not and indeed cant insert a value like that into an auto_increment column if inserting and updating...well then you should only require to update the NEW variables

 

[[SOLVED] Email Contact Form]

REmove this line

 

mail($email_address, $subject, $event, $dateevent, $comments "From: $name <$email>\nX-Mailer: Simple PHP Contact Form 1.0 (www.korske.com)");

 

 

and replace with

 

mail("Lisa Cleveryley <".$email_address. ">",$subject_prefix,$message,"From: ".$name." <".$email.">");

[[SOLVED] script not updating mysql database - php + mysql]

In your WHERE statement you have no ' ' around the $address_no

 

As a result it is failing to find a matching row, but not hitting an error.

 

so it shoudl read WHERE address_no='$address_no'

[[SOLVED] Email Contact Form]

please supply your updated code

[[SOLVED] Email Contact Form]

lets get it working first!

[[SOLVED] Email Contact Form]

your nearly there!!!.

 

 

mail($email_address, $subject, $message, "From: $name <$email>\nX-Mailer: Simple PHP Contact Form 1.0 (www.korske.com)");

 

Think about his line.  It mails all the other bits and pieces.

You need to send a $message ...right?

well you work the rest out

So we can create a $message by saying $message="This is my message...name=".$name." and email=".$email." and event=".$event." and ....you work the rest out!

 

lol

 

am i am bad teacher???

[[SOLVED] Email Contact Form]

are you working on this or just waiting for some poor sucker to code this for you....lol

[[SOLVED] Email Contact Form]

Yeah..sorry just read the post again and actually looked at your page this time.

 

you have HTML...

 

<select name="event" size="1">

 

You need to have a $_POST statement for each name.  Here the name is "event"

 

So the PHP to get this information becomes

 

$event=$_POST['event'];

 

for the <option value=" other">Other</option>

it would be

 

$option=$_POST['other'];

 

etc.

 

FINALLY

use the $message in your code to stake these all together

 

$mesage=$event.$option.etc.etc

 

Now this is not going to be pretty!!!! but one step at a time

[[SOLVED] Email Contact Form]

OK

 

Really we could do with seeing your html form.

 

But in its absense let me make the following clear.

 

The html form has an action attached (or should have) to the <form> tag.  Make sure this points to the php file.

 

The <input> tags all should have a name value ie

<input type="text" name="Your Name" />

 

Where each element has a name you need to make sure that there is a

 

$something= $_POST['something'];

 

that corresponds with it.

 

ie $name=$_POST['Your Name'];

 

This lets PHP identify the field in the form to the the posted information from.

 

Sort all that out and come back to us.

 

Will

[PLEASE PLEASE HELP!! Inverse Recordset]

I must be failing to understand this.  You say that you want all items that are not set to 'N' if that is correct then ask for that in your SQL

 

WHERE completed <>'N'

 

 

[Generating image]

First thing you need to do is checkout the GDlib  http://uk2.php.net/gd

 

Then as you get stuck as spceific questions about each trauma that you having.

 

Good Luck

 

[htm as php]

I cant see any evidence of it being changed or rendered as PHP...how have you come to this conclusion

 

[[SOLVED] Need some help with syntax]

he types faster than me!!!

[[SOLVED] Need some help with syntax]

you have double open quotes that are unescaped.

 

You haven't closed your { } for starters.

 

Other then that I'm not sure yet.

 

Enclose it in php tags on the board and it should highlight it for you which will help.

 

<?php
while ($dbRecord=mysql_fetch_array($queryResult))
      {
        echo "<TR><TD><A href=\"comic.php?title=$dbRecord["title"]\">".$dbRecord["title"]."[/url]</TD>"."<TD>".$dbRecord["author"]."</TD>"."<TD>".$dbRecord["artist"]."</TD>"."<TD>".$dbRecord["publisher"]."</TD></TR>";
}
?>

 

Look at the colors.  You will see the blue in the echo statement.  this needs tro be fixed.

[Getting Variables from a forwarded page]

You wont include a file with the header comand.  The header command will reedirect  rather than include

 

if you are looking to redirect then the command is correct.

 

the main ideas here would be o capture the url (if i understand your question) and for this id use $url =$_SERVER['REQUEST_URI'];

 

the use the $url var in the redirect where appropriate. The explode can be used...perhaps by exploding at each "/".  But from yor post I'd struggle to offer more info.

 

Will

[Return results as Array]

Databas with 3 fields id, name ,active

 

rows are

 

1----option1----1

2----option2----1

3----option3----1

 

How can i extract all options into a single array so as

 

$results=array('option1','option2','option3');

 

 

[Link in a database!?]

$query="SELECT.............my statement..........";

$result=mysql_result($query);

$row_result=mysql_fetch_assoc($result);

$total_rows=mysql_num_rows($result);

 

 

do { ?>

 

<tr>

  <td><? echo $row_result['Song Title'];?></td>

<td><a href "<? echo $row_result['Link'];?>"> Link Title </a>

</tr>

 

<? } while ($row_result = mysql_fetch_assoc ($result))

 

 

 

 

Now this is only part of the code...but it should give you an idea

[Link in a database!?]

sorry you are right

 

the code you have (i blieve) is problematic as it spits all the row from the DB as 1 string.  You will need to rework this before you can have a link where you want it.

 

you will need to seperate out all fields so that your downlaod field can be treated differently

 

 

[Best way to change language]

so you currently echo the results from ['description']?

 

just add a conditional.

 

if ($_Session['lang']=="en") { echo //english description;}

if ($_Session['lang']=="fr") { echo //french description;}

if ($_Session['lang']=="gr") { echo //german description;}

 

PS last post just came up.  Yes if you did that ID's would be a problem....but y would you delete 1 descrition and not all.

 

Anyway youur table is fine.

[Link in a database!?]

you have it

 

<a href " <? echo link from db;?> "><? echo link name from DB ; ?></a>

 

You clearly will have to store the link location in the database OR have a logical process so that all links are 'worked out'

 

ie

 

$link="http://this_path_always/".<? echo $this_name; ?>.$this_file_extension;

[Web Service slow. Need to set time limit]

bumpety bump.

[Best way to change language]

now...with the greatest of respect....we cant help with that sort of response.

 

You have given no indication of a) how your tables are set up...and b) how you come to your next problems about deletion.

 

Lets start again.

 

Try and be more precise in the environment that you are working and the specific issue(s) that you have.

 

Everything will go wrong is a little but vague...lol

 

 

[Best way to change language]

Id use sessions

 

lets say that you have identical data in 3 tables...1 table for each language.

 

tables

 

english,

french,

german

 

I'd set the Session['lang'] to default to "english"

 

$lang=$_SESSION['lang']

 

then i'd "SELECT products from '$lang' WHERE...."

 

then if someone clicks a button (flag) reset the $Session to the relevant language.

 

That could be one solution.

 

it kinda depends on what table format you have.

[Paypal prob: I can't pass my amount variable - its driving me nuts......]

'<?php echo number_format($oRS["GrandTotal"],2) ?>'>

 

change the "" to ' and the opoosite too so that you have

 

"<?php echo number_format($oRS['GrandTotal'],2) ?>">

 

Try That