Fetching data from mysql table using $row

[eMonk]

Can you add a WHERE clause in $row?

 

For example:

 

$row['city_display'] WHERE city_display = 1

$row['city_display'] WHERE city_display = 2

 

etc...

 

How can this be done?

[eMonk]

Right now I'm trying:

 

$id = $_GET['id'];

 

$city_1 = mysql_query("SELECT * FROM model_in_city WHERE city_display = 1 AND model_id = '$id'  ");

$city_2 = mysql_query("SELECT * FROM model_in_city WHERE city_display = 2 AND model_id = '$id'  ");

 

but it's not displaying the correct value in the following text field:

 

<tr>

  <td>City 1</td>

  <td><input name="city_1" type="text" size="2" value="<?=$city_1?>" maxlength="2"></td>

</tr>

 

However, PHPMYADMIN is showing the correct value. Any ideas?

[gizmola]

eMonk:

  When you do a mysql_query() the mysql server calculates the result.  That result then sits on the server.  In order to access it you have to fetch the individual rows.  This is clearly shown in the php manual, so I'm not going to post it here.  There are many different ways to fetch but the one I recommend for most people is mysql_fetch_assoc

[eMonk]

I was about to post that I just realized that I have to extract the data now but too tired now to play with it.

 

Will continue this tomorrow and write a follow up. Thanks!

[eMonk]

See anything wrong with this code? $city_1 and $city_2 still aren't showing up in text fields but the data shows correctly in phpmyadmin.

 

$id = $_GET['id'];

$qP2 = "SELECT * FROM model_in_city WHERE city_display = 1 AND model_id = '$id'  ";
$rsP2 = mysql_query($qP2);
$row2 = mysql_fetch_array($rsP2);
extract($row2);
$city_1 = trim($city_display);

$qP3 = "SELECT * FROM model_in_city WHERE city_display = 2 AND model_id = '$id'  ";
$rsP3 = mysql_query($qP3);
$row3 = mysql_fetch_array($rsP3);
extract($row3);
$city_2 = trim($city_display);

 

[fugix]

try this

$id = $_GET['id'];

$qP2 = "SELECT * FROM model_in_city WHERE city_display = 1 AND model_id = '$id'  ";
$rsP2 = mysql_query($qP2);
$row2 = mysql_fetch_assoc($rsP2);
$city_1 = $row2['example_field']

[eMonk]

I tried that before fugix but it didn't work. Any more ideas?

 

Added the ; on the last line as well.

[fugix]

if you tried that before and it didnt work then you didnt use it correctly...do you have code that shows how you used it?

[eMonk]

$qP3 = "SELECT * FROM model_in_city WHERE city_display = 2 AND model_id = '$id'  ";
$rsP3 = mysql_query($qP3);
$row3 = mysql_fetch_assoc($rsP3);
$city_2 = $row3['city_display'];

[gizmola]

eMonk, read this:  http://www.flingbits.com/article/view/my-script-with-mysql-calls-doesn-t-work-why-1

[fugix]

what you have there will echo whatever is in you city_display column..if your query is grabbing multiple rows then you'll want to use a while() loop as well..if nothing is getting echoed then try debugging your query e.g

$rsP3 = mysql_query($qP3) or die(mysql_error());

 

edit: gizmola posted right before me...read the link that he posted...should help

[eMonk]

Ok, I have it working now...

 

$city_2 = $row3['city_display'];

 

should have been

 

$city_2 = $row3['city_id'];

 

however now when i echo $city_2 at the bottom of the page, the value isn't displaying correctly like before. I'm not overwriting the $city_2 variable anywhere. Why is this variable loosing it's value at the bottom of the page?

[eMonk]

Ah, I have it working now. Just moved this query after a different one.

 

Thanks for the help everyone!