How to select a user's data with guest id?

[m37h0d]

Hi,

I was wondering how you can select the users data out of mysql with their auto_increment guest id...

Any help would be appreciated, thanks.

[m37h0d]

<?php
require("/home/brayden/public_html/includes/config.php");
mysql_connect ($hostname, $db_login, $db_pass);
mysql_select_db($database);

$utm1 = $_REQUEST['utm'];

$reqid = $_REQUEST['id'];

if ($_REQUEST['action']=="test") {

$delete_data=("SELECT * FROM cfrecords WHERE guest_id = 7;");
$ver=mysql_query($delete_data) or die("Can Not Delete This Post..");

echo ".$row[1].";
echo $clan_name;
}

?>

I'm trying to make individual pages for each record, and I need to pull the data from where a certain id's row is. Why wont this script work?

I'm echoing both Row1, and Clan name, which are the same thing, but nothing echoes.

I will honestly paypal $10 to whoever gives me the fix, post the fix and your paypal email address. I'd rather just get the fix off here then pay a coder.

[rajavel]

fetch is missing........use these functions to fetch these values

mysql_fetch_row()

and also if u want to delete....use DELETE Query...here is the syntax...

Single-table syntax:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT row_count]

Multiple-table syntax:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
tbl_name[.] [, tbl_name[.] ...]
FROM table_references
[WHERE where_definition]

Or:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
FROM tbl_name[.] [, tbl_name[.] ...]
USING table_references
[WHERE where_definition]

[m37h0d]

Where do I put the fetch row command?

[m37h0d]

I figured it out, thanks ne way 🙂

[rajavel]

<?php
require("/home/brayden/public_html/includes/config.php");
mysql_connect ($hostname, $db_login, $db_pass);
mysql_select_db($database);

# $utm1 = $_REQUEST['utm'];
# $reqid = $_REQUEST['id'];

if ($_REQUEST['action']=="test") {

$delete_data=("SELECT * FROM cfrecords WHERE `guest_id` = 7;");
$ver=mysql_query($delete_data) or die("Can Not Delete This Post..");

/*.....This is what u need to do......*/
$row = mysql_fetch_row($ver);

/*...if the value is not null it will display the value.....*/
echo $row[1];

echo $clan_name;
}

?> 

This the code u need to do

Welcome🙂

[dcooper]

Originally posted by m37h0d
Hi,

I was wondering how you can select the users data out of mysql with their auto_increment guest id...

Any help would be appreciated, thanks.

Assuming the users id is named uid;

$query = "SELECT * FROM table WHERE uid='$uid'";
$result = mysql_query($query);

[rajavel]

when this is posted

Hi,

I was wondering how you can select the users data out of mysql with their auto_increment guest id...

Any help would be appreciated, thanks.

i didn't get this b4.......