[Resolved] [Resolved] Question on PHP & MySQL

maximum-php

Hi,

I'm trying to find out, if there is a way. That when you pull your Query from MySQL using PHP that the Columns name is accessible with the row data.

For instance, I have the following table in MySQL.

+--------+-------+------+
| user | links | news |
+--------+-------+------+
| auser | 1 | 0 |
+--------+-------+------+

I'm using this table as a way for php to know what links to build for a user. Now I setup a simple php script to Query the database / table and return the results of that user.

At this point, I would have to then, from my understanding. Create a large Loop / If sequence to pretty much check key 2 for 0 or 1 then create LINKS link, Then if Key3 was 0 or 1 create News link. However i think it would far easier to simple use the Table Colum name to know which item i'm on. To have the link created. That way, when i tamper with the php script i dont always have to remember in what sequence my links were setup in Mysql. I can simple just use the Name of the colum to then if it was 1, create a link per that colum name.

I'm fairly new to this, and I appologize. I looked all over, for what I could use to accomplish this. But I fell short.

Any suggestions // comments // code snippets to accomplish this would be great,

Thx,

plex303

check out the mysql_fetch_assoc () function.

http://us4.php.net/manual/en/function.mysql-fetch-assoc.php

maximum-php

Sorry, I dont see how using that over mysql_fetch_array() will solve my problem? Is there something that i'm missing? will mysql_fetch_assoc(), return both the ROW data and Table Column Name?

If so, what is the syntax?

Thx,

plex303

Originally posted by maximum-php
Sorry, I dont see how using that over mysql_fetch_array() will solve my problem? Is there something that i'm missing? will mysql_fetch_assoc(), return both the ROW data and Table Column Name?

If so, what is the syntax?

Thx,

"will mysql_fetch_assoc(), return both the ROW data and Table Column Name? "
Yes... and so does mysql_Fetch_Array() assuming you arent defining the result type as MYSQL_NUM.
You didn't mention which function you were using... but regardless

Are you familiar with associative arrays?

+--------+-------+------+
| user | links | news |
+--------+-------+------+
| auser | 1 | 0 |
+--------+-------+------+

$result = mysql_query("SELECT * FROM table WHERE user = 'auser'");
$row = mysql_fetch_assoc($result);

$news = $row[news]; // 0
$links = $row[links]; //1

is this what you are asking??

maximum-php

What i'm pretty much trying to accomplish. Is when i've pulled the data from MySQL which i've done already, maybe not the right way.

I want to be able to setup a Loop, that will pretty much do this for each element in the array i pull back from MySQL.

if ($value == '1') {
echo '<a href="/$key.php">$key</a>'
}

So to explain further

+--------+-------+------+
| user | links | news |
+--------+-------+------+
| culley | 1 | 0 |
+--------+-------+------+

$value would be either culley, 1, 0.
$key would be either user, links, news. So my basic setup which, I think its close is.

<?php
$connection = mysql_connect('localhost', 'xxx', 'xxxx');
mysql_select_db('usrpsw');

$query = "SELECT * FROM wlinks WHERE user='".$_SESSION['user']."'";
$result = mysql_query($query);

$info = mysql_fetch_array($result, MYSQL_BOTH);
mysql_close($connection);

foreach ($info as $key => $value) {
if ($value == '1') {
echo "<a href=\"/'$key'.php>'$key'</a>"
}

Anyways, I appreciate any help, i'm stumped.

Thx.

plex303

From the looks of it, the bit of code that generates the links would probably print out 2 links per result.

Something like:
<a href="1.php">1</a><Br><a href="links.php">links</a>

If you JUST want the names (that is: Column names as key values) then change MYSQL_BOTH to MYSQL_ASSOC.
otherwise you have an array containing duplicate information with both integers and strings as the index. And FYI: you don't have to specify MYSQL_BOTH as the result type... it's the default value.
Maybe you are completely missing the what this result_type is actually supposed to do. Hint: It has NOTHING to do with the actual values returned... it only affects the structure of the array.

:queasy:

maximum-php

Thx for the help, i'm new to this,,i've just started paying with php,, you helped in at least getting what i wanted working,, thx