DB Search problem

Seft

Hi,
I've been trying to write a set of scripts that modifies data in a database. Two of the colums in a certain table are number and name. I want to write a script that will give the number of a row when the name is inputted. However with teh following script, the output is always 'Resource id #3' whether the name exists or not.

<?php
if($form == NULL) { ?>
<form action="modify.php" method="POST">
Short Name: <input type="text" name="name"><br>
<input type="hidden" name="form" value="named">
<input type="submit" name="submit" value="Submit me!">
<?php } ?>
<?php
if($form == "named") {
mysql_connect('localhost', 'root', '');
mysql_select_db('micropc');
$number = mysql_query("SELECT number
FROM components
WHERE 1 AND name = '$name'
LIMIT 0 , 30"); ?>

Any ideas as to what I'm doing wrong?

Thanks,
Seft

njm

Well, the script below doesn't actually output anything 🙂 but it looks like you're trying to output the result of mysql_query() which is a resource ID, not the result itself. You need to use something like mysql_fetch_array() to get the results.

hth, njm

Seft

there was a print $number later on, but nvm. Ill have a look at that, thanks.

Seft

thanks, fixed it with this code (i chickened out of the mysql_fetch_array as I didnt really understand it when i looked through the php manual. Here it is for anyone else having a similar problem

<?php
mysql_connect('seft', 'root', '');
mysql_select_db('micropc');
$result = mysql_query("SELECT number FROM components WHERE 1 AND name = 'nick' LIMIT 0 , 30");
echo mysql_result($result,0);
?>