quick php question - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » quick php question

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 21:52

I linked to a db run a query now i want to set my varables

how do I set the field name from the db?

$question = feild name

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

26th Jan 08 at 22:01

$query = sprintf("SELECT field FROM table WHERE firstname='%s' AND lastname='%s'")

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
$question = $row['fieldname'];
}

[Edited on 26-01-2008 by Steve]

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 22:27

thanks Steve.

I figured it out just before you posted I did not put it in []

but another quick question

I have $questionnumber then run a form which going to a php script in this form I have

$questionnumber = $questionnumber+1;

but once I run it it does not come back with an increased valve.

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

26th Jan 08 at 22:29

$questionnumber++;

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

26th Jan 08 at 22:33

no just what i put

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 22:34

its ok I did not call it

and to add 2 insteand of one it would be +++

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 22:36

and also if I wanted to go back to the form I just come from after I rang the checking what command would I use.

then that is all thanks for your help

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

26th Jan 08 at 22:52

redirect or include

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 23:10

Thanks

although I fucked up as I set it to 1 on the orginal form so it just resets.

Jodi_the_g

Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline

26th Jan 08 at 23:21